[Home]

Summary:ASTERISK-26041: odbc: Asterisk crashed repeatedly - ODBC connector
Reporter:Truong Duong (truongdm)Labels:
Date Opened:2016-05-19 07:25:46Date Closed:2016-05-26 13:24:00
Priority:MajorRegression?
Status:Closed/CompleteComponents:Resources/res_odbc
Versions:13.9.1 Frequency of
Occurrence		Frequent
Related
Issues:
is the original version of this clone:ASTERISK-26037 Asterisk crashed repeatedly - Segmentation fault
is duplicated byASTERISK-26235 res_odbc: Crash when disconnecting
is duplicated byASTERISK-26261 Segfault with libmysqlclient.so
Environment:Attachments:( 0) backtrace_14h_19_May_2016.txt
Description:Asterisk suddenly crashed multiple times a days.
Comments:By: Asterisk Team (asteriskteam) 2016-05-19 07:25:47.112-0500

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.

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].
By: Truong Duong (truongdm) 2016-05-19 07:28:21.157-0500

Please help to check issue in attached core dump. Thanks.
By: Joshua C. Colp (jcolp) 2016-05-19 08:41:43.846-0500

We need to know:

1. What your ODBC system configuration is.
2. What version of ODBC and associated connector is in use.

As well if it's not the latest you will need to upgrade as older versions have shown themselves to be unstable due to recent changes made to our ODBC usage.
By: Truong Duong (truongdm) 2016-05-19 11:25:01.547-0500

Thanks,

This is the information :
1. ODBC:  unixODBC 2.3.1
2. Database: Mariadb, (mariadb: mysql  Ver 15.1 Distrib 10.1.13-MariaDB, for Linux (x86_64) using readline 5.1)
3. Connector: mariadb-connector-odbc-2.0.10-ga-linux-x86_64
4. Asterisk 13.9.1

Following is my odbc configuration:

{code}
[root@voip ~]# cat /etc/odbcinst.ini
# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package

#[PostgreSQL]
#Description = ODBC for PostgreSQL
#Driver = /usr/lib/psqlodbcw.so
#Setup = /usr/lib/libodbcpsqlS.so
#Driver64 = /usr/lib64/psqlodbcw.so
#Setup64 = /usr/lib64/libodbcpsqlS.so
#FileUsage = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1

[MariaDB]
Description = ODBC for MariaDB
Driver = /usr/lib64/libmaodbc.so
#Setup = /usr/lib64/libodbcmyS.so
#FileUsage = 1
{code}

and

{code}
[root@voip ~]# cat /home/asterisk/.odbc.ini
[MySQL-asteriskcdrdb]
Description=MariaDB connection to 'asteriskcdrdb' database
Driver=MariaDB
Server=localhost
Database=asteriskcdrdb
Socket=/var/lib/mysql/mysql.sock
UID=asterisk
PWD=my_password
#Option=3
{code}
By: Joshua C. Colp (jcolp) 2016-05-20 12:09:14.684-0500

We've seen numerous crashes as a result of old versions. Please upgrade to the latest unixodbc and MariaDB connector and see if the issue reoccurs. If it does then we can explore further and see where the issue is.
By: Truong Duong (truongdm) 2016-05-26 13:18:23.821-0500

Thanks Joshua, i upgraded odbc driver and it works now, no more crash found after several days.