huangdx0726 commented on PR #20207: URL: https://github.com/apache/shardingsphere/pull/20207#issuecomment-1216131015
> @huangdx0726 , scaling-it-test ran failed, the job status is `PREPARING_FAILURE`. Could you do some debug on local? > > Related exception: > > ``` > Error: 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: [ERROR] 2022-08-15 16:43:44.094 [Thread-20] o.a.s.d.p.s.migration.MigrationJob - job prepare failed, j0130317c3054317c7368617264696e675f6462-0 > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: org.apache.shardingsphere.data.pipeline.core.exception.PipelineJobPrepareFailedException: prepare target tables failed. > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.mysql.prepare.datasource.MySQLDataSourcePreparer.prepareTargetTables(MySQLDataSourcePreparer.java:55) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.core.prepare.PipelineJobPreparerUtils.prepareTargetTables(PipelineJobPreparerUtils.java:81) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.scenario.migration.MigrationJobPreparer.prepareTarget(MigrationJobPreparer.java:139) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.scenario.migration.MigrationJobPreparer.prepareAndCheckTarget(MigrationJobPreparer.java:117) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.scenario.migration.MigrationJobPreparer.prepareAndCheckTargetWithLock(MigrationJobPreparer.java:103) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.scenario.migration.MigrationJobPreparer.prepare(MigrationJobPreparer.java:68) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.scenario.migration.MigrationJob.prepare(MigrationJob.java:79) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.scenario.migration.MigrationJob.lambda$execute$0(MigrationJob.java:70) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at java.lang.Thread.run(Thread.java:748) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'scaling_it_4.t_order_0' doesn't exist > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.Util.getInstance(Util.java:408) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: pl.java:2491) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.driver.executor.callback.impl.StatementExecuteQueryCallback.executeQuery(StatementExecuteQueryCallback.java:40) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.driver.executor.callback.ExecuteQueryCallback.executeSQL(ExecuteQueryCallback.java:45) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.driver.executor.callback.ExecuteQueryCallback.executeSQL(ExecuteQueryCallback.java:37) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:95) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:75) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:135) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.parallelExecute(ExecutorEngine.java:131) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:116) > [INFO ] 2022-08-15 16:43:44.309 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:65) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:49) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.driver.executor.DriverJDBCExecutor.executeQuery(DriverJDBCExecutor.java:82) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.executeQuery0(ShardingSphereStatement.java:218) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.executeQuery(ShardingSphereStatement.java:169) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.mysql.ddlgenerator.MySQLCreateTableSQLGenerator.generate(MySQLCreateTableSQLGenerator.java:45) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.core.metadata.generator.PipelineDDLGenerator.generateActualDDLSQL(PipelineDDLGenerator.java:139) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.core.metadata.generator.PipelineDDLGenerator.generateLogicDDLSQL(PipelineDDLGenerator.java:89) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.mysql.prepare.datasource.MySQLDataSourcePreparer.getCreateTableSQL(MySQLDataSourcePreparer.java:71) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: at org.apache.shardingsphere.data.pipeline.mysql.prepare.datasource.MySQLDataSourcePreparer.prepareTargetTables(MySQLDataSourcePreparer.java:50) > [INFO ] 2022-08-15 16:43:44.310 [docker-java-stream--142075617] :ShardingSphere-Proxy - STDOUT: ... 8 common frames omitted > ``` ok， -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
