[mythtv-users] intermittent mythbackend hang EIT?
Stephen Robertson
stephengrobertson at gmail.com
Thu Mar 26 10:45:25 UTC 2009
> 2009/3/25 David Watkins <watkinshome at gmail.com>:
>>> Does anyone have any clues as to how to diagnose this any further?
>>
>>
>> Seeing as the last gasp in the mythbackend log was a DB error, have
>> you looked in the mysql log?
I've had a look in the mysql logs and can't see anything out of the
ordinary. The last entries before the crash were all queries(to do
with EIT?). The mysql log is full of these queries ~30 per second
more or less continuosly. Is that normal?
Logs below. I also checked syslog as I was led to believe that erros
from mysql may be logged there on ubuntu but there is nothing there
for todays date. I do see start and stop messages from yesterday
though.
Thanks
Stephen
mysql.log:
090326 10:15:31 65 Query DELETE FROM eit_cache WHERE
endtime < 1237976450
65 Query SELECT SUM(dishnet_eit) FROM
videosource, cardinput WHERE videosource.sourceid = cardinput.sourceid
AND cardinput.cardid = 2
65 Query SELECT SUM(useeit) FROM
videosource, cardinput WHERE videosource.sourceid = cardinput.sourceid
AND cardinput.cardid = 2
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16256 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14368 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18112 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18048 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 15552 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14784 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18560 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14816 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 26688 AND
networkid = 9018 AND transportid = 24576 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18496 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14592 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 26176 AND
networkid = 9018 AND transportid = 24576 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 8567 AND
networkid = 9018 AND transportid = 8209 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16256 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 26368 AND
networkid = 9018 AND transportid = 24576 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18112 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 15552 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 26560 AND
networkid = 9018 AND transportid = 24576 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 8576 AND
networkid = 9018 AND transportid = 8209 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 26240 AND
networkid = 9018 AND transportid = 24576 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14368 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14816 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16288 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14976 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14976 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16256 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18624 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18240 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
090326 10:15:32 65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16288 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 15552 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14976 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 17984 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14976 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 22592 AND
networkid = 9018 AND transportid = 20480 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 8576 AND
networkid = 9018 AND transportid = 8209 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16224 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18112 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 22976 AND
networkid = 9018 AND transportid = 20480 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 22976 AND
networkid = 9018 AND transportid = 20480 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14592 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18240 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 15552 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16288 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14592 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16256 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16224 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16128 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14784 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14784 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 22976 AND
networkid = 9018 AND transportid = 20480 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 22592 AND
networkid = 9018 AND transportid = 20480 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14368 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 15552 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 16128 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 18688 AND
networkid = 9018 AND transportid = 16384 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
67 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 8576 AND
networkid = 9018 AND transportid = 8209 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
65 Query SELECT chanid, useonairguide FROM
channel, dtv_multiplex WHERE serviceid = 14784 AND
networkid = 9018 AND transportid = 12291 AND
channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = 1
Then it restarts:
090326 10:15:52 72 Connect mythtv at localhost on mythconverg
72 Init DB mythconverg
72 Query SELECT NULL
mythbackend.log:
2009-03-26 10:15:31.528 EITScanner (2): Started passive scan.
2009-03-26 10:15:32.307 DB Error (Looking up chanID):
Query was:
No error type from QSqlError? Strange...
*** glibc detected *** /usr/bin/mythbackend: munmap_chunk(): invalid
pointer: 0x0822daf0 ***
*** glibc detected *** /usr/bin/mythbackend: munmap_chunk(): invalid
pointer: 0x0822daf0 ***
======= Backtrace: =========
======= Backtrace: =========
/lib/tls/i686/cmov/libc.so.6(cfree+0x1bb)[0xb5c3761b]
/lib/tls/i686/cmov/libc.so.6(cfree+0x1bb)[0xb5c3761b]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb5dfeb11]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb5dfeb11]
/usr/lib/libqt-mt.so.3(_ZN11QStringData10deleteSelfEv+0x2e)[0xb66c33ba]
/usr/lib/libqt-mt.so.3(_ZN11QStringData10deleteSelfEv+0x2e)[0xb66c33ba]
/usr/lib/libmyth-0.21.so.0(_ZN12MSqlDatabase12KickDatabaseEv+0x55)[0xb6c69905]
/usr/lib/libmyth-0.21.so.0(_ZN12MSqlDatabase12KickDatabaseEv+0x55)[0xb6c69905]
/usr/lib/libmyth-0.21.so.0(_ZN9MSqlQuery7InitConEv+0x5d)[0xb6c6d3bd]
/usr/lib/libmyth-0.21.so.0(_ZN9MSqlQuery7InitConEv+0x5d)[0xb6c6d3bd]
[0x82595f0]
======= Memory map: ========
More information about the mythtv-users
mailing list