Hello Doug, Thursday, March 13, 2008, 4:27:40 PM, you wrote:
D> I had something very similar happen. In my case there was a journal file D> that was created by a service, so it had different file rights. My account D> didn't have rights to the journal, but when SQLite saw the journal there and D> wasn't able to play it back, it reported the database locked error. D> Changing the journal file rights solved it for me. If you deleted the D> journal file (if there was one) that might explain it in your case. D> Doug >> -----Original Message----- >> From: [EMAIL PROTECTED] D> [mailto:[EMAIL PROTECTED] On >> Behalf Of Teg >> Sent: Thursday, March 13, 2008 9:48 AM >> To: General Discussion of SQLite Database >> Subject: [sqlite] Weird locking issue Windows XP64 3.5.5 >> >> Hello All, >> >> Just thought I'd report this and see if anyone has any ideas. I'm >> upgrading to 3.5.6 as I write this just in case. >> >> I had a DB file that reported locked in my application. I tried it >> with Sqlite3.exe and it also reported it was locked. I exited the >> application, exited the programming environment and shut >> apps down one at a time till I had nothing running. The file >> remained "locked". I copied the file to another filename, this file >> wasn't locked and there was no issue with the copy. >> >> I was able to delete the original file and rename the copy as the >> original filename. Now it's not locked any more. It seems as if there >> was still some OS level lock on the file even thought the application >> had exited. >> >> I'm sure I won't be able to reproduce this. It's never happened before >> as far as I know. >> >> >> -- >> Best regards, >> Conrad mailto:[EMAIL PROTECTED] >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D> _______________________________________________ D> sqlite-users mailing list D> sqlite-users@sqlite.org D> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Appreciate it. If it happens again. I'll look for a journal file. In my case the app was running at my privilege level which was Administrator. It was odd. -- Best regards, Teg mailto:[EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
