Created
July 5, 2017 15:32
-
-
Save geoHeil/d20a3b2099546b66ae9d9a7bdc380d91 to your computer and use it in GitHub Desktop.
catch all exceptions
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 17/07/05 17:57:10 ERROR Executor: Exception in task 7.0 in stage 1.0 (TID 66) | |
| java.lang.IllegalStateException: Can't overwrite cause with java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at java.lang.Throwable.initCause(Throwable.java:457) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:612) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87) | |
| at org.apache.spark.scheduler.Task.run(Task.scala:99) | |
| at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:322) | |
| 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: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032) | |
| at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364) | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839) | |
| at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:597) | |
| ... 12 more | |
| 17/07/05 17:57:10 ERROR Executor: Exception in task 1.0 in stage 1.0 (TID 60) | |
| java.lang.IllegalStateException: Can't overwrite cause with java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at java.lang.Throwable.initCause(Throwable.java:457) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:612) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87) | |
| at org.apache.spark.scheduler.Task.run(Task.scala:99) | |
| at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:322) | |
| 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: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032) | |
| at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364) | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839) | |
| at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:597) | |
| ... 12 more | |
| 17/07/05 17:57:10 WARN TaskSetManager: Lost task 1.0 in stage 1.0 (TID 60, localhost, executor driver): java.lang.IllegalStateException: Can't overwrite cause with java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at java.lang.Throwable.initCause(Throwable.java:457) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:612) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87) | |
| at org.apache.spark.scheduler.Task.run(Task.scala:99) | |
| at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:322) | |
| 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: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032) | |
| at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364) | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839) | |
| at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:597) | |
| ... 12 more | |
| 17/07/05 17:57:10 ERROR TaskSetManager: Task 1 in stage 1.0 failed 1 times; aborting job | |
| 17/07/05 17:57:10 WARN TaskSetManager: Lost task 0.0 in stage 1.0 (TID 59, localhost, executor driver): TaskKilled (killed intentionally) | |
| 17/07/05 17:57:10 WARN TaskSetManager: Lost task 3.0 in stage 1.0 (TID 62, localhost, executor driver): TaskKilled (killed intentionally) | |
| 17/07/05 17:57:10 WARN TaskSetManager: Lost task 6.0 in stage 1.0 (TID 65, localhost, executor driver): TaskKilled (killed intentionally) | |
| 17/07/05 17:57:10 WARN TaskSetManager: Lost task 4.0 in stage 1.0 (TID 63, localhost, executor driver): TaskKilled (killed intentionally) | |
| 17/07/05 17:57:10 ERROR Executor: Exception in task 2.0 in stage 1.0 (TID 61) | |
| java.lang.IllegalStateException: Can't overwrite cause with java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at java.lang.Throwable.initCause(Throwable.java:457) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:612) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:670) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951) | |
| at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87) | |
| at org.apache.spark.scheduler.Task.run(Task.scala:99) | |
| at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:322) | |
| 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: ORA-01461: can bind a LONG value only for insert into a LONG column | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032) | |
| at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364) | |
| at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839) | |
| at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) | |
| at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:597) | |
| ... 12 more | |
| 17/07/05 17:57:11 WARN JdbcUtils: Requested isolation level 1 is not supported; falling back to default isolation level 2 | |
| 17/07/05 17:57:11 WARN TaskSetManager: Lost task 5.0 in stage 1.0 (TID 64, localhost, executor driver): TaskKilled (killed intentionally) | |
| 17/07/05 17:57:12 WARN JdbcUtils: Requested isolation level 1 is not supported; falling back to default isolation level 2 | |
| 17/07/05 17:57:12 WARN TaskSetManager: Lost task 8.0 in stage 1.0 (TID 67, localhost, executor driver): TaskKilled (killed intentionally) | |
| 17/07/05 17:57:12 WARN JdbcUtils: Requested isolation level 1 is not supported; falling back to default isolation level 2 | |
| 17/07/05 17:57:12 WARN TaskSetManager: Lost task 9.0 in stage 1.0 (TID 68, localhost, executor driver): TaskKilled (killed intentionally) | |
| java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended | |
| at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) | |
| at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) | |
| at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) | |
| at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) | |
| at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) | |
| at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) | |
| at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) | |
| at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) | |
| at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) | |
| at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) | |
| at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) | |
| at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) | |
| at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) | |
| at at.tmobile.bigdata.hybridAccess.stage3.arcmap.service.OracleUtils$.alterTable(OracleUtils.scala:45) | |
| at writeDfAlterSchema(<console>:38) | |
| ... 48 elided | |
| Caused by: oracle.jdbc.OracleDatabaseException: ORA-00933: SQL command not properly ended | |
| at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) | |
| ... 62 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment