Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-5472

TransactionCleanupTest throws constraint violations

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 4.1.1
    • Fix Version/s: 4.1.1
    • Component/s: Repository
    • Labels:
      None
    • Bug Priority:
      Category 1

      Description

      When running TransactionCleanupTest (via Eclipse, for example) the following logs messages are observed:

      2012-09-19 22:59:46,094 ERROR [node.db.DeletedNodeCleanupWorker] [main] Failed to purge nodes. If the purgable set is too large for the available DB resources
      then the nodes can be purged manually as well.
      Set log level to WARN for this class to get exception log:
      Max commit time: 1348091981441
      Error:

          1. Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "alf_node" violates foreign key constraint "fk_alf_nprop_n" on table "alf_node_properties"
            Detail: Key (id)=(898) is still referenced from table "alf_node_properties".
          2. The error may involve alfresco.node.delete_NodesByTxnCommitTime-Inline
          3. The error occurred while setting parameters
          4. Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "alf_node" violates foreign key constraint "fk_alf_nprop_n" on table "alf_node_properties"
            Detail: Key (id)=(898) is still referenced from table "alf_node_properties".

      This has to do with the way deleted nodes are handled after changes for ALF-12358.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs
                Reporter:
                dhulley Derek Hulley [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours, 10 minutes
                  3h 10m