------=_NextPart_000_002E_01C63C47.7D191C20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How do you associate a thread ID to a user ID? I have a deadlock in a =
database and want to link it back to a user ID.... I got the information =
from the SHOW INNODB STATUS\G statement.....
Thanks,
Melissa
------=_NextPart_000_002E_01C63C47.7D191C20--
SHOW PROCESSLIST;
http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
=20
-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]=20
Sent: Tuesday, February 28, 2006 3:15 PM
To: win32@lists.mysql.com
Subject: DeadLock Question
How do you associate a thread ID to a user ID? I have a deadlock in a =
database and want to link it back to a user ID.... I got the information =
from the SHOW INNODB STATUS\G statement.....
Thanks,
Melissa=20
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
If that's the only option for showing this type of information..... It looks
like my deadlock is not connected to a user ID anymore. Is there any way to
resolve this other than a db reboot?
Thanks,
Melissa
----- Original Message -----
From: "Armin Schöffmann"
To: "Melissa Dougherty"
Sent: Tuesday, February 28, 2006 9:30 AM
Subject: RE: DeadLock Question
> SHOW PROCESSLIST;
> http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
>
>
> -----Original Message-----
> From: Melissa Dougherty [mailto:melissa@cse-corp.com]
> Sent: Tuesday, February 28, 2006 3:15 PM
> To: win32@lists.mysql.com
> Subject: DeadLock Question
>
> How do you associate a thread ID to a user ID? I have a deadlock in a
> database and want to link it back to a user ID.... I got the information
> from the SHOW INNODB STATUS\G statement.....
>
> Thanks,
>
> Melissa
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=melissa@cse-corp.com
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Here is the lock information..... Does the information at the end mean it
has rollback the delete transaction? And if so, why didn't it release the
deadlock?
Melissa
------------------------
LATEST DETECTED DEADLOCK
------------------------
060227 12:18:04
*** (1) TRANSACTION:
TRANSACTION 0 105546544, ACTIVE 1 sec, OS thread id 20632 starting index
read
mysql tables in use 1, locked 1
LOCK WAIT 14 lock struct(s), heap size 1024, undo log entries 31
MySQL thread id 104, query id 1498230 localhost 127.0.0.1 root updating
delete from vsde_fs_locks where id='979bcd431d730df8bca89e2b403d07e4'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 4481 n bits 96 table vsde_2/vsde_fs_locks
index GEN_CLUST_INDEX trx id 0 105546544 lock_mode X waiti
ng
Record lock, heap no 26 RECORD: info bits 0 0: len 6; hex 000000a7dbe1; asc
....º?ß;; 1:
*** (2) TRANSACTION:
TRANSACTION 0 105546542, ACTIVE 1 sec, OS thread id 23144 starting index
read, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
14 lock struct(s), heap size 1024, undo log entries 32
MySQL thread id 105, query id 1498247 localhost 127.0.0.1 root updating
delete from vsde_fs_locks where id='5b26cb78ea4411c00a621a96e7ecdab4'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 4481 n bits 96 table vsde_2/vsde_fs_locks
index GEN_CLUST_INDEX trx id 0 105546542 lock_mode X locks
rec but not gap
Record lock, heap no 26 RECORD: info bits 0 0: len 6; hex 000000a7dbe1; asc
....º?ß;; 1:
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 4481 n bits 96 table vsde_2/vsde_fs_locks
index GEN_CLUST_INDEX trx id 0 105546542 lock_mode X waiti
ng
Record lock, heap no 26 RECORD: info bits 0 0: len 6; hex 000000a7dbe1; asc
....º?ß;; 1:
*** WE ROLL BACK TRANSACTION (1)
----- Original Message -----
From: "Armin Schöffmann"
To: "Melissa Dougherty"
Sent: Tuesday, February 28, 2006 9:30 AM
Subject: RE: DeadLock Question
> SHOW PROCESSLIST;
> http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
>
>
> -----Original Message-----
> From: Melissa Dougherty [mailto:melissa@cse-corp.com]
> Sent: Tuesday, February 28, 2006 3:15 PM
> To: win32@lists.mysql.com
> Subject: DeadLock Question
>
> How do you associate a thread ID to a user ID? I have a deadlock in a
> database and want to link it back to a user ID.... I got the information
> from the SHOW INNODB STATUS\G statement.....
>
> Thanks,
>
> Melissa
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=melissa@cse-corp.com
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org