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

SQLState.LANG_IGNORE_MISSING_INDEX_ROW_DURING_DELETE during NsTest run

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • 10.4.2.0, 10.5.1.1, 10.6.1.0
    • None
    • Store
    • None
    • Suse Linux 10, IBM 1.6 SR4

    Description

      During the NsTest runs for 10.5.1.0 and 10.5.1.1 I initially ignored warnings showing up in the server's derby.log file:

      WARNING: While deleting a row from a table the index row for base table row (594,12) was not found in index with conglomerate id 1,185. This problem has automatically been corrected as part of the delete operation.

      However, I don't think this is a completely healthy warning, I think it indicates there was corruption in the index.
      I'll investigate further.

      Attachments

        1. derby.log
          40 kB
          Mike Matrigali
        2. derby.properties
          1 kB
          Mike Matrigali
        3. derby4181debug.diff
          3 kB
          Mike Matrigali
        4. log_excerpt_sample_assert.txt
          5 kB
          Katherine Marsden
        5. ReproDerby4181.derby.log
          258 kB
          Katherine Marsden
        6. ReproDerby4181.java
          2 kB
          Katherine Marsden
        7. ReproDerby4181.java
          5 kB
          Katherine Marsden
        8. ReproDerby4181.out
          158 kB
          Katherine Marsden
        9. run1serverlog.jar
          13 kB
          Myrna van Lunteren
        10. serverlog.jar
          6.13 MB
          Myrna van Lunteren

        Activity

          People

            kmarsden Katherine Marsden
            myrna Myrna van Lunteren
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: