java.lang.ArithmeticException: Adding time zone offset caused overflow

GitHub | electrum | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Categorize errors for Joda time ArithmeticException

    GitHub | 8 months ago | electrum
    java.lang.ArithmeticException: Adding time zone offset caused overflow

    Root Cause Analysis

    1. java.lang.ArithmeticException

      Adding time zone offset caused overflow

      at org.joda.time.DateTimeZone.convertUTCToLocal()
    2. Joda-Time
      ZonedChronology$ZonedDateTimeField.get
      1. org.joda.time.DateTimeZone.convertUTCToLocal(DateTimeZone.java:929)
      2. org.joda.time.chrono.ZonedChronology$ZonedDateTimeField.get(ZonedChronology.java:422)
      2 frames
    3. presto-main
      DateTimeFunctions.hourFromTimestamp
      1. com.facebook.presto.operator.scalar.DateTimeFunctions.hourFromTimestamp(DateTimeFunctions.java:648)
      1 frame
    4. Java RT
      MethodHandle.invokeWithArguments
      1. java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
      2. java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:649)
      2 frames
    5. presto-main
      ExpressionInterpreter$Visitor.visitFunctionCall
      1. com.facebook.presto.sql.planner.ExpressionInterpreter.invoke(ExpressionInterpreter.java:1093)
      2. com.facebook.presto.sql.planner.ExpressionInterpreter$Visitor.visitFunctionCall(ExpressionInterpreter.java:826)
      2 frames
    6. presto-parser
      AstVisitor.process
      1. com.facebook.presto.sql.tree.FunctionCall.accept(FunctionCall.java:96)
      2. com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)
      2 frames
    7. presto-main
      SimplifyExpressions$Rewriter.simplifyExpression
      1. com.facebook.presto.sql.planner.ExpressionInterpreter.optimize(ExpressionInterpreter.java:231)
      2. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.simplifyExpression(SimplifyExpressions.java:153)
      2 frames
    8. Guava
      ImmutableMap.copyOf
      1. com.google.common.collect.Maps$7.transformEntry(Maps.java:1812)
      2. com.google.common.collect.Maps$10.getValue(Maps.java:1857)
      3. com.google.common.collect.ImmutableMap.copyOf(ImmutableMap.java:292)
      3 frames
    9. presto-main
      SimplePlanRewriter$RewriteContext.lambda$defaultRewrite$0
      1. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:110)
      2. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:88)
      3. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:76)
      4. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:86)
      5. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:97)
      6. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:109)
      7. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:88)
      8. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:76)
      9. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:86)
      10. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:97)
      11. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:109)
      12. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:88)
      13. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:76)
      14. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:86)
      15. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:97)
      16. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:109)
      17. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions$Rewriter.visitProject(SimplifyExpressions.java:88)
      18. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:76)
      19. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.rewrite(SimplePlanRewriter.java:86)
      20. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.lambda$defaultRewrite$0(SimplePlanRewriter.java:75)
      20 frames
    10. Java RT
      ReferencePipeline.collect
      1. java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
      2. java.util.Iterator.forEachRemaining(Iterator.java:116)
      3. java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
      4. java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
      5. java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
      6. java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
      7. java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
      8. java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
      8 frames
    11. presto-main
      QueuedExecution.lambda$start$1
      1. com.facebook.presto.sql.planner.plan.SimplePlanRewriter$RewriteContext.defaultRewrite(SimplePlanRewriter.java:76)
      2. com.facebook.presto.sql.planner.plan.SimplePlanRewriter.visitPlan(SimplePlanRewriter.java:40)
      3. com.facebook.presto.sql.planner.plan.SimplePlanRewriter.visitPlan(SimplePlanRewriter.java:24)
      4. com.facebook.presto.sql.planner.plan.PlanVisitor.visitOutput(PlanVisitor.java:50)
      5. com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:81)
      6. com.facebook.presto.sql.planner.plan.SimplePlanRewriter.rewriteWith(SimplePlanRewriter.java:29)
      7. com.facebook.presto.sql.planner.optimizations.SimplifyExpressions.optimize(SimplifyExpressions.java:85)
      8. com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:100)
      9. com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:277)
      10. com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:256)
      11. com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:220)
      12. com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:68)
      12 frames
    12. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      3. java.lang.Thread.run(Thread.java:745)
      3 frames