-----------
TRANSACTIONS
------------
Trx id counter 7867680
Purge done for trx's n:o < 7867674 undo n:o < 0 state: running but idle
History list length 10
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 7867679, not started
MySQL thread id 8878, OS thread handle 0x7fe63a24bb00, query id 1964863 localhost bacula Waiting for table metadata lock
LOCK TABLES Path write, batch write, Path as p write
---TRANSACTION 7867674, not started
MySQL thread id 8868, OS thread handle 0x7fe6370d4b00, query id 1964854 localhost bacula cleaning up
---TRANSACTION 6002435, not started
MySQL thread id 1, OS thread handle 0x7fe63a295b00, query id 0 Waiting for requests
---TRANSACTION 7867610, ACTIVE 79 sec setting auto-inc lock
mysql tables in use 4, locked 4
LOCK WAIT 9 lock struct(s), heap size 2936, 5 row lock(s)
MySQL thread id 8877, OS thread handle 0x7fe6371b2b00, query id 1964799 localhost bacula Sending data
INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Fil
ename.Name)
Trx #rec lock waits 0 #table lock waits 1
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
------- TRX HAS BEEN WAITING 79 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `bacula`.`File` trx id 7867610 lock mode AUTO-INC waiting lock hold time 79 wait time before grant 0
------------------
---TRANSACTION 7867609, ACTIVE 79 sec setting auto-inc lock
mysql tables in use 4, locked 4
LOCK WAIT 9 lock struct(s), heap size 2936, 5 row lock(s)
MySQL thread id 8874, OS thread handle 0x7fe63711eb00, query id 1964790 localhost bacula Sending data
INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name)
Trx #rec lock waits 0 #table lock waits 1
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
------- TRX HAS BEEN WAITING 79 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `bacula`.`File` trx id 7867609 lock mode AUTO-INC waiting lock hold time 79 wait time before grant 0
------------------
---TRANSACTION 7867608, ACTIVE 79 sec setting auto-inc lock
mysql tables in use 4, locked 4
LOCK WAIT 9 lock struct(s), heap size 2936, 5 row lock(s)
MySQL thread id 8875, OS thread handle 0x7fe63a201b00, query id 1964794 localhost bacula Sending data
INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name)
Trx #rec lock waits 0 #table lock waits 1
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
------- TRX HAS BEEN WAITING 79 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `bacula`.`File` trx id 7867608 lock mode AUTO-INC waiting lock hold time 79 wait time before grant 0
------------------