On Sat, 25 Apr 2015 17:11:34 +0200 jg <[email protected]> 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 '[email protected]: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 -- _____________________________________________________________________ -- 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
