You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <ji...@apache.org> on 2016/02/21 19:49:18 UTC

[jira] [Created] (DERBY-6873) hand btree rebalance case when it can't get table level lock.

Mike Matrigali created DERBY-6873:
-------------------------------------

             Summary: hand btree rebalance case when it can't get table level lock.
                 Key: DERBY-6873
                 URL: https://issues.apache.org/jira/browse/DERBY-6873
             Project: Derby
          Issue Type: Improvement
            Reporter: Mike Matrigali


current implementation of btree requires table level lock on index to rebalance.  This can result in inefficient tree structure if lock can not
be obtained and if post commit retry also fails.  Similar to other problems
if post commit retry does not succeed.

May also leave unreclaimed space that could be reclaimed.

Work around is to run compress on the table in offline mode.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)