Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-10864

Write to fulltext table single-threaded

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.6
    • Fix Version/s: 5.7.1
    • Component/s: Query & PageProvider

      Description

      Writing to the fulltext table from multiple threads may cause issues in some databases (especially SQL Server), sometimes ending up in failures due to lock acquisition.

      We should modify the fulltext indexing mechanism to do fulltext table writes from a single thread. The extraction from binary text can still proceed from multiple threads as it doesn't touch the fulltext table.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.