Advertisement
Guest User

Untitled

a guest
Sep 11th, 2017
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.01 KB | None | 0 0
  1. ebyhr:~ ebyhr$ embulk run config.yml -X max_threads=1 -X min_output_tasks=1
  2. 2017-09-11 21:13:25.139 +0900: Embulk v0.8.32
  3. 2017-09-11 21:13:29.671 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-randomj (0.2.0)
  4. 2017-09-11 21:13:29.706 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-teradata (0.1.3)
  5. 2017-09-11 21:13:29.753 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=1 / tasks=1
  6. 2017-09-11 21:13:29.777 +0900 [INFO] (0001:transaction): Connecting to jdbc:teradata://wbtlabserver.teradata.com options {user=YE186001}
  7. 2017-09-11 21:13:30.972 +0900 [INFO] (0001:transaction): Using JDBC Driver 15.10.00.33
  8. 2017-09-11 21:13:30.972 +0900 [INFO] (0001:transaction): Using replace mode
  9. 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)
  10. 2017-09-11 21:13:31.613 +0900 [INFO] (0001:transaction): > 0.19 seconds
  11. 2017-09-11 21:13:33.927 +0900 [INFO] (0001:transaction): {done: 0 / 1, running: 0}
  12. 2017-09-11 21:13:33.954 +0900 [INFO] (0016:task-0000): Connecting to jdbc:teradata://wbtlabserver.teradata.com options {user=YE186001}
  13. 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 (?, ?, ?, ?, ?)
  14. 2017-09-11 21:13:35.346 +0900 [INFO] (0016:task-0000): Loading 60,000 rows
  15. 2017-09-11 21:13:49.958 +0900 [ERROR] (0016:task-0000): Operation failed (1338:HY000)
  16. 2017-09-11 21:13:50.235 +0900 [INFO] (0001:transaction): {done: 1 / 1, running: 0}
  17. 2017-09-11 21:13:50.243 +0900 [INFO] (0001:cleanup): Connecting to jdbc:teradata://wbtlabserver.teradata.com options {user=YE186001}
  18. 2017-09-11 21:13:51.139 +0900 [INFO] (0001:cleanup): SQL: SELECT COUNT(1) FROM "YE186001.t2_de91e3834c0_bl_tmp"
  19. 2017-09-11 21:13:51.406 +0900 [INFO] (0001:cleanup): > 0.27 seconds (1 rows)
  20. 2017-09-11 21:13:51.407 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "YE186001.t2_de91e3834c0_bl_tmp"
  21. 2017-09-11 21:13:51.628 +0900 [INFO] (0001:cleanup): > 0.22 seconds (19 rows)
  22. 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.
  23. at org.embulk.exec.BulkLoader$LoaderState.buildPartialExecuteException(BulkLoader.java:375)
  24. at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:607)
  25. at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:35)
  26. at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:391)
  27. at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:387)
  28. at org.embulk.spi.Exec.doWith(Exec.java:25)
  29. at org.embulk.exec.BulkLoader.run(BulkLoader.java:387)
  30. at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:180)
  31. at org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:337)
  32. at org.embulk.EmbulkRunner.run(EmbulkRunner.java:174)
  33. at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:467)
  34. at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:99)
  35. at org.embulk.cli.Main.main(Main.java:28)
  36. 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.
  37. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput.finish(AbstractJdbcOutputPlugin.java:1073)
  38. at org.embulk.spi.PageBuilder.finish(PageBuilder.java:264)
  39. at org.embulk.input.randomj.RandomjInputPlugin.run(RandomjInputPlugin.java:95)
  40. at org.embulk.spi.util.Executors.process(Executors.java:67)
  41. at org.embulk.spi.util.Executors.process(Executors.java:42)
  42. at org.embulk.exec.LocalExecutorPlugin$DirectExecutor$1.call(LocalExecutorPlugin.java:184)
  43. at org.embulk.exec.LocalExecutorPlugin$DirectExecutor$1.call(LocalExecutorPlugin.java:180)
  44. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  45. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  46. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  47. at java.lang.Thread.run(Thread.java:748)
  48. 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.
  49. at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(ErrorFactory.java:149)
  50. at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(ErrorFactory.java:138)
  51. at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeBatchDMLArray(TDPreparedStatement.java:270)
  52. at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeBatch(TDPreparedStatement.java:2659)
  53. at org.embulk.output.jdbc.StandardBatchInsert.flush(StandardBatchInsert.java:75)
  54. at org.embulk.output.jdbc.StandardBatchInsert.finish(StandardBatchInsert.java:88)
  55. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput$4.run(AbstractJdbcOutputPlugin.java:1066)
  56. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1160)
  57. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1148)
  58. at org.embulk.spi.util.RetryExecutor.run(RetryExecutor.java:100)
  59. at org.embulk.spi.util.RetryExecutor.runInterruptible(RetryExecutor.java:77)
  60. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1133)
  61. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1125)
  62. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput.finish(AbstractJdbcOutputPlugin.java:1062)
  63. ... 10 more
  64. 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.
  65. at com.teradata.jdbc.jdbc_4.util.ErrorFactory.cloneJDBCException(ErrorFactory.java:171)
  66. at com.teradata.jdbc.jdbc_4.statemachine.PreparedBatchStatementController.handleRunException(PreparedBatchStatementController.java:95)
  67. at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:145)
  68. at com.teradata.jdbc.jdbc_4.statemachine.PreparedBatchStatementController.run(PreparedBatchStatementController.java:58)
  69. at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:389)
  70. at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeBatchDMLArray(TDPreparedStatement.java:250)
  71. ... 21 more
  72.  
  73. 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.
  74. ebyhr:~ ebyhr$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement