Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sqlalchemy.exc.OperationalError #15

Closed
seozed opened this issue Apr 17, 2017 · 4 comments
Closed

sqlalchemy.exc.OperationalError #15

seozed opened this issue Apr 17, 2017 · 4 comments

Comments

@seozed
Copy link

seozed commented Apr 17, 2017 

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$

好像是建表错误？
@DormyMo
Copy link
Owner

DormyMo commented Apr 17, 2017

重新安装一下 ，旧版本有这问题

pip uninstall spiderkeeper
pip install spiderkeeper

@seozed
Copy link
Author

seozed commented Apr 18, 2017 

whoami@blackman:~/spider$ pip uninstall spiderkeeper
Uninstalling SpiderKeeper-1.0.3:
  /home/whoami/.pyenv/versions/3.5.1/bin/spiderkeeper
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper-1.0.3-py3.5.egg-info
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/__pycache__/config.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/__pycache__/run.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/__pycache__/spiderctrl.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/contrib/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/contrib/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/contrib/__pycache__/scrapy.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/contrib/scrapy.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/proxy/spiderctrl.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/schedulers/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/schedulers/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/schedulers/__pycache__/common.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/schedulers/common.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/spider/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/spider/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/spider/__pycache__/controller.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/spider/__pycache__/model.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/spider/controller.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/spider/model.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/AdminLTE.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/alt/AdminLTE-without-plugins.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/app.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/bootstrap.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/bootstrap.min.css.map
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/font-awesome.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/ionicons.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/skins/_all-skins.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/css/skins/skin-black-light.min.css
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/FontAwesome.otf
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.eot
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.svg
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.ttf
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.woff
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.ttf
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.woff
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.woff2
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.woff
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.woff2
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.eot
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/fontawesome-webfont.woff2
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.eot
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.svg
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.ttf
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.svg
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.ttf
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.woff
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/glyphicons-halflings-regular.woff2
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/ionicons.eot
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/ionicons.svg
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/ionicons.ttf
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/fonts/ionicons.woff
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/AdminLTE.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/Chart.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/bootstrap.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/demo.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/fastclick.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/html5shiv.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/jquery-2.2.3.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/jquery.slimscroll.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/pages/base.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/static/js/respond.min.js
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/base.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/job_dashboard.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/job_log.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/job_periodic.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/project_manage.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/project_stats.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/server_stats.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/spider_dashboard.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/templates/spider_deploy.html
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/util/__init__.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/util/__pycache__/__init__.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/util/__pycache__/http.cpython-35.pyc
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/app/util/http.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/config.py
  /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages/SpiderKeeper/run.py
Proceed (y/n)? y
  Successfully uninstalled SpiderKeeper-1.0.3
whoami@blackman:~/spider$ vi ~/.pip/pip.
whoami@blackman:~/spider$ vi ~/.pip/pip.ini
whoami@blackman:~/spider$ vi ~/.pip/pip.ini
whoami@blackman:~/spider$ sudo vi ~/.pip/pip.ini
[sudo] password for whoami:
whoami@blackman:~/spider$ pip install spiderkeeper
Collecting spiderkeeper
  Using cached SpiderKeeper-1.0.3.2.tar.gz
Requirement already satisfied: APScheduler==3.3.1 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: Flask==0.12.1 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: Flask-RESTful==0.3.5 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: flask-restful-swagger==0.19 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: Flask-SQLAlchemy==2.2 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: PyMySQL==0.7.11 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: requests==2.13.0 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: aniso8601==1.2.0 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: click==6.7 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: itsdangerous==0.24 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: Jinja2==2.9.6 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: MarkupSafe==1.0 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: python-dateutil==2.6.0 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: pytz==2017.2 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: six==1.10.0 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: SQLAlchemy==1.1.9 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: tzlocal==1.3 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: Werkzeug==0.12.1 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from spiderkeeper)
Requirement already satisfied: setuptools>=0.7 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from APScheduler==3.3.1->spiderkeeper)
Requirement already satisfied: packaging>=16.8 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from setuptools>=0.7->APScheduler==3.3.1->spiderkeeper)
Requirement already satisfied: appdirs>=1.4.0 in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from setuptools>=0.7->APScheduler==3.3.1->spiderkeeper)
Requirement already satisfied: pyparsing in /home/whoami/.pyenv/versions/3.5.1/lib/python3.5/site-packages (from packaging>=16.8->setuptools>=0.7->APScheduler==3.3.1->spiderkeeper)
Installing collected packages: spiderkeeper
  Running setup.py install for spiderkeeper ... done
Successfully installed spiderkeeper-1.0.3
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-18 08:51:58,574 - 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-18 08:52:04 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-18 08:52: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']

安装了1.0.3.2的问题依旧
系统：ubuntu 16.04 64bit
python 3.5.1

@DormyMo
Copy link
Owner

DormyMo commented Apr 18, 2017

修复了 ，再重装就可以

@seozed
Copy link
Author

seozed commented Apr 18, 2017 via email

@DormyMo DormyMo closed this as completed Apr 18, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@DormyMo @seozed