1 2024-01-10 13:48:59 [INFO] No Sys user setting, connectionId=33 2 2024-01-10 13:48:59 [INFO] Querying table metadata. This might take a while... 3 2024-01-10 13:49:02 [INFO] Found 2 empty tables before executing.... Elapsed: 38.55 ms 4 2024-01-10 13:49:02 [INFO] Begin transferring schema 5 2024-01-10 13:49:02 [INFO] Generate 1 dump tasks finished. Total Elapsed: 2.272 ms 6 2024-01-10 13:49:02 [INFO] Start 3 schema dump threads for 1 dump tasks finished. 7 2024-01-10 13:49:02 [INFO] Return the latest compatible version: 4.2.1.2 -> 4.0.0.0 8 2024-01-10 13:49:02 [INFO] Dump create objects success. DbType: OBMYSQL Version: 4.2.1.2 9 2024-01-10 13:49:02 [INFO] ObMySql(4.2.1.2) is older than 4.0 ? false 10 2024-01-10 13:49:02 [WARN] ClassLoad load: "meta/obmysql/obmysql14x.xml" as system resource is null 11 2024-01-10 13:49:02 [WARN] ClassLoad load: "meta/obmysql/obmysql22x.xml" as system resource is null 12 2024-01-10 13:49:02 [WARN] ClassLoad load: "meta/obmysql/obmysql2271.xml" as system resource is null 13 2024-01-10 13:49:02 [WARN] ClassLoad load: "meta/obmysql/obmysql3230.xml" as system resource is null 14 2024-01-10 13:49:02 [WARN] ClassLoad load: "meta/obmysql/obmysql40x.xml" as system resource is null 15 2024-01-10 13:49:02 [INFO] Load meta/obmysql/obmysql14x.xml, meta/obmysql/obmysql22x.xml, meta/obmysql/obmysql2271.xml, meta/obmysql/obmysql3230.xml, meta/obmysql/obmysql40x.xml successed 16 2024-01-10 13:49:02 [INFO] Query 5 dependencies elapsed 77.56 ms 17 2024-01-10 13:49:06 [ERROR] SQL: SELECT 18 C.CONSTRAINT_NAME AS CONSTRAINT_NAME, 19 K.COLUMN_NAME AS COLUMN_NAME, 20 K.ORDINAL_POSITION AS ORDINAL_POSITION, 21 K.REFERENCED_TABLE_SCHEMA AS REFERENCED_TABLE_SCHEMA, 22 K.REFERENCED_TABLE_NAME AS REFERENCED_TABLE_NAME, 23 K.REFERENCED_COLUMN_NAME AS REFERENCED_COLUMN_NAME, 24 K.POSITION_IN_UNIQUE_CONSTRAINT AS POSITION_IN_UNIQUE_CONSTRAINT, 25 R.UPDATE_RULE AS UPDATE_RULE, 26 R.DELETE_RULE AS DELETE_RULE 27 FROM information_schema.TABLE_CONSTRAINTS AS C, 28 information_schema.KEY_COLUMN_USAGE AS K, 29 information_schema.REFERENTIAL_CONSTRAINTS AS R 30 WHERE C.TABLE_SCHEMA=K.TABLE_SCHEMA AND C.TABLE_NAME=K.TABLE_NAME AND C.TABLE_NAME=R.TABLE_NAME 31 AND R.CONSTRAINT_SCHEMA=K.REFERENCED_TABLE_SCHEMA AND R.REFERENCED_TABLE_NAME=K.REFERENCED_TABLE_NAME 32 AND K.CONSTRAINT_NAME=C.CONSTRAINT_NAME AND R.CONSTRAINT_NAME=C.CONSTRAINT_NAME 33 AND C.CONSTRAINT_TYPE='FOREIGN KEY' AND C.TABLE_SCHEMA=? AND C.TABLE_NAME=? 34 java.sql.SQLTransientConnectionException: (conn=1277906) No memory or reach tenant memory limit 35 at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.7.1.jar!/:?] 36 at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.7.1.jar!/:?] 37 at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:318) ~[oceanbase-client-2.4.7.1.jar!/:?] 38 at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1040) ~[oceanbase-client-2.4.7.1.jar!/:?] 39 at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.execute(JDBC4ServerPreparedStatement.java:998) ~[oceanbase-client-2.4.7.1.jar!/:?] 40 at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeQuery(JDBC4ServerPreparedStatement.java:938) ~[oceanbase-client-2.4.7.1.jar!/:?] 41 at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213) ~[druid-1.2.18.jar!/:?] 42 at com.oceanbase.tools.loaddump.jdbc.JdbcExecutor.queryMap(JdbcExecutor.java:138) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 43 at com.oceanbase.tools.loaddump.jdbc.JdbcTemplate.queryMap(JdbcTemplate.java:149) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 44 at com.oceanbase.tools.loaddump.schema.accessor.ObMySqlMetadataAccessor.queryForeignMapping(ObMySqlMetadataAccessor.java:1598) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 45 at com.oceanbase.tools.loaddump.schema.accessor.ObMySqlMetadataAccessor.lambda$queryTableMapping$12(ObMySqlMetadataAccessor.java:617) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 46 at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_292] 47 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_292] 48 at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_292] 49 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292] 50 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292] 51 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292] 52 Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: No memory or reach tenant memory limit 53 at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.7.1.jar!/:?] 54 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:206) ~[oceanbase-client-2.4.7.1.jar!/:?] 55 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:187) ~[oceanbase-client-2.4.7.1.jar!/:?] 56 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:545) ~[oceanbase-client-2.4.7.1.jar!/:?] 57 at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1022) ~[oceanbase-client-2.4.7.1.jar!/:?] 58 ... 13 more 59 Caused by: java.sql.SQLException: No memory or reach tenant memory limit 60 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2364) ~[oceanbase-client-2.4.7.1.jar!/:?] 61 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2227) ~[oceanbase-client-2.4.7.1.jar!/:?] 62 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2115) ~[oceanbase-client-2.4.7.1.jar!/:?] 63 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:542) ~[oceanbase-client-2.4.7.1.jar!/:?] 64 at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1022) ~[oceanbase-client-2.4.7.1.jar!/:?] 65 ... 13 more 66 2024-01-10 13:49:06 [INFO] shutdown task context finished 67 2024-01-10 13:49:06 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 68 2024-01-10 13:49:06 [INFO] 69 70 All Dump Tasks Finished: 71 72 ---------------------------------------------------------------------------------------------------------------------------- 73 No.# | Type | Name | Count | Status 74 ---------------------------------------------------------------------------------------------------------------------------- 75 76 77 Nothing was done! 78 79 ---------------------------------------------------------------------------------------------------------------------------- 80 81 Total Count: 0 End Time: 2024-01-10 13:49:06 82 83 84 2024-01-10 13:49:06 [WARN] Failed to execute data transfer task 85 java.lang.IllegalStateException: sdw.null: No memory or reach tenant memory limit 86 at com.oceanbase.odc.service.datatransfer.task.BaseDataTransferTask.syncWaitFinished(BaseDataTransferTask.java:182) ~[odc-service-4.2.2-20231124.jar!/:?] 87 at com.oceanbase.odc.service.datatransfer.task.BaseDataTransferTask.call(BaseDataTransferTask.java:133) ~[odc-service-4.2.2-20231124.jar!/:?] 88 at com.oceanbase.odc.service.datatransfer.task.BaseDataTransferTask.call(BaseDataTransferTask.java:52) ~[odc-service-4.2.2-20231124.jar!/:?] 89 at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_292] 90 at com.oceanbase.odc.common.trace.TraceDecorator.lambda$decorate$0(TraceDecorator.java:40) ~[odc-common-4.2.2-20231124.jar!/:?] 91 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292] 92 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292] 93 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292] 94 2024-01-10 13:49:07 [ERROR] SQL: SELECT 95 NON_UNIQUE, 96 INDEX_SCHEMA, 97 INDEX_NAME, 98 SEQ_IN_INDEX, 99 COLUMN_NAME, 100 COLLATION, 101 -- CARDINALITY, 102 SUB_PART, 103 -- PACKED, 104 -- NULLABLE, 105 INDEX_TYPE, 106 -- COMMENT, 107 INDEX_COMMENT, 108 IS_VISIBLE 109 FROM information_schema.STATISTICS S 110 WHERE TABLE_SCHEMA=? AND TABLE_NAME=? AND 111 NOT EXISTS (SELECT 1 FROM information_schema.TABLE_CONSTRAINTS C WHERE S.TABLE_SCHEMA=C.TABLE_SCHEMA AND S.TABLE_NAME=C.TABLE_NAME AND S.INDEX_NAME=C.CONSTRAINT_NAME AND CONSTRAINT_TYPE NOT IN ('CHECK','FOREIGN KEY')) 112 ORDER BY INDEX_NAME ASC, SEQ_IN_INDEX ASC 113 java.lang.IllegalStateException: SessionManager is not initialized 114 at com.google.common.base.Preconditions.checkState(Preconditions.java:502) ~[guava-31.1-jre.jar!/:?] 115 at com.oceanbase.tools.loaddump.manager.session.SessionManager.getPooledBizConnection(SessionManager.java:165) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 116 at com.oceanbase.tools.loaddump.jdbc.JdbcTemplate.queryMap(JdbcTemplate.java:148) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 117 at com.oceanbase.tools.loaddump.schema.accessor.ObMySqlMetadataAccessor.queryIndexes(ObMySqlMetadataAccessor.java:1187) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 118 at com.oceanbase.tools.loaddump.schema.accessor.ObMySqlMetadataAccessor.queryIndexMappingV4(ObMySqlMetadataAccessor.java:1278) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 119 at com.oceanbase.tools.loaddump.schema.accessor.ObMySqlMetadataAccessor.queryIndexMapping(ObMySqlMetadataAccessor.java:1176) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 120 at com.oceanbase.tools.loaddump.schema.accessor.ObMySqlMetadataAccessor.lambda$queryTableMapping$12(ObMySqlMetadataAccessor.java:618) ~[ob-loader-dumper-4.2.5-RELEASE.jar!/:?] 121 at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_292] 122 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_292] 123 at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_292] 124 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292] 125 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292] 126 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292] 127