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 "Olav Sandstaa (JIRA)" <ji...@apache.org> on 2008/02/05 13:32:12 UTC
[jira] Closed: (DERBY-2592) Wrong description of IndexName field in
public JavaDoc for LockTable
[ https://issues.apache.org/jira/browse/DERBY-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olav Sandstaa closed DERBY-2592.
--------------------------------
I have verified that the change to the JavaDoc looks as intended.
Thanks for the patch and for committing it, Jazarine and Kristian.
> Wrong description of IndexName field in public JavaDoc for LockTable
> --------------------------------------------------------------------
>
> Key: DERBY-2592
> URL: https://issues.apache.org/jira/browse/DERBY-2592
> Project: Derby
> Issue Type: Bug
> Components: Javadoc
> Affects Versions: 10.3.1.4
> Reporter: Olav Sandstaa
> Assignee: Jazarine Jamal
> Priority: Trivial
> Fix For: 10.4.0.0
>
> Attachments: DERBY-2592.diff, DERBY-2592_v2.diff
>
>
> The public JavaDoc for LockTable says the following in the description of the INDEXNAME retrieved from SYSCS_DIAG.LOCK_TABLE:
> INDEXNAME varchar(128) - normally null. If non-null, a lock is held on the index, this can only happen if this is not a user transaction.
> I think the last part is wrong. Normal user transactions might also have a value in the INDEXNAME. For example, here is part of the lock table for three user transactions:
> XID |TYPE |MODE|TABLENAME |LOCKNAME |STATE|TABLETYPE|INDEXNAME
> ---------------------------------------------------------------------
> 186 |ROW |X |T2 |(1,9) |GRANT|T |NULL
> 184 |ROW |S |T2 |(1,9) |WAIT |T |NULL
> 188 |ROW |X |T1 |(1,11) |GRANT|T |NULL
> 186 |ROW |S |T1 |(1,11) |WAIT |T |NULL
> 186 |ROW |S |T1 |(1,1) |GRANT|T |SQL070425023213370
> 188 |ROW |S |T1 |(1,1) |GRANT|T |SQL070425023213370
> 184 |ROW |X |T1 |(1,7) |GRANT|T |NULL
> 188 |ROW |S |T1 |(1,7) |WAIT |T |NULL
> Two of the lock entries have an index. I expect this to be the Scan lock that have been set during traversal of the B-tree.
> Proposed fix: remove the last part of the sentence.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.