ODBC disconnect

In CLI I see Warrnigs:
[2018-08-03 10:34:46] WARNING[16776][C-00003d0e]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Subquery returns more than 1 row (75)
[2018-08-03 10:34:46] WARNING[16776][C-00003d0e]: res_odbc.c:658 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]…
[2018-08-03 10:34:46] WARNING[16776][C-00003d0e]: res_odbc.c:762 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[2018-08-03 10:34:46] NOTICE[16776][C-00003d0e]: res_odbc.c:1537 odbc_obj_connect: Connecting asteriskcdrdb
[2018-08-03 10:34:46] NOTICE[16776][C-00003d0e]: res_odbc.c:1569 odbc_obj_connect: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]

What does it mean?

Do you use a 3rd party call reporting package such as Asternic?

Yes, I use Asternic Call Centre.

Those SQL errors look similar (but not identical) to ones I’ve seen that we traced to a buggy Asternic query. You may want to contact them.

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.