为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:
【CPU】:
【问题描述】*:
存在部分刷新页面时,后台查询会抛出Invalid table or view name [fasm_kg_db] 但实际表已经成功构建 同时有时候刷新也是正常查询的
错误信息如下:The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/code/HQY/IntentFrame/base_rsdb/dbkg_operator.py", line 159, in get_kgdb_page
all_results = query.all()
^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2673, in all
return self._iter().all() # type: ignore
^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
^^^^^^^^^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
return meth(
^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy_dm-2.0.1-py3.11.egg/sqlalchemy_dm/base.py", line 1825, in do_execute
super(DMDialect, self).do_execute(cursor, statement, parameters, context)
File "/root/anaconda3/envs/swift_env/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (dmPython.DatabaseError) [CODE:-2106]Error in line: 3
Invalid table or view name [fasm_kg_db]
[SQL: SELECT fasm_kg_db.kg_id AS fasm_kg_db_kg_id, fasm_kg_db.kg_name AS fasm_kg_db_kg_name, fasm_kg_db.label AS fasm_kg_db_label, fasm_kg_db.avatar AS fasm_kg_db_avatar, fasm_kg_db.status AS fasm_kg_db_status, fasm_kg_db.creator AS fasm_kg_db_creator, fasm_kg_db.create_time AS fasm_kg_db_create_time, fasm_kg_db.modify_time AS fasm_kg_db_modify_time, fasm_kg_db.tenant_id AS fasm_kg_db_tenant_id, fasm_kg_db.description AS fasm_kg_db_description
FROM fasm_kg_db
WHERE fasm_kg_db.tenant_id = ?]
[parameters: ['tenant_123']]
(Background on this error at: https://sqlalche.me/e/20/4xp6)
有人能解答一下吗?是涉及连接池还是别的呢?表是存在得 但就是偶尔刷新会报错