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

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-10823 Proper ecm:fulltextJobId invalidation

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-10860 Activity tests are brittle when some events occur before they run

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-10679 WorkManager should allow Work execution to be delayed after the transaction commit

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-10668 Allow WorkManager scheduling to use a priority queue

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-7956 Random crash in async event listeners on CoreFeature annotated tests with a repository init

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-25716 Simplify fulltext extraction

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            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: