3.实际上你得到的结果是什么？
Traceback (most recent call last):
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1122, in _do_get
return self._pool.get(wait, self._timeout)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/queue.py", line 145, in get
raise Empty
sqlalchemy.util.queue.Empty
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2147, in _wrap_pool_connect
return fn()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 387, in connect
return _ConnectionFairy._checkout(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 766, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 516, in checkout
rec = pool._do_get()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1138, in _do_get
self._dec_overflow()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1135, in _do_get
return self._create_connection()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 333, in _create_connection
return _ConnectionRecord(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 461, in init
self.connect(first_connect_check=True)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 651, in connect
connection = pool._invoke_creator(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 105, in connect
return dialect.connect(*cargs, cparams)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 393, in connect
return self.dbapi.connect(*cargs, *cparams)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/init.py", line 90, in Connect
return Connection(args, kwargs)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 706, in init
self.connect()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 932, in connect
self._request_authentication()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1152, in _request_authentication
auth_packet = self._read_packet()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1014, in _read_packet
packet.check_error()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "config/create_all.py", line 16, in
create_all_table()
File "config/create_all.py", line 12, in create_all_table
metadata.create_all()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/sql/schema.py", line 3949, in create_all
tables=tables)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1928, in _run_visitor
with self._optional_conn_ctx_manager(connection) as conn:
File "/usr/lib/python3.6/contextlib.py", line 81, in enter
return next(self.gen)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1921, in _optional_conn_ctx_manager
with self.contextual_connect() as conn:
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2112, in contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2151, in _wrap_pool_connect
e, dialect, self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1465, in _handle_dbapi_exception_noconnection
exc_info
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2147, in _wrap_pool_connect
return fn()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 387, in connect
return _ConnectionFairy._checkout(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 766, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 516, in checkout
rec = pool._do_get()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1138, in _do_get
self._dec_overflow()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1135, in _do_get
return self._create_connection()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 333, in _create_connection
return _ConnectionRecord(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 461, in init
self.connect(first_connect_check=True)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 651, in connect
connection = pool._invoke_creator(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 105, in connect
return dialect.connect(*cargs, cparams)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 393, in connect
return self.dbapi.connect(*cargs, *cparams)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/init.py", line 90, in Connect
return Connection(args, kwargs)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 706, in init
self.connect()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 932, in connect
self._request_authentication()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1152, in _request_authentication
auth_packet = self._read_packet()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1014, in _read_packet
packet.check_error()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
在提交Issue之前请先回答下面问题，谢谢！
1.你是怎么操作的？ python3 config/create_all.py
尽量把你的操作过程描述清楚，最好能够复现问题。
2.你期望的结果是什么？ 制表
3.实际上你得到的结果是什么？ Traceback (most recent call last): File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1122, in _do_get return self._pool.get(wait, self._timeout) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/queue.py", line 145, in get raise Empty sqlalchemy.util.queue.Empty
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2147, in _wrap_pool_connect return fn() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 387, in connect return _ConnectionFairy._checkout(self) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 766, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 516, in checkout rec = pool._do_get() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1138, in _do_get self._dec_overflow() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit compat.reraise(exc_type, exc_value, exc_tb) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise raise value File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1135, in _do_get return self._create_connection() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 333, in _create_connection return _ConnectionRecord(self) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 461, in init self.connect(first_connect_check=True) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 651, in connect connection = pool._invoke_creator(self) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 105, in connect return dialect.connect(*cargs, cparams) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 393, in connect return self.dbapi.connect(*cargs, *cparams) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/init.py", line 90, in Connect return Connection(args, kwargs) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 706, in init self.connect() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 932, in connect self._request_authentication() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1152, in _request_authentication auth_packet = self._read_packet() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1014, in _read_packet packet.check_error() File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 393, in check_error err.raise_mysql_exception(self._data) File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last): File "config/create_all.py", line 16, in
create_all_table()
File "config/create_all.py", line 12, in create_all_table
metadata.create_all()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/sql/schema.py", line 3949, in create_all
tables=tables)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1928, in _run_visitor
with self._optional_conn_ctx_manager(connection) as conn:
File "/usr/lib/python3.6/contextlib.py", line 81, in enter
return next(self.gen)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1921, in _optional_conn_ctx_manager
with self.contextual_connect() as conn:
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2112, in contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2151, in _wrap_pool_connect
e, dialect, self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1465, in _handle_dbapi_exception_noconnection
exc_info
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2147, in _wrap_pool_connect
return fn()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 387, in connect
return _ConnectionFairy._checkout(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 766, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 516, in checkout
rec = pool._do_get()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1138, in _do_get
self._dec_overflow()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1135, in _do_get
return self._create_connection()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 333, in _create_connection
return _ConnectionRecord(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 461, in init
self.connect(first_connect_check=True)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/pool.py", line 651, in connect
connection = pool._invoke_creator(self)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 105, in connect
return dialect.connect(*cargs, cparams)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 393, in connect
return self.dbapi.connect(*cargs, *cparams)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/init.py", line 90, in Connect
return Connection(args, kwargs)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 706, in init
self.connect()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 932, in connect
self._request_authentication()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1152, in _request_authentication
auth_packet = self._read_packet()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 1014, in _read_packet
packet.check_error()
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/home/wentao/programming/weibospider/.env/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
4.你使用的是哪个版本的WeiboSpider? 你的操作系统是什么？是否有读本项目的[常见问题]
master，ubuntu18.04，读了
(https://github.com/SpiderClub/weibospider/wiki/%E9%A1%B9%E7%9B%AE%E4%BD%BF%E7%94%A8%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98)？