Database Curroption (1 Viewer)

[FlipModeOC]

Hello everyone, couple of weeks ago I was going to watch some episodes but when going into the My TV Series the database showed "No Files" error. I did some trouble shooting and found out that the last 3 episodes of "How I met your mother" was corrupting the database, as soon as I remove the episodes from the tv shows dir it comes back to life.

What info do you guys need to look into this?
Thanks

 

[Inker]

Db Corruption is an ongoing issue, we don't really know what causes it unfortunatly aside from seeing that people that share their db over the network with multiple clients experience it to a much greater degree, which is why we actively discourage such a usage.

Some people never experience it through years of usage, including myself, others seem to run into it every few months, going so far as to backup their database daily to shield against dataloss.

Unless someone can provided an insight into the causes, there is nothing we can do, sorry.

 

[RoChess]

I used to rename, move, and delete files with Windows Explorer all the time, and kept getting problems inside MP-TVSeries, eventually leading to full blown database corruption. After deleting the database and starting fresh, I now only do file maintenance from within MP-TVSeries and have never experienced a corruption ever since.

Now a lot has changed and the new plugin versions deal with file manipulation outside of the plugin a lot better, but from your explanation it does sound like you did some of those same manipulations as I did. I actually tried to find a scenario that would always lead to corruption, but I would get different results each time I would retry. It is the lack of a reproducable scenario that makes it almost impossible for the developers to then find the problem in their source code.

I actually gave up myself, but perhaps you are able to create such a scenario. Just be sure you write down each step required from a fresh install towards the point of corruption, that can be repeated. That way the developer will be able to do the same steps and then trace down the core problem in the source code to fix it.

 

[FlipModeOC]

I managed to reproduce the error twice now, I'll try to reproduce it again later tonight and report back.

Alright, the problem is 100% reproducable.

1. I opened the plugin and the plugin config window to make sure that the database is functional.
2. I moved the suspected episode to the dir that plugin scans.
3. I fired up MP and then the plugin, first few seconds everything seems alright but then the importer catches the new episode and it goes into infinite loading loop.
4. I exit the plugin and close MP, start up the plugin config and the database is empty all of the sudden.
5. I removed the episode from the dir and emptied the database and started a new scan and everything is back to normal - also works if I just restore a backup of the db.

 

[RoChess]

Alright, the problem is 100% reproducable.

Awesome, logs on that will allow the developer to fix it.

for the time to figure that out.

and emptied the database

That's the one part that does worry me, because I kept getting database corruption when I used the 'empty' function. An actual delete of the db3 file was required for me to get rid of my own database corruption. Can you please retry your scenario with an actual delete. This does mean you have to redo all your settings, but this is the only way to know for sure (keep a backup of course).

 

[disaster123]

AW: Database Curroption

i've stopped sharing my DB with other clients but i still see this issue since a long time. The most different thing i'm seeing in mptvseries is that a journal file is created really often i don't see this with other plugins.

 

[FlipModeOC]

That's the one part that does worry me, because I kept getting database corruption when I used the 'empty' function. An actual delete of the db3 file was required for me to get rid of my own database corruption. Can you please retry your scenario with an actual delete. This does mean you have to redo all your settings, but this is the only way to know for sure (keep a backup of course).

Well you were correct, deleting the database dir and starting the plugin solved the problem. Thanks for help.