Details
-
Bug
-
Resolution: Timed out
-
Medium
-
22
-
Severity 1 - Critical
-
Description
NOTE: This bug report is for JIRA Cloud. Using JIRA Server? 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
- 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
- is related to
-
JRASERVER-60392 JIRA Cloud import fails due to 'ERROR: unexpected data beyond EOF ...'
- Gathering Impact