Quantcast

Puzzling error

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Puzzling error

Donald McLean-3
I am running Derby 10.12.1.1 under Java 1.8.0u102.

I am getting an exception trying to delete a record that I added not long before (as part of a unit test) (see stack trace below).

Any thoughts, hints, or ideas as to what I'm doing wrong would really be appreciated.

Thank you,

Donald
Caused by: java.sql.SQLException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby.jar:na]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) ~[hibernate-core-5.0.5.Final.jar:5.0.5.Final]
... 36 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby.jar:na]
... 48 common frames omitted
Caused by: java.io.FileNotFoundException: /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp (No such file or directory)
at java.io.RandomAccessFile.open0(Native Method) ~[na:1.8.0_102]
at java.io.RandomAccessFile.open(RandomAccessFile.java:316) ~[na:1.8.0_102]
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:243) ~[na:1.8.0_102]
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.io.DirFile.getRandomAccessFile(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source) ~[derby.jar:na]
at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_102]
at org.apache.derby.impl.store.raw.data.RAFContainer.createContainer(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.data.FileContainer.createIdent(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.data.FileContainer.createIdentity(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.addContainer(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.xact.Xact.addContainer(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.access.heap.Heap.create(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.createConglomerate(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.store.access.RAMTransaction.createConglomerate(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.execute.TemporaryRowHolderImpl.insert(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby.jar:na]
... 41 common frames omitted

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Puzzling error

Bryan Pendleton-3
> I am getting an exception trying to delete a record that I added not long before (as part of a unit test)

Sometimes unit test frameworks do really clever things, too clever in fact.

For example, I've seen unit test frameworks for database applications which
have automatically "cleanup" code which completely removes the entire
directory tree which was being used by the test, in order to release
the disk space and prevent clutter from accumulating.

Only, it turned out that the framework removed the folder tree while the
test was still running.

One thing you can do to try to get more information is to make sure
you are getting the *full* exception trace, not the abbeviated one. See:

        http://wiki.apache.org/db-derby/UnwindExceptionChain

Another thing you might try is to run your unit tests with Derby
configured so that it has logStatementText=true, and then look at your
derby.log after the test runs to get a better idea about how far your
test ran, and what was going on just before the failure.

bryan

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Puzzling error

Rick Hillegas-3
In reply to this post by Donald McLean-3
On 8/4/16, 7:32 AM, Donald McLean wrote:

> I am running Derby 10.12.1.1 under Java 1.8.0u102.
>
> I am getting an exception trying to delete a record that I added not
> long before (as part of a unit test) (see stack trace below).
>
> Any thoughts, hints, or ideas as to what I'm doing wrong would really
> be appreciated.
>
> Thank you,
>
> Donald
> Caused by: java.sql.SQLException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
>     at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby.jar:na]
>     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) ~[hibernate-core-5.0.5.Final.jar:5.0.5.Final]
>     ... 36 common frames omitted
> Caused by: org.apache.derby.iapi.error.StandardException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
>     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby.jar:na]
>     ... 48 common frames omitted
> Caused by: java.io.FileNotFoundException: /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp (No such file or directory)
>     at java.io.RandomAccessFile.open0(Native Method) ~[na:1.8.0_102]
>     at java.io.RandomAccessFile.open(RandomAccessFile.java:316) ~[na:1.8.0_102]
>     at java.io.RandomAccessFile.<init>(RandomAccessFile.java:243) ~[na:1.8.0_102]
>     at org.apache.derby.impl.io.DirRandomAccessFile.<init>(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.io.DirFile.getRandomAccessFile(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source) ~[derby.jar:na]
>     at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_102]
>     at org.apache.derby.impl.store.raw.data.RAFContainer.createContainer(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.raw.data.FileContainer.createIdent(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.raw.data.FileContainer.createIdentity(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.addContainer(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.raw.xact.Xact.addContainer(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.access.heap.Heap.create(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.createConglomerate(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.store.access.RAMTransaction.createConglomerate(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.sql.execute.TemporaryRowHolderImpl.insert(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby.jar:na]
>     at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby.jar:na]
>     ... 41 common frames omitted
>
Hi Donald,

Can you supply the schema and the offending statement? The stack trace
indicates an UPDATE statement, not a DELETE statement.

Thanks,
-Rick
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Puzzling error

John English-3
In reply to this post by Donald McLean-3
On 04/08/2016 17:32, Donald McLean wrote:
> Caused by: java.sql.SQLException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
> Caused by: java.io.FileNotFoundException: /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp (No such file or directory)

I presume you've already checked the directory permissions?
--
John English
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Puzzling error

mike matrigali
In reply to this post by Donald McLean-3
the problem is creating a tmp file for query execution, probably not with the file with the actual data.
i think derby does this when it needs to do deferred update, and some deferred constraint checking also.

as others have said check permissions/existence on
/Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp
On 8/4/2016 7:32 AM, Donald McLean wrote:
I am running Derby 10.12.1.1 under Java 1.8.0u102.

I am getting an exception trying to delete a record that I added not long before (as part of a unit test) (see stack trace below).

Any thoughts, hints, or ideas as to what I'm doing wrong would really be appreciated.

Thank you,

Donald
Caused by: java.sql.SQLException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby.jar:na]
   at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) ~[hibernate-core-5.0.5.Final.jar:5.0.5.Final]
   ... 36 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: Exception during creation of file /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp for container
   at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby.jar:na]
   ... 48 common frames omitted
Caused by: java.io.FileNotFoundException: /Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp (No such file or directory)
   at java.io.RandomAccessFile.open0(Native Method) ~[na:1.8.0_102]
   at java.io.RandomAccessFile.open(RandomAccessFile.java:316) ~[na:1.8.0_102]
   at java.io.RandomAccessFile.<init>(RandomAccessFile.java:243) ~[na:1.8.0_102]
   at org.apache.derby.impl.io.DirRandomAccessFile.<init>(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.io.DirFile.getRandomAccessFile(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source) ~[derby.jar:na]
   at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_102]
   at org.apache.derby.impl.store.raw.data.RAFContainer.createContainer(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.raw.data.FileContainer.createIdent(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.raw.data.FileContainer.createIdentity(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.addContainer(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.raw.xact.Xact.addContainer(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.access.heap.Heap.create(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.createConglomerate(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.store.access.RAMTransaction.createConglomerate(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.sql.execute.TemporaryRowHolderImpl.insert(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby.jar:na]
   at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby.jar:na]
   ... 41 common frames omitted



-- 
email:    Mike Matrigali - [hidden email]
linkedin: https://www.linkedin.com/in/MikeMatrigali 
Loading...