[2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 11:22:10] [INFO] [PID:3182]: Connecting to the server. [] [2022-03-14 11:22:10] [NOTICE] [PID:3182]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 11:22:10] [INFO] [PID:3182]: Binding to the server. [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 11:22:10] [NOTICE] [PID:3182]: Binded to server with system_id montyws [] [2022-03-14 11:22:10] [INFO] [PID:3182]: Update last_online timestamp. [] [2022-03-14 11:22:10] [WARNING] [PID:3182]: IC point suspend was canceled. [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 11:22:10] [NOTICE] [PID:3182]: Binded to the server. [] [2022-03-14 11:22:10] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:22:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:22:10] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:22:20] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:22:20] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:22:20] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:22:30] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:22:30] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:22:30] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:22:40] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:22:40] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:22:40] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:22:50] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:22:50] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:22:50] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:23:00] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:23:00] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:23:00] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:23:10] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:23:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:23:10] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":"00000010000000150000000000000001"} [2022-03-14 11:23:11] [INFO] [PID:3182]: Update last_online timestamp. [] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":""} [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 11:23:11] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010800000150000000000000002"} [2022-03-14 11:23:20] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:23:20] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:23:20] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:23:30] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:23:30] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:23:30] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:23:40] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:23:40] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:23:40] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:23:50] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:23:50] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:23:50] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:24:00] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:24:00] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:24:00] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:24:10] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:24:10] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:24:10] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010000000150000000000000003"] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":""} [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010000000150000000000000002"] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010000000150000000000000002"} [2022-03-14 11:24:12] [INFO] [PID:3182]: Update last_online timestamp. [] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010800000150000000000000002"] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010800000150000000000000003"] [2022-03-14 11:24:12] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":"00000010800000150000000000000003"} [2022-03-14 11:24:20] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:24:20] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:24:20] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:24:30] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:24:30] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:24:30] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:24:40] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:24:40] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:24:40] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:24:50] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:24:50] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:24:50] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:25:00] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:25:31] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:25:31] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:25:31] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010000000150000000000000004"] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":""} [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010000000150000000000000003"] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":"00000010000000150000000000000003"} [2022-03-14 11:25:31] [INFO] [PID:3182]: Update last_online timestamp. [] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010800000150000000000000003"] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":""} [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010800000150000000000000004"] [2022-03-14 11:25:31] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":"00000010800000150000000000000004"} [2022-03-14 11:25:41] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:25:41] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:25:41] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:25:51] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:25:51] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:25:51] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:26:01] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:26:01] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:26:01] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:26:11] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:26:11] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:26:11] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:26:21] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:26:21] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:26:21] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:26:31] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:26:31] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:26:31] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010000000150000000000000005"] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":""} [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010000000150000000000000004"] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":"00000010000000150000000000000004"} [2022-03-14 11:26:32] [INFO] [PID:3182]: Update last_online timestamp. [] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010800000150000000000000004"] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":""} [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010800000150000000000000005"] [2022-03-14 11:26:32] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":"00000010800000150000000000000005"} [2022-03-14 11:26:41] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:26:41] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:26:41] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:26:51] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:26:51] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:26:51] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:01] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:27:01] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:27:01] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:11] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:27:11] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:27:11] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:21] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:27:21] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:27:21] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:31] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:27:31] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:27:31] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010000000150000000000000006"] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":6},"sourceData":""} [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010000000150000000000000005"] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":"00000010000000150000000000000005"} [2022-03-14 11:27:33] [INFO] [PID:3182]: Update last_online timestamp. [] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU:RAW] :: send ["00000010800000150000000000000005"] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":""} [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU:RAW] :: received ["00000010800000150000000000000006"] [2022-03-14 11:27:33] [DEBUG] [PID:3182]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":6},"sourceData":"00000010800000150000000000000006"} [2022-03-14 11:27:41] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:27:41] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:27:41] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:51] [INFO] [PID:3182]: Get messages from database [] [2022-03-14 11:27:51] [DEBUG] [PID:3182]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 11:27:51] [NOTICE] [PID:3182]: Selected mesages: 0 [] [2022-03-14 11:27:57] [WARNING] [PID:3182]: Cannot read from connection [] [2022-03-14 11:27:57] [NOTICE] [PID:3182]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 11:27:57] [NOTICE] [PID:3182]: Exiting [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:04:07] [INFO] [PID:9486]: Connecting to the server. [] [2022-03-14 12:04:07] [NOTICE] [PID:9486]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:04:07] [INFO] [PID:9486]: Binding to the server. [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:04:07] [NOTICE] [PID:9486]: Binded to server with system_id montyws [] [2022-03-14 12:04:07] [INFO] [PID:9486]: Update last_online timestamp. [] [2022-03-14 12:04:07] [WARNING] [PID:9486]: IC point suspend was canceled. [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:04:07] [NOTICE] [PID:9486]: Binded to the server. [] [2022-03-14 12:04:07] [INFO] [PID:9486]: Get messages from database [] [2022-03-14 12:04:07] [DEBUG] [PID:9486]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:04:07] [NOTICE] [PID:9486]: Selected mesages: 0 [] [2022-03-14 12:04:17] [INFO] [PID:9486]: Get messages from database [] [2022-03-14 12:04:17] [DEBUG] [PID:9486]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:04:17] [NOTICE] [PID:9486]: Selected mesages: 0 [] [2022-03-14 12:04:24] [WARNING] [PID:9486]: Cannot read from connection [] [2022-03-14 12:04:24] [NOTICE] [PID:9486]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:04:24] [NOTICE] [PID:9486]: Exiting [] [2022-03-14 12:10:22] [DEBUG] [PID:14945]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:10:23] [INFO] [PID:14945]: Connecting to the server. [] [2022-03-14 12:10:23] [NOTICE] [PID:14945]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:10:23] [INFO] [PID:14945]: Binding to the server. [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:10:23] [NOTICE] [PID:14945]: Binded to server with system_id montyws [] [2022-03-14 12:10:23] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:10:23] [WARNING] [PID:14945]: IC point suspend was canceled. [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:10:23] [NOTICE] [PID:14945]: Binded to the server. [] [2022-03-14 12:10:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:10:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:10:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:10:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:10:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:10:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:10:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:10:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:10:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:10:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:10:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:10:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:11:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:11:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:11:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:11:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:11:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:11:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:11:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:11:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:11:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":"00000010000000150000000000000001"} [2022-03-14 12:11:24] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":""} [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 12:11:24] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010800000150000000000000002"} [2022-03-14 12:11:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:11:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:11:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:11:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:11:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:11:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:11:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:11:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:11:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:12:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:12:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:12:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:12:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:12:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:12:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:12:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:12:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:12:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000003"] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":""} [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000002"] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010000000150000000000000002"} [2022-03-14 12:12:25] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000002"] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000003"] [2022-03-14 12:12:25] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":"00000010800000150000000000000003"} [2022-03-14 12:12:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:12:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:12:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:12:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:12:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:12:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:12:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:12:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:12:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:13:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:13:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:13:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:13:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:13:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:13:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:13:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:13:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:13:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000004"] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":""} [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000003"] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":"00000010000000150000000000000003"} [2022-03-14 12:13:26] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000003"] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":3},"sourceData":""} [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000004"] [2022-03-14 12:13:26] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":"00000010800000150000000000000004"} [2022-03-14 12:13:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:13:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:13:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:13:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:13:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:13:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:13:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:13:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:13:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:14:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:14:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:14:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:14:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:14:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:14:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:14:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:14:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:14:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000005"] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":""} [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000004"] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":"00000010000000150000000000000004"} [2022-03-14 12:14:27] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000004"] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":4},"sourceData":""} [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000005"] [2022-03-14 12:14:27] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":"00000010800000150000000000000005"} [2022-03-14 12:14:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:14:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:14:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:14:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:14:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:14:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:14:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:14:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:14:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:15:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:15:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:15:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:15:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:15:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:15:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:15:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:15:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:15:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000006"] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":6},"sourceData":""} [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000005"] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":"00000010000000150000000000000005"} [2022-03-14 12:15:28] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000005"] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":5},"sourceData":""} [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000006"] [2022-03-14 12:15:28] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":6},"sourceData":"00000010800000150000000000000006"} [2022-03-14 12:15:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:15:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:15:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:15:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:15:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:15:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:15:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:15:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:15:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:16:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:16:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:16:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:16:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:16:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:16:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:16:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:16:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:16:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000007"] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":7},"sourceData":""} [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000006"] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":6},"sourceData":"00000010000000150000000000000006"} [2022-03-14 12:16:29] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000006"] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":6},"sourceData":""} [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000007"] [2022-03-14 12:16:29] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":7},"sourceData":"00000010800000150000000000000007"} [2022-03-14 12:16:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:16:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:16:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:16:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:16:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:16:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:16:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:16:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:16:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:17:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:17:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:17:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:17:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:17:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:17:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:17:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:17:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:17:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000008"] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":8},"sourceData":""} [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000007"] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":7},"sourceData":"00000010000000150000000000000007"} [2022-03-14 12:17:30] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000007"] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":7},"sourceData":""} [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000008"] [2022-03-14 12:17:30] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":8},"sourceData":"00000010800000150000000000000008"} [2022-03-14 12:17:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:17:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:17:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:17:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:17:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:17:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:17:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:17:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:17:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:18:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:18:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:18:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:18:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:18:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:18:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:18:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:18:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:18:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010000000150000000000000009"] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":9},"sourceData":""} [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000008"] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":8},"sourceData":"00000010000000150000000000000008"} [2022-03-14 12:18:31] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000008"] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":8},"sourceData":""} [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010800000150000000000000009"] [2022-03-14 12:18:31] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":9},"sourceData":"00000010800000150000000000000009"} [2022-03-14 12:18:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:18:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:18:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:18:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:18:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:18:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:18:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:18:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:18:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:19:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:19:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:19:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:19:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:19:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:19:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:19:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:19:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:19:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001000000015000000000000000a"] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":10},"sourceData":""} [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["00000010000000150000000000000009"] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":9},"sourceData":"00000010000000150000000000000009"} [2022-03-14 12:19:32] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["00000010800000150000000000000009"] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":9},"sourceData":""} [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001080000015000000000000000a"] [2022-03-14 12:19:32] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":10},"sourceData":"0000001080000015000000000000000a"} [2022-03-14 12:19:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:19:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:19:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:19:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:19:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:19:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:19:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:19:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:19:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:20:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:20:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:20:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:20:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:20:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:20:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:20:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:20:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:20:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:20:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:20:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001000000015000000000000000b"] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":11},"sourceData":""} [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001000000015000000000000000a"] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":10},"sourceData":"0000001000000015000000000000000a"} [2022-03-14 12:20:33] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001080000015000000000000000a"] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":10},"sourceData":""} [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001080000015000000000000000b"] [2022-03-14 12:20:33] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":11},"sourceData":"0000001080000015000000000000000b"} [2022-03-14 12:20:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:20:43] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:20:43] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:20:53] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:20:53] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:20:53] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:21:03] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:21:03] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:21:03] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:21:13] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:21:13] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:21:13] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:21:23] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:21:23] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:21:23] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:21:33] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:21:33] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:21:33] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001000000015000000000000000c"] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":12},"sourceData":""} [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001000000015000000000000000b"] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":11},"sourceData":"0000001000000015000000000000000b"} [2022-03-14 12:21:34] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001080000015000000000000000b"] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":11},"sourceData":""} [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001080000015000000000000000c"] [2022-03-14 12:21:34] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":12},"sourceData":"0000001080000015000000000000000c"} [2022-03-14 12:21:43] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:21:59] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:21:59] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:21:59] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:21:59] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:21:59] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:22:09] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:22:09] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:22:09] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:22:19] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:22:19] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:22:19] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:22:29] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:22:29] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:22:29] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001000000015000000000000000d"] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":13},"sourceData":""} [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001000000015000000000000000c"] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":12},"sourceData":"0000001000000015000000000000000c"} [2022-03-14 12:22:35] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001080000015000000000000000c"] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":12},"sourceData":""} [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001080000015000000000000000d"] [2022-03-14 12:22:35] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":13},"sourceData":"0000001080000015000000000000000d"} [2022-03-14 12:22:39] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:22:39] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:22:39] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:22:49] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:22:49] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:22:49] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:22:59] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:22:59] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:22:59] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:23:09] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:23:09] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:23:09] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:23:19] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:23:19] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:23:19] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:23:29] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:23:29] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:23:29] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001000000015000000000000000e"] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":14},"sourceData":""} [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001000000015000000000000000d"] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":13},"sourceData":"0000001000000015000000000000000d"} [2022-03-14 12:23:36] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001080000015000000000000000d"] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":13},"sourceData":""} [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001080000015000000000000000e"] [2022-03-14 12:23:36] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":14},"sourceData":"0000001080000015000000000000000e"} [2022-03-14 12:23:39] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:23:39] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:23:39] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:23:49] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:23:51] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:23:51] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:23:59] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:23:59] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:23:59] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:24:09] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:24:09] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:24:09] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:24:19] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:24:19] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:24:19] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:24:29] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:24:29] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:24:29] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001000000015000000000000000f"] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":15},"sourceData":""} [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001000000015000000000000000e"] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":14},"sourceData":"0000001000000015000000000000000e"} [2022-03-14 12:24:37] [INFO] [PID:14945]: Update last_online timestamp. [] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU:RAW] :: send ["0000001080000015000000000000000e"] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":14},"sourceData":""} [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU:RAW] :: received ["0000001080000015000000000000000f"] [2022-03-14 12:24:37] [DEBUG] [PID:14945]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":15},"sourceData":"0000001080000015000000000000000f"} [2022-03-14 12:24:39] [INFO] [PID:14945]: Get messages from database [] [2022-03-14 12:24:39] [DEBUG] [PID:14945]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:24:39] [NOTICE] [PID:14945]: Selected mesages: 0 [] [2022-03-14 12:24:48] [WARNING] [PID:14945]: Cannot read from connection [] [2022-03-14 12:24:48] [NOTICE] [PID:14945]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:24:48] [NOTICE] [PID:14945]: Exiting [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:32:14] [INFO] [PID:17508]: Connecting to the server. [] [2022-03-14 12:32:14] [NOTICE] [PID:17508]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:32:14] [INFO] [PID:17508]: Binding to the server. [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:32:14] [NOTICE] [PID:17508]: Binded to server with system_id montyws [] [2022-03-14 12:32:14] [INFO] [PID:17508]: Update last_online timestamp. [] [2022-03-14 12:32:14] [WARNING] [PID:17508]: IC point suspend was canceled. [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:32:14] [NOTICE] [PID:17508]: Binded to the server. [] [2022-03-14 12:32:14] [INFO] [PID:17508]: Get messages from database [] [2022-03-14 12:32:14] [DEBUG] [PID:17508]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:32:14] [NOTICE] [PID:17508]: Selected mesages: 0 [] [2022-03-14 12:32:24] [INFO] [PID:17508]: Get messages from database [] [2022-03-14 12:32:24] [DEBUG] [PID:17508]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:32:24] [NOTICE] [PID:17508]: Selected mesages: 0 [] [2022-03-14 12:32:34] [INFO] [PID:17508]: Get messages from database [] [2022-03-14 12:32:34] [DEBUG] [PID:17508]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:32:34] [NOTICE] [PID:17508]: Selected mesages: 0 [] [2022-03-14 12:32:44] [INFO] [PID:17508]: Get messages from database [] [2022-03-14 12:32:44] [DEBUG] [PID:17508]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:32:44] [NOTICE] [PID:17508]: Selected mesages: 0 [] [2022-03-14 12:32:44] [NOTICE] [PID:17508]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:32:44] [INFO] [PID:17508]: Unbinding from the server. [] [2022-03-14 12:32:44] [DEBUG] [PID:17508]: [PDU:RAW] :: send ["00000010000000060000000000000002"] [2022-03-14 12:32:44] [DEBUG] [PID:17508]: [PDU] :: send {"pdu":{"command_id":"0x00000006","command_name":"unbind","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 12:32:44] [DEBUG] [PID:17508]: [PDU:RAW] :: received ["00000010800000060000000000000002"] [2022-03-14 12:32:44] [DEBUG] [PID:17508]: [PDU] :: received {"pdu":{"command_id":"0x80000006","command_name":"unbind_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010800000060000000000000002"} [2022-03-14 12:32:44] [INFO] [PID:17508]: Update last_online timestamp. [] [2022-03-14 12:32:44] [DEBUG] [PID:17508]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = NULL WHERE id = 4 [] [2022-03-14 12:32:44] [NOTICE] [PID:17508]: Unbinded from the server. [] [2022-03-14 12:32:44] [NOTICE] [PID:17508]: Exiting [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:32:51] [INFO] [PID:17617]: Connecting to the server. [] [2022-03-14 12:32:51] [NOTICE] [PID:17617]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:32:51] [INFO] [PID:17617]: Binding to the server. [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:32:51] [NOTICE] [PID:17617]: Binded to server with system_id montyws [] [2022-03-14 12:32:51] [INFO] [PID:17617]: Update last_online timestamp. [] [2022-03-14 12:32:51] [WARNING] [PID:17617]: IC point suspend was canceled. [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:32:51] [NOTICE] [PID:17617]: Binded to the server. [] [2022-03-14 12:32:51] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:32:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:32:51] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:01] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:33:01] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:33:01] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:11] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:33:11] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:33:11] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:21] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:33:21] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:33:21] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:31] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:33:31] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:33:31] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:41] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:33:41] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:33:41] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:51] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:33:51] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:33:51] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":"00000010000000150000000000000001"} [2022-03-14 12:33:52] [INFO] [PID:17617]: Update last_online timestamp. [] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":""} [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 12:33:52] [DEBUG] [PID:17617]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010800000150000000000000002"} [2022-03-14 12:34:01] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:34:01] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:34:01] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:34:11] [INFO] [PID:17617]: Get messages from database [] [2022-03-14 12:34:11] [DEBUG] [PID:17617]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:34:11] [NOTICE] [PID:17617]: Selected mesages: 0 [] [2022-03-14 12:34:18] [WARNING] [PID:17617]: Cannot read from connection [] [2022-03-14 12:34:18] [NOTICE] [PID:17617]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:34:18] [NOTICE] [PID:17617]: Exiting [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:34:36] [INFO] [PID:17774]: Connecting to the server. [] [2022-03-14 12:34:36] [NOTICE] [PID:17774]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:34:36] [INFO] [PID:17774]: Binding to the server. [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:34:36] [NOTICE] [PID:17774]: Binded to server with system_id montyws [] [2022-03-14 12:34:36] [INFO] [PID:17774]: Update last_online timestamp. [] [2022-03-14 12:34:36] [WARNING] [PID:17774]: IC point suspend was canceled. [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:34:36] [NOTICE] [PID:17774]: Binded to the server. [] [2022-03-14 12:34:36] [INFO] [PID:17774]: Get messages from database [] [2022-03-14 12:34:36] [DEBUG] [PID:17774]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:34:36] [NOTICE] [PID:17774]: Selected mesages: 0 [] [2022-03-14 12:34:39] [WARNING] [PID:17774]: Cannot read from connection [] [2022-03-14 12:34:39] [NOTICE] [PID:17774]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:34:39] [NOTICE] [PID:17774]: Exiting [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:34:59] [INFO] [PID:17900]: Connecting to the server. [] [2022-03-14 12:34:59] [NOTICE] [PID:17900]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:34:59] [INFO] [PID:17900]: Binding to the server. [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:34:59] [NOTICE] [PID:17900]: Binded to server with system_id montyws [] [2022-03-14 12:34:59] [INFO] [PID:17900]: Update last_online timestamp. [] [2022-03-14 12:34:59] [WARNING] [PID:17900]: IC point suspend was canceled. [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:34:59] [NOTICE] [PID:17900]: Binded to the server. [] [2022-03-14 12:34:59] [INFO] [PID:17900]: Get messages from database [] [2022-03-14 12:34:59] [DEBUG] [PID:17900]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:34:59] [NOTICE] [PID:17900]: Selected mesages: 0 [] [2022-03-14 12:35:09] [INFO] [PID:17900]: Get messages from database [] [2022-03-14 12:35:09] [DEBUG] [PID:17900]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:35:09] [NOTICE] [PID:17900]: Selected mesages: 0 [] [2022-03-14 12:35:19] [INFO] [PID:17900]: Get messages from database [] [2022-03-14 12:35:19] [DEBUG] [PID:17900]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:35:19] [NOTICE] [PID:17900]: Selected mesages: 0 [] [2022-03-14 12:35:22] [WARNING] [PID:17900]: Cannot read from connection [] [2022-03-14 12:35:22] [NOTICE] [PID:17900]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:35:22] [NOTICE] [PID:17900]: Exiting [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:35:26] [INFO] [PID:18014]: Connecting to the server. [] [2022-03-14 12:35:26] [NOTICE] [PID:18014]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:35:26] [INFO] [PID:18014]: Binding to the server. [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:35:26] [NOTICE] [PID:18014]: Binded to server with system_id montyws [] [2022-03-14 12:35:26] [INFO] [PID:18014]: Update last_online timestamp. [] [2022-03-14 12:35:26] [WARNING] [PID:18014]: IC point suspend was canceled. [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:35:26] [NOTICE] [PID:18014]: Binded to the server. [] [2022-03-14 12:35:26] [INFO] [PID:18014]: Get messages from database [] [2022-03-14 12:35:26] [DEBUG] [PID:18014]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:35:26] [NOTICE] [PID:18014]: Selected mesages: 0 [] [2022-03-14 12:35:36] [INFO] [PID:18014]: Get messages from database [] [2022-03-14 12:35:36] [DEBUG] [PID:18014]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:35:36] [NOTICE] [PID:18014]: Selected mesages: 0 [] [2022-03-14 12:35:46] [INFO] [PID:18014]: Get messages from database [] [2022-03-14 12:35:46] [DEBUG] [PID:18014]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:35:46] [NOTICE] [PID:18014]: Selected mesages: 0 [] [2022-03-14 12:35:56] [INFO] [PID:18014]: Get messages from database [] [2022-03-14 12:35:56] [DEBUG] [PID:18014]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:35:56] [NOTICE] [PID:18014]: Selected mesages: 0 [] [2022-03-14 12:36:06] [INFO] [PID:18014]: Get messages from database [] [2022-03-14 12:36:06] [DEBUG] [PID:18014]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:36:06] [NOTICE] [PID:18014]: Selected mesages: 0 [] [2022-03-14 12:36:15] [WARNING] [PID:18014]: Cannot read from connection [] [2022-03-14 12:36:15] [NOTICE] [PID:18014]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:36:15] [NOTICE] [PID:18014]: Exiting [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:36:20] [INFO] [PID:18123]: Connecting to the server. [] [2022-03-14 12:36:20] [NOTICE] [PID:18123]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:36:20] [INFO] [PID:18123]: Binding to the server. [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:36:20] [NOTICE] [PID:18123]: Binded to server with system_id montyws [] [2022-03-14 12:36:20] [INFO] [PID:18123]: Update last_online timestamp. [] [2022-03-14 12:36:20] [WARNING] [PID:18123]: IC point suspend was canceled. [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:36:20] [NOTICE] [PID:18123]: Binded to the server. [] [2022-03-14 12:36:20] [INFO] [PID:18123]: Get messages from database [] [2022-03-14 12:36:20] [DEBUG] [PID:18123]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:36:20] [NOTICE] [PID:18123]: Selected mesages: 0 [] [2022-03-14 12:36:30] [INFO] [PID:18123]: Get messages from database [] [2022-03-14 12:36:30] [DEBUG] [PID:18123]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:36:30] [NOTICE] [PID:18123]: Selected mesages: 0 [] [2022-03-14 12:36:40] [INFO] [PID:18123]: Get messages from database [] [2022-03-14 12:36:40] [DEBUG] [PID:18123]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:36:40] [NOTICE] [PID:18123]: Selected mesages: 0 [] [2022-03-14 12:36:42] [WARNING] [PID:18123]: Cannot read from connection [] [2022-03-14 12:36:42] [NOTICE] [PID:18123]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:36:42] [NOTICE] [PID:18123]: Exiting [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montyws' LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 4 LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: LISTEN "client_montyws_4"; [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:36:49] [INFO] [PID:18239]: Connecting to the server. [] [2022-03-14 12:36:49] [NOTICE] [PID:18239]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:36:49] [INFO] [PID:18239]: Binding to the server. [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74797773006865736c6f00736d70700034010000"] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws","password":"heslo","system_type":"smpp","interface_version":52,"addr_ton":1,"addr_npi":0,"address_range":""},"sourceData":""} [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479777300"] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montyws"},"sourceData":"000000188000000900000000000000016d6f6e7479777300"} [2022-03-14 12:36:49] [NOTICE] [PID:18239]: Binded to server with system_id montyws [] [2022-03-14 12:36:49] [INFO] [PID:18239]: Update last_online timestamp. [] [2022-03-14 12:36:49] [WARNING] [PID:18239]: IC point suspend was canceled. [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 4 [] [2022-03-14 12:36:49] [NOTICE] [PID:18239]: Binded to the server. [] [2022-03-14 12:36:49] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:36:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:36:49] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:36:59] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:36:59] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:36:59] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:37:09] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:37:09] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:37:09] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:37:19] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:37:19] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:37:19] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:37:29] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:37:29] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:37:29] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:37:39] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:37:39] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:37:39] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:37:49] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:37:49] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:37:49] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU] :: received {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":"00000010000000150000000000000001"} [2022-03-14 12:37:50] [INFO] [PID:18239]: Update last_online timestamp. [] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 4 [] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU] :: send {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1},"sourceData":""} [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU] :: send {"pdu":{"command_id":"0x00000015","command_name":"enquire_link","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":""} [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 12:37:50] [DEBUG] [PID:18239]: [PDU] :: received {"pdu":{"command_id":"0x80000015","command_name":"enquire_link_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":2},"sourceData":"00000010800000150000000000000002"} [2022-03-14 12:37:59] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:37:59] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:37:59] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:38:09] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:38:09] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:38:09] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:38:19] [INFO] [PID:18239]: Get messages from database [] [2022-03-14 12:38:19] [DEBUG] [PID:18239]: [SQL::ipfon] :: UPDATE ipfon_sms_out_queue SET time_processed = NOW(), remote_id = 'WAITING' WHERE msg_id IN (SELECT msg_id FROM ipfon_sms_out_queue WHERE msg_id IS NOT NULL AND (dst_gw = 'montyws' AND dst_icpoint = '4') AND status = 'ENROUTE' AND ((errcode IS NULL AND remote_id IS NULL) OR (errcode = 4099 AND (remote_id IS NULL OR remote_id = 'WAITING'))) AND time_send <= NOW() ORDER BY priority DESC NULLS LAST, time_queued ASC, id ASC LIMIT 100) RETURNING * [] [2022-03-14 12:38:19] [NOTICE] [PID:18239]: Selected mesages: 0 [] [2022-03-14 12:38:21] [WARNING] [PID:18239]: Cannot read from connection [] [2022-03-14 12:38:21] [NOTICE] [PID:18239]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:38:21] [NOTICE] [PID:18239]: Exiting []