Hi, I have a pretty simple app with about 7 models defined, generating probably about 15 tables or so. Just to test performance, I wrote a script that tries to populate the database with on the order of about 10,000 entries.
On the backend, right now I'm using sqlite3 just for simplicity's sake, even though I will use MySQL eventually. While the script is running, it dies about 1/8th into it, with the following trace. Afterwards, the database is locked and there's nothing else that can be done about it. Is this a limitation on sqlite3? I looked here (http://www.sqlite.org/ limits.html) and it would seem like sqlite can handle this quantity, but maybe I'm mistaken? Or is this a django problem? Any help would be appreciated, Brian Traceback (most recent call last): File "<console>", line 1, in <module> File "/nfs/users/myname/django/myproj/myapp/bug_setup.py", line 78, in <module> chip = Chip.objects.get(pk=n) File "/usr/local/lib/python2.5/site-packages/django/db/models/ manager.py", line 82, in get return self.get_query_set().get(*args, **kwargs) File "/usr/local/lib/python2.5/site-packages/django/db/models/ query.py", line 282, in get num = len(clone) File "/usr/local/lib/python2.5/site-packages/django/db/models/ query.py", line 139, in __len__ self._result_cache = list(self.iterator()) File "/usr/local/lib/python2.5/site-packages/django/db/models/ query.py", line 252, in iterator for row in self.query.results_iter(): File "/usr/local/lib/python2.5/site-packages/django/db/models/sql/ query.py", line 204, in results_iter for rows in self.execute_sql(MULTI): File "/usr/local/lib/python2.5/site-packages/django/db/models/sql/ query.py", line 1620, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python2.5/site-packages/django/db/backends/ util.py", line 18, in execute return self.cursor.execute(sql, params) File "/usr/local/lib/python2.5/site-packages/django/db/backends/ sqlite3/base.py", line 136, in execute return Database.Cursor.execute(self, query, params) OperationalError: database is locked --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
