[asterisk-users] Error writing CDR
Ethy H. Brito
ethy.brito at inexo.com.br
Sat Apr 25 16:13:29 CDT 2015
On Sat, 25 Apr 2015 17:05:44 -0300
"Ethy H. Brito" <ethy.brito at inexo.com.br> wrote:
> On Sat, 25 Apr 2015 17:11:34 +0200
> jg <webaccounts173 at jgoettgens.de> wrote:
>
> >
> > > Hi All
> > >
> > > I have dozens of these messages on CLI complaining about database
> > > connection and error writing CDR to disk.
> > >
> > > The curious thing is I can find them all inside the database.
> > > I "selected" them using uniqueid and manually compared each column
> > > with the cdr_adaptive_odbc.c error line.
> > >
> > > "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both
> > > returned OK for all tables.
> > >
> > > Environment is:
> > > in production Asterisk 11.7.0~dfsg-1ubuntu1
> > > Ubuntu 14.04.1 LTS
> > >
> > > Any thoughts?
> > >
> > > Thanx
> > >
> > > Ethy
> > >
> > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645
> > > ast_odbc_prepare_and_execute: SQL Execute returned an error -1:
> > > 23000: [MySQL][ODBC 5.1
> > > Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry
> > > '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
> > >
> > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657
> > > ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying
> > > connection to MyAsterisk-asterisk [MyAsterisk-asterisk]...
> > >
> > > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:761
> > > ast_odbc_sanity_check: Connection is down attempting to reconnect...
> > >
> > > [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1527
> > > odbc_obj_connect: Connecting MyAsterisk-asterisk
> > >
> > > [Apr 25 10:57:01] NOTICE[19013][C-000002cb]: res_odbc.c:1559
> > > odbc_obj_connect: res_odbc: Connected to MyAsterisk-asterisk
> > > [MyAsterisk-asterisk]
> > >
> > > [Apr 25 10:57:01] WARNING[19013][C-000002cb]: res_odbc.c:645
> > > ast_odbc_prepare_and_execute: SQL Execute returned an error -1:
> > > 23000: [MySQL][ODBC 5.1
> > > Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry
> > > '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
> > >
> > > [Apr 25 10:57:01] WARNING[19013][C-000002cb]: res_odbc.c:657
> > > ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying
> > > connection to MyAsterisk-asterisk [MyAsterisk-asterisk]...
> > >
> > > [Apr 25 10:57:01]
> > > WARNING[19013][C-000002cb]: res_odbc.c:761 ast_odbc_sanity_check:
> > > Connection is down attempting to reconnect...
> > >
> > > [Apr 25 10:57:02]
> > > WARNING[7666]: chan_sip.c:4409 __sip_autodestruct: Autodestruct on
> > > dialog '34f3f3481b8d1e4772dc111f42d13bd1 at ip.ip.ip.ip:5060' with owner
> > > SIP/CLIENT_ID_1-00000178 in place (Method: BYE). Rescheduling
> > > destruction for 10000 ms
> > >
> > > [Apr 25 10:57:06] NOTICE[19013][C-000002cb]: res_odbc.c:1527
> > > odbc_obj_connect: Connecting MyAsterisk-asterisk
> > >
> > > [Apr 25 10:57:06]
> > > NOTICE[19013][C-000002cb]: res_odbc.c:1559 odbc_obj_connect:
> > > res_odbc: Connected to MyAsterisk-asterisk [MyAsterisk-asterisk]
> > >
> > > [Apr 25 10:57:06]
> > > WARNING[19013][C-000002cb]: cdr_adaptive_odbc.c:739 odbc_log:
> > > cdr_adaptive_odbc: Insert failed on 'MyAsterisk-asterisk:cdr'. CDR
> > > failed: INSERT INTO cdr
> > > (dst,accountcode,clid,src,dcontext,channel,dstchannel,lastapp,duration,billsec,disposition,amaflags,userfield,lastdata,uniqueid)
> > > VALUES (blahblahblah, ... ,'1429970147.612')
> > >
> > Can you post the output of "describe <schema>;"? At least the first
> > error message is probably related to a not so optimal primary key
> > definition.
>
> Thanx for the reply.
>
> request follows...
>
> mysql> describe cdr ;
> +-------------+--------------+------+-----+---------------------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +-------------+--------------+------+-----+---------------------+-------+
> | calldate | datetime | NO | PRI | 0000-00-00 00:00:00 | |
> | dst | varchar(80) | NO | PRI | NULL | |
> | accountcode | varchar(20) | NO | PRI | NULL | |
> | clid | varchar(80) | NO | | NULL | |
> | src | varchar(80) | NO | MUL | NULL | |
> | dcontext | varchar(80) | NO | | NULL | |
> | channel | varchar(80) | NO | | NULL | |
> | dstchannel | varchar(80) | NO | | NULL | |
> | lastapp | varchar(80) | NO | | NULL | |
> | duration | int(11) | NO | | 0 | |
> | billsec | int(11) | NO | | 0 | |
> | disposition | varchar(45) | NO | MUL | NULL | |
> | amaflags | int(11) | NO | | 0 | |
> | userfield | varchar(255) | NO | | NULL | |
> | lastdata | varchar(80) | NO | | NULL | |
> | uniqueid | varchar(32) | YES | MUL | NULL | |
> +-------------+--------------+------+-----+---------------------+-------+
> 16 rows in set (0.00 sec)
>
>
> FYI this has been running smooth for years.
>
> This "problem" started a few days ago.
>
> Ethy
Further informations.
For all those registers in error I have two entries in the database.
(Based on the uniqueid of these entries I inferred that these errors started last April 7th)
echo 'select calldate,dst,disposition,uniqueid from cdr where uniqueid like "%1429994989%";' | mysql -u xxx -pxxx xxx
calldate dst disposition uniqueid
0000-00-00 00:00:00 1140573129 ANSWERED 1429994989.1186
2015-04-25 17:49:49 1140573129 ANSWERED 1429994989.1186
Ethy
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
More information about the asterisk-users
mailing list