[DERBY-6149] Long wait when 10.8 lang.SequenceGeneratorTest is run against 10.10 jars

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 10.10.1.1
• Component/s: Test
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 03/Apr/13 15:51
• Updated: 03/Sep/14 08:31
• Resolved: 01/May/13 20:38

Description

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

Issue Links

• relates to: DERBY-6150 Add automatic cleanup of connections opened with openDefaultConnection()