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

[Joshua C. Colp (JIRA)]

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

Joshua C. Colp commented on ASTERISK-30306:
-------------------------------------------

We require additional debug to continue with triage of your issue. Please follow the instructions on the wiki [1] for how to collect debugging information from Asterisk. For expediency, where possible, attach the debug with a '.txt' file extension so that the debug will be usable for further analysis.

Thanks!

[1] https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information



> 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
>         Attachments: asterisk_queue_log_table.sql, 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)