(Migrated) Multiple servers + SQLite

Community support
#1

(This message has been automatically imported from the retired mailing list)

The tutorial suggests to use sqlite as ODB. I guess it’s fine to start
with a small and simple database. However, quickstart creates 2 servers
and they both use the same DB. It happened to me multiple times now
that one of the servers has crashed because it couldn’t get a lock on
the database. I’m now continuing my testing with just 1 server running.
I’m not getting anymore crashes.

Should the documentation have some advice about when (not) to use
SQLite? Should the tutorial be updated accordingly?

#2

On 29/10/2015 21:05, Sam Geeraerts wrote:

It happened to me multiple times now
that one of the servers has crashed because it couldn’t get a lock on
the database.
Can you define “crash”? Can you show the relevant stderr or log output?

I use mysql as ODB. However, as far as I know sqlite should be able to
work with multiple clients. sqlite doesn’t support row locking, but it
does support database locking, and the other clients should just wait
their turn to acquire a lock.

You are not storing the sqlite database on NFS or something like that?

Regards,

Brian.