[
https://issues.apache.org/jira/browse/DERBY-6283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mike Matrigali updated DERBY-6283:
----------------------------------
Attachment: derby-6283.diff
This patch makes the system always delete orphaned stats,
even in soft upgrade mode.
Running full set of tests now on this patch. A previous patch with the same
code changes passed all tests except upgrade tests. just running the upgrade
tests passed also. I think I have fixed these by changes to the test to make
it understand
that orphaned stats are not deleted in soft upgrade.
> 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
> Assignee: Mike Matrigali
> Priority: Blocker
> Labels: derby_triage10_11
> Attachments: derby-6283.diff
>
>
> 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
