版本:selectdb-doris 3.0.9
原因:测试用集群 FE 和 BE 节点全部挂掉,拉起后针对某张表的所有查询报错:1105, 'errCode = 2, detailMessage = (192.168.5.69)[INTERNAL_ERROR]fail to find path in version_graph. spec_version: 0-138778'
尝试:看到文章 【Apache Doris】数据副本问题排查指南,但是文章中的错误描述信息比较完全,输出了 table_id,但我的错误信息中没有 table_id,无法参照该文章进行修复操作。我只知道出问题的表名,但不知道如何根据表名获取文章中的 table_id。help……
完整报错:
Traceback (most recent call last):
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\connectors\asyncio.py", line 230, in execute
self._adapt_connection._handle_exception(error)
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\dialects\mysql\asyncmy.py", line 91, in _handle_exception
raise error
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\connectors\asyncio.py", line 228, in execute
return self.await_(self._execute_async(operation, parameters))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 132, in await_only
return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 196, in greenlet_spawn
value = await result
^^^^^^^^^^^^
File "C:\Users\2222\AppData\Local\pypoetry\Cache\virtualenvs\project-_EhlPfZM-py3.11\Lib\site-packages\sqlalchemy\connectors\asyncio.py", line 251, in _execute_async
result = await self._cursor.execute(operation, parameters)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "asyncmy\\cursors.pyx", line 179, in execute
File "asyncmy\\cursors.pyx", line 364, in _query
File "asyncmy\\connection.pyx", line 496, in query
File "asyncmy\\connection.pyx", line 684, in _read_query_result
File "asyncmy\\connection.pyx", line 1071, in read
File "asyncmy\\connection.pyx", line 646, in read_packet
File "asyncmy\\protocol.pyx", line 190, in asyncmy.protocol.MysqlPacket.raise_for_error
File "asyncmy\\protocol.pyx", line 194, in asyncmy.protocol.MysqlPacket.raise_for_error
File "asyncmy\\errors.pyx", line 128, in asyncmy.errors.raise_mysql_exception
File "asyncmy\\errors.pyx", line 137, in asyncmy.errors.raise_mysql_exception
asyncmy.errors.OperationalError: (1105, 'errCode = 2, detailMessage = (192.168.5.69)[INTERNAL_ERROR]fail to find path in version_graph. spec_version: 0-138778')