Kilian, I does indeed say here that SQLite can handle concurrent transaction, by queuing them up:
http://www.sqlite.org/faq.html#q7 You're not using an NFS share are you ? Apparently that would break it. Are you running the app / script on each users machine, or on a web server they all access ? I hope I don't get into too much trouble for saying this, but for multi-user production systems (i.e. web apps) MySQL or Postgres would be a better choice. As the link above says they "support a higher level of concurrency and allow multiple processes to be writing to the same database at the same time. " Best regards, Graham. Kilian CAVALOTTI wrote: > Hi all, > > I'm currently developing a little django application for monitoring > workstations. Each monitored host reports its own data by creating an object > in django db. It can obviously occur that several workstations try to access > the db at the same time. And I commonly get the following error (using the > SQLite backend): > > Traceback (most recent call last): > File "/home/lw/localWatch/collect/collect.py", line 168, in ? > h.save() > File "/home/lw/django/django/db/models/base.py", line 166, in save > db_values + [pk_val]) > File "/home/lw/django/django/db/backends/util.py", line 12, in execute > return self.cursor.execute(sql, params) > File "/home/lw/django/django/db/backends/sqlite3/base.py", line 69, in > execute > return Database.Cursor.execute(self, query, params) > pysqlite2.dbapi2.OperationalError: unable to open database file > > When I manually launch my application, on only one host, there's no error, > and > the script correctly completes. > > I thought that SQLite gracefully handled concurrent accesses, so I wonder why > I get these errors. Is there a way to tune framework locks on the database, > to change retry limits, or something else, to avoid this? > > Thanks in advance, --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
