You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2017/05/02 00:03:04 UTC

[jira] [Assigned] (SPARK-20459) JdbcUtils throws IllegalStateException: Cause already initialized after getting SQLException

     [ https://issues.apache.org/jira/browse/SPARK-20459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xiao Li reassigned SPARK-20459:
-------------------------------

    Assignee: Sean Owen

> JdbcUtils throws IllegalStateException: Cause already initialized after getting SQLException
> --------------------------------------------------------------------------------------------
>
>                 Key: SPARK-20459
>                 URL: https://issues.apache.org/jira/browse/SPARK-20459
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.0.1, 2.0.2, 2.1.0
>            Reporter: Jessie Yu
>            Assignee: Sean Owen
>            Priority: Minor
>             Fix For: 2.2.1, 2.3.0
>
>
> Testing some failure scenarios, and JdbcUtils throws an IllegalStateException instead of the expected SQLException:
> {code}
> scala> org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils.saveTable(prodtbl,url3,"DB2.D_ITEM_INFO",prop1) 
> 17/04/03 17:19:35 ERROR Executor: Exception in task 0.0 in stage 1.0 (TID 1)    
> java.lang.IllegalStateException: Cause already initialized                      
> .at java.lang.Throwable.setCause(Throwable.java:365)                            
> .at java.lang.Throwable.initCause(Throwable.java:341)                           
> .at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:241)
> .at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:300)
> .at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$saveTable$1.apply(JdbcUtils.scala:299)
> .at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$28.apply(RDD.scala:902)
> .at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$28.apply(RDD.scala:902)
> .at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1899) 
> .at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1899)  
> .at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:70)          
> .at org.apache.spark.scheduler.Task.run(Task.scala:86)                          
> .at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:274) 
> .at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153
> .at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628
> .at java.lang.Thread.run(Thread.java:785)                                       
> {code}
> The code in JdbcUtils.savePartition has 
> {code}
>     } catch {
>       case e: SQLException =>
>         val cause = e.getNextException
>         if (cause != null && e.getCause != cause) {
>           if (e.getCause == null) {
>             e.initCause(cause)
>           } else {
>             e.addSuppressed(cause)
>           }
>         }
> {code}
> According to Throwable Java doc, {{initCause()}} throws an {{IllegalStateException}} "if this throwable was created with Throwable(Throwable) or Throwable(String,Throwable), or this method has already been called on this throwable". The code does check whether {{cause}} is {{null}} before initializing it. However, {{getCause()}} "returns the cause of this throwable or null if the cause is nonexistent or unknown." In other words, {{null}} is returned if {{cause}} already exists (which would result in {{IllegalStateException}}) but is unknown. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org