[asterisk-bugs] [Asterisk 0014860]: Asterisk Realtime - res_odbc failing MySQL connection on rtupdate=yes

Wed Apr 8 11:38:43 CDT 2009

The following issue has been CLOSED 
====================================================================== 
http://bugs.digium.com/view.php?id=14860 
====================================================================== 
Reported By:                jdmetzger
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   14860
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     closed
Asterisk Version:           1.4.24 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-04-08 11:03 CDT
Last Modified:              2009-04-08 11:38 CDT
====================================================================== 
Summary:                    Asterisk Realtime - res_odbc failing MySQL
connection on rtupdate=yes
Description: 
After upgrading from Asterisk 1.4.20 to 1.4.24, the following error was
appearing in the Asterisk CLI whenever a SIP phone would re-register:

[Apr  8 09:50:54] WARNING[5601]: res_odbc.c:105
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S21:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22]Unknown column 'lastms' in 'field
list' (79)
[Apr  8 09:50:54] WARNING[5601]: res_odbc.c:113
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a
reconnect...
[Apr  8 09:50:54] NOTICE[5601]: res_odbc.c:533 odbc_obj_connect:
Connecting asterisk
[Apr  8 09:50:54] NOTICE[5601]: res_odbc.c:561 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[Apr  8 09:50:54] WARNING[5601]: res_odbc.c:105
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S21:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22]Unknown column 'lastms' in 'field
list' (79)
[Apr  8 09:50:54] WARNING[5601]: res_odbc.c:113
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a
reconnect...
[Apr  8 09:50:54] NOTICE[5601]: res_odbc.c:533 odbc_obj_connect:
Connecting asterisk
[Apr  8 09:50:54] NOTICE[5601]: res_odbc.c:561 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]

With this error, the system would continue running (no crash), but the
Realtime information is not being sent successfully to the Realtime
Database.  Disabling realtime updates by setting "rtupdate=no" in sip.conf
and doing a "sip reload" will stop the error.  Going back and changing
"rtupdate=yes" in sip.conf and doing another "sip reload" brings the error
back.  Error does not occur with Asterisk 1.4.20.

Seems similar to bug http://bugs.digium.com/view.php?id=13784 but without a
segfault. 
====================================================================== 

---------------------------------------------------------------------- 
 (0102917) tilghman (administrator) - 2009-04-08 11:38
 http://bugs.digium.com/view.php?id=14860#c102917 
---------------------------------------------------------------------- 
If you want the error to go away, please add the lastms column to your
database.  However, the error generated by the MySQL driver is completely
superfluous, as this does not affect the functionality of rtupdate in any
significant way. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-04-08 11:38 tilghman       Note Added: 0102917                          
2009-04-08 11:38 tilghman       Status                   assigned => closed  
2009-04-08 11:38 tilghman       Resolution               open => no change
required
======================================================================