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

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
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:                     assigned
Asterisk Version:           1.4.24 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-04-08 11:03 CDT
Last Modified:              2009-04-08 11:03 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. 
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-04-08 11:03 jdmetzger      Asterisk Version          => 1.4.24          
2009-04-08 11:03 jdmetzger      Regression                => No              
2009-04-08 11:03 jdmetzger      SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================