Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Register
  • Sign in
  • erp5 erp5
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Merge requests 142
    • Merge requests 142
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Jobs
  • Commits
Collapse sidebar
  • nexedinexedi
  • erp5erp5
  • Merge requests
  • !2043

defer catalog / uncatalog for deferred connection

  • Review changes

  • Download
  • Patches
  • Plain diff
Merged Kazuhiko Shiozaki requested to merge feat/defer_catalog_uncatalog into master Jan 14, 2025
  • Overview 9
  • Commits 4
  • Pipelines 0
  • Changes 24

Currently, DELETE on deferred connection are executed in uncatalogObject grouped activity. If Mroonga index is broken or locked, uncatalogObject activity will be blocked.

And if Mroonga index is broken or locked AND any activity is spawned by uncatalogObject, activity table will be locked and whole activity processing will be blocked until uncatalogObject finishes.

To avoid such situation, DELETE on deferred connection are also executed in another activity, like we already did for indexation in c39b8e0a.

To make introducing more full text tables easily, now new dedicated search key, sql_deferred_catalog_object_list and sql_deferred_uncatalog_object are introduced. Note that sql_deferred_uncatalog_object SQL should have multiple keyword in uid DTML.

Edited Jan 15, 2025 by Kazuhiko Shiozaki
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: feat/defer_catalog_uncatalog
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7