Skip to content

Instantly share code, notes, and snippets.

@ademola25
Created August 25, 2018 06:53
Show Gist options
  • Select an option

  • Save ademola25/bbc41b3d61c205e6fd413617aaac86bd to your computer and use it in GitHub Desktop.

Select an option

Save ademola25/bbc41b3d61c205e6fd413617aaac86bd to your computer and use it in GitHub Desktop.
can not write in a read only file
Traceback (most recent call last):
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: attempt to write a readonly database
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "lotsofspaitem.py", line 11, in <module>
Base.metadata.drop_all(engine)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/sql/schema.py", line 4032, in drop_all
tables=tables)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/sql/ddl.py", line 906, in visit_metadata
table, drop_ok=True, _is_metadata_operation=True)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/sql/ddl.py", line 951, in visit_table
self.connection.execute(DropTable(table))
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
raise value.with_traceback(tb)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/var/www/catalog/venv/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) attempt to write a readonly database [SQL: '\nDROP TABLE spa_item'] (Background on this error at: http://sqlalche.me/e/e3q8)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment