search

DormyMo / SpiderKeeper

admin ui for scrapy/open source scrapinghub
http://sk.7mdm.com:5000/
2.74k stars 508 forks source link

sqlalchemy.exc.OperationalError #15

Closed seozed closed 7 years ago

seozed commented 7 years ago 
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 commented 7 years ago

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

pip uninstall spiderkeeper pip install spiderkeeper

seozed commented 7 years ago 
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 commented 7 years ago

修复了 ，再重装就可以

seozed commented 7 years ago

解决了 good job!

From: modm Date: 2017-04-18 10:20 To: DormyMo/SpiderKeeper CC: seozed; Author Subject: Re: [DormyMo/SpiderKeeper] sqlalchemy.exc.OperationalError (#15) 修复了 ，再重装就可以 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.