Reply to thread

Message

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.

<blockquote data-quote="RoChess" data-source="post: 569440" data-attributes="member: 18896">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.<ul>
<li data-xf-list-type="ul">NOT storing the database on anything other then a physical drive in the same system MediaPortal is on.</li>
<li data-xf-list-type="ul">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.</li>
<li data-xf-list-type="ul">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.</li>
</ul>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.</blockquote>

[QUOTE="RoChess, post: 569440, member: 18896"] 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. [list][*]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.[/list] 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. [/QUOTE]