Mike Matrigali created DERBY-6283:
-------------------------------------
Summary: indexStat daemon processing tables over and over even
when there are no changes in the tables in soft upgraded database.
Key: DERBY-6283
URL: https://issues.apache.org/jira/browse/DERBY-6283
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.8.3.1, 10.9.2.2, 10.10.1.3, 10.11.0.0
Reporter: Mike Matrigali
Priority: Blocker
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
