…省略1400多张表
2025-09-28 15:34:09 [INFO] Dump [TABLE] t_ds_sjfn_index_detail to "/tmp/wccy_20250928153405/data/sit_wccy/TABLE/t_ds_sjfn_index_detail-schema.sql " finished
2025-09-28 15:34:09 [INFO] Dump [TABLE] dm_tag_finance_org_month to "/tmp/wccy_20250928153405/data/sit_wccy/TABLE/dm_tag_finance_org_month-schema.sql " finished
2025-09-28 15:34:09 [INFO] Dump [TABLE] t_fill_finebi_dataset_blood_relationship_table to "/tmp/wccy_20250928153405/data/sit_wccy/TABLE/t_fill_finebi_dataset_blood_relationship_table-schema.sql " finished
2025-09-28 15:34:17 [INFO] ---------- Finished Tasks: 27 Running Tasks: 5 Progress: 84.00% ----------
2025-09-28 15:34:22 [INFO] ---------- Finished Tasks: 27 Running Tasks: 5 Progress: 84.00% ----------
2025-09-28 15:34:28 [INFO] ---------- Finished Tasks: 27 Running Tasks: 5 Progress: 84.00% ----------
…此处省略大量重复等待的信息，超时时间看起来是30min，问题是为什么show create table xxx能卡到超时。
2025-09-28 16:04:05 [INFO] ---------- Finished Tasks: 27 Running Tasks: 5 Progress: 84.00% ----------
2025-09-28 16:04:08 [INFO] ---------- Finished Tasks: 27 Running Tasks: 5 Progress: 84.00% ----------
2025-09-28 16:04:09 [ERROR] recycle error java.sql.SQLSyntaxErrorException: (conn=3941590) Connection.clearWarnings cannot be called on a closed connection
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:211) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.clearWarnings(OceanBaseConnection.java:1407) ~[oceanbase-client-2.4.11.jar:?]
at com.alibaba.druid.pool.DruidStatementConnection.clearWarnings(DruidStatementConnection.java:160) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.connection_clearWarnings(FilterChainImpl.java:152) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterAdapter.connection_clearWarnings(FilterAdapter.java:749) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.connection_clearWarnings(FilterChainImpl.java:147) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.clearWarnings(ConnectionProxyImpl.java:94) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:415) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:2085) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:343) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5063) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterAdapter.dataSource_releaseConnection(FilterAdapter.java:2753) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:5059) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidPooledConnection.syncClose(DruidPooledConnection.java:317) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:257) ~[druid-1.2.22.jar:?]
at com.oceanbase.tools.loaddump.jdbc.JdbcTemplate.query(JdbcTemplate.java:73) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.ObMysqlCompactSchemaDumpTask.queryTableGrammar(ObMysqlCompactSchemaDumpTask.java:75) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.ObMysqlCompactSchemaDumpTask.showCreateTableOrTableGroup(ObMysqlCompactSchemaDumpTask.java:63) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.ObMysqlCompactSchemaDumpTask.dumpSchema(ObMysqlCompactSchemaDumpTask.java:47) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.AbstractSchemaDumpTask.dumpCreateObjects(AbstractSchemaDumpTask.java:149) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.AbstractSchemaDumpTask.run(AbstractSchemaDumpTask.java:109) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_421]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_421]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_421]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_421]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_421]
2025-09-28 16:04:09 [ERROR] SQL: show create TABLE app_fk_panshi_cart_hg_index_m11m12_cm java.sql.SQLNonTransientConnectionException: (conn=3941590) Connection timed out
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:122) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:320) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1071) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.execute(JDBC4ServerPreparedStatement.java:1027) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeQuery(JDBC4ServerPreparedStatement.java:967) ~[oceanbase-client-2.4.11.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3241) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3238) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:175) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213) ~[druid-1.2.22.jar:?]
at com.oceanbase.tools.loaddump.jdbc.JdbcExecutor.query(JdbcExecutor.java:54) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.jdbc.JdbcTemplate.query(JdbcTemplate.java:72) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.ObMysqlCompactSchemaDumpTask.queryTableGrammar(ObMysqlCompactSchemaDumpTask.java:75) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.ObMysqlCompactSchemaDumpTask.showCreateTableOrTableGroup(ObMysqlCompactSchemaDumpTask.java:63) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.ObMysqlCompactSchemaDumpTask.dumpSchema(ObMysqlCompactSchemaDumpTask.java:47) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.AbstractSchemaDumpTask.dumpCreateObjects(AbstractSchemaDumpTask.java:149) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.dumper.task.schema.AbstractSchemaDumpTask.run(AbstractSchemaDumpTask.java:109) ~[ob-loader-dumper-4.3.3-RELEASE.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_421]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_421]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_421]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_421]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_421]
Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Connection timed out
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:204) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:187) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:546) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1053) ~[oceanbase-client-2.4.11.jar:?]
… 19 more
Caused by: java.sql.SQLNonTransientConnectionException: Read timed out
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2719) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readResultSet(AbstractQueryProtocol.java:2518) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2235) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2108) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:543) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1053) ~[oceanbase-client-2.4.11.jar:?]
… 19 more
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method) ~[?:1.8.0_421]
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[?:1.8.0_421]
at java.net.SocketInputStream.read(SocketInputStream.java:171) ~[?:1.8.0_421]
at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[?:1.8.0_421]
at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[?:1.8.0_421]
at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.readMysqlStream(StandardPacketInputStream.java:162) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:113) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ResultSet.getNextRow(JDBC4ResultSet.java:610) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ResultSet.addStreamingValue(JDBC4ResultSet.java:577) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ResultSet.fetchAllResults(JDBC4ResultSet.java:514) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ResultSet.(JDBC4ResultSet.java:238) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.com.read.resultset.SelectResultSet.(SelectResultSet.java:67) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readResultSet(AbstractQueryProtocol.java:2513) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2235) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2108) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:543) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1053) ~[oceanbase-client-2.4.11.jar:?]
… 19 more