Traceback (most recent call last):
File "/home/web2py/gluon/main.py", line 518, in wsgibase
session._try_store_in_db(request, response)
File "/home/web2py/gluon/globals.py", line 356, in _try_store_in_db
table._db(table.id == record_id).update(**dd)
File "/home/web2py/gluon/sql.py", line 3244, in update
self._db._execute(query)
File "/home/web2py/gluon/sql.py", line 895, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: database is locked
i've google about sqlite and some say that sqlite have a default
timeout of 5 seconds.
i think it should be able to catch the error when the database file is
locked, for other sql database we should be able to catch the error
too when the sql server is down.
-vince
On Mar 17, 10:39 pm, mdipierro <[email protected]> wrote:
> What error do you get? What triggers it? I do not think it related to
> timeout of database.
>
> On Mar 17, 6:01 am, vince <[email protected]> wrote:
>
> > i understand sqlite is not for heavy usage. i just want to know is
> > there any way to set the timeout for database file access before
> > returning "database is locked" error?
>
> > also is there any way to catch the error and return some "busy" error
> > page?
>
> > although i do not have problem with for eg. mysql, but i still want to
> > know is there any way to catch the error if mysql server is down?
>
> > -vince
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
