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

indexStat daemon processing tables over and over even when there are no changes in the tables in soft upgraded database.

    XMLWordPrintableJSON

    Details

    • Issue & fix info:
      High Value Fix, Patch Available
    • Bug behavior facts:
      Performance

      Description

      The fix for DERBY-5680 currently requires hard upgrade. A soft upgrade database with an orphaned stat row, that can be caused by something like DERBY-5681, will cause DERBY to spin eating up 100% of a cpu and possibly all the disk bandwith of the disk where the database is located.

      We should implement a fix that can be applied to soft upgraded databases if at all possible.

      In soft upgraded databases we can no use the work around of dropping the statistics as it is not available
      to soft upgraded db's with version < 10.9. The only current workaround is to disable background stats
      completely. Dropping and recreating the suspect table may also work.

        Attachments

        1. derby-6283.diff
          13 kB
          Mike Matrigali

          Issue Links

            Activity

              People

              • Assignee:
                mikem Mike Matrigali
                Reporter:
                mikem Mike Matrigali
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: