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

Same value returned by successive calls to a sequence generator flanking an unorderly shutdown.

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      High Value Fix, Known fix, Patch Available, Repro attached
    • Bug behavior facts:
      Deviation from standard

      Description

      The following sequence of steps causes a sequence generator to return the same value on successive NEXT VALUE FOR calls.

      1) Bring up ij and issue the following commands:

      connect 'jdbc:derby:db;create=true';

      create sequence s;
      values next value for s;

      2) Control-c out of ij so that the engine comes down hard without an orderly shutdown.

      3) Now bring up ij again and issue the following commands:

      connect 'jdbc:derby:db';

      values next value for s;

      Thanks to Knut for finding this one.

        Attachments

        1. derby-5494_diff_2.txt
          7 kB
          Mike Matrigali
        2. derby-5494_diff_1a.txt
          0.8 kB
          Mike Matrigali
        3. derby-5494_3.diff
          26 kB
          Mike Matrigali

          Issue Links

            Activity

              People

              • Assignee:
                mikem Mike Matrigali
                Reporter:
                rhillegas Rick Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: