'NoneType' object has no attribute 'scalar' #389

JackeyLov5 · 2024-07-08T05:33:21Z

是否使用了最新代码
是或否（如果不是的话尝试克隆最新的代码再跑一下！）

Bug描述
'NoneType' object has no attribute 'scalar'

sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 123150260609024 and this is thread id 123149589028864.

urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='1ec687a4db284800.static-cloudflareinsights-com-s.webvpn.gnnu.edu.cn', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x109f382e0>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known'))

urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPSConnection object at 0x109f382e0>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known

运行环境

系统：Macos（必写）
Python版本：3.9（必写）
OneForAll版本：0.4.5（必写）

如何复现
python3 oneforall.py --targets ./domains.txt run

domains.txt 内容为：
gnnu.edu.cn
gnnu.cn

复现命令（必写）
python3 oneforall.py --targets ./domains.txt run
Request Progress: 9%|█▉ | 270/2854 [00:00<00:05, 476.78it/s]12:33:05,668 [ERROR] database:40 - ('(sqlite3.OperationalError) unable to open database file',)
Exception in thread SaveThread:
Traceback (most recent call last):
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
sqlite3.OperationalError: no such table: gnnu_edu_cn

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/python3.9/threading.py", line 973, in _bootstrap_inner
File "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/python3.9/threading.py", line 910, in run
File "/Users/ookk/Desktop/tools/信息收集/OneForAll/common/request.py", line 209, in save
db.insert_table(name, new_info)
File "/Users/ookk/Desktop/tools/信息收集/OneForAll/common/database.py", line 91, in insert_table
File "/Users/ookk/Desktop/tools/信息收集/OneForAll/common/records.py", line 335, in query
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/base.py", line 1510, in handle_dbapi_exception
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/util/compat.py", line 182, in raise
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: gnnu_edu_cn
[SQL: insert into "gnnu_edu_cn" (id, alive, resolve, request, url, subdomain, port, level,cname, ip, public, cdn, status, reason, title, banner, header,history, response, ip_times, cname_times, ttl, cidr, asn, org,addr, isp, resolver, module, source, elapse, find) values (?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?)]
[parameters: (None, 0, 1, 0, 'https://dmt.gnnu.edu.cn', 'dmt.gnnu.edu.cn', 443, 1, 'dmt.gnnu.edu.cn', '218.64.216.247', None, None, None, '(MaxRetryError("HTTPSConnectionPool(host='dmt.gnnu.edu.cn', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x109774d60>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known'))"),)', None, None, None, None, None, None, None, '3600', None, None, None, None, None, '1.0.0.19:53', 'Dataset', 'SecurityTrailsAPIQuery', 2.1, 150)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Request Progress: 22%|████▌ | 617/2854 [00:03<00:16, 135.04it/s]Exception during reset or similar
Traceback (most recent call last):
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/urllib3/connection.py", line 174, in _new_conn
conn = connection.create_connection(
File "/Users/ookk/Library/Python/3.9/lib/python/site-packages/urllib3/util/connection.py", line 72, in create_connection
for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
File "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/python3.9/socket.py", line 953, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 8] nodename nor servname provided, or not known