|
(→Command Traces)
|
(→Lockable Resources & Lock Holders)
|
| Line 78: | |||
| == Lockable Resources & Lock Holders == | == Lockable Resources & Lock Holders == | ||
| Lockable resources, whether defined or scripted, as well as any resource acquired & holding a lock, should be present in the locking tables of anthillpro. If the locks need cleared, and cannot be revoked manually (or there are simply too many to revoke) it is possible to clean these up via SQL. | Lockable resources, whether defined or scripted, as well as any resource acquired & holding a lock, should be present in the locking tables of anthillpro. If the locks need cleared, and cannot be revoked manually (or there are simply too many to revoke) it is possible to clean these up via SQL. | ||
| - | === SQL to Clear All Locks === | ||
| - | <pre>DELETE FROM LOCK_HOLDER_LOCK_RES; | ||
| - | DELETE FROM LOCK_HOLDER;</pre> | ||
| + | <table border=2 cellspacing=2 cellpadding=2 align=center> | ||
| + | <tr> | ||
| + | <th bgcolor=#000000><font color=white>Type</font></th> | ||
| + | <th bgcolor=#000000><font color=white>SQL</font></th> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>clear all locks</font></td> | ||
| + | <td><font face=monospace>DELETE FROM LOCK_HOLDER_LOCK_RES; | ||
| + | DELETE FROM LOCK_HOLDER;</font></td> | ||
| + | </tr> | ||
| + | </table> | ||
| = Appendix A: Kill All (May Require Server Restart) = | = Appendix A: Kill All (May Require Server Restart) = | ||
| <pre>DELETE FROM LOCK_HOLDER_LOCK_RES; | <pre>DELETE FROM LOCK_HOLDER_LOCK_RES; | ||
