完整的错误日志如下所示
E0104 10:14:18.028393 28810 olap_scan_node.cpp:92] Failed to start scan node: Internal error: [172.16.4.180] fail to prepare tablet reader 355082.2005414796.9c40d2c7e79127fd-9e2be154bf00e3b4: Not found: has missed versions
应用程序错误日志如下:
java.sql.SQLSyntaxErrorException: [172.16.4.180] fail to prepare tablet reader 510126.943131023.824b6d0942983c04-7ca73b4c60f2b9a4: Not found: has missed versions
由此可以定位到是172.16.4.180这台starrocks出现了问题。
出现这种情况一般是在开发环境,由于某台be挂了或重启后出现这个问题,现象为表打不开。
解决办法:
将这台be先剔除,再添加
先执行:
ALTER SYSTEM DROP BACKEND "be_ip:9050";
再执行:
ALTER SYSTEM ADD BACKEND "be_ip:9050";