[
https://issues.apache.org/jira/browse/DERBY-6149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13621014#comment-13621014
]
Kathey Marsden commented on DERBY-6149:
---------------------------------------
Actually after a long wait the test did complete and seems to be due to lock
timeouts dropping the schema. Below is the full test output. It seems maybe
the test uses internal interfaces and checks specific values we don't expect
users to check. I am not sure if the failures themselves are something to
worry about but I will try to fix the drop so 10.10 upgrade and compatibility
testing can advance.
DEBUG: {TC@55923149} basePort=1630, bogusPort=1631, jmxPort=1632
DEBUG: {TC@55937944} basePort=1630, bogusPort=1631, jmxPort=1633
.
test_01_basic DEBUG: Preparing statement:
create sequence seq_01
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_01 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 723 ms F.
test_02_boundary used 323 ms E.
test_03_nonCycling used 315 ms E.
test_04_reboot DEBUG: Preparing statement:
create sequence seq_04
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_04 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 383 ms F.
test_05_concurrency DEBUG: Preparing statement:
create sequence seq_05
DEBUG: Preparing statement:
grant usage on sequence seq_05 to public
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_05 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 427 ms F.
test_06_bigStepSize used 306 ms E.
test_07_dropSequence DEBUG: Preparing statement:
create sequence seq_07
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_07 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 330 ms FE
Time: 307.371
There were 4 errors:
1)
test_02_boundary(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)java.lang.NoSuchMethodError:
org/apache/derby/impl/sql/catalog/SequenceGenerator.<init>(Ljava/lang/Long;ZJJJJLjava/lang/String;)V
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest$T_SequenceUpdater.<init>(SequenceGeneratorTest.java:648)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_02_boundary(SequenceGeneratorTest.java:183)
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:110)
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
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extenDEBUG: {TC@55923149} basePort=1630, bogusPort=1631,
jmxPort=1632
DEBUG: {TC@55937944} basePort=1630, bogusPort=1631, jmxPort=1633
.
test_01_basic DEBUG: Preparing statement:
create sequence seq_01
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_01 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 723 ms F.
test_02_boundary used 323 ms E.
test_03_nonCycling used 315 ms E.
test_04_reboot DEBUG: Preparing statement:
create sequence seq_04
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_04 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 383 ms F.
test_05_concurrency DEBUG: Preparing statement:
create sequence seq_05
DEBUG: Preparing statement:
grant usage on sequence seq_05 to public
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_05 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 427 ms F.
test_06_bigStepSize used 306 ms E.
test_07_dropSequence DEBUG: Preparing statement:
create sequence seq_07
DEBUG: Preparing statement:
values( next value for TEST_DBO.SEQ_07 )
DEBUG: Preparing statement:
select currentvalue from sys.syssequences seq, sys.sysschemas s where
s.schemaname = ? and seq.sequencename = ? and s.schemaid = seq.schemaid
used 330 ms FE
Time: 307.371
There were 4 errors:
1)
test_02_boundary(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)java.lang.NoSuchMethodError:
org/apache/derby/impl/sql/catalog/SequenceGenerator.<init>(Ljava/lang/Long;ZJJJJLjava/lang/String;)V
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest$T_SequenceUpdater.<init>(SequenceGeneratorTest.java:648)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_02_boundary(SequenceGeneratorTest.java:183)
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:110)
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
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)
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)
2)
test_03_nonCycling(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)java.lang.NoSuchMethodError:
org/apache/derby/impl/sql/catalog/SequenceGenerator.<init>(Ljava/lang/Long;ZJJJJLjava/lang/String;)V
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest$T_SequenceUpdater.<init>(SequenceGeneratorTest.java:648)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.vetNonCycling(SequenceGeneratorTest.java:388)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.vetNonCycling(SequenceGeneratorTest.java:360)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_03_nonCycling(SequenceGeneratorTest.java:349)
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:110)
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
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)
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)
3)
test_06_bigStepSize(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)java.lang.NoSuchMethodError:
org/apache/derby/impl/sql/catalog/SequenceGenerator.<init>(Ljava/lang/Long;ZJJJJLjava/lang/String;)V
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest$T_SequenceUpdater.<init>(SequenceGeneratorTest.java:648)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_06_bigStepSize(SequenceGeneratorTest.java:479)
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:110)
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
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)
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)
4) SequenceGeneratorTest:embeddedjava.sql.SQLTransactionRollbackException: A
lock could not be obtained within the time requested
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(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.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown
Source)
at org.apache.derbyTesting.junit.JDBC.dropSchema(JDBC.java:358)
at
org.apache.derbyTesting.junit.CleanDatabaseTestSetup.removeObjects(CleanDatabaseTestSetup.java:231)
at
org.apache.derbyTesting.junit.CleanDatabaseTestSetup.cleanDatabase(CleanDatabaseTestSetup.java:164)
at
org.apache.derbyTesting.junit.CleanDatabaseTestSetup.tearDown(CleanDatabaseTestSetup.java:151)
at junit.extensions.TestSetup$1.protect(TestSetup.java:22)
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
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)
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)
Caused by: java.sql.SQLException: A lock could not be obtained within the time
requested
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 48 more
Caused by: ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown
Source)
at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown
Source)
at
org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source)
at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown
Source)
at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown
Source)
at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSchemaDescriptor(Unknown
Source)
at org.apache.derby.iapi.sql.dictionary.SchemaDescriptor.drop(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DropSchemaConstantAction.executeConstantAction(Unknown
Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 42 more
There were 4 failures:
1)
test_01_basic(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)junit.framework.AssertionFailedError:
expected:<-2147483643> but was:<-2147483548>
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.vetBumping(SequenceGeneratorTest.java:171)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_01_basic(SequenceGeneratorTest.java:140)
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:110)
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
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)
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)
2)
test_04_reboot(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)junit.framework.AssertionFailedError:
expected:<-2147483643> but was:<-2147483548>
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.vetBumping(SequenceGeneratorTest.java:171)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_04_reboot(SequenceGeneratorTest.java:415)
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:110)
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
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)
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)
3)
test_05_concurrency(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)junit.framework.AssertionFailedError:
expected:<-2147483643> but was:<-2147483548>
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.vetBumping(SequenceGeneratorTest.java:171)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_05_concurrency(SequenceGeneratorTest.java:462)
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:110)
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
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)
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)
4)
test_07_dropSequence(org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest)junit.framework.AssertionFailedError:
expected:<-2147483643> but was:<-2147483548>
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.vetBumping(SequenceGeneratorTest.java:171)
at
org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.test_07_dropSequence(SequenceGeneratorTest.java:532)
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:110)
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
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)
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)
FAILURES!!!
Tests run: 7, Failures: 4, Errors: 4
> Long wait when 10.8 lang.SequenceGeneratorTest is run against 10.10 jars
> -------------------------------------------------------------------------
>
> Key: DERBY-6149
> URL: https://issues.apache.org/jira/browse/DERBY-6149
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.10.1.1
> Reporter: Kathey Marsden
>
> Using the 10.8 testing jar and the 10.10 product jars the 10.8 test
> lang.SequenceGeneratorTest has multiple failures and then hangs after
> test_07_dropSequence fails.
> To reproduce put the 10.8 derbyTesting.jar (latest on 10.8 branch) and
> 10.10.1.1 product jars in your classpath and run the junit test
> org.apache.derbyTesting.functionTests.tests.lang.SequenceGeneratorTest.
> ++ java -Xmx512M -Xms512M -Dderby.tests.debug=true -Dderby.tests.trace=true
> -Dderby.tests.basePort=1630 '-DderbyTesting.
> oldReleasePath=C:\cygwin\svnreleases\jars' junit.textui.TestRunner
> org.apache.derbyTesting.functionTests.tests.lang.Sequ
> enceGeneratorTest
> ++ tee rju.out
> DEBUG: {TC@55923149} basePort=1630, bogusPort=1631, jmxPort=1632
> DEBUG: {TC@55937944} basePort=1630, bogusPort=1631, jmxPort=1633
> .
> test_01_basic DEBUG: Preparing statement:
> create sequence seq_01
> DEBUG: Preparing statement:
> select currentvalue from sys.syssequences seq, sys.sysschemas s where
> s.schemaname = ? and seq.sequencename = ?
> and s.schemaid = seq.schemaid
> DEBUG: Preparing statement:
> values( next value for TEST_DBO.SEQ_01 )
> DEBUG: Preparing statement:
> select currentvalue from sys.syssequences seq, sys.sysschemas s where
> s.schemaname = ? and seq.sequencename = ?
> and s.schemaid = seq.schemaid
> used 723 ms F.
> test_02_boundary used 323 ms E.
> test_03_nonCycling used 315 ms E.
> test_04_reboot DEBUG: Preparing statement:
> create sequence seq_04
> DEBUG: Preparing statement:
> values( next value for TEST_DBO.SEQ_04 )
> DEBUG: Preparing statement:
> select currentvalue from sys.syssequences seq, sys.sysschemas s where
> s.schemaname = ? and seq.sequencename = ?
> and s.schemaid = seq.schemaid
> used 383 ms F.
> test_05_concurrency DEBUG: Preparing statement:
> create sequence seq_05
> DEBUG: Preparing statement:
> grant usage on sequence seq_05 to public
> DEBUG: Preparing statement:
> values( next value for TEST_DBO.SEQ_05 )
> DEBUG: Preparing statement:
> select currentvalue from sys.syssequences seq, sys.sysschemas s where
> s.schemaname = ? and seq.sequencename = ?
> and s.schemaid = seq.schemaid
> used 427 ms F.
> test_06_bigStepSize used 306 ms E.
> test_07_dropSequence DEBUG: Preparing statement:
> create sequence seq_07
> DEBUG: Preparing statement:
> values( next value for TEST_DBO.SEQ_07 )
> DEBUG: Preparing statement:
> select currentvalue from sys.syssequences seq, sys.sysschemas s where
> s.schemaname = ? and seq.sequencename = ?
> and s.schemaid = seq.schemaid
> used 330 ms F
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
