Database keeps disapearing part 2!!! (1 Viewer)

[trekkiedj]

Quote:
Originally Posted by Inker
Your database is corrupt.

Stop putting the database on the LAN, this is not supported and the most likely reason this happened, which is also why its not supported.

Seriously.
Thread closed.

Ok, lets see if we can have a civilised discussion without one person being aggressive and deciding it upon themselves to shut the thread down in less than 12 hours!!!! Way to go to make a relative noob feel welcome!

This is nothing to do with a LAN issue. As the original topic starter mentioned, his database is local, and even if the log shows a reference to a //**PC**/ LAN address, the router would tell the PC to look locally. Test this yourself, by copying a file from a local drive to another local folder using the "Network" path.

As for the database, had the thread been allowed to function for more than 12 hours, it would have been mentioned that this is not an isolated case. Many people on another forum have mentioned this, as well as some here, and this includes myself!!!

It has been narrowed down to the db3 format being the issue. If windows updates or crashes or for any other reason the machine is interupted while the db3 file is being written to, it will corrupt the file, period! the only way to tackle this permanently is to switch to SQL. On a temporary basis, take regular backups of the db3 file for TV Series and just drop it back in if it corrupts itself.

Any other people found a better solution?

 

[Zinu]

Not really to help you, but network paths work fine with MyTVseries. I have a path as \\SERVER\\Videos\TV Series from which MyTVseries has been running fine for months. I do have database corruptions now and then, but a simple replacement with a backup of a working database fixes it and lets me pick up where I left off.

I do have to say MyTVseries database is real sensitive for errors. It has corrupted on me about 5 times in 4-5 months.

 

[trekkiedj]

Not really to help you, but network paths work fine with MyTVseries. I have a path as \\SERVER\\Videos\TV Series from which MyTVseries has been running fine for months. I do have database corruptions now and then, but a simple replacement with a backup of a working database fixes it and lets me pick up where I left off.

I do have to say MyTVseries database is real sensitive for errors. It has corrupted on me about 5 times in 4-5 months.

Actually no, you are a great help. This just helps to illustrate that this is NOT related to LAN.

I have noticed that although all the MP DB's are db3 format, it is only TV Series that corrupts itself time after time. It may just be something to do with the more frequent updating the plugin does in comparison to other plugins, although Moving Pictures polls for new backdrops and details frequently too. Now if i lost that DB i would cry with over a thousand movies!!!

 

[Zinu]

Just make sure you get backups, it'll save you alot of hassle Every time I get a problem with MP, i'm glad my Home server has backed up the files when they were actually working

 

[RoChess]

Just to be clear.

Import paths on \\UNC = Not a problem

db3 files on \\UNC = A problem on a lot of configurations. This has nothing to do with MediaPortal, MP-TVSeries or MovingPictures, but is a core problem in SQLite. You are welcome to go to the SQLite development website and read all about it.

Workable solution: setup local db3 file, and use batch files or other ways to sync this file with other clients, possibly using a central server. Just be sure that all *import* paths are UNC based then, because movies/etc on C:/D:/etc on client #1 will not exist on client #2, unless you copy those over as well. But an import path of "\\UNC_Client_1\Share_1\" will work on both client #1 and #2.

There are other solutions, but that's the easiest one, otherwise check the forum for the many other solutions that are worked on. But be aware that an actual server+client modification might be being developed as well, so if you are handy in C#, consider helping the developers on that, to benefit the entire community, instead of hacking together something that works for you alone.

 

[Inker]

Quote:
Originally Posted by Inker
Your database is corrupt.

Stop putting the database on the LAN, this is not supported and the most likely reason this happened, which is also why its not supported.

Seriously.
Thread closed.

Ok, lets see if we can have a civilised discussion without one person being aggressive and deciding it upon themselves to shut the thread down in less than 12 hours!!!! Way to go to make a relative noob feel welcome!

This is nothing to do with a LAN issue. As the original topic starter mentioned, his database is local, and even if the log shows a reference to a //**PC**/ LAN address, the router would tell the PC to look locally. Test this yourself, by copying a file from a local drive to another local folder using the "Network" path.

Actually it has everything to do with a LAN issue. Did you also read the part where I said it doesn't matter if its a different PC? It doesn't matter what the "router would tell the PC". It goes over the network stack and that is the problem.

The thread was closed because it was clear the other person didn't listen, so it was going in circles. Frankly I don't see this thread going anywhere either.

I hope you understand.

BTW, yes the db3 can also get corrupt if its local, but that is much less likely than if its accessed over the network (and yes that includes loopback) which is why we tell people not to do it.

Edit:
Also, what RoChess said is absolutely correct.

 

[trekkiedj]

Rochess/Inker

I totally understand what you are saying, and I understand that network stacks could cause a problem. However in this instance my question is what would cause it to corrupt itself when the path is totally local (i.e. C:\.....\Mediaportal\database\...). This is happening several times a week and is only salvagable by copying the last good copy back to the database folder.

This is a fairly recent issue, maybe in the last month, that has cropped up.

Inker, my post was not meant to light a fire, but to point out that had the thread remained open others with more local issues would have surfaced.

 

[Inker]

We don't really know what causes the corruption. The only thing we know is that it happens alot more if the db is acessed over the network (wether local or not).

My personal oppinion is something interfering with the sole acess to the db3 file (like an AV program briefly interfering). It could also be a bug in the plugin itself, or even a bug in the .net sql lite connector. Or its a weird combination of all of those. For some people it might be a hardware issue. We recently had a few patches by gibman come in that properly close the db before entering standby. It could very well be that this was the issue.

I personally never had it happen to me in the years of using the plugin.

The other thread wasn't the correct place to discuss db corruption for a local db (that and the poster changed the thread title several times and jumped to a different problem in the middle, then came back obviously without having read/acknoledge what had been said before, hence the closure).

 

[RoChess]

Rochess/Inker

I totally understand what you are saying, and I understand that network stacks could cause a problem. However in this instance my question is what would cause it to corrupt itself when the path is totally local (i.e. C:\.....\Mediaportal\database\...). This is happening several times a week and is only salvagable by copying the last good copy back to the database folder.

I've got a massive database, with hourly changes made to the database regarding adding new content, watched flag, user rating and other adjustments, and I've never encountered any corruptions in the db3 file (for a few months now) after taking a few precautions.

• NOT storing the database on anything other then a physical drive in the same system MediaPortal is on.
• For MP-TVSeries, do any file managment inside the plugin GUI (or config), especially deleting. Before I would move files around, rename them and delete ones I've watched via Windows Explorer on the NAS directly or via another system and after a while I would start getting really weird random behaviour.
• For MovingPictures, upgrade to v1.0.x as it has a much improved import folder monitor system that keeps track of files moved/deleted/renamed. But if you try to do things too quick, for example you add a file, and the scraper is processing it and you quickly rename it, then things can go borked if your computer isn't fast enough to complete the one task first. The OS can also end up locking the file, in which a reboot is needed, unless you have tools such as procexp.exe from SysInternals.

You shouldn't have to rely on constant restores, sounds more like you have a core problem that you should hunt down the source on, not the symptoms.

 

[DutchTerror]

I dont know if this is of any help but I would just like to let you all know the person above is not on his own.

My Tvseries Db is on the same machine as my mediaportal installation and and is pointing to a local a path and I have had a corrupted database on so many occasions that I now backup the file every 12 hours - rebuilding the entire DB with over a 100 series with each ~5-6 seasons is a true nightmare.