[jira] [Updated] (CARBONDATA-1153) Can not add column because it is aborted

[Akash R Nilugal (Jira)]

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

cen yuhai updated CARBONDATA-1153:
----------------------------------
    Description:
Sometimes it will throws exception as below. why can't I add column? no one are altering the table...
{code}
scala> carbon.sql("alter table temp.yuhai_carbon add columns(test1 string)")
17/06/11 22:09:13 AUDIT [org.apache.spark.sql.execution.command.AlterTableAddColumns(207) -- main]: [sh-hadoop-datanode-250-104.elenet.me][master][Thread-1]Alter table add columns request has been received for temp.yuhai_carbon
17/06/11 22:10:22 ERROR [org.apache.spark.scheduler.TaskSetManager(70) -- task-result-getter-3]: Task 0 in stage 0.0 failed 4 times; aborting job
17/06/11 22:10:22 ERROR [org.apache.spark.sql.execution.command.AlterTableAddColumns(141) -- main]: main Alter table add columns failed :Job aborted due to stage failure: Task 0 in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0 (TID 3, sh-hadoop-datanode-368.elenet.me, executor 7): java.lang.RuntimeException: Dictionary file test1 is locked for updation. Please try after some time
        at scala.sys.package$.error(package.scala:27)
        at org.apache.carbondata.spark.util.GlobalDictionaryUtil$.loadDefaultDictionaryValueForNewColumn(GlobalDictionaryUtil.scala:857)
        at org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD$$anon$1.<init>(AlterTableAddColumnRDD.scala:83)
        at org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD.compute(AlterTableAddColumnRDD.scala:68)
        at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:331)
        at org.apache.spark.rdd.RDD.iterator(RDD.scala:295)
        at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:88)
        at org.apache.spark.scheduler.Task.run(Task.scala:104)
        at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:351)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
{code}

  was:
why can't I add column? no one are altering the table...
{code}
scala> carbon.sql("alter table temp.yuhai_carbon add columns(test1 string)")
17/06/11 22:09:13 AUDIT [org.apache.spark.sql.execution.command.AlterTableAddColumns(207) -- main]: [sh-hadoop-datanode-250-104.elenet.me][master][Thread-1]Alter table add columns request has been received for temp.yuhai_carbon
17/06/11 22:10:22 ERROR [org.apache.spark.scheduler.TaskSetManager(70) -- task-result-getter-3]: Task 0 in stage 0.0 failed 4 times; aborting job
17/06/11 22:10:22 ERROR [org.apache.spark.sql.execution.command.AlterTableAddColumns(141) -- main]: main Alter table add columns failed :Job aborted due to stage failure: Task 0 in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0 (TID 3, sh-hadoop-datanode-368.elenet.me, executor 7): java.lang.RuntimeException: Dictionary file test1 is locked for updation. Please try after some time
        at scala.sys.package$.error(package.scala:27)
        at org.apache.carbondata.spark.util.GlobalDictionaryUtil$.loadDefaultDictionaryValueForNewColumn(GlobalDictionaryUtil.scala:857)
        at org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD$$anon$1.<init>(AlterTableAddColumnRDD.scala:83)
        at org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD.compute(AlterTableAddColumnRDD.scala:68)
        at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:331)
        at org.apache.spark.rdd.RDD.iterator(RDD.scala:295)
        at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:88)
        at org.apache.spark.scheduler.Task.run(Task.scala:104)
        at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:351)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
{code}

> Can not add column because it is aborted
> ----------------------------------------
>
>                 Key: CARBONDATA-1153
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1153
>             Project: CarbonData
>          Issue Type: Bug
>          Components: spark-integration
>    Affects Versions: 1.2.0
>            Reporter: cen yuhai
>
> Sometimes it will throws exception as below. why can't I add column? no one are altering the table...
> {code}
> scala> carbon.sql("alter table temp.yuhai_carbon add columns(test1 string)")
> 17/06/11 22:09:13 AUDIT [org.apache.spark.sql.execution.command.AlterTableAddColumns(207) -- main]: [sh-hadoop-datanode-250-104.elenet.me][master][Thread-1]Alter table add columns request has been received for temp.yuhai_carbon
> 17/06/11 22:10:22 ERROR [org.apache.spark.scheduler.TaskSetManager(70) -- task-result-getter-3]: Task 0 in stage 0.0 failed 4 times; aborting job
> 17/06/11 22:10:22 ERROR [org.apache.spark.sql.execution.command.AlterTableAddColumns(141) -- main]: main Alter table add columns failed :Job aborted due to stage failure: Task 0 in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0 (TID 3, sh-hadoop-datanode-368.elenet.me, executor 7): java.lang.RuntimeException: Dictionary file test1 is locked for updation. Please try after some time
>         at scala.sys.package$.error(package.scala:27)
>         at org.apache.carbondata.spark.util.GlobalDictionaryUtil$.loadDefaultDictionaryValueForNewColumn(GlobalDictionaryUtil.scala:857)
>         at org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD$$anon$1.<init>(AlterTableAddColumnRDD.scala:83)
>         at org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD.compute(AlterTableAddColumnRDD.scala:68)
>         at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:331)
>         at org.apache.spark.rdd.RDD.iterator(RDD.scala:295)
>         at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:88)
>         at org.apache.spark.scheduler.Task.run(Task.scala:104)
>         at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:351)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at java.lang.Thread.run(Thread.java:745)
> {code}

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