136 深入解析 MetadataReplacementPostProcessor:一种高效的元数据替换后处理器 llamaindex.core.postprocessor.metadata_.py

深入解析 MetadataReplacementPostProcessor:一种高效的元数据替换后处理器

在自然语言处理(NLP)领域,节点后处理是一个关键的步骤。它涉及对检索到的节点进行进一步处理,以便更好地匹配查询需求。今天,我们将深入探讨一种名为 MetadataReplacementPostProcessor 的节点后处理器,它能够将节点的内容替换为目标元数据键的值。这种后处理器在处理包含丰富元数据的节点时尤为有用,因为它可以帮助我们更好地理解节点的实际内容。

前置知识

在深入了解 MetadataReplacementPostProcessor 之前,我们需要掌握以下几个概念:

  1. 节点(Node):在NLP中,节点是文档的基本单元。它可以是一个句子、一个段落或一个词语。
  2. 元数据(Metadata):元数据是关于数据的数据,用于描述节点的额外信息。
  3. 查询包(Query Bundle):包含查询字符串和其他相关信息的包,用于指导节点的检索和后处理。
  4. 后处理器(Postprocessor):一种用于对节点进行进一步处理的工具。

MetadataReplacementPostProcessor 的实现

MetadataReplacementPostProcessor 是一个基于 BaseNodePostprocessor 接口的类,它通过将节点的内容替换为目标元数据键的值来对节点进行后处理。下面是其实现的详细解析:

导入必要的模块

首先,我们需要导入一些必要的模块和函数:

from typing import List, Optional
from llama_index.core.bridge.pydantic import Field
from llama_index.core.postprocessor.types import BaseNodePostprocessor
from llama_index.core.schema import MetadataMode, NodeWithScore, QueryBundle

定义 MetadataReplacementPostProcessor 类

现在,我们定义 MetadataReplacementPostProcessor 类,并为其添加必要的属性和方法:

class MetadataReplacementPostProcessor(BaseNodePostprocessor
(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()" 👉 Using SECRET_KEY: '1sCjCsfAPMBskPWPSJ0Gja7JvpufVc50vTW04MSiJuzNN3JPlUYL3MR+' Loaded your LOCAL configuration at [/home/gapinyc/superset/superset_config.py] 2025-10-25 13:13:27,140:INFO:superset.initialization:Setting database isolation level to READ COMMITTED [2025-10-25 13:13:27 +0800] [19396] [INFO] Starting gunicorn 23.0.0 [2025-10-25 13:13:27 +0800] [19396] [INFO] Listening at: http://0.0.0.0:8088 (19396) [2025-10-25 13:13:27 +0800] [19396] [INFO] Using worker: gthread [2025-10-25 13:13:27 +0800] [19410] [INFO] Booting worker with pid: 19410 [2025-10-25 13:13:27 +0800] [19411] [INFO] Booting worker with pid: 19411 [2025-10-25 13:13:27 +0800] [19412] [INFO] Booting worker with pid: 19412 [2025-10-25 13:13:27 +0800] [19413] [INFO] Booting worker with pid: 19413 127.0.0.1 - - [25/Oct/2025:13:13:31 +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" 127.0.0.1 - - [25/Oct/2025:13:13:31 +0800] "GET /superset/welcome/ HTTP/1.1" 200 5767 "-" "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" 2025-10-25 13:13:31,674:ERROR:flask_appbuilder.models.sqla.filters:Related object for column: owners, value: 1 return Null 2025-10-25 13:13:31,674:WARNING:superset.views.error_handling:Exception Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys return [self._keymap[key][0] for key in keys] File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> return [self._keymap[key][0] for key in keys] KeyError: Column('id', Integer(), table=<ab_permission_view>, primary_key=True, nullable=False, default=Sequence('ab_permission_view_id_seq', metadata=MetaData())) The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps if current_app.appbuilder.sm.is_item_public( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public permissions = self.get_public_permissions() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 391, in get_public_permissions return role.permissions File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload result = session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor _instance = loading._instance_processor( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor primary_key_getter = result._tuple_getter(pk_cols) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter return self._metadata._row_as_tuple_getter(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter indexes = self._indexes_for_keys(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys CursorResultMetaData._key_fallback(self, ke.args[0], ke) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_permission_view.id' 2025-10-25 13:13:31,681:ERROR:superset.views.error_handling:Could not locate column in row for column 'ab_permission_view.id' Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys return [self._keymap[key][0] for key in keys] File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> return [self._keymap[key][0] for key in keys] KeyError: Column('id', Integer(), table=<ab_permission_view>, primary_key=True, nullable=False, default=Sequence('ab_permission_view_id_seq', metadata=MetaData())) The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps if current_app.appbuilder.sm.is_item_public( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public permissions = self.get_public_permissions() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 391, in get_public_permissions return role.permissions File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload result = session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor _instance = loading._instance_processor( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor primary_key_getter = result._tuple_getter(pk_cols) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter return self._metadata._row_as_tuple_getter(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter indexes = self._indexes_for_keys(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys CursorResultMetaData._key_fallback(self, ke.args[0], ke) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_permission_view.id' 127.0.0.1 - - [25/Oct/2025:13:13:31 +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" 500 264 "http://localhost:8088/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" 2025-10-25 13:13:31,689:WARNING:superset.views.error_handling:Exception Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys return [self._keymap[key][0] for key in keys] File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> return [self._keymap[key][0] for key in keys] KeyError: Column('id', Integer(), table=<ab_role>, primary_key=True, nullable=False, default=Sequence('ab_role_id_seq', metadata=MetaData())) The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 106, in wraps if current_app.appbuilder.sm.has_access( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1652, in has_access return self._has_view_access(g.user, permission_name, view_name) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1548, in _has_view_access roles = self.get_user_roles(user) File "/home/gapinyc/superset/superset/security/manager.py", line 2429, in get_user_roles return user.roles File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload result = session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor _instance = loading._instance_processor( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor primary_key_getter = result._tuple_getter(pk_cols) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter return self._metadata._row_as_tuple_getter(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter indexes = self._indexes_for_keys(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys CursorResultMetaData._key_fallback(self, ke.args[0], ke) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_role.id' 2025-10-25 13:13:31,695:ERROR:superset.views.error_handling:Could not locate column in row for column 'ab_role.id' Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys return [self._keymap[key][0] for key in keys] File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> return [self._keymap[key][0] for key in keys] KeyError: Column('id', Integer(), table=<ab_role>, primary_key=True, nullable=False, default=Sequence('ab_role_id_seq', metadata=MetaData())) The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 106, in wraps if current_app.appbuilder.sm.has_access( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1652, in has_access return self._has_view_access(g.user, permission_name, view_name) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1548, in _has_view_access roles = self.get_user_roles(user) File "/home/gapinyc/superset/superset/security/manager.py", line 2429, in get_user_roles return user.roles File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload result = session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor _instance = loading._instance_processor( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor primary_key_getter = result._tuple_getter(pk_cols) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter return self._metadata._row_as_tuple_getter(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter indexes = self._indexes_for_keys(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys CursorResultMetaData._key_fallback(self, ke.args[0], ke) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_role.id' 2025-10-25 13:13:31,690:ERROR:superset.views.error_handling:Could not locate column in row for column 'count(*)' Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 651, in _index_for_key rec = self._keymap[key] KeyError: <sqlalchemy.sql.functions.count at 0x71cc9ac32320; count> The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/superset/views/error_handling.py", line 101, in wraps return f(self, *args, **kwargs) File "/home/gapinyc/superset/superset/views/base_api.py", line 487, in get_list_headless duration, response = time_function(super().get_list_headless, **kwargs) File "/home/gapinyc/superset/superset/utils/core.py", line 1369, in time_function response = func(*args, **kwargs) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py", line 1632, in get_list_headless count, lst = self.datamodel.query( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 501, in query count = self.query_count(query, filters, select_columns) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 408, in query_count ).count() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3176, in count return self._from_self(col).enable_eagerloads(False).scalar() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2893, in scalar ret = self.one() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2870, in one return self._iter().one() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter result = self.session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2911, in row_processor getter = result._getter(column) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 951, in _getter return self._metadata._getter(key, raiseerr) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 98, in _getter index = self._index_for_key(key, raiseerr) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 653, in _index_for_key rec = self._key_fallback(key, ke, raiseerr) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'count(*)' 2025-10-25 13:13:31,702:ERROR:root:DBEventLogger failed to log event(s) 2025-10-25 13:13:31,703:WARNING:superset.views.error_handling:Exception Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps if current_app.appbuilder.sm.is_item_public( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public permissions = self.get_public_permissions() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 391, in get_public_permissions return role.permissions File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload result = session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor _instance = loading._instance_processor( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor primary_key_getter = result._tuple_getter(pk_cols) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter return self._metadata._row_as_tuple_getter(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter indexes = self._indexes_for_keys(keys) AttributeError: '_NoResultMetaData' object has no attribute '_indexes_for_keys'. Did you mean: '_index_for_key'? 2025-10-25 13:13:31,704:ERROR:superset.views.error_handling:'_NoResultMetaData' object has no attribute '_indexes_for_keys' Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps if current_app.appbuilder.sm.is_item_public( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public permissions = self.get_public_permissions() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 391, in get_public_permissions return role.permissions File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ return self.impl.get(state, dict_) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get value = self._fire_loader_callables(state, key, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables return self.callable_(state, passive) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state return self._emit_lazyload( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload result = session.execute( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute result = compile_state_cls.orm_setup_cursor_result( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result return loading.instances(result, querycontext) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances with util.safe_reraise(): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances *[ File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> query_entity.row_processor(context, cursor) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor _instance = loading._instance_processor( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor primary_key_getter = result._tuple_getter(pk_cols) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter return self._metadata._row_as_tuple_getter(keys) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter indexes = self._indexes_for_keys(keys) AttributeError: '_NoResultMetaData' object has no attribute '_indexes_for_keys'. Did you mean: '_index_for_key'? 2025-10-25 13:13:31,702:ERROR:root:(pymysql.err.OperationalError) (2014, 'Command Out of Sync') (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1094, in _commit_impl self.engine.dialect.do_commit(self.connection) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 686, in do_commit dbapi_connection.commit() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 495, in commit self._read_ok_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 467, in _read_ok_packet raise err.OperationalError( pymysql.err.OperationalError: (2014, 'Command Out of Sync') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/superset/utils/log.py", line 407, in log db.session.commit() # pylint: disable=consider-using-transaction File "<string>", line 2, in commit File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1454, in commit self._transaction.commit(_to_root=self.future) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 839, in commit trans.commit() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2469, in commit self._do_commit() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2659, in _do_commit self._connection_commit_impl() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2630, in _connection_commit_impl self.connection._commit_impl() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1096, in _commit_impl self._handle_dbapi_exception(e, None, None, None, None) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1094, in _commit_impl self.engine.dialect.do_commit(self.connection) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 686, in do_commit dbapi_connection.commit() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 495, in commit self._read_ok_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 467, in _read_ok_packet raise err.OperationalError( sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2014, 'Command Out of Sync') (Background on this error at: https://sqlalche.me/e/14/e3q8) 127.0.0.1 - - [25/Oct/2025:13:13:31 +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" 500 65 "http://localhost:8088/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" [2025-10-25 13:13:31 +0800] [19412] [ERROR] Error handling request /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) Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1062, in _rollback_impl self.engine.dialect.do_rollback(self.connection) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 683, in do_rollback dbapi_connection.rollback() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 505, in rollback self._read_ok_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 465, in _read_ok_packet pkt = self._read_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 751, in _read_packet packet_header = self._read_bytes(4) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 805, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/gunicorn/workers/gthread.py", line 281, in handle keepalive = self.handle_request(req, conn) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/gunicorn/workers/gthread.py", line 333, in handle_request respiter = self.wsgi(environ, resp.start_response) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 2213, in __call__ return self.wsgi_app(environ, start_response) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 2206, in wsgi_app ctx.pop(error) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/ctx.py", line 417, in pop app_ctx.pop(exc) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/ctx.py", line 255, in pop self.app.do_teardown_appcontext(exc) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 2063, in do_teardown_appcontext self.ensure_sync(func)(exc) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 899, in shutdown_session self.session.remove() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/scoping.py", line 181, in remove self.registry().close() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1816, in close self._close_impl(invalidate=False) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1858, in _close_impl transaction.close(invalidate) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 926, in close transaction.close() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2426, in close self._do_close() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2649, in _do_close self._close_impl() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2635, in _close_impl self._connection_rollback_impl() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2627, in _connection_rollback_impl self.connection._rollback_impl() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1064, in _rollback_impl self._handle_dbapi_exception(e, None, None, None, None) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception util.raise_( File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1062, in _rollback_impl self.engine.dialect.do_rollback(self.connection) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 683, in do_rollback dbapi_connection.rollback() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 505, in rollback self._read_ok_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 465, in _read_ok_packet pkt = self._read_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 751, in _read_packet packet_header = self._read_bytes(4) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 805, in _read_bytes raise err.OperationalError( sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') (Background on this error at: https://sqlalche.me/e/14/e3q8) 127.0.0.1 - - [25/Oct/2025:13:13:31 +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" 500 0 "-" "-" 2025-10-25 13:13:31,706:ERROR:sqlalchemy.pool.impl.QueuePool:Exception during reset or similar Traceback (most recent call last): File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 763, in _finalize_fairy fairy._reset(pool, transaction_was_reset) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1038, in _reset pool._dialect.do_rollback(self) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 683, in do_rollback dbapi_connection.rollback() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 505, in rollback self._read_ok_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 465, in _read_ok_packet pkt = self._read_packet() File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 751, in _read_packet packet_header = self._read_bytes(4) File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 805, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query') 127.0.0.1 - - [25/Oct/2025:13:13:31 +0800] "GET /api/v1/database/?q=(filters:!((col:allow_file_upload,opr:upload_is_enabled,value:!t))) HTTP/1.1" 500 262 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:31 +0800] "GET /api/v1/log/recent_activity/?q=(distinct:!f,page_size:24) HTTP/1.1" 200 14 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:31 +0800] "GET /api/v1/database/?q=(filters:!((col:database_name,opr:neq,value:examples))) HTTP/1.1" 200 615 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:31 +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 547 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:31 +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 797 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:31 +0800] "GET /api/v1/chart/_info?q=(keys:!(permissions)) HTTP/1.1" 200 74 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:32 +0800] "GET /api/v1/dashboard/_info?q=(keys:!(permissions)) HTTP/1.1" 200 147 "http://localhost:8088/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" 127.0.0.1 - - [25/Oct/2025:13:13:32 +0800] "POST /superset/log/?explode=events HTTP/1.1" 200 9 "http://localhost:8088/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-26
Oct 27 17:59:53 DESKTOP-9QS7RL5 start_superset.sh[5291]: 127.0.0.1 - - [27/Oct/2025:17:59:53 +0800] "GET /dashboard/list/ HTTP/1.1" 200 5381 "http://192.168.110.204/logmodelview/list/" "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 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: 2025-10-27 17:59:54,058:ERROR:superset.views.error_handling:Could not locate column in row for column 'count(*)' Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 651, in _index_for_key Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: rec = self._keymap[key] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: KeyError: <sqlalchemy.sql.functions.count at 0x76946239ad10; count> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: The above exception was the direct cause of the following exception: Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/superset/views/error_handling.py", line 101, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return f(self, *args, **kwargs) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/superset/views/base_api.py", line 487, in get_list_headless Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: duration, response = time_function(super().get_list_headless, **kwargs) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/superset/utils/core.py", line 1369, in time_function Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: response = func(*args, **kwargs) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py", line 1632, in get_list_headless Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: count, lst = self.datamodel.query( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 501, in query Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: count = self.query_count(query, filters, select_columns) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 408, in query_count Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: ).count() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3176, in count Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._from_self(col).enable_eagerloads(False).scalar() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2893, in scalar Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: ret = self.one() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2870, in one Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._iter().one() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: result = self.session.execute( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: result = compile_state_cls.orm_setup_cursor_result( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return loading.instances(result, querycontext) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: with util.safe_reraise(): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: compat.raise_( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: raise exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: *[ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: query_entity.row_processor(context, cursor) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2911, in row_processor Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: getter = result._getter(column) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 951, in _getter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._metadata._getter(key, raiseerr) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 98, in _getter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: index = self._index_for_key(key, raiseerr) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 653, in _index_for_key Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: rec = self._key_fallback(key, ke, raiseerr) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: util.raise_( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: raise exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'count(*)' Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: 2025-10-27 17:59:54,057:WARNING:superset.views.error_handling:Exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return [self._keymap[key][0] for key in keys] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return [self._keymap[key][0] for key in keys] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: KeyError: Column('id', Integer(), table=<ab_role>, primary_key=True, nullable=False, default=Sequence('ab_role_id_seq', metadata=MetaData())) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: The above exception was the direct cause of the following exception: Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: rv = self.dispatch_request() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 106, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: if current_app.appbuilder.sm.has_access( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1652, in has_access Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._has_view_access(g.user, permission_name, view_name) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1548, in _has_view_access Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: roles = self.get_user_roles(user) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/superset/security/manager.py", line 2429, in get_user_roles Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return user.roles Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.impl.get(state, dict_) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: value = self._fire_loader_callables(state, key, passive) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.callable_(state, passive) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._emit_lazyload( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: result = session.execute( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: result = compile_state_cls.orm_setup_cursor_result( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return loading.instances(result, querycontext) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: with util.safe_reraise(): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: compat.raise_( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: raise exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: *[ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: query_entity.row_processor(context, cursor) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: _instance = loading._instance_processor( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: primary_key_getter = result._tuple_getter(pk_cols) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._metadata._row_as_tuple_getter(keys) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: indexes = self._indexes_for_keys(keys) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: CursorResultMetaData._key_fallback(self, ke.args[0], ke) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: util.raise_( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: raise exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_role.id' Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: 2025-10-27 17:59:54,065:ERROR:superset.views.error_handling:Could not locate column in row for column 'ab_role.id' Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in _indexes_for_keys Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return [self._keymap[key][0] for key in keys] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 666, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return [self._keymap[key][0] for key in keys] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: KeyError: Column('id', Integer(), table=<ab_role>, primary_key=True, nullable=False, default=Sequence('ab_role_id_seq', metadata=MetaData())) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: The above exception was the direct cause of the following exception: Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: rv = self.dispatch_request() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 106, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: if current_app.appbuilder.sm.has_access( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1652, in has_access Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._has_view_access(g.user, permission_name, view_name) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1548, in _has_view_access Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: roles = self.get_user_roles(user) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/superset/security/manager.py", line 2429, in get_user_roles Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return user.roles Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.impl.get(state, dict_) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 959, in get Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: value = self._fire_loader_callables(state, key, passive) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.callable_(state, passive) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._emit_lazyload( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: result = session.execute( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1720, in execute Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: result = compile_state_cls.orm_setup_cursor_result( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return loading.instances(result, querycontext) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 88, in instances Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: with util.safe_reraise(): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: compat.raise_( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: raise exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 69, in instances Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: *[ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 70, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: query_entity.row_processor(context, cursor) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2631, in row_processor Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: _instance = loading._instance_processor( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 715, in _instance_processor Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: primary_key_getter = result._tuple_getter(pk_cols) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 962, in _tuple_getter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._metadata._row_as_tuple_getter(keys) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 106, in _row_as_tuple_getter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: indexes = self._indexes_for_keys(keys) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 669, in _indexes_for_keys Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: CursorResultMetaData._key_fallback(self, ke.args[0], ke) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 628, in _key_fallback Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: util.raise_( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: raise exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: sqlalchemy.exc.NoSuchColumnError: Could not locate column in row for column 'ab_role.id' Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: 127.0.0.1 - - [27/Oct/2025:17:59:54 +0800] "GET /api/v1/database/?q=(filters:!((col:allow_file_upload,opr:upload_is_enabled,value:!t))) HTTP/1.1" 500 253 "http://192.168.110.204/dashboard/list/" "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 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: 127.0.0.1 - - [27/Oct/2025:17:59:54 +0800] "GET /api/v1/database/?q=(filters:!((col:database_name,opr:neq,value:examples))) HTTP/1.1" 500 65 "http://192.168.110.204/dashboard/list/" "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 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: 2025-10-27 17:59:54,110:WARNING:superset.views.error_handling:Exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: rv = self.dispatch_request() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: if current_app.appbuilder.sm.is_item_public( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: permissions = self.get_public_permissions() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 389, in get_public_permissions Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: role = self.get_public_role() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 353, in get_public_role Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: .one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2850, in one_or_none Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._iter().one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1510, in one_or_none Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._only_one_row( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 559, in _only_one_row Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: row = onerow(hard_close=True) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1386, in _fetchone_impl Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._real_result._fetchone_impl(hard_close=hard_close) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1801, in _fetchone_impl Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: row = next(self.iterator, _NO_ROW) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: fetch = cursor._raw_all_rows() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in _raw_all_rows Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return [make_row(row) for row in rows] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return [make_row(row) for row in rows] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: RuntimeError: number of values in row (1) differ from number of column processors (2) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: 2025-10-27 17:59:54,111:ERROR:superset.views.error_handling:number of values in row (1) differ from number of column processors (2) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: rv = self.dispatch_request() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: if current_app.appbuilder.sm.is_item_public( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: permissions = self.get_public_permissions() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 389, in get_public_permissions Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: role = self.get_public_role() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 353, in get_public_role Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: .one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2850, in one_or_none Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._iter().one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1510, in one_or_none Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._only_one_row( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 559, in _only_one_row Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: row = onerow(hard_close=True) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1386, in _fetchone_impl Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return self._real_result._fetchone_impl(hard_close=hard_close) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1801, in _fetchone_impl Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: row = next(self.iterator, _NO_ROW) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: fetch = cursor._raw_all_rows() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in _raw_all_rows Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return [make_row(row) for row in rows] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in <listcomp> Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: return [make_row(row) for row in rows] Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: RuntimeError: number of values in row (1) differ from number of column processors (2) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: 2025-10-27 17:59:54,111:WARNING:superset.views.error_handling:Exception Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: rv = self.dispatch_request() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: if current_app.appbuilder.sm.is_item_public( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: permissions = self.get_public_permissions() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 389, in get_public_permissions Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: role = self.get_public_role() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 353, in get_public_role Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: .one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2850, in one_or_none Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._iter().one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: result = self.session.execute( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1716, in execute Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: conn = self._connection_for_bind(bind) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1555, in _connection_for_bind Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._transaction._connection_for_bind( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 750, in _connection_for_bind Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: conn = bind.connect() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3325, in connect Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._connection_cls(self, close_with_result=close_with_result) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 120, in __init__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: self.dispatch.engine_connect(self, _branch_from is not None) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/event/attr.py", line 346, in __call__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: fn(*args, **kw) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/superset/utils/core.py", line 644, in ping_connection Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: connection.scalar(select([1])) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1267, in scalar Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.execute(object_, *multiparams, **params).scalar() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1276, in scalar Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._only_one_row( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 575, in _only_one_row Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: row = make_row(row) if make_row else row Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: RuntimeError: number of values in row (2) differ from number of column processors (1) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: 2025-10-27 17:59:54,112:ERROR:superset.views.error_handling:number of values in row (2) differ from number of column processors (1) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: Traceback (most recent call last): Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: rv = self.dispatch_request() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 98, in wraps Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: if current_app.appbuilder.sm.is_item_public( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/manager.py", line 1518, in is_item_public Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: permissions = self.get_public_permissions() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 389, in get_public_permissions Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: role = self.get_public_role() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/sqla/manager.py", line 353, in get_public_role Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: .one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2850, in one_or_none Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._iter().one_or_none() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: result = self.session.execute( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1716, in execute Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: conn = self._connection_for_bind(bind) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1555, in _connection_for_bind Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._transaction._connection_for_bind( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 750, in _connection_for_bind Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: conn = bind.connect() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3325, in connect Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._connection_cls(self, close_with_result=close_with_result) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 120, in __init__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: self.dispatch.engine_connect(self, _branch_from is not None) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/event/attr.py", line 346, in __call__ Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: fn(*args, **kw) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/superset/utils/core.py", line 644, in ping_connection Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: connection.scalar(select([1])) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1267, in scalar Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self.execute(object_, *multiparams, **params).scalar() Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1276, in scalar Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: return self._only_one_row( Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 575, in _only_one_row Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: row = make_row(row) if make_row else row Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: RuntimeError: number of values in row (2) differ from number of column processors (1) Oct 27 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: 127.0.0.1 - - [27/Oct/2025:17:59:54 +0800] "GET /api/v1/dashboard/_info?q=(keys:!(permissions)) HTTP/1.1" 500 270 "http://192.168.110.204/dashboard/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc&viewMode=table" "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 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5290]: 127.0.0.1 - - [27/Oct/2025:17:59:54 +0800] "GET /api/v1/dashboard/?q=(order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:25,select_columns:!(id,dashboard_title,published,url,slug,changed_by,changed_by.id,changed_by.first_name,changed_by.last_name,changed_on_delta_humanized,owners,owners.id,owners.first_name,owners.last_name,tags.id,tags.name,tags.type,status,certified_by,certification_details,changed_on)) HTTP/1.1" 500 270 "http://192.168.110.204/dashboard/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc&viewMode=table" "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 17:59:54 DESKTOP-9QS7RL5 start_superset.sh[5291]: 127.0.0.1 - - [27/Oct/2025:17:59:54 +0800] "POST /superset/log/?explode=events HTTP/1.1" 200 20 "http://192.168.110.204/dashboard/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc&viewMode=table" "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
内容概要:本文介绍了一个基于MATLAB实现的无人机三维路径规划项目,采用蚁群算法(ACO)与多层感知机(MLP)相结合的混合模型(ACO-MLP)。该模型通过三维环境离散化建模,利用ACO进行全局路径搜索,并引入MLP对环境特征进行自适应学习与启发因子优化,实现路径的动态调整与多目标优化。项目解决了高维空间建模、动态障碍规避、局部最优陷阱、算法实时性及多目标权衡等关键技术难题,结合并行计算与参数自适应机制,提升了路径规划的智能性、安全性和工程适用性。文中提供了详细的模型架构、核心算法流程及MATLAB代码示例,涵盖空间建模、信息素更新、MLP训练与融合优化等关键步骤。; 适合人群:具备一定MATLAB编程基础,熟悉智能优化算法与神经网络的高校学生、科研人员及从事无人机路径规划相关工作的工程师;适合从事智能无人系统、自动驾驶、机器人导航等领域的研究人员; 使用场景及目标:①应用于复杂三维环境下的无人机路径规划,如城市物流、灾害救援、军事侦察等场景;②实现飞行安全、能耗优化、路径平滑与实时避障等多目标协同优化;③为智能无人系统的自主决策与环境适应能力提供算法支持; 阅读建议:此资源结合理论模型与MATLAB实践,建议读者在理解ACO与MLP基本原理的基础上,结合代码示例进行仿真调试,重点关注ACO-MLP融合机制、多目标优化函数设计及参数自适应策略的实现,以深入掌握混合智能算法在工程中的应用方法。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

需要重新演唱

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值