[mythtv-users] mythtv very confused about length of recording

[Richard Holgate]

Check your database, you may have corrupted tables and/or indexes on tables.
Alternatively your database partition may be full (preventing writes), which
amounts to the same problem. I have experienced problems like this after
mysql got itself messed up due to partition full or machine crash, In my
case the db was suffering from inability to write metadata for recordings,
which is why the time data was all off.

Below are the notes I wrote for myself for repairing a broken database.
Check them before using yourself, and of course your mileage may vary :-)
There is much documentation on myisamchk at the mysql website.

If this is your problem, then after repairing tables the recordings with
messed up time info will still have messed up time info, but at least new
recordings will get correct time info.

Recovery of MYSQL after /var/ filled up.

1) Make sure mysql is shut down.

2) Clear some space on /var - i.e. resolve the issue.

3) Run 'myisamchk *.MYI' to see if tables are corrupted. Databases are in
subdir
ectories under /var/lib/mysql. Remember to check/repair ALL databases, not
just
'mythconverg' or 'mysql'. Use --silent to just see errors and not have loads
of
debug output.

4) Run 'myisamchk --recover *.MYI' to repair tables and rebuild indexes. Can
take a binary copy of the tables first if desired.

5) Check tables again as per step 3, using --silent. Hope to see no
messages.

6) If all well, restart mysql.




On 11/15/06, Marco Nelissen <marcone at xs4all.nl> wrote:
>
> >On 11/14/06, Justin Hornsby <justin.hornsby at gmail.com> wrote:
> >> On 15/11/06, Marco Nelissen <marcone at xs4all.nl> wrote:
> >> > I have this recording that is about an hour long, however mythtv
> thinks
> >> > it's 2 minutes and 31 seconds. As a result, skipping forward and
> backward
> >> > is... interesting.
> >> > I tried rebuilding the seektable with mythcommflag, but it had no
> effect.
> >> > How can I convince mythtv that this recording is in fact 1 hour long?
> >>
> >> Is your machine set to use the right timezone?
> >
> >Or if you are using separate fe and be, are their times in sync?
>
> This is a combined FE/BE, and the timezone is set correctly. Why would
> a wrong timezone even make mythtv confused about the duration of this
> recording? I can see how it would cause recordings to happen at the
> wrong time, but why would it make mythtv think that this 1-hour recording
> is a 2-and-a-half minute recording?
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061115/06f1e0a7/attachment.htm