[asterisk-bugs] [JIRA] (ASTERISK-25526) In case of incorrect request in a database, after several attempts, service the asterisk is disconnected

User User (JIRA) noreply at issues.asterisk.org
Fri Nov 6 00:40:34 CST 2015 

User User created ASTERISK-25526:
------------------------------------

             Summary: In case of incorrect request in a database, after several attempts, service the asterisk is disconnected
                 Key: ASTERISK-25526
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25526
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Resources/res_odbc
    Affects Versions: 13.5.0
         Environment: Linux  3.13.0-67-generic #110-Ubuntu SMP Fri Oct 23 13:24:41 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
Asterisk is set from source codes. Postgresql-9.3 from packages
            Reporter: User User
            Severity: Critical


In case of incorrect request in a database, after several attempts, service the asterisk is disconnected. The erratic inquiry isn't ignored, operation stops.

[Oct  5 21:53:19] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:19] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:19] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:19] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:19] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:19] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:19] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:19] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:19] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:19] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:19] WARNING[1302]: cel_odbc.c:772 odbc_log: Insert failed on 'asterisk:cel'.  CEL failed: INSERT INTO cel (eventtype,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,peeraccount,uniqueid,linkedid,userfield,peer) VALUES ('CHAN_START',{ts '2015-10-05 21:53:19.556290'},'','gogina','1843','','','','09989107892981▒095340109','internal','SIP/1843-00005671','','',3,'','','1444071199.36339','1444071199.36339','','')
[Oct  5 21:53:19] WARNING[1549][C-000026a0]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:19] WARNING[1549][C-000026a0]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:19] WARNING[1549][C-000026a0]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:19] NOTICE[1549][C-000026a0]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:20] WARNING[1549][C-000026a0]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:20] NOTICE[1549][C-000026a0]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:20] ERROR[22623][C-000026a0]: json.c:704 ast_json_vpack: Error building JSON from '{s: s, s: s}': Invalid UTF-8 string.
[Oct  5 21:53:20] ERROR[22623][C-000026a0]: stasis_channels.c:771 ast_channel_publish_varset: Error creating message
[Oct  5 21:53:20] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:20] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:20] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:20] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:20] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:20] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:20] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:20] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:20] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:20] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:20] WARNING[1302]: cel_odbc.c:772 odbc_log: Insert failed on 'asterisk:cel'.  CEL failed: INSERT INTO cel (eventtype,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,peeraccount,uniqueid,linkedid,userfield,peer) VALUES ('ANSWER',{ts '2015-10-05 21:53:20.517006'},'','gogina','1843','1843','','09989107892981▒095340109','i','outgoing-in-city-dial','SIP/1843-00005671','Playback','invalid',3,'','','1444071199.36339','1444071199.36339','','')
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:21] WARNING[1302]: cel_odbc.c:772 odbc_log: Insert failed on 'asterisk:cel'.  CEL failed: INSERT INTO cel (eventtype,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,peeraccount,uniqueid,linkedid,userfield,peer) VALUES ('HANGUP',{ts '2015-10-05 21:53:21.553657'},'','gogina','1843','1843','','09989107892981▒095340109','i','outgoing-in-city-dial','SIP/1843-00005671','','',3,'','','1444071199.36339','1444071199.36339','','')
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Oct  5 21:53:21] NOTICE[1302]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Oct  5 21:53:21] WARNING[1302]: cel_odbc.c:772 odbc_log: Insert failed on 'asterisk:cel'.  CEL failed: INSERT INTO cel (eventtype,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,peeraccount,uniqueid,linkedid,userfield,peer) VALUES ('CHAN_END',{ts '2015-10-05 21:53:21.730051'},'','gogina','1843','1843','','09989107892981▒095340109','i','outgoing-in-city-dial','SIP/1843-00005671','','',3,'','','1444071199.36339','1444071199.36339','','')
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 08S01: Error while executing the query (31)
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...
[Oct  5 21:53:21] WARNING[1302]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
dcccast*CLI>
Disconnected from Asterisk server
Asterisk cleanly ending (0).
Executing last minute cleanups



--
This message was sent by Atlassian JIRA
(v6.2#6252)

More information about the asterisk-bugs mailing list