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.
jg
--
_____________________________________________________________________
-- 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
