求助:集群挂掉后,针对某张表的所有查询都报错:INTERNAL_ERROR fail to find path in version_graph. spec_version: 0-138778

Viewed 11

版本: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')
1 Answers

到 192.168.5.69 这个节点上搜这个关键日志,然后看看上下文,有没有 tablet_id 的信息。