java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (7,9) Waiting XID : {104576, S} , APP, INSERT INTO PROCESS_055234_HR (SampleTimestamp,CpuNum,Pin,Priority,UserID,GroupID,ProcessName,Volume,SubVol,FileName,AncestorProcessName,ProcBusyPercent) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Granted XID : {102377, S} Lock : ROW, SYSCONGLOMERATES, (7,8) Waiting XID : {102377, X} , APP, alter table "APP"."PROCESS_055234_HR" compress sequential Granted XID : {102377, S} , {104576, S} . The selected victim is XID : 104576.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Apache's JIRA Issue Tracker by Varma R, 1 year ago
A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (7,9) Waiting XID : {104576, S} , APP, INSERT INTO PROCESS_055234_HR (SampleTimestamp,CpuNum,Pin,Priority,UserID,GroupID,ProcessName
via Mirth Project by joe tilley, 1 year ago
A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (5,15) Waiting XID : {153691294, S} , APP, INSERT INTO MESSAGE (ID, SERVER_ID, CHANNEL_ID, SOURCE, TYPE, DATE_CREATED, VERSION
via Stack Overflow by user3274155
, 2 years ago
A lock could not be obtained within the time requested
via Stack Overflow by Miloš Lukačka
, 2 years ago
A lock could not be obtained within the time requested
via db-derby-user by Hong Ji, 1 year ago
A lock could not be obtained within the time requested
via JFrog JIRA by Laurent Tardif, 1 year ago
A lock could not be obtained within the time requested
java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (7,9) Waiting XID : {104576, S} , APP, INSERT INTO PROCESS_055234_HR (SampleTimestamp,CpuNum,Pin,Priority,UserID,GroupID,ProcessName,Volume,SubVol,FileName,AncestorProcessName,ProcBusyPercent) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Granted XID : {102377, S} Lock : ROW, SYSCONGLOMERATES, (7,8) Waiting XID : {102377, X} , APP, alter table "APP"."PROCESS_055234_HR" compress sequential Granted XID : {102377, S} , {104576, S} . The selected victim is XID : 104576.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:89)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2290)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPreparedStatement.java:151)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(EmbedPreparedStatement30.java:63)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(EmbedPreparedStatement40.java:40)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:107)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1615)
at com.idelji.operations.iasset.plugin.imon.dao.ProcessDAO.insertData(ProcessDAO.java:86)
at com.idelji.operations.iasset.plugin.imon.comm.CPUProcessDataStoreWriter.onData(CPUProcessDataStoreWriter.java:56)
at com.idelji.operations.iasset.plugin.imon.handler.CPUProcessDataHandler.gotData(CPUProcessDataHandler.java:205)
at com.idelji.operations.ibase.core.comm.Connector.makeRequest(Connector.java:83)
at com.idelji.operations.ibase.core.comm.EntityConnector.makeRequest(EntityConnector.java:36)
at com.idelji.operations.iasset.plugin.imon.comm.CPUProcessCommunicator.run(CPUProcessCommunicator.java:98)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.