[
https://issues.apache.org/jira/browse/DERBY-6175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13937502#comment-13937502
]
Marco commented on DERBY-6175:
------------------------------
Maybe I found sth. interesting:
The above exception excerpt occurs in the log at this time:
2014-03-17 06:40:21,436 [main] INFO c.c.c.c.SyncSubCommand - Local sync...:
72.00%
2014-03-17 06:40:33,511 [main] INFO c.c.c.c.SyncSubCommand - Local sync...:
72.07%
2014-03-17 06:40:38,512 [main] INFO c.c.c.c.SyncSubCommand - Local sync...:
72.15%
2014-03-17 06:46:53,825 [main] ERROR D.D.Persist - Update of object
"co.codewizards.cloudstore.core.persistence.NormalFile@7045fc09" using
statement "UPDATE "repofile" SET "changed"=?,"lastmodified"=?,"sha1"=? WHERE
"id"=?" failed : java.sql.SQLNonTransientConnectionException: No current
connection.
As you can see, I (currently) do not log the SHA1 generation and I do not log
details like DB operations, hence it's pretty silent before, but I can tell you
that the SHA1 generation takes a while and therefore the following
*NullPointerException* logged in my derby.log at 06:40:25 might very well be
the actual cause of this error:
----------------------------------------------------------------
Mon Mar 17 06:38:59 CET 2014:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.10.1.1
- (1458268): instance a816c00e-0144-ce8c-d33d-000003e878f0
on database directory /media/crypt/svn/_meta_/.cloudstore-repo/derby with class
loader sun.misc.Launcher$AppClassLoader@12504e0
Loaded from file:/opt/cloudstore/lib/derby-10.10.1.1.jar
java.vendor=Oracle Corporation
java.runtime.version=1.7.0_51-b00
user.dir=/home/user
os.name=Linux
os.arch=amd64
os.version=3.2.0-59-generic
derby.system.home=null
derby.stream.error.file=/home/user/.cloudstore/log/derby.log
Database Class Loader started - derby.database.classpath=''
Warning: While deleting a row from a table the index row for base table row
(87,167) was not found in index with conglomerate id 1,585. This problem has
automatically been corrected as part of the delete operation.
Mon Mar 17 06:40:25 CET 2014 Thread[main,5,main] (XID = 274517), (SESSIONID =
3), (DATABASE = /media/crypt/svn/_meta_/.cloudstore-repo/derby), (DRDAID =
null), Cleanup action starting
Mon Mar 17 06:40:25 CET 2014 Thread[main,5,main] (XID = 274517), (SESSIONID =
3), (DATABASE = /media/crypt/svn/_meta_/.cloudstore-repo/derby), (DRDAID =
null), Failed Statement is: INSERT INTO "filechunk"
("created","normalfile_id_oid","changed","length","sha1","offset") VALUES
(?,?,?,?,?,?) with 6 parameters begin parameter #1: 2014-03-17 05:40:25.715
:end parameter begin parameter #2: 5 :end parameter begin parameter #3:
2014-03-17 05:40:25.734 :end parameter begin parameter #4: 1048576 :end
parameter begin parameter #5: fef76b5620f611b44da053e4e6285c91d8aa3048 :end
parameter begin parameter #6: 1782579200 :end parameter
java.lang.NullPointerException
at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source)
at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(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.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(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.executeLargeUpdate(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.datanucleus.store.rdbms.datasource.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.datanucleus.store.rdbms.datasource.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeUpdate(ParamLoggingPreparedStatement.java:399)
at
org.datanucleus.store.rdbms.SQLController.executeStatementUpdate(SQLController.java:439)
at
org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:410)
at
org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertTable(RDBMSPersistenceHandler.java:167)
at
org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:143)
at
org.datanucleus.state.JDOStateManager.internalMakePersistent(JDOStateManager.java:3784)
at
org.datanucleus.state.JDOStateManager.makePersistent(JDOStateManager.java:3760)
at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2219)
at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2320)
at
org.datanucleus.store.types.SCOUtils.validateObjectForWriting(SCOUtils.java:1352)
at
org.datanucleus.store.rdbms.scostore.ElementContainerStore.validateElementForWriting(ElementContainerStore.java:365)
at
org.datanucleus.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:438)
at org.datanucleus.store.types.backed.Set.add(Set.java:614)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoSync.sha(LocalRepoSync.java:497)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoSync.updateRepoFile(LocalRepoSync.java:253)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoSync.sync(LocalRepoSync.java:128)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoSync.sync(LocalRepoSync.java:139)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoSync.sync(LocalRepoSync.java:139)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoSync.sync(LocalRepoSync.java:68)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoManagerImpl.localSync(LocalRepoManagerImpl.java:666)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
co.codewizards.cloudstore.core.repo.local.LocalRepoManagerInvocationHandler.invoke(LocalRepoManagerInvocationHandler.java:61)
at com.sun.proxy.$Proxy17.localSync(Unknown Source)
at
co.codewizards.cloudstore.client.SyncSubCommand.sync(SyncSubCommand.java:90)
at
co.codewizards.cloudstore.client.SyncSubCommand.run(SyncSubCommand.java:75)
at
co.codewizards.cloudstore.client.CloudStoreClient.execute(CloudStoreClient.java:187)
at
co.codewizards.cloudstore.client.CloudStoreClient.main(CloudStoreClient.java:145)
Cleanup action completed
----------------------------------------------------------------
> testComparisonAcrossPages failure -
> java.sql.SQLNonTransientConnectionException: No current connection.
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6175
> URL: https://issues.apache.org/jira/browse/DERBY-6175
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.10.1.4
> Reporter: Mamta A. Satoor
>
> Failure on 10.10.1.2(1466316) windows machine with IBM 1.7
> http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1466316-suites.All_diff.txt
> 1)
> testComparisonAcrossPages(org.apache.derbyTesting.functionTests.tests.lang.NullableUniqueConstraintTest)java.sql.SQLNonTransientConnectionException:
> No current connection.
> at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.PreparedStatement.setString(Unknown
> Source)
> at
> org.apache.derbyTesting.functionTests.tests.lang.NullableUniqueConstraintTest.testComparisonAcrossPages(NullableUniqueConstraintTest.java:393)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:442)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:459)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: org.apache.derby.client.am.SqlException: No current connection.
> at org.apache.derby.client.am.Statement.checkForClosedStatement(Unknown
> Source)
> at
> org.apache.derby.client.am.PreparedStatement.getColumnMetaDataX(Unknown
> Source)
> ... 46 more
--
This message was sent by Atlassian JIRA
(v6.2#6252)
