[siesta-dev] SQLite 'issues'

[prev] [thread] [next] [lurker] [Date index for 2002/08/26]

From: Richard Clamp
Subject: [siesta-dev] SQLite 'issues'
Date: 19:04 on 26 Aug 2002
After exhaustive committing and manually debouncing mails I decided to
RTFM and have come to a stupefying conclusion.  DBD::SQLite doesn't
allow for concurrent access: http://www.hwaci.com/sw/sqlite/faq.html#q7

Whenever I do a commit of two directories at once I'm pretty much
guaranteed a bounce from one of them as CVS generates two commit
Ima::DBI->connect(/home/richardc/lab/siesta/bin/siesta.db) failed:  at /home/richardc/lab/siesta/lib/Siesta/List.pm line 36
 at /home/richardc/lab/siesta/lib/Siesta/List.pm line 36
couldn't load list 'siesta-commit' at /home/richardc/lab/siesta/lib/Siesta.pm line 18, <STDIN> line 55.

There's a couple of easy ways to handle this, I think.

1) Externally lock tequila so that mail-runs happen sequentially.
2) Migrate to a different database (this also means using a different
box for hosting as plough doesn't have mysql or postgresql on it, and
may be unlikely to - Evil?)
3) Cry, pout, kill everyone.


Richard Clamp <richardc@xxxxxxxxx.xxx>

Generated at 13:56 on 01 Jul 2004 by mariachi 0.52