search

bslatkin / dpxdt

Make continuous deployment safe by comparing before and after webpage screenshots for each release. Depicted shows when any visual, perceptual differences are found. This is the ultimate, automated end-to-end test.
https://dpxdt-test.appspot.com
Apache License 2.0
1.44k stars 124 forks source link

Table not found after restarting - Sqlalchemy error #69

Closed itoufexi closed 10 years ago

itoufexi commented 10 years ago

Hi,

When I killed the process and ran it again it worked ok.

But when I restarted the computer, ran the worker and browsed http://localhost:5000/ I got this error on screen

sqlalchemy.exc.OperationalError

Traceback (most recent call last): File "/home/toufexii/dpxdt/dependencies/flask/flask/app.py", line 1823, in call return self.wsgi_app(environ, start_response) File "/home/toufexii/dpxdt/dependencies/flask/flask/app.py", line 1811, in wsgi_app response = self.make_response(self.handle_exception(e)) File "/home/toufexii/dpxdt/dependencies/flask/flask/app.py", line 1809, in wsgi_app response = self.full_dispatch_request() File "/home/toufexii/dpxdt/dependencies/flask/flask/app.py", line 1482, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/toufexii/dpxdt/dependencies/flask/flask/app.py", line 1480, in full_dispatch_request rv = self.dispatch_request() File "/home/toufexii/dpxdt/dependencies/flask/flask/app.py", line 1466, in dispatch_request return self.view_functionsrule.endpoint File "/home/toufexii/dpxdt/dpxdt/server/frontend.py", line 51, in homepage build_list = operations.UserOps(current_user.get_id()).get_builds() File "/home/toufexii/dpxdt/dependencies/flask-cache/flask_cache/init.py", line 513, in decorated_function rv = f(_args, *_kwargs) File "/home/toufexii/dpxdt/dpxdt/server/operations.py", line 67, in get_builds .limit(1000) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/orm/query.py", line 2237, in all return list(self) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/orm/query.py", line 2349, in iter return self._execute_and_instances(context) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/orm/query.py", line 2364, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/engine/base.py", line 662, in execute params) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/engine/base.py", line 763, in _execute_clauseelement compiled_sql, distilled_params File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/engine/base.py", line 876, in _execute_context context) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/engine/base.py", line 1020, in _handle_dbapi_exception exc_info File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/engine/base.py", line 869, in _execute_context context) File "/home/toufexii/dpxdt/dependencies/sqlalchemy/lib/sqlalchemy/engine/default.py", line 326, in do_execute cursor.execute(statement, parameters)

OperationalError: (OperationalError) no such table: build u'SELECT build.id AS build_id, build.created AS build_created, build.modified AS build_modified, build.name AS build_name, build.public AS build_public, build.send_email AS build_send_email, build.email_alias AS build_email_alias \nFROM build \nWHERE build.public = 1 ORDER BY build.created DESC\n LIMIT ? OFFSET ?' (1000, 0)

There is no way to make it work, only delete the project and clone it from scratch.

I could not find someone having the exact same problem. Any help welcome please.

itoufexi commented 10 years ago

Sqlite was being stored in the tmp directory. I changed the path in config.py file.