whoami@blackman:~/spider$ spiderkeeper --server=http://localhost:6800
/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/__init__.py:9: ExtDeprecationWarning: Importing flask.ext.restful is deprecated, use flask_restful instead.
from flask.ext.restful import Api
/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/__init__.py:10: ExtDeprecationWarning: Importing flask.ext.restful_swagger is deprecated, use flask_restful_swagger instead.
from flask.ext.restful_swagger import swagger
/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/flask_sqlalchemy/__init__.py:839: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/flask_sqlalchemy/__init__.py:839: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
--------------------------------------------------------------------------------
INFO in run [/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/run.py:19]:
SpiderKeeper startd on 0.0.0.0:5000 with scrapyd servers:http://localhost:6800
--------------------------------------------------------------------------------
2017-04-17 18:25:01,071 - SpiderKeeper.app - INFO - SpiderKeeper startd on 0.0.0.0:5000 with scrapyd servers:http://localhost:6800
Job "sync_job_execution_status_job (trigger: interval[0:00:03], next run at: 2017-04-17 18:25:07 CST)" raised an exception
Traceback (most recent call last):
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: sk_project
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/apscheduler/executors/base.py", line 125, in run_job
retval = job.func(*job.args, **job.kwargs)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/schedulers/common.py", line 14, in sync_job_execution_status_job
for project in Project.query.all():
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2703, in all
return list(self)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: sk_project [SQL: 'SELECT sk_project.id AS sk_project_id, sk_project.date_created AS sk_project_date_created, sk_project.date_modified AS sk_project_date_modified, sk_project.project_name AS sk_project_project_name \nFROM sk_project']
Job "sync_job_execution_status_job (trigger: interval[0:00:03], next run at: 2017-04-17 18:25:10 CST)" raised an exception
Traceback (most recent call last):
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: sk_project
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/apscheduler/executors/base.py", line 125, in run_job
retval = job.func(*job.args, **job.kwargs)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/schedulers/common.py", line 14, in sync_job_execution_status_job
for project in Project.query.all():
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2703, in all
return list(self)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: sk_project [SQL: 'SELECT sk_project.id AS sk_project_id, sk_project.date_created AS sk_project_date_created, sk_project.date_modified AS sk_project_date_modified, sk_project.project_name AS sk_project_project_name \nFROM sk_project']
^Cwhoami@blackman:~/spider$