Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 19 Jul 2013 21:10:49 +0000 (UTC)
From: "ASF subversion and git services (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12655383.1372438478336.83769.1374268249027@arcas>
In-Reply-To: <JIRA.12655383.1372438478336@arcas>
References: <JIRA.12655383.1372438478336@arcas>
Subject: [jira] [Commented] (DERBY-6283) indexStat daemon processing tables
 over and over even when there are no changes in the tables in soft upgraded
 database.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-6283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13714076#comment-13714076 ] 

ASF subversion and git services commented on DERBY-6283:
--------------------------------------------------------

Commit 1505021 from mikem@apache.org in branch 'code/branches/10'
[ https://svn.apache.org/r1505021 ]

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

backported change #1502319 from trunk to 10.8, some manual merging was
required.

Changed system to always drop orphaned stats during update statistics call.

Without this change soft upgraded systems running on 10.8 or higher derby
software, that had an orphaned statistic would spin forever in the index
stat daemon due to the same problem fixed by DERBY-5680 for hard
upgraded databases.
                
> 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