------------
TRANSACTIONS
------------
Trx id counter 9366476
Purge done for trx's n:o < 9366468 undo n:o < 0 state: running but idle
History list length 40
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 3986, OS thread handle 0x7f90e9d1fb00, query id 14071 localhost root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 100, locked 0
MySQL thread id 3980, OS thread handle 0x7f90ea8abb00, query id 13825 hprx01.colpbx.lan 10.30.100.34 voipmonitor Sending data
select max(calldate) as max_calldate from cdr where calldate > date_add(now(), interval -1 day)  and id_sensor = 1245
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3979, OS thread handle 0x7f90ea8f5b00, query id 13819 hprx01.colpbx.lan 10.30.100.34 asterisk-master Sorting result
SELECT * FROM ps_endpoints WHERE aors LIKE ? ORDER BY aors
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3978, OS thread handle 0x7f90e9c8bb00, query id 13813 hprx01.colpbx.lan 10.30.100.34 asterisk-master statistics
SELECT * FROM ps_endpoints WHERE id = ?
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3977, OS thread handle 0x7f90e9cd5b00, query id 13807 hprx01.colpbx.lan 10.30.100.34 asterisk-master Sorting result
SELECT * FROM ps_endpoints WHERE aors LIKE ? ORDER BY aors
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3600, OS thread handle 0x7f901aed5b00, query id 12840 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080875 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3489, OS thread handle 0x7f901ae8bb00, query id 12526 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `active_watchers` where `expires`<1512080781
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3472, OS thread handle 0x7f901af69b00, query id 12476 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080763 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3373, OS thread handle 0x7f901af1fb00, query id 12192 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `active_watchers` where `expires`<1512080669
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3364, OS thread handle 0x7f901e6b4b00, query id 12166 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080651 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3355, OS thread handle 0x7f901afb3b00, query id 12140 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080651 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3352, OS thread handle 0x7f901affdb00, query id 12132 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080651 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3238, OS thread handle 0x7f901e66ab00, query id 11842 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `active_watchers` where `expires`<1512080557
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3225, OS thread handle 0x7f901e6feb00, query id 11803 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080539 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3119, OS thread handle 0x7f901e748b00, query id 11498 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `active_watchers` where `expires`<1512080445
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3110, OS thread handle 0x7f904bc7cb00, query id 11472 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080427 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3101, OS thread handle 0x7f901e792b00, query id 11444 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080427 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 3098, OS thread handle 0x7f901e7dcb00, query id 11436 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080427 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2985, OS thread handle 0x7f90546b6b00, query id 11141 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `watchers` where `inserted_time`<1511993927 AND `status`=2
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2980, OS thread handle 0x7f904bcc6b00, query id 11127 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `watchers` where `inserted_time`<1511993927 AND `status`=2
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2977, OS thread handle 0x7f904bd10b00, query id 11118 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080315 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2974, OS thread handle 0x7f904bd5ab00, query id 11110 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080315 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2971, OS thread handle 0x7f904bda4b00, query id 11102 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080315 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2968, OS thread handle 0x7f904bdeeb00, query id 11093 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080315 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2965, OS thread handle 0x7f905474ab00, query id 11084 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080315 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2962, OS thread handle 0x7f905466cb00, query id 11075 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080315 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2854, OS thread handle 0x7f9054700b00, query id 10786 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `watchers` where `inserted_time`<1511993815 AND `status`=2
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2841, OS thread handle 0x7f9054794b00, query id 10748 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080203 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2836, OS thread handle 0x7f90547deb00, query id 10734 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080203 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2733, OS thread handle 0x7f906565cb00, query id 10442 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `watchers` where `inserted_time`<1511993703 AND `status`=2
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2726, OS thread handle 0x7f90656f0b00, query id 10422 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080091 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2715, OS thread handle 0x7f90656a6b00, query id 10408 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512080091 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2712, OS thread handle 0x7f906573ab00, query id 10399 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080091 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2707, OS thread handle 0x7f9065784b00, query id 10384 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080091 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2657, OS thread handle 0x7f90657ceb00, query id 10237 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','croncheck.php','6206','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2654, OS thread handle 0x7f907ec5cb00, query id 10227 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkqueuecallback.php','30603','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2613, OS thread handle 0x7f907eca6b00, query id 10102 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `active_watchers` where `expires`<1512079997
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2600, OS thread handle 0x7f907ecf0b00, query id 10064 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `presentity` where `expires`<1512079979 AND `expires`>0
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2593, OS thread handle 0x7f907ed3ab00, query id 10044 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checksendfax.php','6170','10','Checking FAX to be sent')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2592, OS thread handle 0x7f907edceb00, query id 10040 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','croncheck.php','6172','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2591, OS thread handle 0x7f907ed84b00, query id 10036 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkfaxmailboxes.php','30568','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2588, OS thread handle 0x7f909826cb00, query id 10026 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512079979 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2529, OS thread handle 0x7f90982b6b00, query id 9850 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkqueuecallback.php','6133','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2528, OS thread handle 0x7f90983deb00, query id 9846 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkalarms.php','30528','10','Checking wakeup alarms')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2527, OS thread handle 0x7f9098300b00, query id 9842 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkfaxmailboxes.php','30533','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2488, OS thread handle 0x7f909834ab00, query id 9723 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `watchers` where `inserted_time`<1511993479 AND `status`=2
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2467, OS thread handle 0x7f9098394b00, query id 9661 hprx00.colpbx.lan 10.30.100.33 asterisk-master statistics
SELECT * FROM ps_endpoints WHERE id = ?
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2464, OS thread handle 0x7f90a925cb00, query id 9649 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkalarms.php','6097','10','Checking wakeup alarms')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2463, OS thread handle 0x7f90a92a6b00, query id 9645 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkgeoipf2b.php','6089','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2462, OS thread handle 0x7f90a92f0b00, query id 9641 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checksendfax.php','6090','10','Checking FAX to be sent')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2401, OS thread handle 0x7f90a933ab00, query id 9457 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checksendfax.php','6057','10','Checking FAX to be sent')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2400, OS thread handle 0x7f90c2900b00, query id 9453 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkgeoipf2b.php','30464','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2399, OS thread handle 0x7f90a9384b00, query id 9452 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkqueuecallback.php','30461','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2374, OS thread handle 0x7f90a93ceb00, query id 9373 hprx00.colpbx.lan 10.30.100.33 north-dev updating
delete from `active_watchers` where `expires`<1512079773
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2365, OS thread handle 0x7f90c286cb00, query id 9347 hprx00.colpbx.lan 10.30.100.33 asterisk-master Sorting result
SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 2354, OS thread handle 0x7f90c28b6b00, query id 9311 hprx00.colpbx.lan 10.30.100.33 north-dev Sorting result
select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512079755 AND `expires`>0 order by username
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2336, OS thread handle 0x7f90c29deb00, query id 9261 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','croncheck.php','6013','30','Couldn\'t get the lock! This script is probably already running')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2337, OS thread handle 0x7f90c294ab00, query id 9259 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkalarms.php','30421','10','Checking wakeup alarms')
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2335, OS thread handle 0x7f90c2994b00, query id 9257 hprx00.colpbx.lan 10.30.100.33 asterisk-master update
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkalarms.php','6014','10','Checking wakeup alarms')
---TRANSACTION 9365387, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 1575, OS thread handle 0x7f90e6bfcb00, query id 9074 hprx00.colpbx.lan 10.30.100.33 asterisk-master statistics
SELECT * FROM ps_endpoints WHERE id = ?
---TRANSACTION 0, not started sleeping before entering InnoDB
mysql tables in use 1, locked 0
MySQL thread id 709, OS thread handle 0x7f90e9d69b00, query id 13894 localhost root Sending data
select * from innodb_table_stats
---TRANSACTION 9366432, not started
MySQL thread id 2, OS thread handle 0x7f91f04dcb00, query id 8235 committed 1184
---TRANSACTION 9363715, not started
MySQL thread id 3, OS thread handle 0x7f90ea93fb00, query id 0 Waiting for requests
---TRANSACTION 9366473, ACTIVE 4776 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2274, OS thread handle 0x7f90dca88b00, query id 9066 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checksendfax.php','30385','10','Checking FAX to be sent')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366472, ACTIVE 4776 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2273, OS thread handle 0x7f90dcb1cb00, query id 9064 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','croncheck.php','30379','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366471, ACTIVE 4776 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2272, OS thread handle 0x7f90dcad2b00, query id 9059 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkalarms.php','30384','10','Checking wakeup alarms')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366470, ACTIVE 4836 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2211, OS thread handle 0x7f90dcb66b00, query id 8874 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkfaxmailboxes.php','30337','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366469, ACTIVE 4836 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2210, OS thread handle 0x7f90dcbfab00, query id 8872 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkqueuecallback.php','30333','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366468, ACTIVE 4836 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2209, OS thread handle 0x7f90dcbb0b00, query id 8866 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checksendfax.php','30336','10','Checking FAX to be sent')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366463, ACTIVE 4894 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 863, OS thread handle 0x7f90ea861b00, query id 8684 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
INSERT INTO ps_contacts (id, via_addr, qualify_timeout, call_id, reg_server, path, endpoint, via_port, authenticate_qualify, uri, qualify_frequency, user_agent, expiration_time, outbound_proxy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366446, ACTIVE 4896 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2148, OS thread handle 0x7f90e588bb00, query id 8637 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checksendfax.php','5894','10','Checking FAX to be sent')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366445, ACTIVE 4896 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2147, OS thread handle 0x7f90e58d5b00, query id 8633 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkgeoipf2b.php','5888','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366444, ACTIVE 4896 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2146, OS thread handle 0x7f90e591fb00, query id 8629 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkalarms.php','5892','10','Checking wakeup alarms')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366441, ACTIVE 4956 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2084, OS thread handle 0x7f90e59b3b00, query id 8434 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','croncheck.php','30261','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366440, ACTIVE 4956 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2083, OS thread handle 0x7f90e59fdb00, query id 8430 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkalarms.php','30263','10','Checking wakeup alarms')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366439, ACTIVE 4956 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2082, OS thread handle 0x7f90e6a8ab00, query id 8426 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkalarms.php','5856','10','Checking wakeup alarms')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366436, ACTIVE 5015 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2023, OS thread handle 0x7f90e6bb2b00, query id 8242 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checkfaxmailboxes.php','5820','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366434, ACTIVE 5015 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2022, OS thread handle 0x7f90e6b1eb00, query id 8238 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx01.colpbx.lan','checksendfax.php','5819','10','Checking FAX to be sent')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 9366433, ACTIVE 5015 sec, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 2021, OS thread handle 0x7f90e6ad4b00, query id 8236 hprx00.colpbx.lan 10.30.100.33 asterisk-master query end
insert into sl_serverlogs(sl_peername,sl_processname,sl_pid,sl_severity,sl_message) values ('pbx00.colpbx.lan','checkgeoipf2b.php','30229','30','Couldn\'t get the lock! This script is probably already running')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (read thread)
I/O thread 9 state: waiting for completed aio requests (read thread)
I/O thread 10 state: waiting for completed aio requests (read thread)
I/O thread 11 state: waiting for completed aio requests (read thread)
I/O thread 12 state: waiting for completed aio requests (read thread)
I/O thread 13 state: waiting for completed aio requests (read thread)
I/O thread 14 state: waiting for completed aio requests (read thread)
I/O thread 15 state: waiting for completed aio requests (read thread)
I/O thread 16 state: waiting for completed aio requests (read thread)
I/O thread 17 state: waiting for completed aio requests (read thread)
I/O thread 18 state: waiting for completed aio requests (write thread)
I/O thread 19 state: waiting for completed aio requests (write thread)
I/O thread 20 state: waiting for completed aio requests (write thread)
I/O thread 21 state: waiting for completed aio requests (write thread)
I/O thread 22 state: waiting for completed aio requests (write thread)
I/O thread 23 state: waiting for completed aio requests (write thread)
I/O thread 24 state: waiting for completed aio requests (write thread)
I/O thread 25 state: waiting for completed aio requests (write thread)
I/O thread 26 state: waiting for completed aio requests (write thread)
I/O thread 27 state: waiting for completed aio requests (write thread)
I/O thread 28 state: waiting for completed aio requests (write thread)
I/O thread 29 state: waiting for completed aio requests (write thread)
I/O thread 30 state: waiting for completed aio requests (write thread)
I/O thread 31 state: waiting for completed aio requests (write thread)
I/O thread 32 state: waiting for completed aio requests (write thread)
I/O thread 33 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
6686 OS file reads, 2911 OS file writes, 652 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------