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.

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

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development