Author |
Message |
Registered: March 18, 2007 | Posts: 426 |
| Posted: | | | | For the last couple of months, my database keeps getting corrupt regularly. This typically happens when I download updated profiles or add new DVDs. I would get an error (which I wished I took a screenshot of). It will say about 2 fields that it has an invalid value "[ ]". Most of the times I can repair the database, although it seems to delete records. Recently it turned into quite a mess where several profiles were gone. I had to go look at my online database to compare one by one which ones were gone . These issues started a while ago when I would also get a Windows warning stating "Delayed Write Failed". Which brings me to some background info... I'm not sure if this is causing this, but I have a particular deployment. My entire database is on a file server as a shared directory, such that I can access my database from mulitple clients (desktop, laptop, netbook). This worked great for years though. But the fact that the latest DVDP now also has a sharing feature made me doubt. I don't understand the advantage of that sharing feature though as you can't even update your database from the clients, whereas in my setup any client could do the update. Mind you, I make sure that no 2 clients are accessing the database in parallel, as I realize that that might corrupt the database. I'm at the point now that I've installed DVDP on my file server (XP Pro) and only do updates of DVDP anymore through Remote Desktop on the file server itself. This of course I would like to get fixed still, because I also use DVDP Mobile which is synced to my desktop so I can't keep using the desktop client in read-only mode. |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,946 |
| Posted: | | | | I'm not sure if this will fix your problem, but you could try the following steps
Run a full database repair (if you still see errors, try running it until you have no more errors) Backup your database Create a new database Perform a restore, but make sure you deselect "Replace full user database)
It's a long shot, but if you have some structural database error the repair can't fix, this might do the trick. | | | View my collection at http://www.chriskepolis.be/home/dvd.htm
Chris | | | Last edited: by cvermeylen |
|
Registered: May 19, 2007 | Reputation: | Posts: 5,917 |
| Posted: | | | | Here's a link to look into to see if you can find and solve the underlying issue for the network delayed write errors. http://support.microsoft.com/kb/321733You can also try some long pings. From a cmd prompt: ping -t -n 2000 -l 60000 x.x.x.x Where x.x.x.x is the other's IP Do this on both PC's simultaniously towards each other. Let it run for a minute or so and press Ctrl-C . Check if there is any loss. | | | Last edited: by Dr. Killpatient |
|
Registered: May 19, 2007 | Reputation: | Posts: 5,917 |
| Posted: | | | | Also, how is your network set up in your house between the computers in question? Wireless/wired/switches/routers/etc |
|
Registered: March 18, 2007 | Posts: 426 |
| Posted: | | | | Thanks for the suggestions.
Well, I recently had to re-install my file server completely and since then haven't seen the 'Delayed Write Failure' thing anymore. Nonetheless, I am still getting the DVDP errors. In fact tonight again a problem. It now tells me that there is an error in my 'With Love From Russia' profile from my 007 box, and asked if I wanted to delete it. I said no, but it still is missing from my database now. No idea why this happened because I have not touched that profile in ages.
So I had to go restore from my file backup. I now have done the suggestion of starting from a completely new database and doing the DVDP Import into that. I hope that finally fixes it, because I'm getting completely clueless why I keep getting errors. Obviously I'll be doing the built-in DVDP backups regularly now (in addition to my standard weekly file server backups).
FWIW, the network setup is pretty standard. Server and Desktop PC connected through LAN on the router. Netbook and laptop connected through Wfi. The error tonight was on my Desktop PC. |
|
Registered: May 19, 2007 | Reputation: | Posts: 5,917 |
| Posted: | | | | There might be issues hanging around from the Delayed Write Error days. I'd perform a db repair and re-add the profile that reported the error. |
|
Registered: March 29, 2007 | Reputation: | Posts: 2,750 |
| Posted: | | | | I agree with the Dr. | | | Marty - Registered July 10, 2004, User since 2002. |
|
Registered: March 18, 2007 | Posts: 426 |
| Posted: | | | | Ok, trouble in paradise again.
Just opened DVDP on my desktop computer and did a refresh all profiles. It found about 10, and downloaded them. Then after the download finished, my PC gave the following error:
Windows - Delayed Write Failed Windows was unable to save all the data for the file \\Server\Shared\DVD Profiler\Databases\Our Collection\DirectProduce.DAT. The data has been lost. This error may be caused by a failure of your computer hardware or network connection. Please try to save.
At the same time, DVDP gave a popup :
Error loading the following Entry. Delete this record? UPC: [] Title: [] Delete Record ?
After clicking Yes (as I intend to just restore my backup) I get a couple of other errors as well.
As the Delayed Write Failure error is again showing up, even after I recently reinstalled my server, I'll look a bit further down that path, with the link that Dr.Killpatient gave. |
|
Registered: March 18, 2007 | Posts: 426 |
| Posted: | | | | The problem I am having is exactly what is described here : http://support.microsoft.com/kb/890352 . However, my server is XP Pro, not 2003, so doubt that the cause is the same. After googling on that same event detail, I however found several hits of other people who have the same problem, even on XP. There are a few mentions about changing the network card's rate from 'auto' to '100 Full Duplex' so am trying that out now... Update: no help, same problem during update of profiles . | | | Last edited: by hevanw |
|
Registered: March 18, 2007 | Posts: 426 |
| Posted: | | | | Really clueless now. I did some other tests and nothing is revealing any problems with the communication between PC and server. I've never had problems streaming video or copying large files. Just did a test with a >1G file and it copies in a few minutes without hickups. In fact, I have other applications where the client runs on my PC or laptop and that use a database (postgres) on the server and I never had any problems there either.
So why is it that only DVDP is triggering this Windows 'Delayed Write Failed' error ??? |
|