Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] The catalog can't be search #49177

Open
2 of 3 tasks
QQxiaoyuyu opened this issue Mar 18, 2025 · 1 comment
Open
2 of 3 tasks

[Bug] The catalog can't be search #49177

QQxiaoyuyu opened this issue Mar 18, 2025 · 1 comment

Comments

@QQxiaoyuyu
Copy link

Search before asking

  • I had searched in the issues 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

@zy-kkk
Copy link
Member

zy-kkk commented Mar 18, 2025

Upgrading to 2.1.8.1 can be fixed
https://github.com/apache/doris/releases/tag/2.1.8.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants