[2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 11:22:10] [INFO] [PID:3183]: Connecting to the server. [] [2022-03-14 11:22:10] [NOTICE] [PID:3183]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 11:22:10] [INFO] [PID:3183]: Binding to the server. [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:3183]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 11:22:10] [NOTICE] [PID:3183]: Binded to server with system_id montydr [] [2022-03-14 11:22:10] [INFO] [PID:3183]: Update last_online timestamp. [] [2022-03-14 11:22:10] [WARNING] [PID:3183]: IC point suspend was canceled. [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 11:22:10] [NOTICE] [PID:3183]: Binded to the server. [] [2022-03-14 11:22:10] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:22:10] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:22:20] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:22:20] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:22:30] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:22:30] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:22:40] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:22:40] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:22:50] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:22:50] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:23:00] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:23:00] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:23:10] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:23:10] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [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:3183]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [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:3183]: Update last_online timestamp. [] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [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:3183]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 11:23:11] [DEBUG] [PID:3183]: [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:3183]: Get messages from database [] [2022-03-14 11:23:20] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:23:30] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:23:30] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:23:40] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:23:40] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:23:50] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:23:50] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:24:00] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:24:00] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:24:10] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:24:10] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010000000150000000000000003"] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [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:3183]: [PDU:RAW] :: received ["00000010800000150000000000000003"] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [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:12] [INFO] [PID:3183]: Update last_online timestamp. [] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [PDU:RAW] :: received ["00000010000000150000000000000002"] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [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] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010800000150000000000000002"] [2022-03-14 11:24:12] [DEBUG] [PID:3183]: [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:20] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:24:20] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:24:30] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:24:30] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:24:40] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:24:40] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:24:50] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:24:50] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:25:00] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:25:31] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:25:31] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:25:31] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:25:31] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010000000150000000000000004"] [2022-03-14 11:25:31] [DEBUG] [PID:3183]: [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:3183]: [PDU:RAW] :: received ["00000010800000150000000000000004"] [2022-03-14 11:25:31] [DEBUG] [PID:3183]: [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:31] [INFO] [PID:3183]: Update last_online timestamp. [] [2022-03-14 11:25:31] [DEBUG] [PID:3183]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 11:25:32] [DEBUG] [PID:3183]: [PDU:RAW] :: received ["00000010000000150000000000000003"] [2022-03-14 11:25:32] [DEBUG] [PID:3183]: [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:32] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010800000150000000000000003"] [2022-03-14 11:25:32] [DEBUG] [PID:3183]: [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:41] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:25:41] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:25:51] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:25:51] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:26:01] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:26:01] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:26:11] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:26:11] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:26:21] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:26:21] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:26:31] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:26:31] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:26:32] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010000000150000000000000005"] [2022-03-14 11:26:32] [DEBUG] [PID:3183]: [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:3183]: [PDU:RAW] :: received ["00000010800000150000000000000005"] [2022-03-14 11:26:32] [DEBUG] [PID:3183]: [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:32] [INFO] [PID:3183]: Update last_online timestamp. [] [2022-03-14 11:26:32] [DEBUG] [PID:3183]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 11:26:33] [DEBUG] [PID:3183]: [PDU:RAW] :: received ["00000010000000150000000000000004"] [2022-03-14 11:26:33] [DEBUG] [PID:3183]: [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:33] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010800000150000000000000004"] [2022-03-14 11:26:33] [DEBUG] [PID:3183]: [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:41] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:26:41] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:26:51] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:26:51] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:01] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:27:01] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:11] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:27:11] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:21] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:27:21] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:31] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:27:31] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:33] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010000000150000000000000006"] [2022-03-14 11:27:33] [DEBUG] [PID:3183]: [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:3183]: [PDU:RAW] :: received ["00000010800000150000000000000006"] [2022-03-14 11:27:33] [DEBUG] [PID:3183]: [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:33] [INFO] [PID:3183]: Update last_online timestamp. [] [2022-03-14 11:27:33] [DEBUG] [PID:3183]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 11:27:34] [DEBUG] [PID:3183]: [PDU:RAW] :: received ["00000010000000150000000000000005"] [2022-03-14 11:27:34] [DEBUG] [PID:3183]: [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:34] [DEBUG] [PID:3183]: [PDU:RAW] :: send ["00000010800000150000000000000005"] [2022-03-14 11:27:34] [DEBUG] [PID:3183]: [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:41] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:27:41] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:51] [INFO] [PID:3183]: Get messages from database [] [2022-03-14 11:27:51] [DEBUG] [PID:3183]: [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 = 'montydr' AND dst_icpoint = '5') 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:3183]: Selected mesages: 0 [] [2022-03-14 11:27:57] [WARNING] [PID:3183]: Cannot read from connection [] [2022-03-14 11:27:57] [NOTICE] [PID:3183]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 11:27:57] [NOTICE] [PID:3183]: Exiting [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:04:07] [INFO] [PID:9487]: Connecting to the server. [] [2022-03-14 12:04:07] [NOTICE] [PID:9487]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:04:07] [INFO] [PID:9487]: Binding to the server. [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:9487]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:04:07] [NOTICE] [PID:9487]: Binded to server with system_id montydr [] [2022-03-14 12:04:07] [INFO] [PID:9487]: Update last_online timestamp. [] [2022-03-14 12:04:07] [WARNING] [PID:9487]: IC point suspend was canceled. [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:04:07] [NOTICE] [PID:9487]: Binded to the server. [] [2022-03-14 12:04:07] [INFO] [PID:9487]: Get messages from database [] [2022-03-14 12:04:07] [DEBUG] [PID:9487]: [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 = 'montydr' AND dst_icpoint = '5') 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:9487]: Selected mesages: 0 [] [2022-03-14 12:04:17] [INFO] [PID:9487]: Get messages from database [] [2022-03-14 12:04:17] [DEBUG] [PID:9487]: [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 = 'montydr' AND dst_icpoint = '5') 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:9487]: Selected mesages: 0 [] [2022-03-14 12:04:23] [WARNING] [PID:9487]: Cannot read from connection [] [2022-03-14 12:04:23] [NOTICE] [PID:9487]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:04:23] [NOTICE] [PID:9487]: Exiting [] [2022-03-14 12:10:22] [DEBUG] [PID:14946]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:10:22] [DEBUG] [PID:14946]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:10:22] [DEBUG] [PID:14946]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:10:22] [DEBUG] [PID:14946]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:10:23] [INFO] [PID:14946]: Connecting to the server. [] [2022-03-14 12:10:23] [NOTICE] [PID:14946]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:10:23] [INFO] [PID:14946]: Binding to the server. [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:14946]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:10:23] [NOTICE] [PID:14946]: Binded to server with system_id montydr [] [2022-03-14 12:10:23] [INFO] [PID:14946]: Update last_online timestamp. [] [2022-03-14 12:10:23] [WARNING] [PID:14946]: IC point suspend was canceled. [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:10:23] [NOTICE] [PID:14946]: Binded to the server. [] [2022-03-14 12:10:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:10:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:10:33] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:10:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:10:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:10:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:10:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:10:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:11:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:11:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:11:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:11:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:11:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:11:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 12:11:24] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:11:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:11:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:11:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:11:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:11:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:12:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:12:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:12:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:12:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:12:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:12:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [PDU:RAW] :: received ["00000010000000150000000000000002"] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000002"] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: send ["00000010000000150000000000000003"] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000003"] [2022-03-14 12:12:25] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:12:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:12:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:12:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:12:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:12:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:13:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:13:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:13:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:13:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:13:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:13:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [PDU:RAW] :: received ["00000010000000150000000000000003"] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000003"] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: send ["00000010000000150000000000000004"] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000004"] [2022-03-14 12:13:26] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:13:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:13:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:13:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:13:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:13:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:14:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:14:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:14:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:14:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:14:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:14:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010000000150000000000000005"] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010000000150000000000000004"] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000004"] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000005"] [2022-03-14 12:14:27] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:14:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:14:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:14:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:14:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:14:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:15:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:15:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:15:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:15:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:15:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:15:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010000000150000000000000006"] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010000000150000000000000005"] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000005"] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000006"] [2022-03-14 12:15:28] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:15:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:15:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:15:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:15:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:15:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:16:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:16:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:16:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:16:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:16:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:16:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010000000150000000000000007"] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010000000150000000000000006"] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000006"] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000007"] [2022-03-14 12:16:29] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:16:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:16:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:16:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:16:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:16:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:17:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:17:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:17:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:17:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:17:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:17:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010000000150000000000000008"] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000008"] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [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:30] [INFO] [PID:14946]: Update last_online timestamp. [] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [PDU:RAW] :: received ["00000010000000150000000000000007"] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [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] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000007"] [2022-03-14 12:17:30] [DEBUG] [PID:14946]: [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:33] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:17:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:17:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:17:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:17:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:17:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:18:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:18:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:18:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:18:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:18:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:18:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010000000150000000000000009"] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010000000150000000000000008"] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000008"] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["00000010800000150000000000000009"] [2022-03-14 12:18:31] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:18:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:18:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:18:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:18:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:18:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:19:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:19:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:19:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:19:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:19:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:19:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [PDU:RAW] :: received ["00000010000000150000000000000009"] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["00000010800000150000000000000009"] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: send ["0000001000000015000000000000000a"] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001080000015000000000000000a"] [2022-03-14 12:19:32] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:19:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:19:43] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:19:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:19:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:19:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:20:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:20:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:20:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:20:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:20:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:20:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:20:33] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001000000015000000000000000b"] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001000000015000000000000000a"] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001080000015000000000000000a"] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001080000015000000000000000b"] [2022-03-14 12:20:33] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:20:43] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:20:53] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:20:53] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:21:03] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:21:03] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:21:13] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:21:13] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:21:23] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:21:23] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:21:33] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:21:33] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001000000015000000000000000c"] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001000000015000000000000000b"] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001080000015000000000000000b"] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001080000015000000000000000c"] [2022-03-14 12:21:34] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:21:59] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:21:59] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:21:59] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:22:09] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:22:09] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:22:19] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:22:19] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:22:29] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:22:29] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001000000015000000000000000d"] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001000000015000000000000000c"] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001080000015000000000000000c"] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001080000015000000000000000d"] [2022-03-14 12:22:35] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:22:39] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:22:49] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:22:49] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:22:59] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:22:59] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:23:09] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:23:09] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:23:19] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:23:19] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:23:29] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:23:29] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001000000015000000000000000e"] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001000000015000000000000000d"] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001080000015000000000000000d"] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001080000015000000000000000e"] [2022-03-14 12:23:36] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:23:39] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:23:49] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:23:49] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:49] [NOTICE] [PID:14946]: Selected mesages: 0 [] [2022-03-14 12:23:59] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:23:59] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:24:09] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:24:09] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:24:19] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:24:19] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:24:29] [INFO] [PID:14946]: Get messages from database [] [2022-03-14 12:24:29] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [PDU:RAW] :: received ["0000001000000015000000000000000e"] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [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:14946]: Update last_online timestamp. [] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [PDU:RAW] :: send ["0000001080000015000000000000000e"] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: send ["0000001000000015000000000000000f"] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [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:14946]: [PDU:RAW] :: received ["0000001080000015000000000000000f"] [2022-03-14 12:24:37] [DEBUG] [PID:14946]: [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:14946]: Get messages from database [] [2022-03-14 12:24:39] [DEBUG] [PID:14946]: [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 = 'montydr' AND dst_icpoint = '5') 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:14946]: Selected mesages: 0 [] [2022-03-14 12:24:48] [WARNING] [PID:14946]: Cannot read from connection [] [2022-03-14 12:24:48] [NOTICE] [PID:14946]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:24:48] [NOTICE] [PID:14946]: Exiting [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:32:14] [INFO] [PID:17509]: Connecting to the server. [] [2022-03-14 12:32:14] [NOTICE] [PID:17509]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:32:14] [INFO] [PID:17509]: Binding to the server. [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:17509]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:32:14] [NOTICE] [PID:17509]: Binded to server with system_id montydr [] [2022-03-14 12:32:14] [INFO] [PID:17509]: Update last_online timestamp. [] [2022-03-14 12:32:14] [WARNING] [PID:17509]: IC point suspend was canceled. [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:32:14] [NOTICE] [PID:17509]: Binded to the server. [] [2022-03-14 12:32:14] [INFO] [PID:17509]: Get messages from database [] [2022-03-14 12:32:14] [DEBUG] [PID:17509]: [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 = 'montydr' AND dst_icpoint = '5') 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:17509]: Selected mesages: 0 [] [2022-03-14 12:32:24] [INFO] [PID:17509]: Get messages from database [] [2022-03-14 12:32:24] [DEBUG] [PID:17509]: [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 = 'montydr' AND dst_icpoint = '5') 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:17509]: Selected mesages: 0 [] [2022-03-14 12:32:34] [INFO] [PID:17509]: Get messages from database [] [2022-03-14 12:32:34] [DEBUG] [PID:17509]: [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 = 'montydr' AND dst_icpoint = '5') 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:17509]: Selected mesages: 0 [] [2022-03-14 12:32:43] [WARNING] [PID:17509]: Cannot read from connection [] [2022-03-14 12:32:43] [NOTICE] [PID:17509]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:32:43] [NOTICE] [PID:17509]: Exiting [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:32:51] [INFO] [PID:17618]: Connecting to the server. [] [2022-03-14 12:32:51] [NOTICE] [PID:17618]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:32:51] [INFO] [PID:17618]: Binding to the server. [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:17618]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:32:51] [NOTICE] [PID:17618]: Binded to server with system_id montydr [] [2022-03-14 12:32:51] [INFO] [PID:17618]: Update last_online timestamp. [] [2022-03-14 12:32:51] [WARNING] [PID:17618]: IC point suspend was canceled. [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:32:51] [NOTICE] [PID:17618]: Binded to the server. [] [2022-03-14 12:32:51] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:32:51] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:01] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:33:01] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:11] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:33:11] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:21] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:33:21] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:31] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:33:31] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:41] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:33:41] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:51] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:33:51] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [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:17618]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [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:17618]: Update last_online timestamp. [] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [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:17618]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 12:33:52] [DEBUG] [PID:17618]: [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:17618]: Get messages from database [] [2022-03-14 12:34:01] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:34:11] [INFO] [PID:17618]: Get messages from database [] [2022-03-14 12:34:11] [DEBUG] [PID:17618]: [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 = 'montydr' AND dst_icpoint = '5') 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:17618]: Selected mesages: 0 [] [2022-03-14 12:34:18] [WARNING] [PID:17618]: Cannot read from connection [] [2022-03-14 12:34:18] [NOTICE] [PID:17618]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:34:18] [NOTICE] [PID:17618]: Exiting [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:34:36] [INFO] [PID:17775]: Connecting to the server. [] [2022-03-14 12:34:36] [NOTICE] [PID:17775]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:34:36] [INFO] [PID:17775]: Binding to the server. [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:17775]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:34:36] [NOTICE] [PID:17775]: Binded to server with system_id montydr [] [2022-03-14 12:34:36] [INFO] [PID:17775]: Update last_online timestamp. [] [2022-03-14 12:34:36] [WARNING] [PID:17775]: IC point suspend was canceled. [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:34:36] [NOTICE] [PID:17775]: Binded to the server. [] [2022-03-14 12:34:36] [INFO] [PID:17775]: Get messages from database [] [2022-03-14 12:34:36] [DEBUG] [PID:17775]: [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 = 'montydr' AND dst_icpoint = '5') 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:17775]: Selected mesages: 0 [] [2022-03-14 12:34:39] [WARNING] [PID:17775]: Cannot read from connection [] [2022-03-14 12:34:39] [NOTICE] [PID:17775]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:34:39] [NOTICE] [PID:17775]: Exiting [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:34:59] [INFO] [PID:17901]: Connecting to the server. [] [2022-03-14 12:34:59] [NOTICE] [PID:17901]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:34:59] [INFO] [PID:17901]: Binding to the server. [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:17901]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:34:59] [NOTICE] [PID:17901]: Binded to server with system_id montydr [] [2022-03-14 12:34:59] [INFO] [PID:17901]: Update last_online timestamp. [] [2022-03-14 12:34:59] [WARNING] [PID:17901]: IC point suspend was canceled. [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:34:59] [NOTICE] [PID:17901]: Binded to the server. [] [2022-03-14 12:34:59] [INFO] [PID:17901]: Get messages from database [] [2022-03-14 12:34:59] [DEBUG] [PID:17901]: [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 = 'montydr' AND dst_icpoint = '5') 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:17901]: Selected mesages: 0 [] [2022-03-14 12:35:09] [INFO] [PID:17901]: Get messages from database [] [2022-03-14 12:35:09] [DEBUG] [PID:17901]: [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 = 'montydr' AND dst_icpoint = '5') 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:17901]: Selected mesages: 0 [] [2022-03-14 12:35:19] [INFO] [PID:17901]: Get messages from database [] [2022-03-14 12:35:19] [DEBUG] [PID:17901]: [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 = 'montydr' AND dst_icpoint = '5') 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:17901]: Selected mesages: 0 [] [2022-03-14 12:35:21] [WARNING] [PID:17901]: Cannot read from connection [] [2022-03-14 12:35:21] [NOTICE] [PID:17901]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:35:21] [NOTICE] [PID:17901]: Exiting [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:35:26] [INFO] [PID:18015]: Connecting to the server. [] [2022-03-14 12:35:26] [NOTICE] [PID:18015]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:35:26] [INFO] [PID:18015]: Binding to the server. [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:18015]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:35:26] [NOTICE] [PID:18015]: Binded to server with system_id montydr [] [2022-03-14 12:35:26] [INFO] [PID:18015]: Update last_online timestamp. [] [2022-03-14 12:35:26] [WARNING] [PID:18015]: IC point suspend was canceled. [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:35:26] [NOTICE] [PID:18015]: Binded to the server. [] [2022-03-14 12:35:26] [INFO] [PID:18015]: Get messages from database [] [2022-03-14 12:35:26] [DEBUG] [PID:18015]: [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 = 'montydr' AND dst_icpoint = '5') 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:18015]: Selected mesages: 0 [] [2022-03-14 12:35:36] [INFO] [PID:18015]: Get messages from database [] [2022-03-14 12:35:36] [DEBUG] [PID:18015]: [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 = 'montydr' AND dst_icpoint = '5') 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:18015]: Selected mesages: 0 [] [2022-03-14 12:35:46] [INFO] [PID:18015]: Get messages from database [] [2022-03-14 12:35:46] [DEBUG] [PID:18015]: [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 = 'montydr' AND dst_icpoint = '5') 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:18015]: Selected mesages: 0 [] [2022-03-14 12:35:56] [INFO] [PID:18015]: Get messages from database [] [2022-03-14 12:35:56] [DEBUG] [PID:18015]: [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 = 'montydr' AND dst_icpoint = '5') 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:18015]: Selected mesages: 0 [] [2022-03-14 12:36:06] [INFO] [PID:18015]: Get messages from database [] [2022-03-14 12:36:06] [DEBUG] [PID:18015]: [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 = 'montydr' AND dst_icpoint = '5') 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:18015]: Selected mesages: 0 [] [2022-03-14 12:36:15] [WARNING] [PID:18015]: Cannot read from connection [] [2022-03-14 12:36:15] [NOTICE] [PID:18015]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:36:15] [NOTICE] [PID:18015]: Exiting [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::globis] :: set datestyle=iso [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: set datestyle=iso [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_route WHERE sysname = 'montydr' LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: SELECT * FROM ipfon_sms_icpoint WHERE id = 5 LIMIT 1 OFFSET 0 [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: LISTEN "client_montydr_5"; [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: LISTEN notify_limit_changed; [] [2022-03-14 12:36:49] [INFO] [PID:18240]: Connecting to the server. [] [2022-03-14 12:36:49] [NOTICE] [PID:18240]: Connected to the server. IP:PORT => 127.0.0.1:2775 [] [2022-03-14 12:36:49] [INFO] [PID:18240]: Binding to the server. [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [PDU:RAW] :: send ["000000270000000900000000000000016d6f6e74796472006865736c6f00736d70700034010000"] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [PDU] :: send {"pdu":{"command_id":"0x00000009","command_name":"bind_transceiver","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr","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:18240]: [PDU:RAW] :: received ["000000188000000900000000000000016d6f6e7479647200"] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [PDU] :: received {"pdu":{"command_id":"0x80000009","command_name":"bind_transceiver_resp","command_status":"0x00000000","command_status_description":"No Error","sequence_number":1,"system_id":"montydr"},"sourceData":"000000188000000900000000000000016d6f6e7479647200"} [2022-03-14 12:36:49] [NOTICE] [PID:18240]: Binded to server with system_id montydr [] [2022-03-14 12:36:49] [INFO] [PID:18240]: Update last_online timestamp. [] [2022-03-14 12:36:49] [WARNING] [PID:18240]: IC point suspend was canceled. [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now(), "suspend_until" = NULL WHERE id = 5 [] [2022-03-14 12:36:49] [NOTICE] [PID:18240]: Binded to the server. [] [2022-03-14 12:36:49] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:36:49] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:36:59] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:36:59] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:37:09] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:37:09] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:37:19] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:37:19] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:37:29] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:37:29] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:37:39] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:37:39] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:37:49] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:37:49] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [PDU:RAW] :: send ["00000010000000150000000000000002"] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [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:18240]: [PDU:RAW] :: received ["00000010000000150000000000000001"] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [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:18240]: Update last_online timestamp. [] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [SQL::ipfon] :: UPDATE ipfon_sms_icpoint SET "last_online" = now() WHERE id = 5 [] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [PDU:RAW] :: send ["00000010800000150000000000000001"] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [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:18240]: [PDU:RAW] :: received ["00000010800000150000000000000002"] [2022-03-14 12:37:50] [DEBUG] [PID:18240]: [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:18240]: Get messages from database [] [2022-03-14 12:37:59] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:38:09] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:38:09] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:38:19] [INFO] [PID:18240]: Get messages from database [] [2022-03-14 12:38:19] [DEBUG] [PID:18240]: [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 = 'montydr' AND dst_icpoint = '5') 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:18240]: Selected mesages: 0 [] [2022-03-14 12:38:21] [WARNING] [PID:18240]: Cannot read from connection [] [2022-03-14 12:38:21] [NOTICE] [PID:18240]: Received signal for exit, waiting for finish current batch. [] [2022-03-14 12:38:21] [NOTICE] [PID:18240]: Exiting []