[Home]

Summary:ASTERISK-16328: odbc can't insert specyfic record
Reporter:Maciej Krajewski (jamicque)Labels:
Date Opened:2010-07-07 11:47:10Date Closed:2010-07-09 06:31:39
Priority:MinorRegression?No
Status:Closed/CompleteComponents:CDR/cdr_odbc
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:Below I paste a cdr record, which cannot be inserted via odbc (via cdr_pgsql works).
The mentioned column "sip_proxy_host" exists, I don't know why there is an "v_" before it in log.
I can insert the query to the database manually.

INSERT INTO cdr (clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,number_a,number_b,src_interface,dst_interface,is_outbound,is_inbound,sip_proxy_host) VALUES ('"Unknown" <Unknown>','Unknown','boniek420','CALLEX','SIP/boniek420-00000041','SIP/boniek420-00000042','Dial','SIP/0693618338@boniek420,45,wW',12,2,'ANSWERED',3,'boniek420','1278503202.119','UID:1278503202.119;','Unknown','+48693618338','SIP/testowy','SIP/testowy','f','f','sip.freeconet.pl')


****** ADDITIONAL INFORMATION ******


  -- Executing [h@CALLEX:1] NoOp("SIP/boniek420-00000041", ""po AGI ===================="h" "boniek420"") in new stack
   -- Executing [h@CALLEX:2] Hangup("SIP/boniek420-00000041", "") in new stack
 == Spawn extension (CALLEX, h, 2) exited non-zero on 'SIP/boniek420-00000041'
[2010-07-07 13:46:54] WARNING[6270]: res_odbc.c:316 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: column "v_sip_proxy_host" does not exist at character 26;
Error while executing the query (97)
[2010-07-07 13:46:54] WARNING[6270]: res_odbc.c:324 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[2010-07-07 13:46:54] WARNING[6270]: res_odbc.c:400 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[2010-07-07 13:46:54] NOTICE[6270]: res_odbc.c:838 odbc_obj_connect: Connecting asterisk
[2010-07-07 13:46:54] NOTICE[6270]: res_odbc.c:866 odbc_obj_connect: res_odbc: Connected to asterisk [postgresql]
[2010-07-07 13:46:54] WARNING[6270]: res_odbc.c:316 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: column "v_sip_proxy_host" does not exist at character 26;
Error while executing the query (97)
[2010-07-07 13:46:54] WARNING[6270]: res_odbc.c:324 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[2010-07-07 13:46:54] WARNING[6270]: res_odbc.c:400 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[2010-07-07 13:46:54] NOTICE[6270]: res_odbc.c:838 odbc_obj_connect: Connecting asterisk
[2010-07-07 13:46:54] NOTICE[6270]: res_odbc.c:866 odbc_obj_connect: res_odbc: Connected to asterisk [postgresql]
[2010-07-07 13:46:54] WARNING[6270]: cdr_adaptive_odbc.c:618 odbc_log: cdr_adaptive_odbc: Insert failed on 'asterisk:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,number_a,number_b,src_interface,dst_interface,is_outbound,is_inbound,sip_proxy_host) VALUES ('"Unknown" <Unknown>','Unknown','boniek420','CALLEX','SIP/boniek420-00000041','SIP/boniek420-00000042','Dial','SIP/0693618338@boniek420,45,wW',12,2,'ANSWERED',3,'boniek420','1278503202.119','UID:1278503202.119;','Unknown','+48693618338','SIP/testowy','SIP/testowy','f','f','sip.freeconet.pl')
   -- AGI Script Executing Application: (Hangup) Options: (1)
   -- <SIP/boniek420-00000041>AGI Script agi://127.0.0.1/script.agi [^] completed, returning -1
Comments:By: Maciej Krajewski (jamicque) 2010-07-09 05:27:51

I've done some research, and the problem occurred in cdr_pgsql also.
After analysing postgres logs I found it was a mistake in pgsql trigger made on the table.

Ticket can be closed.
By: Paul Belanger (pabelanger) 2010-07-09 06:31:39

Closer per reporter.