java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : TABLE, PROCESS_055234_HR, Tablelock Waiting XID : {104215, IS} , APP, SELECT CpuNum, SampleTimestamp AS TimeStamp, ProcBusyPercent AS BusyPercent FROM PROCESS_055234_HR WHERE SampleTimestamp >= ? AND Volume=? AND Subvol=? AND Filename=? AND ProcessName=? AND CpuNum=? AND PIN=? ORDER BY SampleTimestamp Granted XID : {102377, X} Lock : ROW, SYSCONGLOMERATES, (7,9) Waiting XID : {102377, X} , APP, alter table "APP"."PROCESS_055234_HR" compress sequential Granted XID : {102377, S} , {104215, S} . The selected victim is XID : 104215.

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

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 : TABLE, PROCESS_055234_HR, Tablelock Waiting XID : {104215, IS} , APP, SELECT CpuNum, SampleTimestamp AS TimeStamp, ProcBusyPercent AS BusyPercent FROM
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 db-derby-user by Hong Ji, 1 year 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 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 : TABLE, PROCESS_055234_HR, Tablelock Waiting XID : {104215, IS} , APP, SELECT CpuNum, SampleTimestamp AS TimeStamp, ProcBusyPercent AS BusyPercent FROM PROCESS_055234_HR WHERE SampleTimestamp >= ? AND Volume=? AND Subvol=? AND Filename=? AND ProcessName=? AND CpuNum=? AND PIN=? ORDER BY SampleTimestamp Granted XID : {102377, X} Lock : ROW, SYSCONGLOMERATES, (7,9) Waiting XID : {102377, X} , APP, alter table "APP"."PROCESS_055234_HR" compress sequential Granted XID : {102377, S} , {104215, S} . The selected victim is XID : 104215.
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.getLastRecordFromIntervalTableShowGap(ProcessDAO.java:503)
at imon.utils.DataSourceRouter.getLatestProcessData(DataSourceRouter.java:608)
at imon.db.ProcessDataProvider.getLatestData(ProcessDataProvider.java:131)
at imon.charts.LineChartWithSlider.refreshChartData(LineChartWithSlider.java:558)
at imon.charts.LineChartWithSlider$1.handle(LineChartWithSlider.java:327)
at imon.charts.LineChartWithSlider$1.handle(LineChartWithSlider.java:322)
at com.sun.scenario.animation.shared.TimelineClipCore.visitKeyFrame(TimelineClipCore.java:196)
at com.sun.scenario.animation.shared.TimelineClipCore.playTo(TimelineClipCore.java:137)
at javafx.animation.Timeline.impl_playTo(Timeline.java:163)
at com.sun.scenario.animation.shared.InfiniteClipEnvelope.timePulse(InfiniteClipEnvelope.java:89)
at javafx.animation.Animation.impl_timePulse(Animation.java:952)
at com.sun.scenario.animation.shared.AnimationPulseReceiver.timePulse(AnimationPulseReceiver.java:75)
at com.sun.scenario.animation.AbstractMasterTimer.timePulseImpl(AbstractMasterTimer.java:357)
at com.sun.javafx.tk.quantum.QuantumToolkit.pulse(QuantumToolkit.java:381)
at com.sun.javafx.tk.quantum.QuantumToolkit$8.run(QuantumToolkit.java:311)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.access$100(WinApplication.java:29)
at com.sun.glass.ui.win.WinApplication$2$1.run(WinApplication.java:62)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

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