Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6149

Long wait when 10.8 lang.SequenceGeneratorTest is run against 10.10 jars

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: None
    • Component/s: Test
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                kmarsden Katherine Marsden
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: