mysql real connect failed. Err: Unknown database 'xxxxxx_tenant_T0000NBGF'

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】查询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和内存使用率截图
  • 查询报错:
  • 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’

be.WARNING 信息
W1016 11:07:26.743696 30733 mysql_scanner.cpp:69] connect Mysql: Host: X.X.X.X user: XXXXXX passwd: XXXXXX db: xxxxxx_tenant_T0000NBGF port: 3306
E1016 11:07:26.743745 30733 scan_operator.cpp:386] scan fragment c5c220fe-8b6b-11ef-8450-005056827f67 driver 0 Scan tasks error: Internal error: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
/build/starrocks/be/src/connector/mysql_connector.cpp:88 _mysql_scanner->open()
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:498 _data_source->open(state)
W1016 11:07:26.743824 30647 pipeline_driver.cpp:267] pull_chunk returns not ok status Internal error: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
/build/starrocks/be/src/connector/mysql_connector.cpp:88 _mysql_scanner->open()
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:498 _data_source->open(state)
/build/starrocks/be/src/exec/pipeline/scan/scan_operator.cpp:213 _get_scan_status()
W1016 11:07:26.743847 30647 pipeline_driver_executor.cpp:138] [Driver] Process error, query_id=c5c220fe-8b6b-11ef-8450-005056827f66, instance_id=c5c220fe-8b6b-11ef-8450-005056827f67, status=Internal error: mysql real connect failed. Err: Unknown database ‘xxxxxx_tenant_T0000NBGF’
/build/starrocks/be/src/connector/mysql_connector.cpp:88 _mysql_scanner->open()
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:498 _data_source->open(state)
/build/starrocks/be/src/exec/pipeline/scan/scan_operator.cpp:213 _get_scan_status()