Summary: | ASTERISK-26170: cdr_odbc: Insertion of record fails with Postgresql | ||||
Reporter: | Celso Annes (celsoannes) | Labels: | |||
Date Opened: | 2016-07-01 14:51:58 | Date Closed: | 2016-07-05 06:25:59 | ||
Priority: | Minor | Regression? | |||
Status: | Closed/Complete | Components: | CDR/cdr_odbc | ||
Versions: | 13.9.1 | Frequency of Occurrence | |||
Related Issues: |
| ||||
Environment: | Attachments: | ||||
Description: | Hi,
I am getting the follow error when I hang up a call. {noformat} [Jul 1 16:07:59] WARNING[26140]: 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-07-01 16:07:56'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) [Jul 1 16:07:59] ERROR[26140]: cdr_odbc.c:189 odbc_log: CDR direct execute failed {noformat} I am using *cdr_odbc.conf* and I have used the *contrib/realtime/postgresql/postgresql_cdr.sql* to create the table. To solve the problem I had to add the following cell: {noformat} calldate timestamp with time zone NOT NULL DEFAULT now() {noformat} | ||||
Comments: | By: Asterisk Team (asteriskteam) 2016-07-01 14:51:58.752-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: Joshua C. Colp (jcolp) 2016-07-05 05:57:42.832-0500 What version of Asterisk is this against? By: Celso Annes (celsoannes) 2016-07-05 06:18:09.424-0500 I tried asterisk-13.7.0 and asterisk-13.9.1, both have the same problem. I don't know about other versions. By: Joshua C. Colp (jcolp) 2016-07-05 06:25:59.223-0500 After looking at the other ASTERISK-26146 issue I think we've got similar problems going on between both, so I'm going to track this over there instead. |