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 "Marco (JIRA)" <ji...@apache.org> on 2014/02/15 10:55:19 UTC

[jira] [Comment Edited] (DERBY-6175) testComparisonAcrossPages failure - java.sql.SQLNonTransientConnectionException: No current connection.

    [ https://issues.apache.org/jira/browse/DERBY-6175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13902369#comment-13902369 ] 

Marco edited comment on DERBY-6175 at 2/15/14 9:54 AM:
-------------------------------------------------------

I'm experiencing the same problem with Derby 10.10.1.1 - sometimes. Here's a link with more details: https://github.com/cloudstore/main/issues/10

I'm using Derby with DataNucleus and first there occurs an error concerning a duplicate column (which does not exist at all in this table ["repofile"], though!!!):

Caused by: org.apache.derby.iapi.error.StandardException: Column 'PARAM1' already exists.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.10.1.1.jar:na]
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown Source) ~[derby-10.10.1.1.jar:na]
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown Source) ~[derby-10.10.1.1.jar:na]

My software then closes the connection (shutting down the DataNucleus PersistenceManagerFactory AND Derby with ";shutdown=true" appended to the connection URL) and then retries the process.

During the retries (more than once!) the "No current connection." exception occurs (again and again - retrying multiple times seems not to help).

The error happens only very rarely on our (pretty slow) build server (GNU/Linux [Ubuntu server 12.04] with Oracle JDK 7). It happens far more often on my (very fast) notebook (GNU/Linux [Kubuntu 13.10] with OpenJDK 7).


was (Author: nlmarco):
I'm experiencing the same problem with Derby 10.10.1.1 - sometimes. Here's a link with more details: https://github.com/cloudstore/main/issues/10

I'm using Derby with DataNucleus and first there occurs an error concerning a duplicate column (which does not exist at all in this table ["repofile"], though!!!):

Caused by: org.apache.derby.iapi.error.StandardException: Column 'PARAM1' already exists.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.10.1.1.jar:na]
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown Source) ~[derby-10.10.1.1.jar:na]
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown Source) ~[derby-10.10.1.1.jar:na]

My software then closes the connection (shutting down the DataNucleus PersistenceManagerFactory AND Derby with ";shutdown=true" appended to the connection URL) and then retries the process.

During the retries (more than once!) the "No current connection." exception occurs (again and again - retrying multiple times seems not to help).

> 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.1.5#6160)