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

VCS: don't crash in fulltext indexing of huge text with PostgreSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.2 GA
    • Fix Version/s: 5.2 GA SP1, 5.3 RC
    • Component/s: Core VCS
    • Environment:
      nuxeo-dm-5.2.1-I20090728_0305 with Postgres 8.2 and 8.3

      Description

      I import some files via "nuxeo-shell fsimport".
      Nuxeo EP crashes when it updates "binarytext" column of "fulltext" table (UPDATE "fulltext" SET "binarytext" = NX_TO_TSVECTOR WHERE "id" = ?).

      The postgress error is "string is too long for tsvector Where: SQL function "nx_to_tsvector" during inlining".

      Then, the server crashes displaying error about XA Transaction (XA error on start: Transaction interleaving not implemented).

        Attachments

          Issue Links

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-4085 Nuxeo 5.2.0 GA SP1

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: