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 "Kathey Marsden (JIRA)" <ji...@apache.org> on 2009/05/07 01:52:30 UTC

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

    [ 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.