Summary:	ASTERISK-09252: Asterisk segfaults when loading cdr_addon_mysql.so
Reporter:	Stan Iulian (siulian)	Labels:
Date Opened:	2007-04-12 09:56:28	Date Closed:	2007-06-11 10:37:42
Priority:	Critical	Regression?	No
Status:	Closed/Complete	Components:	Core/General
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) bug.txt ( 1) trace2.txt
Description:	It works like a charm with app_addon_sql_mysql.so , res_config_mysql.so but it hangs when i have cdr_addon_mysql.so loaded. It happens a few minutes after i start asterisk with  cdr_addon_mysql.so or after i load this module. ****** ADDITIONAL INFORMATION ****** platform : gentoo kernel: 2.6.18-gentoo-r3 mysql  Ver 14.12 Distrib 5.0.34, for pc-linux-gnu (i686) using readline 5.1 asterisk : 1.2.17 asterisk-addons : 1.2.5 I tried with asterisk  1.2.14-r2 from gentoo , and after that i installed 1.2.17 from the site but with no success. I also tried with other version of mysql (mysql-5.0.26-r2 ) but i have the same problem.
Comments:	By: Stan Iulian (siulian) 2007-04-12 10:04:24 here is my sql table cdr   | CREATE TABLE `cdr` (  `uniqueid` varchar(32) NOT NULL default '',  `userfield` varchar(255) NOT NULL default '',  `accountcode` varchar(20) NOT NULL default '',  `src` varchar(80) NOT NULL default '',  `dst` varchar(80) NOT NULL default '',  `dcontext` varchar(80) NOT NULL default '',  `clid` varchar(80) NOT NULL default '',  `channel` varchar(80) NOT NULL default '',  `dstchannel` varchar(80) NOT NULL default '',  `lastapp` varchar(80) NOT NULL default '',  `lastdata` varchar(80) NOT NULL default '',  `calldate` datetime NOT NULL default '0000-00-00 00:00:00',  `duration` int(11) NOT NULL default '0',  `billsec` int(11) NOT NULL default '0',  `disposition` varchar(45) NOT NULL default '',  `amaflags` int(11) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | By: Tilghman Lesher (tilghman) 2007-04-17 00:17:18 Please regen your backtrace with the command: gdb /usr/sbin/asterisk core.10031 It is absolutely necessary to specify the full path or gdb will not load the symbols correctly, and the backtrace is fairly useless. By: Stan Iulian (siulian) 2007-04-17 02:15:55 trace2.txt is the new gdb trace. I saw now i have a couple of errors in the new backtrace, but i don't know why. I reinstalled asterisk and mysql a few times, and i always delete the "old" instalation(emerge -C ) and always look after old files(locate) i use gcc version 4.1.1 (Gentoo 4.1.1) By: Stan Iulian (siulian) 2007-06-11 10:30:58 I've recompiled with a new mysql version and everything it's ok now mysql -V mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i686) using readline 5.1 I am pretty sure asterisk will not work correctly with mysql  5.0.34(or his gentoo  variants), but i cannot make further tests because is a production server By: Tilghman Lesher (tilghman) 2007-06-11 10:37:42 Fixed by upgrading external dependency.