Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-42126

Looping DELETE operation messages in replicatedindexoperation

    XMLWordPrintable

Details

    Description

      Looping replicatedindexoperation messages for DELETE operations, which result in the table growing to a massive size.

      Impact

      Only affects Data Center. If the table grows to an overwhelming size, queries may timeout and replication could fail

      Could also result in:

      2016-03-16 09:12:13,284 NodeReindexServiceThread:thread-1 WARN      [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception
      java.sql.SQLException: Numeric overflow in conversion of value 2,147,483,700 to type INTEGER.
              at net.sourceforge.jtds.jdbc.Support.convert(Support.java:300)
              at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:656)
              at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:983)
      
      
      2016-09-29 20:05:05,900 NodeReindexServiceThread:thread-1 ERROR [jira.index.ha.DefaultReplicatedIndexManager] Caught an exception trying to replicate deindexed shared entity. The replicated index may or may not be correct
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ReplicatedIndexOperation][indexTime,2016-09-29 20:05:05.809][filename,][entityType,SEARCH_REQUEST][affectedIndex,SHAREDENTITY][affectedIds,xxxx][id,null][operation,DELETE][nodeId,node5] (SQL Exception while executing the following:INSERT INTO replicatedindexoperation (ID, INDEX_TIME, NODE_ID, AFFECTED_INDEX, ENTITY_TYPE, AFFECTED_IDS, OPERATION, FILENAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (ORA-01400: cannot insert NULL into ("<oracle_schema>"."REPLICATEDINDEXOPERATION"."ID")
      ))
      

      Workaround

      1. Reduce the retention period of the records
        • Administration > Services > Replicated index flush service
        • Edit this service and reduce the retention period
          This would not stop the loop, but will help keep the table in a more manageable size

      Attachments

        Issue Links

          Activity

            People

              ohernandez@atlassian.com Oswaldo Hernandez (Inactive)
              dchan David Chan
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: