Hi again guys. I have most of my problems sorted.

After my mythbox booted up, my tv shows are no longer appearing in the media library. The actual files still exist in the /myth/tv directory. I wonder if there is a way to re-scan for them such as there is for the video.

I didn't see the first part of this tread so I don't how your problems started. It would seem like the data in your mysql database that existed prior to whatever happened has not been restored.

Is other stuff missing as well? Recording Schedules, etc..

martin

Assuming the db data is gone, there is a script on the forum somewhere here that will try and restore some data back into the db - enough to use the files I think but no descriptions etc.

_________________
HP VL400 (PIII 866), Skystar2 2.6D, PVR350, Nvidia FX5200, 384MB, 200GB, KnoppMyth R5.5

When I try and schedule a recording via mythweb, I get the following message:

Recording Group:
Warning at /usr/share/mythtv/mythweb/includes/recording_schedules.php, line 412:
mysql_fetch_row(): supplied argument is not a valid MySQL result resource Warning at /usr/share/mythtv/mythweb/includes/recording_schedules.php, line 416:
mysql_free_result(): supplied argument is not a valid MySQL result resource

So yes it would appear that something in my MySQL is messed up.

to mac: this is the beginning of the thread

do you have anything in this directory?

/var/lib/mysql/mythconverg

yes I have lots of files. Any specific one I should be looking for? I can post the list a bit later today.

Don't need a list. Just seeing if your data was still there.

run:
mysqlcheck -c -umythtv -pmythtv mythconverg

If it reports error see this for info on repairing it:
http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043

is the ownership and group of /var/lib/mysql still mysql?
if not do a:
chown mysql.mysql /var/lib/mysql

If for some reason the mythconverg database didn't load take a look for clues in:

/var/log/mysql/mysql.log
/var/log/mysql/mysql.err

Look at /etc/myth/mysql.txt

do a
/etc/init.d/mythtv-backend stop
/etc/init.d/mysql stop
/etc/init.d/mysql start
/etc/init.d/mythtv-backend start

and see what if any useful messages are kicked back..

It might help if we knew what these other problems you already sorted out are. They could be related to this problem.

Thanks guys.

I simply looked at the thread posted by mac and then:





then



and then restarted mysql and the backend. You guys have been great. Thanks so much

did the trick for me! I have no idea what caused my recordings to disappear, but myisamchk recovered them!

Your symptoms and successful recovery indicate that there was mysql DB corruption. This usually occurs as the result of an unclean shutdown. The most common causes of this are naive users who turn off the box by flipping the switch or unplugging it and short power blips.

For the first, education is the best answer, although some people do end up going so far as disabling or blocking access to the power switches and cords. I know one guy who had to use a strap fastened behind the wall plate around the UPS power cable to keep his wifes cleaning lady from unplugging it to use the outlet for a vacuum.

For the second, a UPS is _HIGHLY_ recommended. A working PVR box is a server which is running more or less continuously. It needs a reliable power supply to function reliably. No pro worthy of the name would deploy a server without some kind of backup power source with enough capacity to at least ensure a clean shutdown, and neither should you.

You don't need a fancy or expensive UPS, just a reliable one. If you check the sale inserts in your Sunday paper you should be able to find a ~500 VA APC UPS for ~$40. This is a serious bargain when it comes to cheap insurance. Look for one with a USB monitoring port which will let your KM box do an automatic shutdown if the batteries ever get low.

In addition, even a UPS can't always save you...

I just tracked down a random power-off of my UPS-connected FE/BE machine (random=weekly initially, but recently it's been almost hourly!) to what was probably a ground loop between the computer and the stereo via the line-out connector. Randomly I'd hear a click/pop and the machine would either immediately power off or immediately go into sleep mode (but unrecoverably).

I switched from using the stereo to some cheap, USB-powered computer speakers and have been up for a couple of days.

I know there's a resistance to automatically running database fixups...but perhaps it is time to consider a "Run Database Fixup" script for the knoppmyth page of the frontend menu? Something that doesn't requre sshing in... my ancient tivo didn't seem to care much about unplanned power outs...it probably automatically performed database checkups on unclean startups, though.

-brendan