Summary:ASTERISK-16170: Asterisk crashes on sip_realtime using MySQL via ODBC
Reporter:Marcin Kowalczyk (kowalma)Labels:
Date Opened:2010-05-28 17:52:04Date Closed:2010-06-08 13:56:35
Versions:Frequency of
Environment:Attachments:( 0) 2010-05-28.txt
( 1) crash_31052010_2.txt
( 2) crash_31052010_3.txt
( 3) crash_31052010.txt

Recently I migrated sip peers to database and since then I expirience system crashes, mostly in BT I can see that it crashed following:

sql = "SELECT * FROM sip_peers WHERE name = ? AND host = ?",
Comments:By: Marcin Kowalczyk (kowalma) 2010-05-28 17:58:03

I've just noticed that it's in wrong category - should go to Resources/res_config_odbc
Can you please move it to right one? thx!

By: Marcin Kowalczyk (kowalma) 2010-05-31 06:17:48

and again crash

#1  0xb6c2fe36 in realtime_odbc (database=0xb1f68220 "ccig", table=0xb1f68120 "sip_peers", ap=0xb1f68374 "\003!\023?\234?4?\017\"\023?\a\"\023?") at res_config_odbc.c:195

bt uploaded

By: Leif Madsen (lmadsen) 2010-06-02 10:22:55

Typically at this point we'll ask what version of unixODBC you're using. It is recommended that you not use the ones that are distributed with your distribution, but rather compile directly from source using the latest version available from the unixODBC website (http://www.unixodbc.org)

By: Marcin Kowalczyk (kowalma) 2010-06-02 10:51:14

I'm using following versions:

ii  libiodbc2                            3.52.6-2                   iODBC Driver Manager
ii  libmyodbc                            3.51.15r409-4              the MySQL ODBC driver
ii  unixodbc                             2.2.11-16                  ODBC tools libraries
ii  unixodbc-bin                         2.2.11-16                  Graphical tools for ODBC management and brow
ii  unixodbc-dev                         2.2.11-16                  ODBC libraries for UNIX (development files)

I will upgrade libODBC to most recent one version and check.

By: Marcin Kowalczyk (kowalma) 2010-06-04 04:33:57

Upgraded to most recent versions of libraries:


By: Marcin Kowalczyk (kowalma) 2010-06-08 12:57:56

Since upgrade I have not noticed any crash. Looks indeed there could be issue with * while using old ODBC libs

By: Paul Belanger (pabelanger) 2010-06-08 13:56:35

Closing since reporter has upgraded ODBC and unable to reproduce issue.