QQxiaoyuyu opened a new issue, #49177: URL: https://github.com/apache/doris/issues/49177
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris version: 2.1.6 ### What's Wrong? sometimes our doris catalog can't be search. The client exception is follow: jdbc:mysql://192.168.1.100:9060/ex_public?useUnicode=true&useCompression=true&zeroDateTimeBehavior=CONVERT_TO_NULL&transformedBitIsBoolean=true&autoReconnect=true&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true SELECT T1.place_id place_id,T1.m_date m_date, round(IFNULL(T2.uv_showsuc/T1.v_show_suc,0)*100,4) uvrate_showsuc,round(IFNULL(T2.uv_click/T1.v_click,0)*100,4) uvrate_click from ( SELECT sum( v_show_suc ) v_show_suc, sum( v_click_u ) v_click , place_id,m_date FROM ex_dsp_pid_all_report_tidb WHERE m_date >= '2025-03-17' GROUP BY place_id, m_date ) T1 join jdbc_core.ex_public.report_place_user T2 on T1.place_id = T2.place_id and T1.m_date = T2.m_date ------------------------------------------------------------------------------ java.sql.SQLException: errCode = 2, detailMessage = Unexpected exception: No remote table found for table: report_place_user. Please refresh this catalog. CAUSE:null at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1198) at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110) at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) at easy.sql.Sql.executeQuery(Sql.java:113) at easy.sql.Sql.executeQuery(Sql.java:99) at com.tuiyi.body.SumData.updateData(SumData.java:466) at com.tuiyi.exec.SqlMain.main(SqlMain.java:337) ------------------------------------------------------------------------------ [2025-03-17 23:00:11]java.sql.SQLException: errCode = 2, detailMessage = Unexpected exception: No remote table found for table: report_place_user. Please refresh this catalog. CAUSE:null ### What You Expected? no ### How to Reproduce? I don't know how to reproduce ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
