FHIR Chat · CI Failure on JDK8 · ibm

Stream: ibm

Topic: CI Failure on JDK8


view this post on Zulip 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)

view this post on Zulip Paul Bastide (Nov 14 2019 at 19:46):

Interesting...

view this post on Zulip Lee Surprenant (Nov 14 2019 at 19:47):

@Albert(Xu) Wang is it similar to the deadlock issues you were seeing with networked derby?

view this post on Zulip Lee Surprenant (Nov 14 2019 at 19:47):

i'm gonna download the logs and re-run the checks

view this post on Zulip Paul Bastide (Nov 14 2019 at 19:48):

I think it's the FOR UPDATE on the SELECT

view this post on Zulip Lee Surprenant (Nov 14 2019 at 20:03):

re-run passed

view this post on Zulip 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