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

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

    [ https://issues.asterisk.org/jira/browse/ASTERISK-25526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=228169#comment-228169 ] 

Asterisk Team commented on ASTERISK-25526:
------------------------------------------

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

> 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