[asterisk-bugs] [JIRA] (ASTERISK-30306) require_odbc: Realtime table queue_log requires column 'time', but that column does not exist!

[Juan Cuervo (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-30306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=260630#comment-260630 ] 

Juan Cuervo commented on ASTERISK-30306:
----------------------------------------

OS is Ubuntu 22.04.1 LTS 
Postgres Database version (output of "psql --version") : psql (PostgreSQL) 14.5 (Ubuntu 14.5-2.pgdg22.04+2)
output of "isql --version" : unixODBC 2.3.9




> require_odbc: Realtime table queue_log requires column 'time', but that column does not exist!
> ----------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-30306
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-30306
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_odbc
>    Affects Versions: 18.15.0
>            Reporter: Juan Cuervo
>            Assignee: Unassigned
>         Attachments: asterisk_queue_log_table.sql, debug_log_123456.txt, modules.conf, res_odbc.conf
>
>
> There is a series of warnings in the console everytime asterisk is started: 
> Asterisk Ready.
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'time', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data1', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data2', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data3', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data4', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data5', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data1', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data2', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data3', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data4', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data5', but that column does not exist!
> *CLI> 
> *CLI> odbc show voicemax
> ODBC DSN Settings
> -----------------
>   Name:   voicemax
>   DSN:    voicemax
>     Number of active connections: 1 (out of 16)
>     Logging: Enabled
>     Number of prepares executed: 1
>     Number of queries executed: 1
>     Longest running SQL query: INSERT INTO queue_log (time, data5, data4, data3, data2, data1, event, agent, queuename, callid) VALUES (?, ?, ?, ?, ?, ?, ?,?, ?, ?) (5 milliseconds)
> Despite the warning, the odbc connection is stablished and data is saved in the queue_log table. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)