[mythtv-users] Erratic failure. Wonky database connexion?

Jonathan Sambrook jonathan at hmmn.org
Wed Jul 9 09:16:36 UTC 2008


Jonathan Sambrook wrote:
> Nick Morrott wrote:
>> 2008/7/5 Jonathan Sambrook <jonathan at hmmn.org>:
>>> I'm not sure whether this is a MySQL problem or a MythTV one.
>>>
>>> Running under GDB I'm getting the following output:
>>>
>>> 2008-07-05 09:25:27.514 Using runtime prefix = /opt/mythtv
>>> 2008-07-05 09:25:27.515 Empty LocalHostName.
>>> 2008-07-05 09:25:27.515 Using localhost value of soprano
>>> 2008-07-05 09:25:27.531 New DB connection, total: 1
>>> 2008-07-05 09:25:27.537 Connected to database 'mythconverg' at host: localhost
>>> 2008-07-05 09:25:27.539 Closing DB connection named 'DBManager0'
>>> 2008-07-05 09:25:27.540 Connected to database 'mythconverg' at host: localhost
>>> 2008-07-05 09:25:27.550 New DB connection, total: 2
>>> 2008-07-05 09:25:27.550 Connected to database 'mythconverg' at host: localhost
>>> 2008-07-05 09:25:27.552 mythfilldatabase: Listings Download Started
>> I don't have any obvious answers for you but:
>>
>> i) Post which versions of MythTV and MySQL you are running. There have
>> been recent tickets raised concerning segfaults in mythfilldatabase,
>> and commits to fix these issues
> 
> I was getting the problem using Ubuntu Hardy's 0.21, and then went on to compiling from MythTV's own svn repo in order to feed gdb with the debug info. I last updated from the svn repo on Monday.
> 
> 
>> ii) Check your DB for errors using the optimize_mythdb.pl script in
>> mythtv/contrib
> 
> Have done so.
> 
> 
>> iii) Clear out your old listings data
> 
> Not sure what you mean/how to do it...

How do I go about doing this?


>> iv) If you're compiling MythTV yourself, post your configure options
> 
> I've tried the following (with a dist clen in between) and get the problem under both:
> 
> ./configure --prefix=/opt/mythtv --enable-opengl-vsync --enable-opengl-video --enable-proc-opt --enable-symbol-visibility --disable-directfb --with-bindings=perl,python --disable-joystick-menu --disable-firewire --disable-dbox2 --disable-hdhomerun --compile-type=debug
> 
> ./configure --compile-type=debug
> 

I've added a cron job for optimize_mythdb.pl but it hasn't helped this issue:

#0  0xb7f4f410 in __kernel_vsyscall ()
#1  0xb5ae9085 in raise () from /lib/tls/i686/cmov/libc.so.6
#2  0xb5aeaa01 in abort () from /lib/tls/i686/cmov/libc.so.6
#3  0xb5b21b7c in ?? () from /lib/tls/i686/cmov/libc.so.6
#4  0xb5b2d61b in free () from /lib/tls/i686/cmov/libc.so.6
#5  0xb5cf4b11 in operator delete () from /usr/lib/libstdc++.so.6
#6  0xb65d03ba in QStringData::deleteSelf () from /usr/lib/libqt-mt.so.3
#7  0xb6b974bd in ~QString (this=0xa97f2cdc) at ../../../../../../include/qt3/qstring.h:851
#8  0xb6c15086 in MSqlDatabase::KickDatabase (this=0x82249f0) at mythdbcon.cpp:133
#9  0xb6c16ddb in MSqlQuery::InitCon () at mythdbcon.cpp:321
#10 0xb7becfec in get_chan_id_from_db (sourceid=0, serviceid=27072, networkid=9018, transportid=24576)
    at eithelper.cpp:640
#11 0xb7bed5b9 in EITHelper::GetChanID (this=0x824b090, serviceid=27072, networkid=9018, tsid=24576)
    at eithelper.cpp:604
#12 0xb7bef44d in EITHelper::AddEIT (this=0x824b090, eit=0xa97f2ff0) at eithelper.cpp:314
#13 0xb7909b29 in DVBStreamData::HandleTables (this=0xaf8431a0, pid=18, psip=@0x834b1f8)
    at mpeg/dvbstreamdata.cpp:347
#14 0xb78e0034 in MPEGStreamData::HandleTSTables (this=0xaf843220, tspacket=0xa8d425e8)
    at mpeg/mpegstreamdata.cpp:920
#15 0xb78d9e1d in MPEGStreamData::ProcessTSPacket (this=0xaf843220, tspacket=@0xa8d425e8)
    at mpeg/mpegstreamdata.cpp:991
#16 0xb78d6c4b in MPEGStreamData::ProcessData (this=0xaf843220, 
    buffer=0xa8d42008 "G@\022\033\022 + n/wk chrg)./7´g`ðÈB@ðø@", len=4136) at mpeg/mpegstreamdata.cpp:944
#17 0xb7d09430 in DVBStreamHandler::RunTS (this=0xaf847bc0) at dvbstreamhandler.cpp:334
#18 0xb7d09b84 in DVBStreamHandler::Run (this=0xaf847bc0) at dvbstreamhandler.cpp:221
#19 0xb7d09b9d in run_dvb_stream_handler_thunk (param=0xaf847bc0) at dvbstreamhandler.cpp:173
#20 0xb5d354fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0
#21 0xb5b94e5e in clone () from /lib/tls/i686/cmov/libc.so.6


-- 
#  Jonathan Sambrook         Senior Software and Systems Engineer,
#                        Internet Platform Development Team, Thus Plc.
#----------------------------------------------------------------------
# This message, including any attachment, contains information that may
# be confidential or legally privileged.  If you are  not  the intended 
# recipient please notify the sender and delete the message immediately


More information about the mythtv-users mailing list