MariaDB [(none)]> SHOW FULL PROCESSLIST -> ; +------+-----------------+-------------------------+-------------+---------+------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-----------------+-------------------------+-------------+---------+------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 1 | system user | | NULL | Sleep | 7500 | wsrep aborter idle | NULL | 0.000 | | 2 | system user | | NULL | Sleep | 5429 | committed 1184 | NULL | 0.000 | | 709 | root | localhost | mysql | Killed | 1637 | Sending data | select * from innodb_table_stats | 0.000 | | 863 | asterisk-master | hprx00.colpbx.lan:48330 | asterisk | Killed | 5307 | 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | 0.000 | | 1575 | asterisk-master | hprx00.colpbx.lan:54112 | asterisk | Execute | 5186 | statistics | SELECT * FROM ps_endpoints WHERE id = ? | 0.000 | | 2021 | asterisk-master | hprx00.colpbx.lan:57668 | asterisk | Killed | 5429 | 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') | 0.000 | | 2022 | asterisk-master | hprx00.colpbx.lan:57672 | asterisk | Killed | 5429 | 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') | 0.000 | | 2023 | asterisk-master | hprx00.colpbx.lan:57678 | asterisk | Killed | 5428 | 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') | 0.000 | | 2082 | asterisk-master | hprx00.colpbx.lan:58162 | asterisk | Killed | 5369 | 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') | 0.000 | | 2083 | asterisk-master | hprx00.colpbx.lan:58170 | asterisk | Killed | 5369 | 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') | 0.000 | | 2084 | asterisk-master | hprx00.colpbx.lan:58178 | asterisk | Killed | 5369 | 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') | 0.000 | | 2146 | asterisk-master | hprx00.colpbx.lan:58688 | asterisk | Killed | 5309 | 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') | 0.000 | | 2147 | asterisk-master | hprx00.colpbx.lan:58696 | asterisk | Killed | 5309 | 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') | 0.000 | | 2148 | asterisk-master | hprx00.colpbx.lan:58704 | asterisk | Killed | 5309 | 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') | 0.000 | | 2209 | asterisk-master | hprx00.colpbx.lan:59196 | asterisk | Query | 5249 | 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') | 0.000 | | 2210 | asterisk-master | hprx00.colpbx.lan:59204 | asterisk | Killed | 5249 | 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') | 0.000 | | 2211 | asterisk-master | hprx00.colpbx.lan:59212 | asterisk | Killed | 5249 | 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') | 0.000 | | 2272 | asterisk-master | hprx00.colpbx.lan:59706 | asterisk | Killed | 5189 | 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') | 0.000 | | 2273 | asterisk-master | hprx00.colpbx.lan:59714 | asterisk | Killed | 5189 | 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') | 0.000 | | 2274 | asterisk-master | hprx00.colpbx.lan:59722 | asterisk | Killed | 5189 | 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') | 0.000 | | 2335 | asterisk-master | hprx00.colpbx.lan:60218 | asterisk | Killed | 5129 | 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') | 0.000 | | 2336 | asterisk-master | hprx00.colpbx.lan:60226 | asterisk | Killed | 5129 | 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') | 0.000 | | 2337 | asterisk-master | hprx00.colpbx.lan:60234 | asterisk | Query | 5129 | 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') | 0.000 | | 2354 | north-dev | hprx00.colpbx.lan:60390 | kamailio | Query | 5111 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512079755 AND `expires`>0 order by username | 0.000 | | 2365 | asterisk-master | hprx00.colpbx.lan:60470 | asterisk | Execute | 5103 | Sorting result | SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time | 0.000 | | 2374 | north-dev | hprx00.colpbx.lan:60554 | kamailio | Killed | 5093 | updating | delete from `active_watchers` where `expires`<1512079773 | 0.000 | | 2399 | asterisk-master | hprx00.colpbx.lan:60754 | asterisk | Query | 5069 | 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') | 0.000 | | 2400 | asterisk-master | hprx00.colpbx.lan:60762 | asterisk | Killed | 5069 | 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') | 0.000 | | 2401 | asterisk-master | hprx00.colpbx.lan:60770 | asterisk | Killed | 5069 | 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') | 0.000 | | 2462 | asterisk-master | hprx00.colpbx.lan:61262 | asterisk | Query | 5009 | 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') | 0.000 | | 2463 | asterisk-master | hprx00.colpbx.lan:61270 | asterisk | Killed | 5009 | 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') | 0.000 | | 2464 | asterisk-master | hprx00.colpbx.lan:61278 | asterisk | Killed | 5009 | 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') | 0.000 | | 2467 | asterisk-master | hprx00.colpbx.lan:61306 | asterisk | Execute | 5006 | statistics | SELECT * FROM ps_endpoints WHERE id = ? | 0.000 | | 2488 | north-dev | hprx00.colpbx.lan:61488 | kamailio | Query | 4987 | updating | delete from `watchers` where `inserted_time`<1511993479 AND `status`=2 | 0.000 | | 2527 | asterisk-master | hprx00.colpbx.lan:61796 | asterisk | Killed | 4949 | 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') | 0.000 | | 2528 | asterisk-master | hprx00.colpbx.lan:61804 | asterisk | Killed | 4949 | 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') | 0.000 | | 2529 | asterisk-master | hprx00.colpbx.lan:61814 | asterisk | Killed | 4949 | 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') | 0.000 | | 2588 | north-dev | hprx00.colpbx.lan:62300 | kamailio | Query | 4891 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512079979 AND `expires`>0 order by username | 0.000 | | 2591 | asterisk-master | hprx00.colpbx.lan:62318 | asterisk | Killed | 4889 | 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') | 0.000 | | 2592 | asterisk-master | hprx00.colpbx.lan:62330 | asterisk | Killed | 4889 | 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') | 0.000 | | 2593 | asterisk-master | hprx00.colpbx.lan:62338 | asterisk | Query | 4889 | 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') | 0.000 | | 2600 | north-dev | hprx00.colpbx.lan:62394 | kamailio | Query | 4883 | updating | delete from `presentity` where `expires`<1512079979 AND `expires`>0 | 0.000 | | 2613 | north-dev | hprx00.colpbx.lan:62502 | kamailio | Query | 4871 | updating | delete from `active_watchers` where `expires`<1512079997 | 0.000 | | 2654 | asterisk-master | hprx00.colpbx.lan:62846 | asterisk | Query | 4829 | 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') | 0.000 | | 2657 | asterisk-master | hprx00.colpbx.lan:62858 | asterisk | Killed | 4828 | 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') | 0.000 | | 2707 | north-dev | hprx00.colpbx.lan:63272 | kamailio | Query | 4779 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080091 AND `expires`>0 order by username | 0.000 | | 2712 | north-dev | hprx00.colpbx.lan:63310 | kamailio | Query | 4775 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080091 AND `expires`>0 order by username | 0.000 | | 2715 | north-dev | hprx00.colpbx.lan:63324 | kamailio | Query | 4773 | updating | delete from `presentity` where `expires`<1512080091 AND `expires`>0 | 0.000 | | 2726 | north-dev | hprx00.colpbx.lan:63386 | kamailio | Query | 4769 | updating | delete from `presentity` where `expires`<1512080091 AND `expires`>0 | 0.000 | | 2733 | north-dev | hprx00.colpbx.lan:63442 | kamailio | Query | 4763 | updating | delete from `watchers` where `inserted_time`<1511993703 AND `status`=2 | 0.000 | | 2836 | north-dev | hprx00.colpbx.lan:64244 | kamailio | Query | 4667 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080203 AND `expires`>0 order by username | 0.000 | | 2841 | north-dev | hprx00.colpbx.lan:64286 | kamailio | Query | 4663 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080203 AND `expires`>0 order by username | 0.000 | | 2854 | north-dev | hprx00.colpbx.lan:64400 | kamailio | Query | 4651 | updating | delete from `watchers` where `inserted_time`<1511993815 AND `status`=2 | 0.000 | | 2962 | north-dev | hprx00.colpbx.lan:65218 | kamailio | Query | 4555 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080315 AND `expires`>0 order by username | 0.000 | | 2965 | north-dev | hprx00.colpbx.lan:65238 | kamailio | Query | 4553 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080315 AND `expires`>0 order by username | 0.000 | | 2968 | north-dev | hprx00.colpbx.lan:65254 | kamailio | Query | 4551 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080315 AND `expires`>0 order by username | 0.000 | | 2971 | north-dev | hprx00.colpbx.lan:65274 | kamailio | Query | 4549 | updating | delete from `presentity` where `expires`<1512080315 AND `expires`>0 | 0.000 | | 2974 | north-dev | hprx00.colpbx.lan:65290 | kamailio | Killed | 4547 | updating | delete from `presentity` where `expires`<1512080315 AND `expires`>0 | 0.000 | | 2977 | north-dev | hprx00.colpbx.lan:65312 | kamailio | Killed | 4545 | updating | delete from `presentity` where `expires`<1512080315 AND `expires`>0 | 0.000 | | 2980 | north-dev | hprx00.colpbx.lan:65328 | kamailio | Query | 4543 | updating | delete from `watchers` where `inserted_time`<1511993927 AND `status`=2 | 0.000 | | 2985 | north-dev | hprx00.colpbx.lan:65366 | kamailio | Query | 4539 | updating | delete from `watchers` where `inserted_time`<1511993927 AND `status`=2 | 0.000 | | 3098 | north-dev | hprx00.colpbx.lan:4754 | kamailio | Query | 4443 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080427 AND `expires`>0 order by username | 0.000 | | 3101 | north-dev | hprx00.colpbx.lan:4772 | kamailio | Query | 4441 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080427 AND `expires`>0 order by username | 0.000 | | 3110 | north-dev | hprx00.colpbx.lan:4848 | kamailio | Query | 4433 | updating | delete from `presentity` where `expires`<1512080427 AND `expires`>0 | 0.000 | | 3119 | north-dev | hprx00.colpbx.lan:4922 | kamailio | Query | 4425 | updating | delete from `active_watchers` where `expires`<1512080445 | 0.000 | | 3225 | north-dev | hprx00.colpbx.lan:5788 | kamailio | Query | 4325 | updating | delete from `presentity` where `expires`<1512080539 AND `expires`>0 | 0.000 | | 3238 | north-dev | hprx00.colpbx.lan:5898 | kamailio | Query | 4313 | updating | delete from `active_watchers` where `expires`<1512080557 | 0.000 | | 3352 | north-dev | hprx00.colpbx.lan:6708 | kamailio | Query | 4219 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080651 AND `expires`>0 order by username | 0.000 | | 3355 | north-dev | hprx00.colpbx.lan:6728 | kamailio | Query | 4217 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080651 AND `expires`>0 order by username | 0.000 | | 3364 | north-dev | hprx00.colpbx.lan:6802 | kamailio | Query | 4209 | updating | delete from `presentity` where `expires`<1512080651 AND `expires`>0 | 0.000 | | 3373 | north-dev | hprx00.colpbx.lan:6874 | kamailio | Killed | 4201 | updating | delete from `active_watchers` where `expires`<1512080669 | 0.000 | | 3472 | north-dev | hprx00.colpbx.lan:7706 | kamailio | Killed | 4105 | Sorting result | select `username`,`domain`,`etag`,`event` from `presentity` where `expires`<1512080763 AND `expires`>0 order by username | 0.000 | | 3489 | north-dev | hprx00.colpbx.lan:7852 | kamailio | Killed | 4089 | updating | delete from `active_watchers` where `expires`<1512080781 | 0.000 | | 3600 | north-dev | hprx00.colpbx.lan:8766 | kamailio | Killed | 3985 | updating | delete from `presentity` where `expires`<1512080875 AND `expires`>0 | 0.000 | | 3977 | asterisk-master | hprx01.colpbx.lan:4996 | asterisk | Execute | 3664 | Sorting result | SELECT * FROM ps_endpoints WHERE aors LIKE ? ORDER BY aors | 0.000 | | 3978 | asterisk-master | hprx01.colpbx.lan:5004 | asterisk | Execute | 3664 | statistics | SELECT * FROM ps_endpoints WHERE id = ? | 0.000 | | 3979 | asterisk-master | hprx01.colpbx.lan:5012 | asterisk | Execute | 3664 | Sorting result | SELECT * FROM ps_endpoints WHERE aors LIKE ? ORDER BY aors | 0.000 | | 3980 | voipmonitor | hprx01.colpbx.lan:5020 | voipmonitor | Query | 3664 | Sending data | select max(calldate) as max_calldate from cdr where calldate > date_add(now(), interval -1 day) and id_sensor = 1245 | 0.000 | | 3986 | root | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST | 0.000 | +------+-----------------+-------------------------+-------------+---------+------+--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ 79 rows in set (0.00 sec)