fixfamily

Heute haben wir in nur zehn Minuten, allerdings mit der Hilfe der Cache-Besitzer, den Schatz “Aquebuc” (GCQM5G) im vierten Anlauf gefunden. Uff!

The sheep, originally uploaded by jfix.

Sadly, you cannot see the newly-fitted ears, made of some kind of rolled-up mesh. But that’s not a surprise, I took the picture with a cameraphone late last night, it was maybe about half past eleven …

Link to album.

Quelqu’un d’autre, de Tonino Benacquista.

My mythtv backend was dying unexpectedly and without reason, and huge binary mysql logs were created each day.

mythbackend.log had thousands of error messages like this one:

2006-09-10 17:52:09.358 DB Error (Recorded program delete recordedmarkup):
Query was:
DELETE FROM recordedmarkup WHERE chanid = ‘29008′ AND starttime = ‘2006-09-09T04:00:00′;
Driver error was [2/1016]:
QMYSQL3: Unable to execute query
Database error was:
Can’t open file: ‘recordedmarkup.MYI’. (errno: 145)

Search found this message:
http://www.mythtv.org/pipermail/mythtv-users/2006-January/118253.html

I ran this command twice, first time there were indeed two corrupted tables, and the second time the output was all OK:

# mysqlcheck -r -u mythtv -pmythtv mythconverg
mythconverg.callsignnetworkmap                     OK
mythconverg.capturecard                            OK
mythconverg.cardinput                              OK
mythconverg.channel                                OK
mythconverg.codecparams                            OK
mythconverg.credits                                OK
mythconverg.dtv_multiplex                          OK
mythconverg.dtv_privatetypes                       OK
mythconverg.dvdinput                               OK
mythconverg.dvdtranscode                           OK
mythconverg.favorites                              OK
mythconverg.filemarkup                             OK
mythconverg.gallerymetadata                        OK
mythconverg.housekeeping                           OK
mythconverg.inuseprograms                          OK
mythconverg.jobqueue                               OK
mythconverg.jumppoints                             OK
mythconverg.keybindings                            OK
mythconverg.keyword                                OK
mythconverg.mythlog                                OK
mythconverg.mythweb_sessions                       OK
mythconverg.networkiconmap                         OK
mythconverg.oldfind                                OK
mythconverg.oldprogram                             OK
mythconverg.oldrecorded                            OK
mythconverg.people                                 OK
mythconverg.pidcache                               OK
mythconverg.playgroup                              OK
mythconverg.profilegroups                          OK
mythconverg.program                                OK
mythconverg.programgenres                          OK
mythconverg.programrating                          OK
mythconverg.recgrouppassword                       OK
mythconverg.record                                 OK
mythconverg.record_tmp                             OK
mythconverg.recorded                               OK
mythconverg.recordedcredits                        OK
mythconverg.recordedmarkup                         OK
mythconverg.recordedprogram                        OK
mythconverg.recordedrating                         OK
mythconverg.recordingprofiles                      OK
mythconverg.recordmatch                            OK
mythconverg.schemalock                             OK
mythconverg.settings                               OK
mythconverg.tvchain                                OK
mythconverg.videobookmarks                         OK
mythconverg.videocategory                          OK
mythconverg.videocountry                           OK
mythconverg.videogenre                             OK
mythconverg.videometadata                          OK
mythconverg.videometadatacountry                   OK
mythconverg.videometadatagenre                     OK
mythconverg.videosource                            OK
mythconverg.videotypes                             OK
mythconverg.xvmc_buffer_settings                   OK

Also found that the EPG was very slow because many icons were expected in /var/video/livetv where they weren’t, and the EPG was requesting them up to 12 times per logo icon. Copied all icons there and checked they were of the correct type.

Finally, I also fixed the problem that the MythTV frontend wouldn’t start automatically. It appears that xdm has been installed by a recent apt-get and is run in runlevel 5, just before everything of my own stuff is run, basically invalidating everything. So, my temporary fix is to exit 0 out of the /etc/rc5.d/S99xdm, which allows my startx-mythtv.sh to take control and start an X session. Also discovered the following useful options for X:

xset s off ## no X screensaver
xset -dpms ## disable energy saving features

which I found this on this page: http://www.pvrweb.com/bbs/index.php?showtopic=4658