(dp1 S'output' p2 S" database is locked" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py' p5 sS'code' p6 S' at 0x7f190a7a8430, file "/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py", line 1>' p7 sS'snapshot' p8 (dp9 S'exception' p10 (dp11 S'__module__' p12 S"'sqlite3'" p13 sS'__getslice__' p14 S"" p15 sS'__str__' p16 S"" p17 sS'__reduce__' p18 S'' p19 sS'__dict__' p20 S'{}' p21 sS'__sizeof__' p22 S'' p23 sS'__weakref__' p24 S'None' p25 sS'message' p26 S"'database is locked'" p27 sS'__init__' p28 S"" p29 sS'__setattr__' p30 S"" p31 sS'__reduce_ex__' p32 S'' p33 sS'__new__' p34 S'' p35 sS'__format__' p36 S'' p37 sS'__class__' p38 S"" p39 sS'__doc__' p40 S'None' p41 sS'__getitem__' p42 S"" p43 sS'__setstate__' p44 S'' p45 sS'__getattribute__' p46 S"" p47 sS'args' p48 S"('database is locked',)" p49 sS'__subclasshook__' p50 S'' p51 sS'__unicode__' p52 S'' p53 sS'__delattr__' p54 S"" p55 sS'__repr__' p56 S"" p57 sS'__hash__' p58 S"" p59 ssS'evalue' p60 S'database is locked' p61 sS'request' p62 cgluon.html XML_unpickle p63 (S's`\\\x00\x00
ajax:
False
application:
HLD
args:
cid:
None
client:
127.0.0.1
controller:
default
cookies:
session_id_admin:
127.0.0.1-2d0c1c6c-dcb3-4443-b1b3-fa032509dc6a
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_hld:
127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_welcome:
127.0.0.1-ac132756-0bb0-401d-a583-5ff90dff4a86
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
env:
HTTP_ACCEPT:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING:
gzip, deflate
HTTP_ACCEPT_LANGUAGE:
en-US,en;q=0.5
HTTP_CONNECTION:
keep-alive
HTTP_COOKIE:
session_id_welcome=127.0.0.1-ac132756-0bb0-401d-a583-5ff90dff4a86; session_id_admin=127.0.0.1-2d0c1c6c-dcb3-4443-b1b3-fa032509dc6a; session_id_hld=127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
HTTP_HOST:
127.0.0.1:8000
HTTP_UPGRADE_INSECURE_REQUESTS:
1
HTTP_USER_AGENT:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
PATH_INFO:
/HLD/default/
QUERY_STRING:
REMOTE_ADDR:
127.0.0.1
REMOTE_PORT:
33348
REQUEST_METHOD:
GET
SCRIPT_NAME:
SERVER_NAME:
Omen
SERVER_PORT:
8000
SERVER_PROTOCOL:
HTTP/1.1
SERVER_SOFTWARE:
Rocket 1.2.6
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin', '/home/jdalbey/Dropbox/web2py/applications/HLD'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f193b7ed9b0: {'verbose': False, 'ip': '127.0.0.1', 'debuglevel': 30, 'with_scheduler': False, 'shutdown_timeout': 5, 'taskbar': False, 'with_coverage': False, 'pid_filename': 'httpserver.pid', 'maxthreads': None, 'softcron': False, 'server_name': 'Omen', 'bpython': False, 'nogui': False, 'port': 8000, 'print_errors': False, 'extcron': False, 'runcron': False, 'run_system_tests': False, 'test': None, 'folder': '/home/jdalbey/Dropbox/web2py', 'config': '', 'minthreads': None, 'shell': None, 'run': '', 'log_filename': 'httpserver.log', 'profiler_dir': None, 'args': [], 'socket_timeout': 5, 'ssl_ca_certificate': None, 'scheduler': None, 'interfaces': None, 'ssl_private_key': '', 'gae': None, 'password': '******', 'request_queue_size': 5, 'ssl_certificate': '', 'cronjob': False, 'numthreads': None, 'quiet': False, 'import_models': False, 'timeout': 10, 'plain': False, 'nobanner': False}>
db_sessions:
set([])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
http_accept:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
http_accept_encoding:
gzip, deflate
http_accept_language:
en-US,en;q=0.5
http_connection:
keep-alive
http_cookie:
session_id_welcome=127.0.0.1-ac132756-0bb0-401d-a583-5ff90dff4a86; session_id_admin=127.0.0.1-2d0c1c6c-dcb3-4443-b1b3-fa032509dc6a; session_id_hld=127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
http_host:
127.0.0.1:8000
http_upgrade_insecure_requests:
1
http_user_agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
is_jython:
False
is_py2:
True
is_pypy:
False
is_source:
True
local_hosts:
::1
127.0.1.1
::ffff:127.0.0.1
127.0.0.1
Omen
path_info:
/HLD/default/
query_string:
remote_addr:
127.0.0.1
remote_port:
33348
request_method:
GET
request_uri:
/HLD/default/
script_name:
server_name:
Omen
server_port:
8000
server_protocol:
HTTP/1.1
server_software:
Rocket 1.2.6
web2py_path:
/home/jdalbey/Dropbox/web2py
web2py_version:
2.18.5-stable+timestamp.2019.04.08.04.22.03
wsgi.errors:
<open file '<stderr>', mode 'w' at 0x7f1942869270>
wsgi.file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f193b823980>
wsgi.input:
<socket._fileobject object at 0x7f1909777350>
wsgi.multiprocess:
False
wsgi.multithread:
True
wsgi.run_once:
False
wsgi.url_scheme:
http
wsgi.version:
1
0
wsgi_errors:
<open file '<stderr>', mode 'w' at 0x7f1942869270>
wsgi_file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f193b823980>
wsgi_input:
<socket._fileobject object at 0x7f1909777350>
wsgi_multiprocess:
False
wsgi_multithread:
True
wsgi_run_once:
False
wsgi_url_scheme:
http
wsgi_version:
1
0
extension:
html
folder:
/home/jdalbey/Dropbox/web2py/applications/HLD
function:
index
global_settings:
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin', '/home/jdalbey/Dropbox/web2py/applications/HLD'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f193b7ed9b0: {'verbose': False, 'ip': '127.0.0.1', 'debuglevel': 30, 'with_scheduler': False, 'shutdown_timeout': 5, 'taskbar': False, 'with_coverage': False, 'pid_filename': 'httpserver.pid', 'maxthreads': None, 'softcron': False, 'server_name': 'Omen', 'bpython': False, 'nogui': False, 'port': 8000, 'print_errors': False, 'extcron': False, 'runcron': False, 'run_system_tests': False, 'test': None, 'folder': '/home/jdalbey/Dropbox/web2py', 'config': '', 'minthreads': None, 'shell': None, 'run': '', 'log_filename': 'httpserver.log', 'profiler_dir': None, 'args': [], 'socket_timeout': 5, 'ssl_ca_certificate': None, 'scheduler': None, 'interfaces': None, 'ssl_private_key': '', 'gae': None, 'password': '******', 'request_queue_size': 5, 'ssl_certificate': '', 'cronjob': False, 'numthreads': None, 'quiet': False, 'import_models': False, 'timeout': 10, 'plain': False, 'nobanner': False}>
db_sessions:
set([])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
is_jython:
False
is_py2:
True
is_pypy:
False
is_source:
True
local_hosts:
::1
127.0.1.1
::ffff:127.0.0.1
127.0.0.1
Omen
web2py_version:
2.18.5-stable+timestamp.2019.04.08.04.22.03
is_https:
False
is_local:
True
is_restful:
False
is_scheduler:
False
is_shell:
False
method:
GET
now:
datetime.datetime(2020, 3, 15, 18, 57, 33, 755544)
raw_args:
raw_extension:
None
url:
/HLD/default/
utcnow:
datetime.datetime(2020, 3, 16, 1, 57, 33, 755574)
wsgi:
<gluon.main.LazyWSGI object at 0x7f190a2cdc90>
' tRp64 sS'frames' p65 (lp66 (dp67 S'file' p68 S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py' p69 sS'dump' p70 (dp71 S'environment' p72 S"{'A': , 'ANY_OF': , 'ASSIGNJS': , 'B': , 'BEAUTIFY': , 'BODY': , 'BR': , 'BUTTON': , 'CAT': , 'CENTER': , ...}" p73 sS'ccode' p74 S' at 0x7f190a7a8430, file "/...ox/web2py/applications/HLD/models/db.py", line 1>' p75 ssS'lnum' p76 I219 sS'lines' p77 (dp78 I214 S' if environment is None:' p79 sI215 S' environment = {}' p80 sI216 S" environment['__file__'] = layer" p81 sI217 S" environment['__name__'] = '__restricted__'" p82 sI218 S' try:' p83 sI219 S' exec(ccode, environment)' p84 sI220 S' except HTTP:' p85 sI221 S' raise' p86 sI222 S' except RestrictedError:' p87 sI223 S' # do not encapsulate (obfuscate) the original RestrictedError' p88 ssS'call' p89 S'(ccode= at 0x7f190a7a8430, file "/...ox/web2py/applications/HLD/models/db.py", line 1>, environment={\'A\': , \'ANY_OF\': , \'ASSIGNJS\': , \'B\': , \'BEAUTIFY\': , \'BODY\': , \'BR\': , \'BUTTON\': , \'CAT\': , \'CENTER\': , ...}, layer=\'/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py\', scode= at 0x7f190a7a8430, file "/...ox/web2py/applications/HLD/models/db.py", line 1>)' p90 sS'func' p91 S'restricted' p92 sa(dp93 g68 S'/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py' p94 sg70 (dp95 S'builtinopen' p96 S'' p97 sS'db.supervisors' p98 S'' p99 sS'db' p100 S'' p101 sS'db.supervisors.import_from_csv_file' p102 S'>' p103 ssg76 I57 sg77 (dp104 I48 S'db.closures.endlocation.requires = IS_NOT_EMPTY()' p105 sI49 S'db.closures.closuretype.requires = IS_NOT_EMPTY()' p106 sI50 S'db.closures.worktype.requires = IS_NOT_EMPTY()' p107 sI51 S'db.closures.supervisor.requires = IS_NOT_EMPTY()' p108 sI52 S'' sI53 S"db.define_table('supervisors'," p109 sI54 S" Field('name')," p110 sI55 S" Field('radiocallnum')\\" p111 sI56 S' )' p112 sI57 S"db.supervisors.import_from_csv_file(open('supervisors.csv', 'r'))" p113 ssg89 S'()' p114 sg91 S'' p115 sa(dp116 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py' p117 sg70 (dp118 S'inserting' p119 S'>' p120 sS'new_id' p121 S'undefined' p122 sS'ditems' p123 S"{'name': u'Joe', 'radiocallnum': u'31-30'}" p124 ssg76 I1029 sg77 (dp125 I1024 S' self._db(getattr(self, cid) == curr_id).delete()' p126 sI1025 S' curr_id = inserting(**ditems)' p127 sI1026 S" # Validation. Check for duplicate of 'unique' &," p128 sI1027 S' # if present, update instead of insert.' p129 sI1028 S' elif not unique_idx:' p130 sI1029 S' new_id = inserting(**ditems)' p131 sI1030 S' else:' p132 sI1031 S' unique_value = line[unique_idx]' p133 sI1032 S' query = getattr(self, unique) == unique_value' p134 sI1033 S' record = self._db(query).select().first()' p135 ssg89 S"(self=
, csvfile=, id_map=None, null='', unique='uuid', id_offset=None, transform=None, validate=False, encoding='utf-8', **kwargs={})" p136 sg91 S'import_from_csv_file' p137 sa(dp138 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py' p139 sg70 (dp140 S'self' p141 S'
' p142 sS'ret' p143 g122 sS'row.op_values' p144 S">" p145 sS'self._db._adapter' p146 S'' p147 sS'self._db._adapter.insert' p148 S'>' p149 sS'self._db' p150 S'' p151 sS'row' p152 S"" p153 ssg76 I762 sg77 (dp154 I757 S'' sI758 S' def insert(self, **fields):' p155 sI759 S' row = self._fields_and_values_for_insert(fields)' p156 sI760 S' if any(f(row) for f in self._before_insert):' p157 sI761 S' return 0' p158 sI762 S' ret = self._db._adapter.insert(self, row.op_values())' p159 sI763 S' if ret and self._after_insert:' p160 sI764 S' for f in self._after_insert:' p161 sI765 S' f(row, ret)' p162 sI766 S' return ret' p163 ssg89 S"(self=
, **fields={'name': u'Joe', 'radiocallnum': u'31-30'})" p164 sg91 S'insert' p165 sa(dp166 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p167 sg70 (dp168 S'e' S"OperationalError('database is locked',)" p169 ssg76 I487 sg77 (dp170 I482 S' self.execute(query)' p171 sI483 S' except:' p172 sI484 S' e = sys.exc_info()[1]' p173 sI485 S" if hasattr(table, '_on_insert_error'):" p174 sI486 S' return table._on_insert_error(table, fields, e)' p175 sI487 S' raise e' p176 sI488 S" if hasattr(table, '_primarykey'):" p177 sI489 S' pkdict = dict([' p178 sI490 S' (k[0].name, k[1]) for k in fields' p179 sI491 S' if k[0].name in table._primarykey])' p180 ssg89 S"(self=, table=
, fields=[(, u'Joe'), (, u'31-30')])" p181 sg91 g165 sasS'pyver' p182 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p183 sS'session' p184 g63 (S's\x1c\x05\x00\x00
closureid:
direction:
enddate:
flash:
None
last_orderby:
None
last_query:
with open('snoopy.csv', 'wb') as dumpfile: dumpfile.write(str(db(db.closures).select()))
lognum:
route:
5
startdate:
' tRp185 sS'etype' p186 S"" p187 sS'date' p188 S'Sun Mar 15 18:57:38 2020' p189 sS'response' p190 g63 (S's\xda\x17\x00\x00
body:
<cStringIO.StringO object at 0x7f19098f21f0>
cookies:
session_id_hld:
127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
comment:
domain:
expires:
httponly:
max-age:
path:
/
samesite:
secure:
version:
delimiters:
{{
}}
files:
flash:
form_label_separator:
:
formstyle:
table3cols
generic_patterns:
*
headers:
X-Powered-By:
web2py
menu:
meta:
models_to_run:
^\\w+\\.py$
^default/\\w+\\.py$
^default/index/\\w+\\.py$
postprocessing:
session_client:
127.0.0.1
session_cookie_compression_level:
None
session_cookie_expires:
None
session_data_name:
session_data_hld
session_file:
<open file '/home/jdalbey/Dropbox/web2py/applications/HLD/sessions/1db/0eb/127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc', mode 'rb+' at 0x7f190996de40>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/HLD/sessions/127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
session_hash:
e830b69dd346da54fe16bc2e4bc4d971
session_id:
127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
session_id_name:
session_id_hld
session_locked:
True
session_masterapp:
HLD
session_new:
False
session_storage_type:
file
status:
200
view:
default/index.html
' tRp191 sS'locals' p192 (dp193 S'fields' p194 S"[(, u'Joe'), (, u'31-30')]" p195 sS'self' p196 S'' p197 sS'e' S"OperationalError('database is locked',)" p198 sS'table' p199 S'' p200 sS'query' p201 S'\'INSERT INTO "supervisors"("name","radiocallnum") VALUES (\\\'Joe\\\',\\\'31-30\\\');\'' p202 sssS'traceback' p203 S'Traceback (most recent call last):\n File "/home/jdalbey/Dropbox/web2py/gluon/restricted.py", line 219, in restricted\n exec(ccode, environment)\n File "/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py", line 57, in \n db.supervisors.import_from_csv_file(open(\'supervisors.csv\', \'r\'))\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py", line 1029, in import_from_csv_file\n new_id = inserting(**ditems)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py", line 762, in insert\n ret = self._db._adapter.insert(self, row.op_values())\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 487, in insert\n raise e\nOperationalError: database is locked\n' p204 s.