[Home]

Summary:ASTERISK-26392: Asterisk reports error in CDR data insertion, but data is available in DB
Reporter:Marcelo Terres (mhterres)Labels:
Date Opened:2016-09-20 07:56:23Date Closed:2016-09-20 08:30:57
Priority:MajorRegression?
Status:Closed/CompleteComponents:CDR/cdr_odbc
Versions:14.0.0-rc1 Frequency of
Occurrence		Constant
Related
Issues:
Environment:Ubuntu 14.04.5 LTS - Linux rtc 4.5.5-x86_64-linode69 #3 SMP Fri May 20 15:25:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux Attachments:( 0) cdr_adaptive_odbc.conf
( 1) cdr_odbc.conf
( 2) cdr.conf
( 3) odbc.ini
( 4) odbcinst.ini
Description:After I started to use Asterisk 14 rc1, I noticed something. I'm not sure if it starts in this version, but let me show you.

I'm using cdr_odbc and cdr_adaptive_odbc.

When a call is finished, I'm receiving the following messages:

[Sep 20 09:47:47] WARNING[24412]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2016-09-20 09:47:44'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[Sep 20 09:47:47] ERROR[24412]: cdr_odbc.c:189 odbc_log: CDR direct execute failed

But, data is being saved in my db:

            | 1000 | 1111          | ramais         | "Marcelo Terres" <1000>     | SIP/1000-00000010            |                              | Playback    | thanks_for_call                                                                 | 2016-09-20 09:47:44 | 2016-09-20 09:47:44 | 2016-09-20 09:47:47 |        3 |       3 | ANSWERED    | DOCUMENTATION |           | 1474375664.31  | 1474375664.31  |             |       19

Comments:By: Asterisk Team (asteriskteam) 2016-09-20 07:56:24.153-0500

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].
By: Marcelo Terres (mhterres) 2016-09-20 07:58:20.492-0500

This is my configurations files.
By: Joshua C. Colp (jcolp) 2016-09-20 08:16:42.996-0500

What is the schema of the table that cdr_odbc is interesting into? Is cdr_adaptive_odbc working and cdr_odbc not working, thus why you see an entry?
By: Marcelo Terres (mhterres) 2016-09-20 08:28:47.899-0500

Sorry to bother you with this issue.

Now I noticed that it was a configuration mistake. My bad.

Thanks.