| Summary: | ASTERISK-30306: require_odbc: Realtime table queue_log requires column 'time', but that column does not exist! | ||
| Reporter: | Juan Cuervo (juanrcuervo) | Labels: | |
| Date Opened: | 2022-11-10 19:06:40.000-0600 | Date Closed: | |
| Priority: | Minor | Regression? | |
| Status: | Open/New | Components: | Resources/res_config_odbc |
| Versions: | 18.15.0 | Frequency of Occurrence | Constant |
| Related Issues: | |||
| Environment: | Attachments: | ( 0) asterisk_queue_log_table.sql ( 1) debug_log_123456.txt ( 2) modules.conf ( 3) res_odbc.conf | |
| Description: | 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@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@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@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@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@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@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@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@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@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@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@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. | ||
| Comments: | By: Asterisk Team (asteriskteam) 2022-11-10 19:06:43.572-0600 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. Please note that log messages and other files should not be sent to the Sangoma Asterisk Team unless explicitly asked for. All files should be placed on this issue in a sanitized fashion as needed. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. Please note that once your issue enters an open state it has been accepted. As Asterisk is an open source project there is no guarantee or timeframe on when your issue will be looked into. If you need expedient resolution you will need to find and pay a suitable developer. Asking for an update on your issue will not yield any progress on it and will not result in a response. All updates are posted to the issue when they occur. Please note that by submitting data, code, or documentation to Sangoma through JIRA, you accept the Terms of Use present at [https://www.asterisk.org/terms-of-use/|https://www.asterisk.org/terms-of-use/]. By: Juan Cuervo (juanrcuervo) 2022-11-10 19:33:56.686-0600 Content of configuration file res_odbc.conf to create a ODBC connection By: Juan Cuervo (juanrcuervo) 2022-11-10 19:51:12.214-0600 This is postgresql script to create the queue_log table By: Joshua C. Colp (jcolp) 2022-11-11 03:17:35.739-0600 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 By: Juan Cuervo (juanrcuervo) 2022-11-11 08:37:40.071-0600 My modules.conf configuration file I must say that this is a fresh asterisk install. No extensions, sip, pjsip or any others channels have been configured. By: Juan Cuervo (juanrcuervo) 2022-11-11 08:44:20.724-0600 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 | ||