Has anyone encountered the error in the message subject before?
I saw it for the first time last night in the logs of one of the
embedded servers I described in a recent post. Here's the code that
threw the error
def _sysid():
""" Utility. Returns f_system_identifier_string """
sysid =
db(db.t_sys_config).select(db.t_sys_config.f_system_identifier_string).last()
['f_system_identifier_string']
return sysid
The _sysid() function gets called in a loop about once per minute in a
continually running web2py shell process as part of normal data
processing. The system had been running for weeks when the error
occurred.
The log leading up to the error is at the bottom of this message.
Everything resumed normally after with no error reports after I
manually restarted the process.
Any help appreciated. The app is running under web2py 1.97 using
SQLite as the db. The OS is Linux Mint 10.
Thanks,
Mike
2011-09-23 00:59:13,799 - pid=1547 - INFO
Entering v2_data_insert
2011-09-23 00:59:14,065 - pid=1547 - INFO
before: 50388, after: 50389
2011-09-23 00:59:14,065 - pid=1547 - INFO
Leaving v2_data_insert
2011-09-23 00:59:14,084 - pid=1547 - DEBUG
About to sleep.
2011-09-23 00:59:15,133 - pid=1547 - ERROR
Traceback (most recent call last):
File "web2py.py", line 19, in <module>
gluon.widget.start(cron=True)
File "/home/solarmax/web2py/gluon/widget.py", line 809, in start
import_models=options.import_models, startfile=options.run)
File "/home/solarmax/web2py/gluon/shell.py", line 200, in run
execfile(startfile, _env)
File "applications/sunrex/modules/fls_data_handler.py", line 540, in
<module>
runDataHandler()
File "applications/sunrex/modules/fls_data_handler.py", line 507, in
runDataHandler
sys_config = getSysConfig()
File "applications/sunrex/modules/fls_data_handler.py", line 154, in
getSysConfig
return sys_config_list()['data']['sys_config']
File "applications/sunrex/modules/fls_data_handler.py", line 129, in
sys_config_list
return dict(data = dict(sys_config = conf[-1],
f_system_identifier_string = _sysid()))
File "applications/sunrex/modules/fls_data_handler.py", line 134, in
_sysid
sysid =
db(db.t_sys_config).select(db.t_sys_config.f_system_identifier_string).last()
['f_system_identifier_string']
File "/home/solarmax/web2py/gluon/dal.py", line 5394, in select
return self.db._adapter.select(self.query,fields,attributes)
File "/home/solarmax/web2py/gluon/dal.py", line 1176, in select
rows = response(sql)
File "/home/solarmax/web2py/gluon/dal.py", line 1166, in response
self.execute(sql)
File "/home/solarmax/web2py/gluon/dal.py", line 1251, in execute
return self.log_execute(*a, **b)
File "/home/solarmax/web2py/gluon/dal.py", line 1246, in log_execute
ret = self.cursor.execute(*a,**b)
DatabaseError: file is encrypted or is not a database
