BUGREPORT: SQL module fails on every CISCO reboot

[Alexander Voropay]

"Nicolas Baradakis" <nbk at sitadelle.com> wrote:

>> I'm using a CISCO NAS with 240 modem lines and
>> SQL/MySQL as accounting module.
> [...]
>> As far as I understand, SQL module segfaults when SQL
>> connection pool is over. Seems, pooling mechanism is bogus.
> 
> Thanks for the report. Please specify the version of FreeRADIUS
> you're using. You could also post the output of gdb,

 FreeRADIUS is CVS snapshot ~ 29-may-2005

 Nothing informative in gdb output.

 May be, "rlm_sql" module is not thread-safe ?

 It makes ~150 records (of 240) in the SQL "radacct" table
before die.


$ gdb  /opt/sbin/radiusd ./core.1100
GNU gdb Red Hat Linux (6.1post-1.20040607.62rh)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "ppc64-redhat-linux-gnu"...Using host libthread_db library "/lib64/tls/libthread_db.so.1".

Core was generated by `/opt/sbin/radiusd -xx'.
Program terminated with signal 6, Aborted.
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/tls/libpthread.so.0...done.
Loaded symbols for /lib/tls/libpthread.so.0
Reading symbols from /opt/lib/libradius-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/libradius-1.1.0-pre0.so
Reading symbols from /usr/lib/libsnmp.so.5...done.
Loaded symbols for /usr/lib/libsnmp.so.5
Reading symbols from /usr/lib/libltdl.so.3...done.
Loaded symbols for /usr/lib/libltdl.so.3
Reading symbols from /lib/libssl.so.4...done.
Loaded symbols for /lib/libssl.so.4
Reading symbols from /lib/libcrypto.so.4...done.
Loaded symbols for /lib/libcrypto.so.4
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/tls/libc.so.6...done.
Loaded symbols for /lib/tls/libc.so.6
Reading symbols from /lib/ld.so.1...done.
Loaded symbols for /lib/ld.so.1
Reading symbols from /usr/lib/libgssapi_krb5.so.2...done.
Loaded symbols for /usr/lib/libgssapi_krb5.so.2
Reading symbols from /usr/lib/libkrb5.so.3...done.
Loaded symbols for /usr/lib/libkrb5.so.3
Reading symbols from /lib/libcom_err.so.2...done.
Loaded symbols for /lib/libcom_err.so.2
Reading symbols from /usr/lib/libk5crypto.so.3...done.
Loaded symbols for /usr/lib/libk5crypto.so.3
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
Reading symbols from /opt/lib/rlm_preprocess-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/rlm_preprocess-1.1.0-pre0.so
Reading symbols from /opt/lib/rlm_detail-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/rlm_detail-1.1.0-pre0.so
Reading symbols from /opt/lib/rlm_sql-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/rlm_sql-1.1.0-pre0.so
Reading symbols from /opt/lib/rlm_sql_mysql-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/rlm_sql_mysql-1.1.0-pre0.so
Reading symbols from /usr/lib/mysql/libmysqlclient.so.14...done.
Loaded symbols for /usr/lib/mysql/libmysqlclient.so.14
Reading symbols from /lib/tls/libm.so.6...done.
Loaded symbols for /lib/tls/libm.so.6
Reading symbols from /opt/lib/rlm_acct_unique-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/rlm_acct_unique-1.1.0-pre0.so
Reading symbols from /opt/lib/rlm_radutmp-1.1.0-pre0.so...done.
Loaded symbols for /opt/lib/rlm_radutmp-1.1.0-pre0.so
#0  0x0fe90d1c in raise () from /lib/tls/libc.so.6
(gdb) bt
#0  0x0fe90d1c in raise () from /lib/tls/libc.so.6
#1  0x0fe927a0 in abort () from /lib/tls/libc.so.6
#2  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#3  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#4  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#5  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#6  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#7  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#8  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#9  0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#10 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#11 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#12 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#13 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#14 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#15 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#16 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#17 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#18 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#19 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#20 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#21 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#22 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
#23 0x0fec7674 in __libc_message () from /lib/tls/libc.so.6
Previous frame inner to this frame (corrupt stack?)



--
-=AV=-