Are you using multiple connections to the same database? db=DAL(...) On Mar 17, 7:51 pm, vince <[email protected]> wrote: > 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.
