[mythtv-users] Horrible performance fastforwarding HDTV - FIXED
Billy Macdonald
billymacdonald at gmail.com
Wed Jul 25 04:57:34 UTC 2007
Hi,
I was having difficulty fast-forwarding HDTV shows. It would
take take longer than 5 seconds to skip 5 seconds. The frontend logs
showed the following errors when I would try to skip.
2007-07-24 21:16:17.286
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 1.0
seconds for data to become available...
2007-07-24 21:16:18.294
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 2.0
seconds for data to become available...
2007-07-24 21:16:19.701
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
2007-07-24 21:16:20.703
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
2007-07-24 21:16:22.304
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 1.0
seconds for data to become available...
2007-07-24 21:16:23.315
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 2.0
seconds for data to become available...
2007-07-24 21:16:24.706
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
2007-07-24 21:16:25.708
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
I finally found the following problem in the database when I tried to
manually access the recordedseek table.
Table './mythconverg/recordedseek' is marked as crashed and should be repaired
And used the following command to fix it. I used the same command
without --auto-repair to make sure that no other tables weren't
corrupted. This happened after a power failure. It was odd that I
didn't see any errors in the backend log even though it couldn't write
to this table.
mysqlcheck --auto-repair -u root -p mythconverg
This was my first experience with a data problem on mysql that I've
always heard of as a negative for mysql. The recordings that happened
when it was broke are still laggy fast-forwarding, but a new
recordings work well.
Just thought I would post this to the list for documentation in case
someone else has similar issues down the road.
Billy
More information about the mythtv-users
mailing list