Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ebyhr:~ ebyhr$ embulk run config.yml -X max_threads=1 -X min_output_tasks=1
- 2017-09-11 21:13:25.139 +0900: Embulk v0.8.32
- 2017-09-11 21:13:29.671 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-randomj (0.2.0)
- 2017-09-11 21:13:29.706 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-teradata (0.1.3)
- 2017-09-11 21:13:29.753 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=1 / tasks=1
- 2017-09-11 21:13:29.777 +0900 [INFO] (0001:transaction): Connecting to jdbc:teradata://wbtlabserver.teradata.com options {user=YE186001}
- 2017-09-11 21:13:30.972 +0900 [INFO] (0001:transaction): Using JDBC Driver 15.10.00.33
- 2017-09-11 21:13:30.972 +0900 [INFO] (0001:transaction): Using replace mode
- 2017-09-11 21:13:31.424 +0900 [INFO] (0001:transaction): SQL: CREATE MULTISET TABLE "YE186001.t2_de91e3834c0_bl_tmp" ("id" BIGINT, "account" BIGINT, "time" BIGINT, "purchase" BIGINT, "comment" BIGINT)
- 2017-09-11 21:13:31.613 +0900 [INFO] (0001:transaction): > 0.19 seconds
- 2017-09-11 21:13:33.927 +0900 [INFO] (0001:transaction): {done: 0 / 1, running: 0}
- 2017-09-11 21:13:33.954 +0900 [INFO] (0016:task-0000): Connecting to jdbc:teradata://wbtlabserver.teradata.com options {user=YE186001}
- 2017-09-11 21:13:34.839 +0900 [INFO] (0016:task-0000): Prepared SQL: INSERT INTO "YE186001.t2_de91e3834c0_bl_tmp" ("id", "account", "time", "purchase", "comment") VALUES (?, ?, ?, ?, ?)
- 2017-09-11 21:13:35.346 +0900 [INFO] (0016:task-0000): Loading 60,000 rows
- 2017-09-11 21:13:49.958 +0900 [ERROR] (0016:task-0000): Operation failed (1338:HY000)
- 2017-09-11 21:13:50.235 +0900 [INFO] (0001:transaction): {done: 1 / 1, running: 0}
- 2017-09-11 21:13:50.243 +0900 [INFO] (0001:cleanup): Connecting to jdbc:teradata://wbtlabserver.teradata.com options {user=YE186001}
- 2017-09-11 21:13:51.139 +0900 [INFO] (0001:cleanup): SQL: SELECT COUNT(1) FROM "YE186001.t2_de91e3834c0_bl_tmp"
- 2017-09-11 21:13:51.406 +0900 [INFO] (0001:cleanup): > 0.27 seconds (1 rows)
- 2017-09-11 21:13:51.407 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "YE186001.t2_de91e3834c0_bl_tmp"
- 2017-09-11 21:13:51.628 +0900 [INFO] (0001:cleanup): > 0.22 seconds (19 rows)
- org.embulk.exec.PartialExecutionException: java.lang.RuntimeException: java.sql.BatchUpdateException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.33] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.
- at org.embulk.exec.BulkLoader$LoaderState.buildPartialExecuteException(BulkLoader.java:375)
- at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:607)
- at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:35)
- at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:391)
- at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:387)
- at org.embulk.spi.Exec.doWith(Exec.java:25)
- at org.embulk.exec.BulkLoader.run(BulkLoader.java:387)
- at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:180)
- at org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:337)
- at org.embulk.EmbulkRunner.run(EmbulkRunner.java:174)
- at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:467)
- at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:99)
- at org.embulk.cli.Main.main(Main.java:28)
- Caused by: java.lang.RuntimeException: java.sql.BatchUpdateException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.33] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput.finish(AbstractJdbcOutputPlugin.java:1073)
- at org.embulk.spi.PageBuilder.finish(PageBuilder.java:264)
- at org.embulk.input.randomj.RandomjInputPlugin.run(RandomjInputPlugin.java:95)
- at org.embulk.spi.util.Executors.process(Executors.java:67)
- at org.embulk.spi.util.Executors.process(Executors.java:42)
- at org.embulk.exec.LocalExecutorPlugin$DirectExecutor$1.call(LocalExecutorPlugin.java:184)
- at org.embulk.exec.LocalExecutorPlugin$DirectExecutor$1.call(LocalExecutorPlugin.java:180)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: java.sql.BatchUpdateException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.33] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.
- at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(ErrorFactory.java:149)
- at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(ErrorFactory.java:138)
- at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeBatchDMLArray(TDPreparedStatement.java:270)
- at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeBatch(TDPreparedStatement.java:2659)
- at org.embulk.output.jdbc.StandardBatchInsert.flush(StandardBatchInsert.java:75)
- at org.embulk.output.jdbc.StandardBatchInsert.finish(StandardBatchInsert.java:88)
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput$4.run(AbstractJdbcOutputPlugin.java:1066)
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1160)
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1148)
- at org.embulk.spi.util.RetryExecutor.run(RetryExecutor.java:100)
- at org.embulk.spi.util.RetryExecutor.runInterruptible(RetryExecutor.java:77)
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1133)
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1125)
- at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput.finish(AbstractJdbcOutputPlugin.java:1062)
- ... 10 more
- Caused by: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.33] [Error 5966] [SQLState HY000] Too many data records packed in one USING row.
- at com.teradata.jdbc.jdbc_4.util.ErrorFactory.cloneJDBCException(ErrorFactory.java:171)
- at com.teradata.jdbc.jdbc_4.statemachine.PreparedBatchStatementController.handleRunException(PreparedBatchStatementController.java:95)
- at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:145)
- at com.teradata.jdbc.jdbc_4.statemachine.PreparedBatchStatementController.run(PreparedBatchStatementController.java:58)
- at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:389)
- at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeBatchDMLArray(TDPreparedStatement.java:250)
- ... 21 more
- Error: java.lang.RuntimeException: java.sql.BatchUpdateException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.33] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.
- ebyhr:~ ebyhr$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement