[mythtv-users] Database woes..
Greg Oliver
oliver.greg at gmail.com
Mon Oct 4 13:40:01 UTC 2010
On Sat, Oct 2, 2010 at 10:21 PM, Greg Oliver <oliver.greg at gmail.com> wrote:
> I rebooted my system so I could use a new kernel for my VMs this
> evening. After the reboot, the mythtv recorded table had issues. I
> guess it was my fault I did not investigate further before blindly
> running the optimize/repair script, which just basically tells mysql
> to repair the tables.. Little did I know, it was just going to
> truncaet it for me..!.!.!.!.!
>
> And of course my cronjob to back it up each night has been forgotten
> on this install (but in place now)..
>
> 2010-10-02 21:52:16.202 Error preparing query: SELECT recorded.chanid,
> starttime, endtime, title, subtitle,
> description, hostname, channum, name,
> callsign, seriesid, programid,
> recorded.recpriority, progstart, progend,
> filesize, recgroup, storagegroup, basename FROM
> recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE
> recgroup = 'LiveTV' AND endtime < DATE_ADD(starttime, INTERVAL '2'
> MINUTE) AND endtime <= DATE_ADD(NOW(), INTERVAL '-1' MINUTE) AND
> deletepending = 0 ORDER BY autoexpire DESC, starttime ASC
> 2010-10-02 21:52:16.204 Driver error was [2/144]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Table './mythconverg/recorded' is marked as crashed and last
> (automatic?) repair failed
>
> Is myth.rebuilddatabase.pl the best way to go about repopulating it?
> We have not watched any of our shows from the week, and I might be
> killed before I get to go back to work monday and get out of the line
> of fire :) Would it be better to rename them to something
> show-centric and use mythvideo to pull down metadata?
>
> Thanks for any tips.
BTW - If anyone is interested and has a mythconverg.recorded table
corruption, that script works like a champ. Assuming there is old
guide data still there to cover the dates of the *lost* data, it pulls
it all back in for you.
-Greg
More information about the mythtv-users
mailing list