[
https://issues.apache.org/jira/browse/DERBY-2817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12505160
]
Knut Anders Hatlen commented on DERBY-2817:
-------------------------------------------
SYSCS_DIAG.LOCK_TABLE shows the XID correctly.
ij> select * from syscs_diag.lock_table;
XID |TYPE |MODE|TABLENAME
|LOCKNAME |STATE|TABLETYPE|LOCK&|INDEXNAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
180 |TABLE|IX |T
|Tablelock |GRANT|T |2 |NULL
180 |ROW |X |T
|(1,7) |GRANT|T |3 |NULL
2 rows selected
> Error messages for deadlocks contain less information than in 10.2
> ------------------------------------------------------------------
>
> Key: DERBY-2817
> URL: https://issues.apache.org/jira/browse/DERBY-2817
> Project: Derby
> Issue Type: Bug
> Components: Services
> Affects Versions: 10.3.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: deadlock.diff
>
>
> In 10.2, an error message for a deadlock would look like this:
> ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks
> and waiters is:
> Lock : ROW, T, (1,8)
> Waiting XID : {235, S} , APP, select * from t where id = 2
> Granted XID : {238, X}
> Lock : ROW, T, (1,7)
> Waiting XID : {238, S} , APP, select * from t where id = 1
> Granted XID : {235, X}
> . The selected victim is XID : 235.
> On trunk, the same deadlock would be reported as
> java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle
> of locks and waiters is:
> Lock : ROW, T, (1,8)
> Waiting XID : [EMAIL PROTECTED], S}
> Granted XID : [EMAIL PROTECTED], X}
> Lock : ROW, T, (1,7)
> Waiting XID : [EMAIL PROTECTED], S}
> Granted XID : [EMAIL PROTECTED], X}
> . The selected victim is XID : [EMAIL PROTECTED]
> That is, the transaction id and the failing statement are not shown.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
