-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/25/2015 10:51 PM, Ethy H. Brito 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)
Hi Ethy, why date and time are empty? At least date is used as a unique key and a unique key has to be unique. In other words, the same key can not exist twice like in your case. Check why there is no date and time anymore ... Regards Guenther -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJVPEuqAAoJENexF5oIz3BCQaoP/2foZJ2Um5m49rgGe8jd+zEY NwQucaye9O+euCNpjae08SaO8RnlD7WSK1H+jCsXw/pNp+NsQ+2kTDzOIdDLdmj7 sg93SjAUdEz0bivrhzcjf9K+Z6DKG4EOsHEpqwStIVaGU95JjUYza79ka1Evsghg roJaSP9DpbpN4+lnVdPTRX2LUUK4okB4YKuVcxRUg7QfZ9BS0M5KzZOSg8HvjmN8 uEbyvNsX2tO6awhxn3pX4Pl/x/z3EzzuIKiVzckT3UdyBu67eIkCgcHzrIPUlwZQ Wk/gz1W5dqjKPoImrGDxEZJi0PnAsuvtAE/TzN3CdyG8gA5vYvf3K2WhJ5ri2XNG Kr78HHV2rA5VOr45yx1vjUYhjdNt1Q0OkJ4WAV2scUOyUvQLgbc29pEXgOrQn0Tr 4JJXuBDyYsvGupLOrKP/c7gBPLYsCHUl9XfRoBKEelM8rQFBbLz3xtxvZuGzNlH9 +4uZ3EvqJ7LuN4cZH9xCqYQHbbXdk5/CXo8OKoz0Nw4FTk/wWSZicEJ/AqCof+be GlEFvlKrPY+NaoLH4l0zf27Lff6k1oaYLnxEMMcvOXaqYPLhK2gvQeBhh43GiIBJ 6fTER9WRtW/RfvzBmnpvI850f1Ws8qfF/gbbGLOqwL8d7WOeHgeQ7SPdnhLFhHYE JPHXBlT9rFqT28M4Z9QJ =NVPO -----END PGP SIGNATURE----- -- _____________________________________________________________________ -- 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