could not write bytes: Broken pipe解决

本文介绍了解决Ubuntu12.04 64位系统中安装软件后出现的黑屏问题,通过进入命令行模式并重新安装xserver-xorg来恢复正常显示。

系统:Ubuntu 12.04 64bit

现象:昨天装了几款软件(QT4,以及几款软件更新),今天再开机,没等进入登录界面就黑屏显示“could not write bytes: Broken pipe”

解决:

1. 开机按“Ctrl + Alt + F1”,进入命令行模式,并登录

2. 输入ls,发现环境变量没有问题。(若环境变量有问题,请参考其他资料)

3. 执行startx。提示“.../usr/bin/X:No such file or directory”

4. 执行sudo apt-get install xserver-xorg

5. 重启即可


转载:http://blog.youkuaiyun.com/yhm18ke/article/details/18400677
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
### 解决 'Could not write JSON: Invalid ID for region-b' 错误 当遇到 `Could not write JSON: Invalid ID for region-b` 这样的错误提示时,通常意味着尝试写入的 JSON 数据中存在不符合预期格式或范围的区域标识符 (ID)。为了有效解决问题,可以从以下几个方面着手: #### 验证数据源中的Region-B ID合法性 确保输入文件中的所有 Region-B IDs 符合定义的标准和约束条件。如果这些IDs是从外部获取或是由其他程序生成,则需确认其准确性。 #### 检查并修正配置文件编码问题 有时不正确的字符集可能导致解析失败或其他异常行为。虽然此案例主要涉及的是无效ID而非编码问题,但考虑到提及到了编码转换的需求[^1],建议也验证下相关配置文件是否确实采用UTF-8编码保存,以排除潜在干扰因素。 #### 审核JSON Schema 或者模式定义 对于有严格结构要求的数据交换格式来说,遵循既定的Schema是非常重要的。如果有可用的JSON Schema文档来描述合法的对象模型,请仔细对照检查每一个字段特别是Region-B ID部分的要求,并据此调整待写入的内容。 #### 编程层面处理非法值 在编写负责创建或修改此类记录的应用逻辑时加入必要的校验机制,在提交前先对即将被序列化的对象实例做一次全面审查,拦截任何可能引起冲突的情况。例如可以使用正则表达式匹配期望的形式或者通过查询数据库等方式核实特定范围内唯一性的保持。 ```python import re def validate_region_b_id(region_b_id): pattern = r'^[A-Za-z0-9_-]+$' return bool(re.match(pattern, str(region_b_id))) if __name__ == "__main__": test_ids = ["valid-id", "invalid/id!", 12345] for id_ in test_ids: print(f"Checking '{id_}': {validate_region_b_id(id_)}.") ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值