backup crashing - missing pidcache table ?

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
gaskit
Newcomer
Posts: 1
Joined: Sat Jul 30, 2016 8:42 am
Australia

backup crashing - missing pidcache table ?

Post by gaskit »

I've been running 0.27 on Ubuntu 14.04 for some time without problems. I was thinking to upgrade to 0.28 so went to check on my automatic database backups. They were all there - but just 807 Bytes which looked suspicious so ran a manual backup and found it crashed due to missing pidcache table. Checking the database in Mythweb also gives:

Can't find file: 'pidcache' (errno: 2)

I ran Repair Tables from Mythweb but no fix. I've no idea what pidcache is for or how I might fix it. I have no clue as far as mysql goes!

I repeat - MythTV works fine despite this error. Does it matter? Am I going to hit problems if I try to upgrade to 0.28?
Whatever, I'd like to fix this as I don't like having a working backup after the grief Ubuntu and MythTV has given me in the past!
User avatar
paulh
Developer
Posts: 909
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: backup crashing - missing pidcache table ?

Post by paulh »

If you are competent with Mysql you could recreate the table using the info here
https://github.com/MythTV/mythtv/blob/m ... .cpp#L3929
Post Reply