Error ticket for "MyAppTest"
Ticket ID

10.25.9.218.2016-05-31.11-15-14.e2d535a4-681a-4037-ae57-e4f7376f1092
<class 'sqlite3.OperationalError'> database is locked
Version
web2py™ 	Version 2.14.6-stable+timestamp.2016.05.09.19.18.48
Python 	Python 2.7.10: Q:\WinPython27\python-2.7.10\python.exe (prefix: Q:\WinPython27\python-2.7.10)
Traceback

Traceback (most recent call last):
  File "Q:\web2py\gluon\restricted.py", line 227, in restricted
    exec ccode in environment
  File "Q:/web2py/applications/MyAppTest/controllers/test.py", line 32, in <module>
  File "Q:\web2py\gluon\globals.py", line 417, in <lambda>
    self._caller = lambda f: f()
  File "Q:/web2py/applications/MyAppTest/controllers/test.py", line 18, in index
    myRecord.update_record(name="yeahupdateeee")
  File "Q:\web2py\gluon\packages\dal\pydal\helpers\classes.py", line 245, in __call__
    **newfields
  File "Q:\web2py\gluon\packages\dal\pydal\objects.py", line 2054, in update
    ret = db._adapter.update("%s" % table._tablename, self.query, fields)
  File "Q:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1031, in update
    raise e
OperationalError: database is locked

Error snapshot help

<class 'sqlite3.OperationalError'>(database is locked)

inspect attributes
Frames

    File Q:\web2py\gluon\restricted.py in restricted at line 227 code arguments variables

    File Q:\web2py\applications\MyAppTest\controllers\test.py in <module> at line 32 code arguments variables

    File Q:\web2py\gluon\globals.py in <lambda> at line 417 code arguments variables

    File Q:\web2py\applications\MyAppTest\controllers\test.py in index at line 18 code arguments variables

    File Q:\web2py\gluon\packages\dal\pydal\helpers\classes.py in __call__ at line 245 code arguments variables

    File Q:\web2py\web2py\gluon\packages\dal\pydal\objects.py in update at line 2054 code arguments variables

    File Q:\web2py\gluon\packages\dal\pydal\adapters\base.py in update at line 1031 code arguments variables
    Function argument list

    (self=<pydal.adapters.sqlite.SQLiteAdapter object>, tablename='mytest', query=<Query (mytest.id = 4)>, fields=[(<pydal.objects.Field object>, 'yeahupdateeee')])
    Code listing

            except Exception:
                e = sys.exc_info()[1]
                table = self.db[tablename]
                if hasattr(table,'_on_update_error'):
                    return table._on_update_error(table,query,fields,e)
                raise e

            try:
                return self.cursor.rowcount
            except:
                return None

    Variables
    e 	OperationalError('database is locked',)

Context

locals request session response
In file: Q:\web2py\applications\MyAppTest\controllers/test.py

# -*- coding: utf-8 -*-
# try something like
def index():
    # connect
    db = DAL('sqlite://storage.sqlite',pool_size=10,auto_import=True)

    # get first record
    myRecord = db(db.mytest).select().first()

    if myRecord:
        myRecord.update_record(name="yeahupdateeee")
    else: # no record
        db(db.mytest).insert(name="insertteeee")

    # just in case needed?
    db.commit()
    db.close()

    return "test"

response._vars=response._caller(index)