[OK] 2023-03-17 01:50:01 get non-sleep session details (limit 100) select * from information_schema.PROCESSLIST where lower(command) <> 'sleep' and user not in ('root') order by time desc limit 100 +----------+-------------+----------------------+------+---------+------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------+-----------+----------+-------------+-----------------+---------------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | STAGE | MAX_STAGE | PROGRESS | MEMORY_USED | MAX_MEMORY_USED | EXAMINED_ROWS | QUERY_ID | INFO_BINARY | TID | +----------+-------------+----------------------+------+---------+------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------+-----------+----------+-------------+-----------------+---------------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+ | 13985804 | besdb_user | XXX.XX.XXX.XXX:54721 | das | Query | 19 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX1' | 19024.360 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860864 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX1' | 17751 | | 13985385 | besdb_user | XXX.XX.XXX.XXX:30544 | das | Query | 19 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX2' | 19233.438 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860853 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX2' | 128547 | | 13983900 | besdb_user | XXX.XX.XXX.XXX:22823 | das | Query | 19 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX3' | 19383.809 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860847 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX3' | 55815 | | 13983375 | besdb_user | XXX.XX.XXX.XXX:26433 | das | Query | 19 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX4' | 19178.565 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860858 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX4' | 47353 | | 13983264 | besdb_user | XXX.XX.XXX.XXX:26618 | das | Query | 19 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX5' | 19129.045 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860861 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX5' | 54340 | | 13981361 | besdb_user | XXX.XX.XXX.XXX:63351 | das | Query | 19 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX6' | 19253.053 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860850 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX6' | 126424 | | 13986020 | besdb_user | XXX.XX.XXX.XXX:17855 | das | Query | 18 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX7' | 18126.882 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860936 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX7' | 55784 | | 13986019 | besdb_user | XXX.XX.XXX.XXX:31137 | das | Query | 18 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX8' | 18169.770 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860906 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX8' | 38179 | | 13986018 | besdb_user | XXX.XX.XXX.XXX:53516 | das | Query | 18 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX9' | 18188.761 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860904 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX9' | 25410 | | 13986017 | besdb_user | XXX.XX.XXX.XXX:51401 | das | Query | 18 | Sending data | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX0' | 18583.275 | 0 | 0 | 0.000 | 98392 | 98392 | 0 | 833860884 | insert into tb_das_raw_data_pairing_unsuccess (ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,dt_create_datetime, dt_update_datetime ) select ti_toll_point_id, vc_evidence_id, dt_trxn_time, bi_das_trxn_obj_id, bi_das_evid_obj_id,sysdate(), sysdate() from tb_das_raw_data_pairing_00 where vc_evidence_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXX0' | 19016 | | 13984517 | besdb_owner | %:20625 | das | Query | 18 | Starting cleanup | COMMIT | 18145.230 | 0 | 0 | 0.000 | 82024 | 90184 | 0 | 833860920 | COMMIT | 73328 | | 13984501 | besdb_owner | %:58134 | das | Query | 18 | Updating | update tb_das_trxn_seq set bi_trxn_seq = bi_trxn_seq + 1 where vc_toll_point_code = NAME_CONST('in_toll_point',_utf8mb4'LRT4' COLLATE 'utf8mb4_unicode_ci') and i_yyyymmdd = NAME_CONST('in_date_no',20230317) | 18127.967 | 0 | 0 | 0.000 | 86104 | 90184 | 0 | 833860935 | update tb_das_trxn_seq set bi_trxn_seq = bi_trxn_seq + 1 where vc_toll_point_code = NAME_CONST('in_toll_point',_utf8mb4'LRT4' COLLATE 'utf8mb4_unicode_ci') and i_yyyymmdd = NAME_CONST('in_date_no',20230317) | 20119 | XXX XXX XXX XXX XXX XXX XXX XXX