Stephen Lombardo wrote:
Hi Mohit,
Are you using TortoiseSVN by any chance?
This is absolutely incredible!! Unbelievable that someone would notice
this... and remember it! Thanks very much.. and even hunting up the
thread for me!
I remember seeing a post to the sqlite list regarding issues sqlite
database TortoiseSVN a
couple months ago. The tsvncache process was interfering with sqlite's
deletion of the transaction journal causing seemingly random errors. I dug
up the link to the thread for you.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg34453.html
Yes, I am running TSVN...
I did a brute force test - tried running rake production db:migrate and
it crashed.
Then, I killed TSVNCache and did the same thing - and it worked! Amazing!
If you are running tsvn you could try to configure it to ignore the
directory your database file resides in. Or, I suppose you could also try to
rig up a migration to change the sqlite journal mode so the library will
reuse the journal.
I'll look this up! At least, it's starting to work!
execute "PRAGMA journal_mode = PERSIST"
For what its worth it looks like this kind of problem could be caused by
virus scanners or search services that open and scan new files when they are
created.
Thanks a lot for this. It really had me at world's end. This needs to
go into the documentation. I shall do that!
I'm off to bed now!
Cheers,
Mohit.
8/12/2008 | 2:46 AM.
_______________________________________________
Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
