[asterisk-users] Error writing CDR

[Guenther Boelter]

-----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-----