Stream: ibm
Topic: CI Failure on JDK8
Lee Surprenant (Nov 14 2019 at 19:45):
Interesting failure from my latest pull request: https://github.com/IBM/FHIR/pull/416/checks?check_run_id=303537276
Nov 14, 2019 7:24:20 PM com.ibm.fhir.persistence.jdbc.dao.impl.FHIRDbDAOImpl severe SEVERE: SQLException encountered while inserting Resource. java.sql.SQLException: Too much contention on sequence FHIR_SEQUENCE. This is probably caused by an uncommitted scan of the SYS.SYSSEQUENCES catalog. Do not query this catalog directly. Instead, use the SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function to view the current value of a sequence generator. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) at com.ibm.fhir.persistence.jdbc.derby.DerbyResourceDAO.storeResource(DerbyResourceDAO.java:143) at com.ibm.fhir.persistence.jdbc.dao.impl.ResourceDAOImpl.insertToDerby(ResourceDAOImpl.java:678) at com.ibm.fhir.persistence.jdbc.dao.impl.ResourceDAOImpl.insert(ResourceDAOImpl.java:520)
Paul Bastide (Nov 14 2019 at 19:46):
Interesting...
Lee Surprenant (Nov 14 2019 at 19:47):
@Albert(Xu) Wang is it similar to the deadlock issues you were seeing with networked derby?
Lee Surprenant (Nov 14 2019 at 19:47):
i'm gonna download the logs and re-run the checks
Paul Bastide (Nov 14 2019 at 19:48):
I think it's the FOR UPDATE on the SELECT
Lee Surprenant (Nov 14 2019 at 20:03):
re-run passed
Lee Surprenant (Nov 14 2019 at 20:03):
just keep an eye on it i guess
Last updated: Apr 12 2022 at 19:14 UTC