TVSeriesDatabase4 corrupts on import? (1 Viewer)

[scythe000]

MP 1.1
StreamedMP 1.4.3.2245
MP-TVSeries 2.6.6.1275
Windows 7 x86

DB on file server

Ok, this is really pissing me off. Started having weird issues. did full uninstall, deleted DBs, fresh install and i keep getting errors like the following in configuration.log:

2010-11-19 23:34:07.617900 [Info.][(8)]: SQLiteClient: query returned CORRUPT insert into local_episodes (EpisodeFilename,OriginalComposite,CompositeID,SeriesID,SeasonIndex,EpisodeIndex,LocalEpisodeName,LocalImportProcessed,CompositeUpdated,AvailableSubtitles,OriginalComposite2,CompositeID2,EpisodeIndex2,videoWidth,videoHeight,FileDateAdded,FileDateCreated,IsAvailable,DateWatched,ext,VolumeLabel) values( 'Z:\TV Series\Bill Nye The Science Guy\Bill Nye - 0204 - Chemical Reactions.avi', '', '-12_2x4',-12,2,4, '',1,0, '', '', '',0,0,0, '', '',1, '', '', '')
2010-11-19 23:34:07.617900 [ERROR][(8)]: SQLiteClient: query returned CORRUPT insert into local_episodes (EpisodeFilename,OriginalComposite,CompositeID,SeriesID,SeasonIndex,EpisodeIndex,LocalEpisodeName,LocalImportProcessed,CompositeUpdated,AvailableSubtitles,OriginalComposite2,CompositeID2,EpisodeIndex2,videoWidth,videoHeight,FileDateAdded,FileDateCreated,IsAvailable,DateWatched,ext,VolumeLabel) values( 'Z:\TV Series\Bill Nye The Science Guy\Bill Nye - 0204 - Chemical Reactions.avi', '', '-12_2x4',-12,2,4, '',1,0, '', '', '',0,0,0, '', '',1, '', '', '')
2010-11-19 23:34:07.617900 [Info.][(8)]: SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:insert into local_episodes (EpisodeFilename,OriginalComposite,CompositeID,SeriesID,SeasonIndex,EpisodeIndex,LocalEpisodeName,LocalImportProcessed,CompositeUpdated,AvailableSubtitles,OriginalComposite2,CompositeID2,EpisodeIndex2,videoWidth,videoHeight,FileDateAdded,FileDateCreated,IsAvailable,DateWatched,ext,VolumeLabel) values( 'Z:\TV Series\Bill Nye The Science Guy\Bill Nye - 0204 - Chemical Reactions.avi', '', '-12_2x4',-12,2,4, '',1,0, '', '', '',0,0,0, '', '',1, '', '', '')
2010-11-19 23:34:07.633500 [ERROR][(8)]: SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:insert into local_episodes (EpisodeFilename,OriginalComposite,CompositeID,SeriesID,SeasonIndex,EpisodeIndex,LocalEpisodeName,LocalImportProcessed,CompositeUpdated,AvailableSubtitles,OriginalComposite2,CompositeID2,EpisodeIndex2,videoWidth,videoHeight,FileDateAdded,FileDateCreated,IsAvailable,DateWatched,ext,VolumeLabel) values( 'Z:\TV Series\Bill Nye The Science Guy\Bill Nye - 0204 - Chemical Reactions.avi', '', '-12_2x4',-12,2,4, '',1,0, '', '', '',0,0,0, '', '',1, '', '', '')

or like this in MP-TVSeries.log:
00000008 - 11/19/2010 11:34:07 PM - Commit failed on this command: <insert into local_episodes (EpisodeFilename,OriginalComposite,CompositeID,SeriesID,SeasonIndex,EpisodeIndex,LocalEpisodeName,LocalImportProcessed,CompositeUpdated,AvailableSubtitles,OriginalComposite2,CompositeID2,EpisodeIndex2,videoWidth,videoHeight,FileDateAdded,FileDateCreated,IsAvailable,DateWatched,ext,VolumeLabel) values( 'Z:\TV Series\Bill Nye The Science Guy\Bill Nye - 0204 - Chemical Reactions.avi', '', '-12_2x4',-12,2,4, '',1,0, '', '', '',0,0,0, '', '',1, '', '', '')> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:insert into local_episodes (EpisodeFilename,OriginalComposite,CompositeID,SeriesID,SeasonIndex,EpisodeIndex,LocalEpisodeName,LocalImportProcessed,CompositeUpdated,AvailableSubtitles,OriginalComposite2,CompositeID2,EpisodeIndex2,videoWidth,videoHeight,FileDateAdded,FileDateCreated,IsAvailable,DateWatched,ext,VolumeLabel) values( 'Z:\TV Series\Bill Nye The Science Guy\Bill Nye - 0204 - Chemical Reactions.avi', '', '-12_2x4',-12,2,4, '',1,0, '', '', '',0,0,0, '', '',1, '', '', '')).


Any ideas???
No other clients are connected.

 

[scythe000]

Logs attached. It will import for a bit then eventually do nothing but report corruption. AGh!

 

[Lyfesaver74]

I am guessing you are using a 'Centralized Database' setup? If so you need to set all client machines to have any kind of automatic importing turned off. Only the server side should control importing. What usually fixes it for me is to let have all versions of medial portal turned off and then boot into MP on the server machine and let it fully load. Then power off MP and enter MP configuration.

I just reread that you currently have all clients off. I have 4 clients on my set-up and those machines bork my database lke nobody's business if I dont have the automatic importing turned off. It has happened once or twice that it got borked beyond repair, and that could be the case here. Fortunately MyTVSeries is not as picky as MovingPictures and a rebuild of my TVSeries database (74 series, 411 seasons, 6891 episodes) takes about 2 hours with little to no tweaking after importing, so it is not a big deal. Thats including all my NFL games for the past two years. As long as everything is named right and u keep any graphics that u used it will be a breeze =)

For the record, I know how you feel, and I am sorry =(

 

[scythe000]

Yeah, I have the db on a shared folder on a windows 2008 server machine I don't log on to. My htpc is the one I usually do all the maintenance with. The only thing I could do this time to get it to work was to use mediaportaldirs.XML to make a local fresh db, then copy it to the server and point the clients to it. It had never been a problem before, but seems to be working ok now. I guess the recent changes make mp not like importing 3200 episodes over a network.

Btw, any way to centralize watched flags for movingpictures?

I think I'll take your advice and turn off auto import, and just import on one machine.

I also wish there was a way to repair a corrupt db. Even if it needed to drop some records, that'd be nicer than redoing the whole thing. Maybe also a db scanner to check for corruption in case you get weird random errors and want to check.

 

[Lyfesaver74]

Yeah, I have the db on a shared folder on a windows 2008 server machine I don't log on to. My htpc is the one I usually do all the maintenance with. The only thing I could do this time to get it to work was to use mediaportaldirs.XML to make a local fresh db, then copy it to the server and point the clients to it. It had never been a problem before, but seems to be working ok now. I guess the recent changes make mp not like importing 3200 episodes over a network.

Btw, any way to centralize watched flags for movingpictures?

I think I'll take your advice and turn off auto import, and just import on one machine.

I also wish there was a way to repair a corrupt db. Even if it needed to drop some records, that'd be nicer than redoing the whole thing. Maybe also a db scanner to check for corruption in case you get weird random errors and want to check.

I will double check but I believe my watched flag is shared, If so I will look back thru the changes I made and share that with you.

as for DB repair, that is completely possible, but I wish to say this: If you would just take the time to make sure all of your movies are titled "Name (Year) - IMDBid.ext" Then importing will forever be a faster way to repair a bad DB over having to peck and pull thru the database to identify the error. Granted... I know this would be a LONG process over 3200 files, but you will be MUCH happier with results if you do. =)

Hope this helps, and I will get back with you on the watched flags issue after the Cowboy game!!!

 

[scythe000]

Enjoy the game

Yeah, after this I spent about 2 hours renaming all my series and movies so ~95% import right away.

I love how MP-TVSeries lets you export the watched flags. Too bad MovingPictures doesn't do the same.

 

[Lyfesaver74]

Okay, well it appears my flags are not being shared with all the clients. I thot I had it that way once and then my family decided that with so many clients and ppl watching different things that we liked it set up with each clients individual flags. I will see if can find out more tho. Sorry I could not be more help.