You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Jim Newsham (JIRA)" <ji...@apache.org> on 2008/11/06 03:24:44 UTC

[jira] Created: (DERBY-3939) IllegalMonitorStateException in PreparedStatement.executeUpdate()

IllegalMonitorStateException in PreparedStatement.executeUpdate()
-----------------------------------------------------------------

                 Key: DERBY-3939
                 URL: https://issues.apache.org/jira/browse/DERBY-3939
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.4.2.0
         Environment: Windows XP, Sun Java 1.6.0_07, Embedded Derby

            Reporter: Jim Newsham


We received a bug report against our application.  The failure was in Derby, which threw a SQLException caused by an IllegalMonitorStateException.  This is the first time I have seen this error, so I do not have a reproducible case for it.  

I notice that there are a few reported Derby JIRA issues which involve IllegalMonitorStateException.  Those issues implicate the IBM 1.6 JVM, however I am using Sun 1.6 JVM.

The following log capture contains 2 log events.  The first event is an attempted insert into the database; it failed with IllegalMonitorStateException.  The second event is our application attempting to recover by rolling back the transaction; it failed with "java.sql.SQLNonTransientConnectionException: No current connection".

2008-10-31 13:44:42,328 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - transaction attempt failure
java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.javaException(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.EmbedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl$3.perform(DerbySampleBaseImpl.java:653)
	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3055)
	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
	at $Proxy21.insertSamples(Unknown Source)
	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
	... 26 more
Caused by: java.lang.IllegalMonitorStateException
	at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)
	at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
	at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
	at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
	at org.apache.derby.impl.store.access.btree.BTreeScan.next(Unknown Source)
	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
	... 19 more
2008-10-31 13:44:42,390 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - failed to roll back failed transaction
java.sql.SQLNonTransientConnectionException: No current connection.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3103)
	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
	at $Proxy21.insertSamples(Unknown Source)
	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: No current connection.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
	... 22 more


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (DERBY-3939) IllegalMonitorStateException in PreparedStatement.executeUpdate()

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12645756#action_12645756 ] 

Knut Anders Hatlen commented on DERBY-3939:
-------------------------------------------

> Caused by: java.lang.IllegalMonitorStateException
> at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)

That's strange. My understanding is that IllegalMonitorStateException is only thrown by wait/notify/notifyAll or similar methods, but there are no such calls in FileContainer.pageValid(). It would be great if you could try to reproduce it with a debug build so that we could see the exact line number where the exception is thrown.

> IllegalMonitorStateException in PreparedStatement.executeUpdate()
> -----------------------------------------------------------------
>
>                 Key: DERBY-3939
>                 URL: https://issues.apache.org/jira/browse/DERBY-3939
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.4.2.0
>         Environment: Windows XP, Sun Java 1.6.0_07, Embedded Derby
>            Reporter: Jim Newsham
>
> We received a bug report against our application.  The failure was in Derby, which threw a SQLException caused by an IllegalMonitorStateException.  This is the first time I have seen this error, so I do not have a reproducible case for it.  
> I notice that there are a few reported Derby JIRA issues which involve IllegalMonitorStateException.  Those issues implicate the IBM 1.6 JVM, however I am using Sun 1.6 JVM.
> The following log capture contains 2 log events.  The first event is an attempted insert into the database; it failed with IllegalMonitorStateException.  The second event is our application attempting to recover by rolling back the transaction; it failed with "java.sql.SQLNonTransientConnectionException: No current connection".
> 2008-10-31 13:44:42,328 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - transaction attempt failure
> java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.javaException(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.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl$3.perform(DerbySampleBaseImpl.java:653)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3055)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 26 more
> Caused by: java.lang.IllegalMonitorStateException
> 	at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.next(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 19 more
> 2008-10-31 13:44:42,390 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - failed to roll back failed transaction
> java.sql.SQLNonTransientConnectionException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3103)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 22 more

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (DERBY-3939) IllegalMonitorStateException in PreparedStatement.executeUpdate()

Posted by "Jim Newsham (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12706724#action_12706724 ] 

Jim Newsham commented on DERBY-3939:
------------------------------------

As suggested, we are now using a debug build of Derby so that we can provide more information if it happens again -- which it hasn't yet.  You can go ahead and close the issue for now and I'll reopen it if it happens again.  Thanks.

> IllegalMonitorStateException in PreparedStatement.executeUpdate()
> -----------------------------------------------------------------
>
>                 Key: DERBY-3939
>                 URL: https://issues.apache.org/jira/browse/DERBY-3939
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.4.2.0
>         Environment: Windows XP, Sun Java 1.6.0_07, Embedded Derby
>            Reporter: Jim Newsham
>
> We received a bug report against our application.  The failure was in Derby, which threw a SQLException caused by an IllegalMonitorStateException.  This is the first time I have seen this error, so I do not have a reproducible case for it.  
> I notice that there are a few reported Derby JIRA issues which involve IllegalMonitorStateException.  Those issues implicate the IBM 1.6 JVM, however I am using Sun 1.6 JVM.
> The following log capture contains 2 log events.  The first event is an attempted insert into the database; it failed with IllegalMonitorStateException.  The second event is our application attempting to recover by rolling back the transaction; it failed with "java.sql.SQLNonTransientConnectionException: No current connection".
> 2008-10-31 13:44:42,328 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - transaction attempt failure
> java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.javaException(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.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl$3.perform(DerbySampleBaseImpl.java:653)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3055)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 26 more
> Caused by: java.lang.IllegalMonitorStateException
> 	at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.next(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 19 more
> 2008-10-31 13:44:42,390 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - failed to roll back failed transaction
> java.sql.SQLNonTransientConnectionException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3103)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 22 more

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DERBY-3939) IllegalMonitorStateException in PreparedStatement.executeUpdate()

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3939:
----------------------------------

    Component/s: Store

> IllegalMonitorStateException in PreparedStatement.executeUpdate()
> -----------------------------------------------------------------
>
>                 Key: DERBY-3939
>                 URL: https://issues.apache.org/jira/browse/DERBY-3939
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.4.2.0
>         Environment: Windows XP, Sun Java 1.6.0_07, Embedded Derby
>            Reporter: Jim Newsham
>
> We received a bug report against our application.  The failure was in Derby, which threw a SQLException caused by an IllegalMonitorStateException.  This is the first time I have seen this error, so I do not have a reproducible case for it.  
> I notice that there are a few reported Derby JIRA issues which involve IllegalMonitorStateException.  Those issues implicate the IBM 1.6 JVM, however I am using Sun 1.6 JVM.
> The following log capture contains 2 log events.  The first event is an attempted insert into the database; it failed with IllegalMonitorStateException.  The second event is our application attempting to recover by rolling back the transaction; it failed with "java.sql.SQLNonTransientConnectionException: No current connection".
> 2008-10-31 13:44:42,328 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - transaction attempt failure
> java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.javaException(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.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl$3.perform(DerbySampleBaseImpl.java:653)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3055)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 26 more
> Caused by: java.lang.IllegalMonitorStateException
> 	at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.next(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 19 more
> 2008-10-31 13:44:42,390 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - failed to roll back failed transaction
> java.sql.SQLNonTransientConnectionException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3103)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 22 more

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Closed: (DERBY-3939) IllegalMonitorStateException in PreparedStatement.executeUpdate()

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden closed DERBY-3939.
---------------------------------

    Resolution: Cannot Reproduce

Closing CNR. User will reopen if it occurs again.


> IllegalMonitorStateException in PreparedStatement.executeUpdate()
> -----------------------------------------------------------------
>
>                 Key: DERBY-3939
>                 URL: https://issues.apache.org/jira/browse/DERBY-3939
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.4.2.0
>         Environment: Windows XP, Sun Java 1.6.0_07, Embedded Derby
>            Reporter: Jim Newsham
>
> We received a bug report against our application.  The failure was in Derby, which threw a SQLException caused by an IllegalMonitorStateException.  This is the first time I have seen this error, so I do not have a reproducible case for it.  
> I notice that there are a few reported Derby JIRA issues which involve IllegalMonitorStateException.  Those issues implicate the IBM 1.6 JVM, however I am using Sun 1.6 JVM.
> The following log capture contains 2 log events.  The first event is an attempted insert into the database; it failed with IllegalMonitorStateException.  The second event is our application attempting to recover by rolling back the transaction; it failed with "java.sql.SQLNonTransientConnectionException: No current connection".
> 2008-10-31 13:44:42,328 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - transaction attempt failure
> java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.javaException(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.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl$3.perform(DerbySampleBaseImpl.java:653)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3055)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 26 more
> Caused by: java.lang.IllegalMonitorStateException
> 	at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.next(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 19 more
> 2008-10-31 13:44:42,390 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - failed to roll back failed transaction
> java.sql.SQLNonTransientConnectionException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3103)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 22 more

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (DERBY-3939) IllegalMonitorStateException in PreparedStatement.executeUpdate()

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12706668#action_12706668 ] 

Kathey Marsden commented on DERBY-3939:
---------------------------------------

Was there any luck getting a reproduction for this issue. If not I suggest we close it cannot reproduce. If a reproduction is found we can reopen.


> IllegalMonitorStateException in PreparedStatement.executeUpdate()
> -----------------------------------------------------------------
>
>                 Key: DERBY-3939
>                 URL: https://issues.apache.org/jira/browse/DERBY-3939
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.4.2.0
>         Environment: Windows XP, Sun Java 1.6.0_07, Embedded Derby
>            Reporter: Jim Newsham
>
> We received a bug report against our application.  The failure was in Derby, which threw a SQLException caused by an IllegalMonitorStateException.  This is the first time I have seen this error, so I do not have a reproducible case for it.  
> I notice that there are a few reported Derby JIRA issues which involve IllegalMonitorStateException.  Those issues implicate the IBM 1.6 JVM, however I am using Sun 1.6 JVM.
> The following log capture contains 2 log events.  The first event is an attempted insert into the database; it failed with IllegalMonitorStateException.  The second event is our application attempting to recover by rolling back the transaction; it failed with "java.sql.SQLNonTransientConnectionException: No current connection".
> 2008-10-31 13:44:42,328 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - transaction attempt failure
> java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.javaException(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.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl$3.perform(DerbySampleBaseImpl.java:653)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3055)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Java exception: ': java.lang.IllegalMonitorStateException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 26 more
> Caused by: java.lang.IllegalMonitorStateException
> 	at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
> 	at org.apache.derby.impl.store.access.btree.BTreeScan.next(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 19 more
> 2008-10-31 13:44:42,390 [PollController.PollerTask - 7204VXR-132] WARN  com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl - failed to roll back failed transaction
> java.sql.SQLNonTransientConnectionException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.performInTransaction(DerbySampleBaseImpl.java:3103)
> 	at com.referentia.sdf.monitor.samplebase.derby.DerbySampleBaseImpl.insertSamples(DerbySampleBaseImpl.java:608)
> 	at com.referentia.sdf.monitor.samplebase.util.WarnOnEdtSampleBase.insertSamples(WarnOnEdtSampleBase.java:159)
> 	at com.referentia.sdf.monitor.samplebase.derby.ManagedDerbySampleBase.insertSamples(ManagedDerbySampleBase.java:227)
> 	at com.referentia.sdf.monitor.samplebase.event.NotifyingSampleBaseImpl.insertSamples(NotifyingSampleBaseImpl.java:517)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.referentia.sdf.commons.lang.reflect.RetargettableProxy$Handler.invoke(RetargettableProxy.java:235)
> 	at $Proxy21.insertSamples(Unknown Source)
> 	at com.referentia.sdf.monitor.db.DBManagement.insertStartOrStop(DBManagement.java:183)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.perform(PollController.java:484)
> 	at com.referentia.sdf.monitor.PollController$PollerTask.run(PollController.java:450)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 22 more

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.