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

Rusty Newton (JIRA) noreply at issues.asterisk.org
Fri Nov 6 07:38:33 CST 2015 

     [ https://issues.asterisk.org/jira/browse/ASTERISK-25526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-25526:
------------------------------------

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

[Edit by Rusty - debug log removed from *Description* field. Please attach debug logs to the issue as .txt files]

  was:
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


> 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.
> [Edit by Rusty - debug log removed from *Description* field. Please attach debug logs to the issue as .txt files]



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

More information about the asterisk-bugs mailing list