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

JIRA Cloud import fails due to 'ERROR: unexpected data beyond EOF ...'

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      When performing a JIRA import, an error is shown and JIRA is locked.

      Environment

      • JIRA Cloud

      Steps to Reproduce

      1. Start a JIRA import
        (there is no indication yet of what types of files cause this as it is an intermittent database problem)

      Expected Results

      Import Completes

      Actual Results

      Import fails and JIRA is locked with the following message in the UI:

      JIRA logs:

      Error Messages: [Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][propertyKey,cecb847c-a45b-3919-b565-44cbd9367482][entityName,fusion.caches.issue][created,2014-10-21 21:15:21.325][entityId,26603][id,179114][updated,2014-10-21 21:15:22.348][value,{"value":{"targets":{"JRADEV-5589":[{"type":{"id":"repository"},"objects":[]},{"type":{"id":"branch"},"objects":[]}],"JDEV-5589":[{"type":{"id":"repository"},"objects":[]},{"type":{"id":"branch"},"objects":[]}]}},"expiry":1413888322346}] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: unexpected data beyond EOF in block 6250 of relation base/16386/16608
         Hint: This has been seen to occur with buggy kernels; consider updating your system.))
       ...
      java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][propertyKey,cecb847c-a45b-3919-b565-44cbd9367482][entityName,fusion.caches.issue][created,2014-10-21 21:15:21.325][entityId,26603][id,179114][updated,2014-10-21 21:15:22.348][value,{"value":{"targets":{"JRADEV-5589":[{"type":{"id":"repository"},"objects":[]},{"type":{"id":"branch"},"objects":[]}],"JDEV-5589":[{"type":{"id":"repository"},"objects":[]},{"type":{"id":"branch"},"objects":[]}]}},"expiry":1413888322346}] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: unexpected data beyond EOF in block 6250 of relation base/16386/16608
         Hint: This has been seen to occur with buggy kernels; consider updating your system.))]
      

      JIRA may log multiple of those but the backup finally fails if it goes over 5 attempts:

      Create failed - retrying. Attempt [5] out of [5]
      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSCurrentStepPrev][previousId,226600][id,227114] (SQL Exception while executing the following:INSERT INTO public.OS_CURRENTSTEP_PREV (ID, PREVIOUS_ID) VALUES (?, ?) (ERROR: unexpected data beyond EOF in block 876 of relation base/16385/17092
        Hint: This has been seen to occur with buggy kernels; consider updating your system.))
      	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:213)
      	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:178)
      	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
      	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:556)
      	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:542)
      	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:97)
      	at com.atlassian.jira.bc.dataimport.OfbizImportHandler.createWithRetry(OfbizImportHandler.java:559)
      	at com.atlassian.jira.bc.dataimport.OfbizImportHandler.lambda$createValue$0(OfbizImportHandler.java:537)
      	at com.atlassian.jira.bc.dataimport.OfbizImportHandler$$Lambda$1110/28503440.run(Unknown Source)
      	at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.OS_CURRENTSTEP_PREV (ID, PREVIOUS_ID) VALUES (?, ?) (ERROR: unexpected data beyond EOF in block 876 of relation base/16385/17092
        Hint: This has been seen to occur with buggy kernels; consider updating your system.)
      	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:683)
      	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:205)
      	... 12 more
      Caused by: org.postgresql.util.PSQLException: ERROR: unexpected data beyond EOF in block 876 of relation base/16385/17092
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1810)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:498)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)
      	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
      	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
      	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:673)
      	... 13 more
      

      Notes

      The problem appears to be due to concurrent processes.
      Running another import may succeed.

      Workaround

      Contact support to restore functionality, apply a database fix and run the backup again.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mfernandezbadii Mauro Badii
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated: