为了更快的定位您的问题,请提供以下信息,谢谢
【详述】查询A库的表报错B库不存在
【背景】做过哪些操作?
【业务影响】
【是否存算分离】
【StarRocks版本】例如:2.5.22 (由2.3.2升级至2.5.22)
【集群规模】例如:1fe()+1be(fe与be混部)单节点
【机器信息】
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息,请补充下您的联系方式,例如:社区群17-林哥小子或者邮箱,谢谢
【附件】
- fe.log/beINFO/相应截图
- 慢查询:
- Profile信息
- 并行度:show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启:show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错:
- query_dump,怎么获取query_dump文件
- be crash
- be.out
- 外表查询报错
- be.out和fe.warn.log
执行A库的表的查询老是报B库不存在
mysql> select * from hw_db.as_financing_apply limit 1 ;
ERROR 1064 (HY000): mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
fe.log -----------------------
2024-10-16 10:59:34,433 INFO (starrocks-mysql-nio-pool-8|268) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: ac3df3ca-8b6a-11ef-8450-005056827f66
2024-10-16 10:59:34,434 INFO (starrocks-mysql-nio-pool-8|268) [QeProcessorImpl.registerQuery():83] register query id = ac3df3ca-8b6a-11ef-8450-005056827f66, job: -1
2024-10-16 10:59:34,438 WARN (thrift-server-pool-3|140) [Coordinator.updateFragmentExecStatus():2528] exec state report failed status=errorCode INTERNAL_ERROR mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’, query_id=ac3df3ca-8b6a-11ef-8450-005056827f66, instance_id=ac3df3ca-8b6a-11ef-8450-005056827f67
2024-10-16 10:59:34,438 WARN (thrift-server-pool-3|140) [Coordinator.updateStatus():1564] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: ac3df3ca-8b6a-11ef-8450-005056827f66, instance id: ac3df3ca-8b6a-11ef-8450-005056827f67
2024-10-16 10:59:34,438 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.getNext():1584] get next fail, need cancel. status errorCode INTERNAL_ERROR mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’, query id: ac3df3ca-8b6a-11ef-8450-005056827f66
2024-10-16 10:59:34,438 INFO (thrift-server-pool-3|140) [Coordinator.cancelInternal():1678] unfinished instance: ac3df3ca-8b6a-11ef-8450-005056827f67
2024-10-16 10:59:34,438 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.getNext():1605] query failed: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
2024-10-16 10:59:34,438 INFO (starrocks-mysql-nio-pool-8|268) [QeProcessorImpl.unregisterQuery():93] deregister query id ac3df3ca-8b6a-11ef-8450-005056827f66
2024-10-16 10:59:34,438 INFO (starrocks-mysql-nio-pool-8|268) [StmtExecutor.execute():605] execute Exception, sql: /* ApplicationName=DBeaver 22.3.5 - Main */ select * from hw_db.as_financing_apply limit 1
, error: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
2024-10-16 10:59:34,438 INFO (starrocks-mysql-nio-pool-8|268) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: ac3df3ca-8b6a-11ef-8450-005056827f66
fe.WARN.log -----------------------
2024-10-16 10:59:14,820 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.getNext():1584] get next fail, need cancel. status errorCode INTERNAL_ERROR mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’, query id: a08cc9c4-8b6a-11ef-8450-005056827f66
2024-10-16 10:59:14,820 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.updateStatus():1564] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: a08cc9c4-8b6a-11ef-8450-005056827f66, instance id: NaN
2024-10-16 10:59:14,821 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.getNext():1605] query failed: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
2024-10-16 10:59:14,821 WARN (thrift-server-pool-3|140) [Coordinator.updateFragmentExecStatus():2528] exec state report failed status=errorCode INTERNAL_ERROR mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’, query_id=a08cc9c4-8b6a-11ef-8450-005056827f66, instance_id=a08cc9c4-8b6a-11ef-8450-005056827f67
2024-10-16 10:59:34,438 WARN (thrift-server-pool-3|140) [Coordinator.updateFragmentExecStatus():2528] exec state report failed status=errorCode INTERNAL_ERROR mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’, query_id=ac3df3ca-8b6a-11ef-8450-005056827f66, instance_id=ac3df3ca-8b6a-11ef-8450-005056827f67
2024-10-16 10:59:34,438 WARN (thrift-server-pool-3|140) [Coordinator.updateStatus():1564] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: ac3df3ca-8b6a-11ef-8450-005056827f66, instance id: ac3df3ca-8b6a-11ef-8450-005056827f67
2024-10-16 10:59:34,438 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.getNext():1584] get next fail, need cancel. status errorCode INTERNAL_ERROR mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’, query id: ac3df3ca-8b6a-11ef-8450-005056827f66
2024-10-16 10:59:34,438 WARN (starrocks-mysql-nio-pool-8|268) [Coordinator.getNext():1605] query failed: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’