NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Add-ons (3rd party plugins, utilities and skins) Old Stuff (Legacy) GB-PVR Support (legacy) v
« Previous 1 … 599 600 601 602 603 … 1231 Next »
Database Trouble - SQLite

 
  • 0 Vote(s) - 0 Average
Database Trouble - SQLite
86atc250r
Offline

Member

Posts: 128
Threads: 19
Joined: Nov 2005
#1
2007-02-15, 12:47 AM
It seems I now have 300GB of recorded files that I no longer have information for.

Unsure what happened - but everything in my "recordings" section is gone. I still have EPG and other data - browsing the DB, it appears the EPG for the recorded files is still there, but I can only assume that the file name associations are stored in the recording_schedule table - which has somehow emptied itself - completely.

Anyone have any idea what could have caused this & how to prevent it in the future - it doesn't appear that there is any way to get any of it back.

Using SQLite, 99.5, etc. Nothing changed on my end to make this happen. Data was there last night, gone today - odd thing is, this appears to be the only table that has emptied itself. Unfortunately, it's probably the only table that can't be easily rebuilt.
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,809
Threads: 769
Joined: Nov 2003
#2
2007-02-15, 01:03 AM
Each time GB-PVR loads the recording list, it checks that the file that is referred to is still in the specified location. If not, then it assumes the user manually deleted the file, so it automatically removes the record from the database to clean up.

This logic usually works well, and really helps with keeping things up to date, but it does occasionally trip people up that might have temporarily moved recordings around on disk.

If its just happened in the last day, then you should be able to click 'import recordings' in the config app and select the 'recordings-dump.xml' file. Assuming the files are in their original locations, this should recreate the recordings in the database.

If you dont like this behaviour, it can be disabled by setting <AutoRemoveMissingRecordings>false</AutoRemoveMissingRecordings> in config.xml
86atc250r
Offline

Member

Posts: 128
Threads: 19
Joined: Nov 2005
#3
2007-02-15, 01:10 AM
Your kung-fu is strong.

I was all bummed out that the data was lost but the import function worked most excellently.

I don't know what happened, I have a seperate 500gb drive that does nothing but media storage in my system (my F: drive) - nothing was moved manually or even changed, for some reason the db was cleared. Maybe this drive dropped off radar for a short time? Unknown.

That was the 2nd time I've lost my DB - the first time something weird happened during an upgrade and unfortunately, past upgrades had went so well that I was complacent about backing up the db for the first time and it bit me. I wonder if the import function would have worked for me then, too?

Anyhow - all is well, you're the man!
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,809
Threads: 769
Joined: Nov 2003
#4
2007-02-15, 01:19 AM
Quote:I wonder if the import function would have worked for me then, too?
Probably Big Grin

If that doesnt work, GB-PVR also stores recording meta data with the video file if you're on an NTFS filesystem, which can be used to rebuild the recordings. There are some utilities on the wiki for this.
86atc250r
Offline

Member

Posts: 128
Threads: 19
Joined: Nov 2005
#5
2007-02-15, 01:23 AM
Interesting... I still have files from that original db that are orphaned out there on the file system. I'll do some reading and see if I can restore them into the database too.

Thanks again for the quick fix Smile
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,809
Threads: 769
Joined: Nov 2003
#6
2007-02-15, 01:25 AM
If its only a few files, you can also manually edit the recordings-dump.xml file to create entries for the shows you want to add to the Recordings list, then do the import.
86atc250r
Offline

Member

Posts: 128
Threads: 19
Joined: Nov 2005
#7
2007-02-15, 01:40 AM
There were about 40 additional recordings. The utility in the wiki worked perfectly. If I had only known that there was meta data and the dump file. At least my DB is now more complete than it has ever been. Thanks again!
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,809
Threads: 769
Joined: Nov 2003
#8
2007-02-15, 01:48 AM
Even though its very rare to have a database problem like this, its worth while having these safety nets in place.
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Huge database (+27GB) - is it a problem? pme 7 3,137 2011-01-24, 12:37 AM
Last Post: gEd
  "database disk image is malformed" during attemped EPG update! (GBPVR v.1.4.7) DaveA 4 3,461 2011-01-23, 06:35 PM
Last Post: DaveA
  GBPVR Database question - Recording Schedule David B 1 1,672 2010-11-08, 09:21 PM
Last Post: sub
  Lost recordings database keith_leitch 9 3,872 2010-09-22, 09:20 PM
Last Post: keith_leitch
  Postprocessing and the recordings database shsw 1 1,548 2010-08-29, 04:46 PM
Last Post: sub
  Lost recordings database dongna 25 8,172 2010-08-26, 10:00 AM
Last Post: martint123
  Strange database problem -- pvrx2 not seeing updates, EWA and Config.exe are. 86atc250r 5 2,527 2010-07-26, 10:09 AM
Last Post: martint123
  Trouble with mapped network drive DrNic2032 2 1,839 2010-07-13, 05:45 PM
Last Post: pBS
  EPG update trouble gaspika 2 1,855 2010-06-06, 07:21 AM
Last Post: gaspika
  Cleaning up the database? Spark 3 1,883 2010-03-28, 07:20 PM
Last Post: sub

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode