superset0.34，报错flask_appbuilder.security.sqla.manager:DB Creation and initialization failed

最新推荐文章于 2025-10-13 19:51:25 发布
原创 最新推荐文章于 2025-10-13 19:51:25 发布 · 5.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

在使用Superset 0.34时遇到数据库创建初始化失败的问题，错误提示为'sqlite3.DatabaseError'，文件不是数据库。解决方案是删除现有的superset.db文件并重新运行项目，但这会导致所有数据丢失，包括图表和配置。删除后需重新创建管理员账号、数据库和加载实例。执行后，系统会生成新的superset.db文件。

前提条件：我的superset0.34之前安装好的，也可以正常执行，今天打开以后，先起了flask的项目，虽然flask是superset的底层，但是我改的东西是自己项目里面的，跟虚拟环境里面的superset没关系。然后我打开过superset.db文件，但是我记得也没干啥，人家的东西，不敢乱动。

反正就是superset.db的毛病，不清楚原因。这个文件在之前安装superset的时候，加载实例的时候会有显示。

错误如图：

flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (sqlite3.DatabaseError) file is not a database

 

修改方法：找到自己的superset.db文件，删除重新运行项目。我的默认在这个地方，不知道为啥在这

关于删除：删掉以后，就是相当于重新建立数据库，之前的都不好使的，之前的账号密码，画的图就全部没有了。

谨慎删除。要是没啥东西删除以后，重新建立管理员账号，重新建立数据库，重新加载实例，重新安装前台

----------------------------------------------------------------------------------------------------------------------------------------------------

反正我的，删了啥都没了，我画了好几天的图呐，啊啊啊啊啊啊啊啊啊啊啊啊

重新run以后，如图：

这时候再查看C:\Users\Administrator\.superset文件夹，下面有个新建的superset.db

 

结束（要是不好用，我也不知道怎么办了，我也不知道我干了啥，它就坏了）

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

我啥也不知道，啥也不明白，日常坑多多。。。。。。。。。。。。。。。

 

初始化Superset数据库superset db upgrade报错的记录
zxctime的博客
03-15 1058
初始化superset数据库报错的解决方法
django连接mysql出现MySQLdb._exceptions.OperationalError
virusss的博客
06-23 1028
遇到问题 django连接mysql时，出现MySQLdb._exceptions.OperationalError导致连接不上，出现该问题的原因是mysql8.0对用户密码的加密方式为caching_sha2_password, MySQLdb版本暂不支持这种新增的加密方式，只需要将用户加密方式改为旧版加密方式即可。 解决方法 登录mysql 选择mysql自带的数据库，并且查看加密的方式是不是 caching_sha2_password 修改为旧版的加密方式 更新配置 重启Pycharm后，执
superset二次开发
weixin_44825621的博客
10-13 900
Superset二次开发环境搭建与配置 本文介绍了开源数据可视化平台Superset的二次开发环境部署流程。主要内容包括： 开发环境准备：创建Python虚拟环境，安装系统依赖，克隆Superset源码并编译安装。 前后端启动： 后端：初始化数据库，创建管理员账户，启动Flask开发服务器 前端：配置Node.js环境，安装依赖，启动开发服务器 关键配置： 集成LDAP认证：实现自动化用户管理 配置Redis缓存：替换默认SQLite缓存提升性能。
python运行时出现MySQLdb._exceptions.OperationalError错误解决方法
热门推荐
风云千樯、
04-28 1万+
上篇安装好mysqlclient之后进行连接mysql数据库，在连接的过程中出现以下错误： MySQLdb._exceptions.OperationalError：（2059，<NULL>） 经过一番查找得知是因为mysql版本与我所使用的Python Flask不兼容，因此出现以上错误 环境：mysql8.0 flask 更多关于该错误在stackoverflow上的...
使用superset遇到的问题总结
Romance5201314的博客
09-19 3261
使用superset遇到的问题总结 ImportError: cannot import name _remove_dead_weakref 这个错误出现在我升级了Ubuntu系统之后。解决办法是删除了venv文件夹，重新创建Python virtualenv环境，然后重新安装一下superset就可以了。具体步骤可看这里的3、4步。理论上应该不需要创建管理员了，如果要创建管理员，注意保证ema...
superset0.28.1安装、初始化、运行以及相关错误解决
fancychuan的博客
07-23 5342
【安装方法】 # 1. 创建虚拟环境并指定python版本： conda create -n superset_env python=3.6 # 2. 直接安装superset pip install -i https://pypi.tuna.tsinghua.edu.cn/simple superset # 期间可能安装失败，比如prison提示失败，那么单独装上prison pip...
airflow error Flask-Appbuilder setp command
zhouzba的博客
11-27 387
如图 解决 sudo pip install --upgrade setuptools
(venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ flask shell Loaded your LOCAL configuration at [/home/gapinyc/superset/superset_config.py] 2025-10-24 18:02:13,925:DEBUG:superset.utils.logging_configurator:logging was configured successfully 2025-10-24 18:02:13,932:DEBUG:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> 2025-10-24 18:02:13,934:INFO:superset.initialization:Setting database isolation level to READ COMMITTED 2025-10-24 18:02:13,937:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '192.168.110.204\\r' ([Errno -2] Name or service not known)") (Background on this error at: https://sqlalche.me/e/14/e3q8) (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ nc -zv 192.168.110.204 3306 Connection to 192.168.110.204 3306 port [tcp/mysql] succeeded! (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ flask shell Loaded your LOCAL configuration at [/home/gapinyc/superset/superset_config.py] 2025-10-24 18:05:52,709:DEBUG:superset.utils.logging_configurator:logging was configured successfully 2025-10-24 18:05:52,717:DEBUG:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> 2025-10-24 18:05:52,720:INFO:superset.initialization:Setting database isolation level to READ COMMITTED 2025-10-24 18:05:52,722:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '192.168.110.204\\r' ([Errno -2] Name or service not known)") (Background on this error at: https://sqlalche.me/e/14/e3q8) (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$
10-25
| `flask shell` 报错 | ❌ 失败 | 错误指向 `'192.168.110.204\r'` | | 错误内容 | `Name or service not known` | 主机名解析失败 | **最关键线索：** ``` Can't connect to MySQL server on '192.168.110.204\\...
Loaded your LOCAL configuration at [/home/gapinyc/superset/superset_config.py] 2025-10-25 07:16:08,739:DEBUG:superset.utils.logging_configurator:logging was configured successfully 2025-10-25 07:16:08,744:DEBUG:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> 2025-10-25 07:16:08,746:INFO:superset.initialization:Setting database isolation level to READ COMMITTED 2025-10-25 07:16:08,747:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '192.168.110.204\\r' ([Errno -2] Name or service not known)") (Background on this error at: https://sqlalche.me/e/14/e3q8) (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$
10-26
cat -A /home/gapinyc/superset/superset_config.py | grep -A5 -B5 '\^M' ``` 如果有，也执行清理： ```bash sed -i 's/\r$//' /home/gapinyc/superset/superset_config.py ``` --- ### ✅ 步骤 3：验证环境...
将wsl设置为与主机同IP后， (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ gunicorn \ --bind 0.0.0.0:8088 \ --workers 4 \ --worker-class gthread \ --threads 4 \ --timeout 120 \ --max-requests 1000 \ --max-requests-jitter 100 \ --preload \ --access-logfile - \ --error-logfile - \ "superset.app:create_app()" Loaded your LOCAL configuration at [/home/gapinyc/superset/superset_config.py] 2025-10-27 10:48:23,986:INFO:superset.initialization:Setting database isolation level to READ COMMITTED 2025-10-27 10:48:23,990:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '192.168.110.204' ([Errno 111] Connection refused)") (Background on this error at: https://sqlalche.me/e/14/e3q8) (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$
10-28
- DATABASE_URL=mysql+pymysql://superset:yourpassword@db:3306/superset depends_on: - db volumes: mysql_data: ``` 这样可以彻底隔离依赖，避免手动配置。 --- ## ✅ 最终验证步骤 无论哪种方案，请...
Oct 27 14:06:14 DESKTOP-9QS7RL5 start_superset.sh[1673]: Loaded your LOCAL configuration at [/home/gapinyc/superset/superset_config.py] Oct 27 14:06:14 DESKTOP-9QS7RL5 start_superset.sh[1673]: 2025-10-27 14:06:14,796:INFO:superset.initialization:Setting database isolation level to READ COMMITTED Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1673]: [2025-10-27 14:06:15 +0800] [1673] [INFO] Starting gunicorn 23.0.0 Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1673]: [2025-10-27 14:06:15 +0800] [1673] [INFO] Listening at: http://0.0.0.0:8088 (1673) Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1673]: [2025-10-27 14:06:15 +0800] [1673] [INFO] Using worker: gthread Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1687]: [2025-10-27 14:06:15 +0800] [1687] [INFO] Booting worker with pid: 1687 Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1688]: [2025-10-27 14:06:15 +0800] [1688] [INFO] Booting worker with pid: 1688 Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1689]: [2025-10-27 14:06:15 +0800] [1689] [INFO] Booting worker with pid: 1689 Oct 27 14:06:15 DESKTOP-9QS7RL5 start_superset.sh[1690]: [2025-10-27 14:06:15 +0800] [1690] [INFO] Booting worker with pid: 1690 Oct 27 14:06:39 DESKTOP-9QS7RL5 start_superset.sh[1688]: 127.0.0.1 - - [27/Oct/2025:14:06:39 +0800] "GET / HTTP/1.1" 302 223 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:39 DESKTOP-9QS7RL5 start_superset.sh[1688]: 2025-10-27 14:06:39,599:ERROR:superset.translations.utils:Error loading language pack for, falling back on en zh Oct 27 14:06:39 DESKTOP-9QS7RL5 start_superset.sh[1688]: 127.0.0.1 - - [27/Oct/2025:14:06:39 +0800] "GET /superset/welcome/ HTTP/1.1" 200 5443 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: 2025-10-27 14:06:40,223:WARNING:superset.views.error_handling:Exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return [self._keymap[key][0] for key in keys] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return [self._keymap[key][0] for key in keys] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: KeyError: Column('id', Integer(), table=<ab_user>, primary_key=True, nullable=False, default=Sequence('ab_user_id_seq', metadata=MetaData())) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: The above exception was the direct cause of the following exception: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: rv = self.dispatch_request() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 106, in wraps Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: if current_app.appbuilder.sm.has_access( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1651, in has_access Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: if current_user.is_authenticated: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/werkzeug/local.py", line 318, in __get__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: obj = instance._get_current_object() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/werkzeug/local.py", line 526, in _get_current_object Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return get_name(local()) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_login/utils.py", line 25, in <lambda> Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: current_user = LocalProxy(lambda: _get_user()) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_login/utils.py", line 370, in _get_user Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: current_app.login_manager._load_user() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_login/login_manager.py", line 364, in _load_user Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: user = self._user_callback(user_id) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 2226, in load_user Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: user = self.get_user_by_id(int(pk)) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 286, in get_user_by_id Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.get_session.query(self.user_model).get(pk) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "<string>", line 2, in get Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 468, in warned Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return fn(*args, **kwargs) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 947, in get Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self._get_impl(ident, loading.load_on_pk_identity) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 951, in _get_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.session._get_impl( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2975, in _get_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return db_load_fn( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 530, in load_on_pk_identity Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: session.execute( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: result = compile_state_cls.orm_setup_cursor_result( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return loading.instances(result, querycontext) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: with util.safe_reraise(): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: compat.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: *[ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: query_entity.row_processor(context, cursor) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: _instance = loading._instance_processor( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: primary_key_getter = result._tuple_getter(pk_cols) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self._metadata._row_as_tuple_getter(keys) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: indexes = self._indexes_for_keys(keys) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: CursorResultMetaData._key_fallback(self, ke.args[0], ke) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: util.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_user.id' Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: 2025-10-27 14:06:40,238:ERROR:superset.views.error_handling:Could not locate column in row for column 'ab_user.id' Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return [self._keymap[key][0] for key in keys] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return [self._keymap[key][0] for key in keys] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: KeyError: Column('id', Integer(), table=<ab_user>, primary_key=True, nullable=False, default=Sequence('ab_user_id_seq', metadata=MetaData())) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: The above exception was the direct cause of the following exception: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: rv = self.dispatch_request() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 106, in wraps Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: if current_app.appbuilder.sm.has_access( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1651, in has_access Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: if current_user.is_authenticated: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/werkzeug/local.py", line 318, in __get__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: obj = instance._get_current_object() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/werkzeug/local.py", line 526, in _get_current_object Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return get_name(local()) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_login/utils.py", line 25, in <lambda> Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: current_user = LocalProxy(lambda: _get_user()) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_login/utils.py", line 370, in _get_user Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: current_app.login_manager._load_user() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_login/login_manager.py", line 364, in _load_user Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: user = self._user_callback(user_id) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 2226, in load_user Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: user = self.get_user_by_id(int(pk)) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 286, in get_user_by_id Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.get_session.query(self.user_model).get(pk) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "<string>", line 2, in get Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 468, in warned Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return fn(*args, **kwargs) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 947, in get Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self._get_impl(ident, loading.load_on_pk_identity) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 951, in _get_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.session._get_impl( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2975, in _get_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return db_load_fn( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 530, in load_on_pk_identity Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: session.execute( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: result = compile_state_cls.orm_setup_cursor_result( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return loading.instances(result, querycontext) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: with util.safe_reraise(): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: compat.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: *[ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: query_entity.row_processor(context, cursor) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: _instance = loading._instance_processor( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: primary_key_getter = result._tuple_getter(pk_cols) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self._metadata._row_as_tuple_getter(keys) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: indexes = self._indexes_for_keys(keys) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: CursorResultMetaData._key_fallback(self, ke.args[0], ke) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: util.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_user.id' Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: [2025-10-27 14:06:40 +0800] [1687] [ERROR] Error handling request /api/v1/database/?q=(filters:!((col:allow_file_upload,opr:upload_is_enabled,value:!t))) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1062, in _rollback_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.engine.dialect.do_rollback(self.connection) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 683, in do_rollback Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: dbapi_connection.rollback() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 505, in rollback Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._read_ok_packet() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 465, in _read_ok_packet Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: pkt = self._read_packet() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 751, in _read_packet Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: packet_header = self._read_bytes(4) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 805, in _read_bytes Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise err.OperationalError( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query') Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: The above exception was the direct cause of the following exception: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/gunicorn/workers/gthread.py", line 281, in handle Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: keepalive = self.handle_request(req, conn) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/gunicorn/workers/gthread.py", line 333, in handle_request Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: respiter = self.wsgi(environ, resp.start_response) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 2213, in __call__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: return self.wsgi_app(environ, start_response) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 2206, in wsgi_app Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: ctx.pop(error) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/ctx.py", line 417, in pop Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: app_ctx.pop(exc) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/ctx.py", line 255, in pop Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.app.do_teardown_appcontext(exc) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 2063, in do_teardown_appcontext Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.ensure_sync(func)(exc) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 899, in shutdown_session Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.session.remove() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/scoping.py", line 181, in remove Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.registry().close() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1816, in close Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._close_impl(invalidate=False) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1858, in _close_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: transaction.close(invalidate) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 926, in close Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: transaction.close() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2426, in close Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._do_close() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2649, in _do_close Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._close_impl() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2635, in _close_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._connection_rollback_impl() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2627, in _connection_rollback_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.connection._rollback_impl() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1064, in _rollback_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._handle_dbapi_exception(e, None, None, None, None) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: util.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1062, in _rollback_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self.engine.dialect.do_rollback(self.connection) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 683, in do_rollback Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: dbapi_connection.rollback() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 505, in rollback Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: self._read_ok_packet() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 465, in _read_ok_packet Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: pkt = self._read_packet() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 751, in _read_packet Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: packet_header = self._read_bytes(4) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 805, in _read_bytes Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: raise err.OperationalError( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: (Background on this error at: https://sqlalche.me/e/14/e3q8) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/database/?q=(filters:!((col:allow_file_upload,opr:upload_is_enabled,value:!t))) HTTP/1.1" 500 0 "-" "-" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1689]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/log/recent_activity/?q=(distinct:!f,page_size:24) HTTP/1.1" 200 175 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: 2025-10-27 14:06:40,222:ERROR:superset.views.error_handling:This result object does not return rows. It has been closed automatically. Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/views/error_handling.py", line 101, in wraps Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return f(self, *args, **kwargs) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/views/base_api.py", line 487, in get_list_headless Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: duration, response = time_function(super().get_list_headless, **kwargs) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/utils/core.py", line 1369, in time_function Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: response = func(*args, **kwargs) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py", line 1632, in get_list_headless Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: count, lst = self.datamodel.query( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 501, in query Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: count = self.query_count(query, filters, select_columns) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 406, in query_count Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return self._apply_inner_all( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 388, in _apply_inner_all Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: query = self.apply_filters(query, inner_filters) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 225, in apply_filters Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return filters.apply_all(query) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/filters.py", line 302, in apply_all Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: query = flt.apply(query, values) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/databases/filters.py", line 58, in apply Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: if security_manager.can_access_all_databases(): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/security/manager.py", line 469, in can_access_all_databases Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return self.can_access("all_database_access", "all_database_access") Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/security/manager.py", line 441, in can_access Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return self._has_view_access(user, permission_name, view_name) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1561, in _has_view_access Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return bool(db_role_ids) and self.exist_permission_on_roles( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 440, in exist_permission_on_roles Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return self.appbuilder.get_session.query(q).scalar() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2893, in scalar Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: ret = self.one() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2870, in one Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return self._iter().one() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1258, in one Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return self._only_one_row( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 559, in _only_one_row Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: row = onerow(hard_close=True) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1801, in _fetchone_impl Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: row = next(self.iterator, _NO_ROW) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: fetch = cursor._raw_all_rows() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 391, in _raw_all_rows Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: make_row = self._row_getter Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 1184, in __get__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: obj.__dict__[self.__name__] = result = self.fget(obj) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 320, in _row_getter Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: keymap = metadata._keymap Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 1221, in _keymap Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._we_dont_return_rows() Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 1202, in _we_dont_return_rows Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: util.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: sqlalchemy.exc.ResourceClosedError: This result object does not return rows. It has been closed automatically. Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: 2025-10-27 14:06:40,287:ERROR:root:DBEventLogger failed to log event(s) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/saved_query/?q=(filters:!((col:created_by,opr:rel_o_m,value:%271%27)),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:5) HTTP/1.1" 200 457 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: 2025-10-27 14:06:40,288:ERROR:root:(pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))") Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: [SQL: INSERT INTO logs (action, user_id, json, dttm, duration_ms, referrer) VALUES (%(action)s, %(user_id)s, %(json)s, %(dttm)s, %(duration_ms)s, %(referrer)s)] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: [parameters: {'action': 'DatabaseRestApi.get_list', 'user_id': 1, 'json': '{"path": "/api/v1/database/", "q": "(filters:!((col:database_name,opr:neq,value:examples)))", "rison": {"filters": [{"col": "database_name", "opr": "neq", "value": "examples"}]}}', 'dttm': datetime.datetime(2025, 10, 27, 6, 6, 40, 287254), 'duration_ms': 71, 'referrer': 'http://192.168.110.204/superset/welcome/'}] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: (Background on this error at: https://sqlalche.me/e/14/e3q8) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 813, in _write_bytes Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._sock.sendall(data) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: BrokenPipeError: [Errno 32] Broken pipe Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: During handling of the above exception, another exception occurred: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self.dialect.do_execute( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: cursor.execute(statement, parameters) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: result = self._query(query) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: conn.query(q) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 574, in query Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._execute_command(COMMAND.COM_QUERY, sql) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 865, in _execute_command Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._write_bytes(packet) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 816, in _write_bytes Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: raise err.OperationalError( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))") Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: The above exception was the direct cause of the following exception: Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: Traceback (most recent call last): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/superset/utils/log.py", line 406, in log Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: db.session.bulk_save_objects(logs) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "<string>", line 2, in bulk_save_objects Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3705, in bulk_save_objects Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._bulk_save_mappings( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3912, in _bulk_save_mappings Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: with util.safe_reraise(): Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: compat.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3901, in _bulk_save_mappings Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: persistence._bulk_insert( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 107, in _bulk_insert Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: _emit_insert_statements( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: c = connection._execute_20( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20 Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return meth(self, args_10style, kwargs_10style, execution_options) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: return connection._execute_clauseelement( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: ret = self._execute_context( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._handle_dbapi_exception( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: util.raise_( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: raise exception Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self.dialect.do_execute( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: cursor.execute(statement, parameters) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: result = self._query(query) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: conn.query(q) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 574, in query Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._execute_command(COMMAND.COM_QUERY, sql) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 865, in _execute_command Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: self._write_bytes(packet) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 816, in _write_bytes Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: raise err.OperationalError( Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))") Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: [SQL: INSERT INTO logs (action, user_id, json, dttm, duration_ms, referrer) VALUES (%(action)s, %(user_id)s, %(json)s, %(dttm)s, %(duration_ms)s, %(referrer)s)] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: [parameters: {'action': 'DatabaseRestApi.get_list', 'user_id': 1, 'json': '{"path": "/api/v1/database/", "q": "(filters:!((col:database_name,opr:neq,value:examples)))", "rison": {"filters": [{"col": "database_name", "opr": "neq", "value": "examples"}]}}', 'dttm': datetime.datetime(2025, 10, 27, 6, 6, 40, 287254), 'duration_ms': 71, 'referrer': 'http://192.168.110.204/superset/welcome/'}] Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: (Background on this error at: https://sqlalche.me/e/14/e3q8) Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1688]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/database/?q=(filters:!((col:database_name,opr:neq,value:examples))) HTTP/1.1" 500 87 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1687]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/dashboard/?q=(filters:!(),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:5) HTTP/1.1" 200 734 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1690]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/dashboard/?q=(filters:!((col:owners,opr:rel_m_m,value:%271%27)),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:5) HTTP/1.1" 200 734 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1689]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/chart/?q=(filters:!(),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:5) HTTP/1.1" 200 749 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1690]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/chart/?q=(filters:!((col:owners,opr:rel_m_m,value:%271%27)),order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:5) HTTP/1.1" 200 749 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1689]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/dashboard/favorite_status/?q=!(1) HTTP/1.1" 200 36 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1690]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/dashboard/_info?q=(keys:!(permissions)) HTTP/1.1" 200 147 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:40 DESKTOP-9QS7RL5 start_superset.sh[1689]: 127.0.0.1 - - [27/Oct/2025:14:06:40 +0800] "GET /api/v1/chart/_info?q=(keys:!(permissions)) HTTP/1.1" 200 74 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0" Oct 27 14:06:41 DESKTOP-9QS7RL5 start_superset.sh[1690]: 127.0.0.1 - - [27/Oct/2025:14:06:41 +0800] "POST /superset/log/?explode=events HTTP/1.1" 200 20 "http://192.168.110.204/superset/welcome/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0"
最新发布
10-28
File ".../flask_appbuilder/security/sqla/manager.py", line 286, in get_user_by_id return self.get_session.query(self.user_model).get(pk) ``` 执行 SQL： ```sql SELECT * FROM ab_user WHERE id = 1; ``...
关于报错 ：MySQLdb._exceptions.OperationalError) (2026, ‘SSL connection error: error:00000001的解决方案
一颗正在成长的在校卷心菜
06-20 2596
(MySQLdb._exceptions.OperationalError) (2026, 'SSL connection error: error:00000001:lib(0):func(0):reason(1)') (Background on this error at: http://sqlalche.me/e/13/e3q8) This may be triggered by: Issue 1002 - The database returned an unexpected error.
flask启动项目提示NO Module ‘MySQLdb’
配置django虚拟环境（windows和基于linux系统的ubuntu）
11-25 242
在最新的python3中已经不支持mysqldb了，在这里说一下最简单的解决办法，pip install mysqldb的这个方法需要装的包太多不推荐使用 如果你有flask的虚拟环境找到sqlalchemy这个文件夹在这个文件夹的__init__.py中添加两行代码 import pymysql pymysql.install_as_MySQLdb() 保存退出，重启项目，完美解决 ...
flaskappbuilder缺点
python_tty的专栏
07-09 1716
选择框不能联动 页面加载的过程中没有赋值的接口，pre_add, post_add 只在页面已经加载出来，将要保存时的操作
Superset连接本地MySQL异常解决
weixin_46161645的博客
09-05 1170
说明mysqlclient模块使用的参数名与MySQL文档中的不一致。但查询mysqlclient文档并未发现Unix socket文件参数的说明😂。没办法，只能使用码农基本能力 - 读源代码了😁。如何在superset中配置指定MySQL连接的Unix socket文件呢？查看MySQL官方文档，可以看到在连接串中通过。中的描述，连接MySQL用的是。驱动，问题可能出现在该驱动上。文件与MySQL服务的不同，在指定正确的。如果想快速解决问题，可将连接串中的。从上面的验证可以看出，问题出在。
【superset安装】史上最全superset安装过程中错误解决方案
m0_58195451的博客
10-31 9916
superset安装过程中各种错误的解决方案
关于superset初始化报错总结
一颗正在成长的在校卷心菜
06-20 2355
ImportError: cannot import name '_ColumnEntity' ModuleNotFoundError: No module named 'dataclasses' No module named 'cryptography.hazmat.backends.openssl.x509' No PIL installation found INFO:superset.utils.screenshots:No PIL installation found
superset 出现数据库错误
远古小山的专栏
09-24 7036
出错log： sqlalchemy.exc.OperationalError sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: dbs.impersonate_user [SQL: 'SELECT dbs.created_on AS dbs_created_on, dbs.changed_o
评论 2
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值