Bug 138821 – mythtv-0.19_p9163-r1's mythbackend crashes when starting

• Status: RESOLVED TEST-REQUEST
• Product: Gentoo Linux

[Description Nathan Sullivan 2006-07-02 02:23:29 UTC]

starting mythbackend from init.d caused it to die unexpectedly, so i logged in as user mythtv, and started mythbackend under gdb, with the following results. i get a standard segv with no output outside gdb as expected.

(gdb) run
Starting program: /usr/bin/mythbackend 

[Thread debugging using libthread_db enabled]
[New Thread -1512036672 (LWP 30709)]
Qt: gdb: -nograb added to command-line options.
         Use the -dograb option to enforce grabbing.
2006-07-02 19:18:06.557 Using runtime prefix = /usr
2006-07-02 19:18:06.857 New DB connection, total: 1
2006-07-02 19:18:06.868 Connected to database 'mythconverg' at host: localhost
2006-07-02 19:18:06.877 Current Schema Version: 1123
Starting up as the master server.
[New Thread -1515254880 (LWP 30714)]
2006-07-02 19:18:06.908 New DB connection, total: 2
2006-07-02 19:18:06.909 Connected to database 'mythconverg' at host: localhost
[New Thread -1523647584 (LWP 30716)]
2006-07-02 19:18:06.920 DVB#0 Using DVB card 0, with frontend 'Twinhan VP7045/46 USB DVB-T'.
2006-07-02 19:18:06.927 New DB connection, total: 3
2006-07-02 19:18:06.929 Connected to database 'mythconverg' at host: localhost
[New Thread -1532040288 (LWP 30719)]
[New Thread -1540432992 (LWP 30720)]
2006-07-02 19:18:07.511 DVB#1 Using DVB card 1, with frontend 'Twinhan VP7045/46 USB DVB-T'.
[New Thread -1548825696 (LWP 30722)]
2006-07-02 19:18:08.059 New DB scheduler connection
2006-07-02 19:18:08.061 Connected to database 'mythconverg' at host: localhost
[New Thread -1557218400 (LWP 30724)]
[New Thread -1565611104 (LWP 30725)]
[New Thread -1574003808 (LWP 30726)]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread -1557218400 (LWP 30724)]
_db_return_ (_line_=2471, _sfunc_=0xa32ead24, _sfile_=0xa32ead20, _slevel_=0xa32ead1c) at dbug.c:841
841     dbug.c: No such file or directory.
        in dbug.c
Current language:  auto; currently c
(gdb) 
(gdb) bt 
#0  _db_return_ (_line_=2471, _sfunc_=0xa32ead24, _sfile_=0xa32ead20, _slevel_=0xa32ead1c) at dbug.c:841
#1  0xa5cc7ae8 in cli_read_query_result (mysql=0x812ea90) at client.c:2471
#2  0xa5cc577c in mysql_real_query (mysql=0x812ea90, query=0x812f128 "UPDATE oldrecorded SET recstatus = -4   WHERE recstatus = -2", length=60) at client.c:2538
#3  0xa5dfd034 in QMYSQLResult::reset (this=0x8132c30, query=@0xa32eaf4c) at ../../../../src/sql/drivers/mysql/qsql_mysql.cpp:301
#4  0xa693769c in QSqlQuery::exec (this=0xa32eb260, query=@0xa32eaf4c) at sql/qsqlquery.cpp:369
#5  0xa7150949 in MSqlQuery::exec (this=0xa32eb260, query=@0xa32eaf4c) at mythdbcon.cpp:338
#6  0xa69366b8 in QSqlQuery::exec (this=0xa32eb260) at sql/qsqlquery.cpp:1048
#7  0x0806331b in MSqlQuery::exec (this=0xa32eb260) at ../../libs/libmyth/mythdbcon.h:109
#8  0x080bb21b in Scheduler::RunScheduler (this=0x8132c68) at scheduler.cpp:1113
#9  0x080be5a9 in Scheduler::SchedulerThread (param=0x8132c68) at scheduler.cpp:1565
#10 0xa622a294 in start_thread () from /lib/libpthread.so.0
#11 0xa60b1dbe in clone () from /lib/libc.so.6
(gdb)

emerge info to follow...

[Comment 1 Nathan Sullivan 2006-07-02 02:23:58 UTC]

Portage 2.1.1_pre1-r5 (default-linux/x86/2006.0, gcc-4.1.1/vanilla, glibc-2.4-r3, 2.6.17-ck1 i686)
=================================================================
System uname: 2.6.17-ck1 i686 Pentium III (Coppermine)
Gentoo Base System version 1.12.1
distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled]
ccache version 2.4 [enabled]
dev-lang/python:     2.3.5-r2, 2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r2
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.17
sys-devel/gcc-config: 2.0.0_rc1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.16
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=pentium3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/eselect/compiler /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O2 -march=pentium3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache distlocks fixpackages metadata-transfer nostrip sandbox sfperms strict"
GENTOO_MIRRORS="ftp://mirror.isp.net.au/pub/gentoo/ ftp://ftp.swin.edu.au/gentoo"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage-overlays/testing /usr/local/portage-overlays/gentoo-webapps-overlay/experimental"
SYNC="rsync://ftp.cc.swin.edu.au/gentoo-portage"
USE="alsa apache2 apm avi bash-completion berkdb bitmap-fonts bzip2 calendar cli crypt ctype cups curl dba debug dhcp divx4linux dri dv dvb dvd dvdread eds eix emboss encode esd exif extraengine fam ffmpeg foomaticdb fortran ftp gd gdbm gif gpm gstreamer hash iconv imap imlib innodb isdnlog jabber jpeg kerberos ldap libclamav libg++ libwww logrotate mad maildir mcal mhash mikmod mmx motif mp3 mpeg mysql mysqli ncurses nls nptl nptlonly ogg opengl pam pcntl pcre pdflib perl pic pie png posix postfix postgres pppd python qt3 qt4 quicktime radius readline reflection samba sasl sdl session simplexml snmp soap sockets spamassassin spell spl sqlite ssl tcpd tidy tiff tokenizer truetype truetype-fonts type1-fonts udev unicode usb userlocales utf8 v4l vhosts vorbis wddx x86 xml xml2 xmlrpc xmms xorg xv xvid zaptel zlib dvb_cards_usb-vp7045 elibc_glibc input_devices_evdev input_devices_keyboard input_devices_mouse kernel_linux userland_GNU video_cards_r128 video_cards_radeon"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS

[Comment 2 Doug Goldstein (RETIRED) 2006-07-02 18:16:40 UTC]

unfortunately, the crasher is happening in libmysqlclient... I would re-emerge mysql then qt3

[Comment 3 Nathan Sullivan 2006-07-03 15:15:13 UTC]

thanks cardoe, will give it a try...

[Comment 4 Nathan Sullivan 2006-07-03 15:18:36 UTC]

confirmed, similar crash occurs on mythtv-0.19_p10281, BT is slightly different but still relevant to the same libs (libmysqlclient and qt)

[Comment 5 Nathan Sullivan 2006-07-08 06:07:25 UTC]

ok...im using mysql-5.0.22 and qt-3.3.6-r1, both which were built with USE="debug" which is default across my system...

as the issue is with dbug.c in mysql (libmysqlclient specifically) i decided to build both mysql and then qt with USE="-debug". after doing so, mythbackend no longer segvs...


Cardoe, whats your opinion on this? leave it open? put a warning in the ebuilds about USE="debug"? reassign to mysql-bugs?

[Comment 6 Doug Goldstein (RETIRED) 2006-09-12 19:38:17 UTC]

Lemme know if this still happens with 0.20 and we'll go from there.

[Comment 7 Nathan Sullivan 2006-09-13 02:25:50 UTC]

np I get my media pc components over the next few days so ill give it a good test.

[Comment 8 Doug Goldstein (RETIRED) 2006-10-05 19:50:47 UTC]

Try 0.20_p11444

[Comment 9 Nathan Sullivan 2006-10-07 22:23:08 UTC]

sorry Doug, no go...

Program received signal SIGSEGV, Segmentation fault.[Switching to Thread -1515669808 (LWP 12048)]_db_return_ (_line_=2618, _sfunc_=0xaff2c164, _sfile_=0xaff2c160, _slevel_=0xaff2c15c) at dbug.c:828828     dbug.c: No such file or directory.        in dbug.cCurrent language:  auto; currently c(gdb) Quit(gdb) (gdb) (gdb) bt#0  _db_return_ (_line_=2618, _sfunc_=0xaff2c164, _sfile_=0xaff2c160, _slevel_=0xaff2c15c) at dbug.c:828#1  0xa594fce8 in cli_read_query_result (mysql=0x8148b38) at client.c:2618#2  0xa594d7ec in mysql_real_query (mysql=0x8148b38,     query=0x814f1f0 "SELECT data FROM settings WHERE value = 'ThreadCountInitial_HTTP' AND hostname = 'nsys-home1-gt' ;", length=98)    at client.c:2662#3  0xa5a86024 in QMYSQLResult::reset (this=0x8169ba8, query=@0xaff2c38c) at ../../../../src/sql/drivers/mysql/qsql_mysql.cpp:301#4  0xa67917a0 in QSqlQuery::exec (this=0xaff2c41c, query=@0xaff2c38c) at sql/qsqlquery.cpp:369#5  0xa6f1d1dd in MSqlQuery::exec (this=0xaff2c41c, query=@0xaff2c38c) at mythdbcon.cpp:338#6  0xa67907bc in QSqlQuery::exec (this=0xaff2c41c) at sql/qsqlquery.cpp:1048#7  0x08068b37 in MSqlQuery::exec (this=0xaff2c41c) at ../../libs/libmyth/mythdbcon.h:109#8  0xa6e19528 in MythContext::GetSetting (this=0x812a0b0, key=@0xaff2c508, defaultval=@0xaff2c4cc) at mythcontext.cpp:1844#9  0xa6e19fb2 in MythContext::GetNumSetting (this=0x812a0b0, key=@0xaff2c508, defaultval=1) at mythcontext.cpp:1890#10 0xa703d7e3 in ThreadPool (this=0x816cac4, sName=@0xaff2c54c) at threadpool.cpp:245#11 0xa70408a0 in HttpServer (this=0x816ca98, nPort=6544) at httpserver.cpp:36#12 0x0808e46c in main (argc=1, argv=0xaff2cba4) at main.cpp:616

Sun Oct  8 11:13:21 2006 >>> dev-db/mysql-5.0.24-r1
Sun Oct  8 14:50:17 2006 >>> x11-libs/qt-3.3.6-r2
Sun Oct  8 15:13:05 2006 >>> media-tv/mythtv-0.20_p11444

Portage 2.1.2_pre2-r5 (default-linux/x86/2006.0, gcc-4.1.1, glibc-2.5-r0, 2.6.18-ck1 i686)
=================================================================
System uname: 2.6.18-ck1 i686 Pentium III (Coppermine)
Gentoo Base System version 1.12.5
Last Sync: Sat, 07 Oct 2006 16:50:01 +0000
distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [enabled]
ccache version 2.4 [enabled]
app-admin/eselect-compiler: [Not Present]
dev-java/java-config: [Not Present]
dev-lang/python:     2.3.5-r3, 2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.17
sys-devel/gcc-config: 1.3.13-r4
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r1
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=pentium3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O2 -march=pentium3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache distcc distlocks fixpackages metadata-transfer nostrip sandbox sfperms strict"
GENTOO_MIRRORS="http://ftp.swin.edu.au/gentoo "
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage-overlays/testing /usr/local/portage-overlays/gentoo-webapps-overlay/experimental"
SYNC="rsync://ftp.cc.swin.edu.au/gentoo-portage"
USE="alsa apache2 apm avi bash-completion berkdb bitmap-fonts bzip2 calendar cli crypt ctype cups curl dba debug dhcp divx4linux dlloader dri dv dvb dvb_cards_usb-vp7045 dvd dvdread eds eix elibc_glibc emboss encode esd exif extraengine fam ffmpeg foomaticdb fortran ftp gd gdbm gif gpm gstreamer hash iconv imap imlib innodb input_devices_evdev input_devices_keyboard input_devices_mouse isdnlog jabber jpeg kerberos kernel_linux l7filter ldap libclamav libg++ libwww logrotate mad maildir mcal mhash mikmod mmx motif mp3 mpeg mysql mysqli ncurses nfs nls nptl nptlonly ogg opengl pam pcntl pcre perl pic pie png posix postfix postgres pppd python qt3 qt4 quicktime radius readline reflection samba sasl sdl session simplexml snmp soap sockets spamassassin spell spl sqlite ssl tcpd tidy tiff tokenizer truetype truetype-fonts type1-fonts udev unicode usb userland_GNU userlocales utf8 v4l vhosts video_cards_r128 video_cards_radeon vorbis wddx x86 xml xml2 xmlrpc xorg xv xvid zaptel zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS

[Comment 10 Nathan Sullivan 2006-10-07 22:25:36 UTC]

Created attachment 99092 [details]
mythtv 0.20_p11444 segv bt

gah that pasted BT looked messy, attaching instead... also reopening.