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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • 10.10.1.1
    • None
    • Test
    • 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

              Unassigned Unassigned
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: