Warnings when starting asterisk 16 with odbc realtime

[juanrcuervo]

Hi All.
Im having some warnings after installing asterisk 16.13 on a fresh centos server.
I decided to test realtime-odbc for queues and members classes. While asterisk is starting, I get these messages:

Loading app_queue.so.
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_members@voicemax requires column ‘paused’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_members@voicemax requires column ‘uniqueid’, but that column does not exist!
. . .
Asterisk Ready.
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘time’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data1’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data2’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data3’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data4’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data5’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data1’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data2’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data3’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data4’, but that column does not exist!
[Sep 12 18:29:27] WARNING[9675]: res_config_odbc.c:1224 require_odbc: Realtime table public.queue_log@voicemax requires column ‘data5’, but that column does not exist!

This only happens if I use realtime=>odbc. Messages doest show up if I use realtime=>postgres. I can connect from asterisk server to database server and check that tables are created and all fields exists. If I do a ‘queue show’ from CLI, asterisk reponds ok.

Any clue of why does asterisk-odbc prints those warnings ?

my odbc versions are:

rpm -qa | grep -i odbc

unixODBC-devel-2.3.7-1.el8.x86_64
libiodbc-3.52.13-1.el8.x86_64
perl-DBD-ODBC-1.61-2.el8.x86_64
postgresql12-odbc-12.02.0000-1PGDG.rhel8.x86_64
unixODBC-2.3.7-1.el8.x86_64

[juanrcuervo]

Doing some tests with this odbc configuration, I found that same warnings appear everytime a call is sent to a queue.
I also found that despite the warning says that columns data1,data2…data5 of the queue_log table does not exists, data is successfully inserted in those columns of the table. So warnings are being loggued with no real reason, because in fact, both table and columns exists !
I tested another LTS version (asterisk 13.36) with same results