On Sat, 25 Apr 2015 17:05:44 -0300 "Ethy H. Brito" <ethy.br...@inexo.com.br> wrote:
> On Sat, 25 Apr 2015 17:11:34 +0200 > jg <webaccounts...@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 '34f3f3481b8d1e4772dc111f42d13...@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 -- _____________________________________________________________________ -- 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