LinHES Forums
http://forum.linhes.org/

Lost my database!!!
http://forum.linhes.org/viewtopic.php?f=6&t=16818		 Page 1 of 1
Author:  Gibble [ Mon Oct 01, 2007 5:07 pm ]
Post subject:  Lost my database!!!
I noticed today when I went to view mythweb, it had no upcoming recordings, etc. Thought my listings and schedules were still there.

Though, if I click on a schedule I see
Code:
Recording Group:

    Error at /usr/share/mythtv/mythweb/includes/recording_schedules.php, line 503:
    mysql_fetch_row(): supplied argument is not a valid MySQL result resource

    Error at /usr/share/mythtv/mythweb/includes/recording_schedules.php, line 507:
    mysql_free_result(): supplied argument is not a valid MySQL result resource 


I thought the mysql daemon just crashed, but I ps -A | grep sql shows the mysqld and mysqld_safe processes both running.

I need to fix this ASAP! I have stuff scheduled 45 minutes from now EEK! :shock:
Author:  Gibble [ Mon Oct 01, 2007 5:11 pm ]
Post subject: 
Looking further...

mysql> select * from recorded;
ERROR 145 (HY000): Table './mythconverg/recorded' is marked as crashed and should be repaired
Author:  Gibble [ Mon Oct 01, 2007 5:16 pm ]
Post subject: 
I've repaired that table, not sure what to do next.
Author:  Gibble [ Mon Oct 01, 2007 5:20 pm ]
Post subject: 
Catastrophe averted.

There were a whole series of "recorded***" tables that had crashed, they all had an extra row in them. After doing a repair table on them each, the db was clean, and had no more issues that I could find.

I then went to mythweb, selected any recording schedule, and saved it without making changes and now my upcoming recordings all show up.

I hope this helps anyone who has a similar problem.

I think it all stems from a crash yesterday when I had to hit reset. Myth had crashed bringing up the guide while watching livetv...hopefully this is a one time occurence!

ciao,
C
Author:  slowtolearn [ Mon Oct 01, 2007 6:06 pm ]
Post subject: 
You probably want to check/repair the other tables as well http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/