The oracle catalog mode is abnormal or the metadata synchronization of the FE node is abnormal #49071

koooolllll · 2025-03-14T06:33:27Z

koooolllll
Mar 14, 2025

The oracle catalog mode is abnormal or the metadata synchronization of the FE node is abnormal

Machine environment: 3 * FE + 3 * BE,
Database version: doris-2.0.11,

Description: When linking Oracle using the catalog method, the following situation occurred: The FE of the master node and one of the slave nodes have no issues and can be used normally, but the other slave node cannot use the created catalog.

And it will prompt the following content:

1105 - errCode = 2, detailMessage = Unexpected exception: org.apache.doris.datasource.jdbc.client.JdbcClientException: Can not connect to jdbc due to error: ORA-01005: null password given; logon denied

https://docs.oracle.com/error-help/db/ora-01005/, Catalog name: smom_db

And I'm pretty sure there's nothing abnormal between the master node and the other slave node!

The catalog creation statement used is as follows:

CREATE CATALOG smom_db PROPERTIES (
    "type"="jdbc",
    "user"="dw_catalog_readonly",
    "password"="xxxxxxxx",
    "jdbc_url" = "jdbc:oracle:thin:@//172.16.200.24:1521/SMOMDB",
    "driver_url" = "ojdbc8.jar",
    "driver_class" = "oracle.jdbc.driver.OracleDriver"
)

View the log information of the abnormal FE node as follows:

2025-03-14 13:41:59,734 WARN (mysql-nio-pool-1008|7500) [StmtExecutor.analyze():1077] Analyze failed. stmt[5667, 892745e7ec8e44e6-9da3eaf92d53a0fe]
com.google.common.util.concurrent.UncheckedExecutionException: org.apache.doris.datasource.jdbc.client.JdbcClientException: Can not connect to jdbc due to error: ORA-01005: null password given; logon denied

https://docs.oracle.com/error-help/db/ora-01005/, Catalog name: smom_db
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2086) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache.get(LocalCache.java:4012) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4035) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5013) ~[guava-32.1.2-jre.jar:?]
	at org.apache.doris.datasource.ExternalSchemaCache.getSchema(ExternalSchemaCache.java:90) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.catalog.external.ExternalTable.getFullSchema(ExternalTable.java:241) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.catalog.external.ExternalTable.getBaseSchema(ExternalTable.java:246) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.analysis.SelectStmt.expandStar(SelectStmt.java:1230) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.analysis.SelectStmt.expandStar(SelectStmt.java:1199) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.analysis.SelectStmt.analyze(SelectStmt.java:564) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1152) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1060) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:735) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:507) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:475) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:429) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:577) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:846) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_131]
Caused by: org.apache.doris.datasource.jdbc.client.JdbcClientException: Can not connect to jdbc due to error: ORA-01005: null password given; logon denied

https://docs.oracle.com/error-help/db/ora-01005/, Catalog name: smom_db
	at org.apache.doris.datasource.jdbc.client.JdbcClient.getConnection(JdbcClient.java:179) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.jdbc.client.JdbcOracleClient.getJdbcColumnsInfo(JdbcOracleClient.java:101) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.jdbc.client.JdbcClient.getColumnsFromJdbc(JdbcClient.java:353) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.catalog.external.JdbcExternalTable.initSchema(JdbcExternalTable.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.catalog.external.ExternalTable.initSchemaAndUpdateTime(ExternalTable.java:379) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalCatalog.getSchema(ExternalCatalog.java:315) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache.loadSchema(ExternalSchemaCache.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache.access$000(ExternalSchemaCache.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache$1.load(ExternalSchemaCache.java:61) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache$1.load(ExternalSchemaCache.java:58) ~[doris-fe.jar:1.2-SNAPSHOT]
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3571) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2313) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2190) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2080) ~[guava-32.1.2-jre.jar:?]
	... 21 more
Caused by: java.sql.SQLException: ORA-01005: null password given; logon denied

https://docs.oracle.com/error-help/db/ora-01005/
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:712) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:607) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:602) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1695) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:936) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:969) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:547) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTHWithO5Logon(T4CTTIoauthenticate.java:1746) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1493) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1433) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CConnection.authenticateWithPassword(T4CConnection.java:2056) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CConnection.authenticateUserForLogon(T4CConnection.java:1993) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:1086) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1158) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:106) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:895) ~[ojdbc8.jar:23.6.0.24.10]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:702) ~[ojdbc8.jar:23.6.0.24.10]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:112) ~[HikariCP-java7-2.4.13.jar:?]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97) ~[HikariCP-java7-2.4.13.jar:?]
	at org.apache.doris.datasource.jdbc.client.JdbcClient.getConnection(JdbcClient.java:175) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.jdbc.client.JdbcOracleClient.getJdbcColumnsInfo(JdbcOracleClient.java:101) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.jdbc.client.JdbcClient.getColumnsFromJdbc(JdbcClient.java:353) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.catalog.external.JdbcExternalTable.initSchema(JdbcExternalTable.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.catalog.external.ExternalTable.initSchemaAndUpdateTime(ExternalTable.java:379) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalCatalog.getSchema(ExternalCatalog.java:315) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache.loadSchema(ExternalSchemaCache.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache.access$000(ExternalSchemaCache.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache$1.load(ExternalSchemaCache.java:61) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.datasource.ExternalSchemaCache$1.load(ExternalSchemaCache.java:58) ~[doris-fe.jar:1.2-SNAPSHOT]
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3571) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2313) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2190) ~[guava-32.1.2-jre.jar:?]
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2080) ~[guava-32.1.2-jre.jar:?]
	... 21 more
2025-03-14 13:41:59,737 WARN (mysql-nio-pool-1008|7500) [StmtExecutor.executeByLegacy():844] execute Exception. stmt[5667, 892745e7ec8e44e6-9da3eaf92d53a0fe]
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Unexpected exception: org.apache.doris.datasource.jdbc.client.JdbcClientException: Can not connect to jdbc due to error: ORA-01005: null password given; logon denied

https://docs.oracle.com/error-help/db/ora-01005/, Catalog name: smom_db
	at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1078) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:735) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:507) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:475) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:429) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:577) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:846) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_131]

I also checked the metadata version of each FE node and found that there was no difference between them.

This is information from a normal FE node

This is information from an abnormal FE node

This is the information about a normal FE master node

Next, I checked the version of the jdbc driver in the FE node server. Of course, in order to ensure that the jdbc driver is not different, I also uploaded a new jdbc driver.

However, I found other anomalies in the "warn" log of the FE node in question, I am not sure if it is related to this.

Below is the warn log for this node:

fe.warn.log

yuanyuan8983 · 2025-03-19T12:03:37Z

yuanyuan8983
Mar 19, 2025

This issue appears to have been fixed, and it is recommended that you upgrade to apache doris version 2.1.8.

1 reply

koooolllll Mar 25, 2025
Author

Thank you. I'll give it a try.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

The oracle catalog mode is abnormal or the metadata synchronization of the FE node is abnormal #49071

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 1 reply

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

The oracle catalog mode is abnormal or the metadata synchronization of the FE node is abnormal #49071

Uh oh!

koooolllll Mar 14, 2025

Replies: 1 comment · 1 reply

Uh oh!

yuanyuan8983 Mar 19, 2025

Uh oh!

koooolllll Mar 25, 2025 Author

koooolllll
Mar 14, 2025

Replies: 1 comment 1 reply

yuanyuan8983
Mar 19, 2025

koooolllll Mar 25, 2025
Author