Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
erp5 erp5
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Labels
    • Labels
  • Merge requests 139
    • Merge requests 139
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Environments
  • Analytics
    • Analytics
    • CI/CD
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Jobs
  • Commits
Collapse sidebar
  • nexedi
  • erp5erp5
  • Merge requests
  • !2043

Merged
Created Jan 14, 2025 by Kazuhiko Shiozaki@kazuhikoOwner

defer catalog / uncatalog for deferred connection

  • Overview 9
  • Commits 4
  • 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
Reviewer
Request review from
None
Milestone
None
Assign milestone
Time tracking
Source branch: feat/defer_catalog_uncatalog
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7