Stack Over flow Error while Previewing DataSet

I am getting Error while Previewing Virtual Data Set,

Caused by: com.dremio.exec.work.foreman.ForemanException: Unexpected exception during fragment initialization: null
at com.dremio.exec.work.foreman.AttemptManager.run(AttemptManager.java:333) [dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
… 3 common frames omitted
Caused by: java.lang.StackOverflowError: null
at com.dremio.exec.planner.sql.SqlConverter.parse(SqlConverter.java:182) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]

same thread i have triyed but not worked for me

@Vikash_Singh, can you attach the query profile?

Hello Ben,
I am still getting stackOverFlow Error even on Latest Version Dremio 3.1.10 ,i am attaching here Query Profile for My production Dremio 3.1.1 c394b4d7-9761-42dd-b88e-6c779bf1a68c.zip (4.8 KB)

2019-04-26 04:55:45,513 [233d70af-3a5e-4644-ba13-e594630c4c00:foreman] ERROR c.d.exec.work.foreman.AttemptManager - StackOverflowError
com.dremio.common.exceptions.UserException: StackOverflowError
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:746) ~[dremio-common-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.work.foreman.AttemptManager$AttemptResult.close(AttemptManager.java:520) [dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.work.foreman.AttemptManager.moveToState(AttemptManager.java:579) [dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.work.foreman.AttemptManager.run(AttemptManager.java:332) [dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]
Caused by: com.dremio.exec.work.foreman.ForemanException: Unexpected exception during fragment initialization: null
at com.dremio.exec.work.foreman.AttemptManager.run(AttemptManager.java:333) [dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
… 3 common frames omitted
Caused by: java.lang.StackOverflowError: null
at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_181]
at java.net.URLClassLoader.findClass(URLClassLoader.java:362) ~[na:1.8.0_181]
at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_181]
at java.lang.ClassLoader.loadClass(ClassLoader.java:411) ~[na:1.8.0_181]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) ~[na:1.8.0_181]
at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_181]
at ch.qos.logback.classic.spi.PackagingDataCalculator.loadClass(PackagingDataCalculator.java:207) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.PackagingDataCalculator.bestEffortLoadClass(PackagingDataCalculator.java:232) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.PackagingDataCalculator.computeBySTEP(PackagingDataCalculator.java:138) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.PackagingDataCalculator.populateUncommonFrames(PackagingDataCalculator.java:113) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.PackagingDataCalculator.populateFrames(PackagingDataCalculator.java:105) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.PackagingDataCalculator.calculate(PackagingDataCalculator.java:57) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.ThrowableProxy.calculatePackagingData(ThrowableProxy.java:147) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.spi.LoggingEvent.(LoggingEvent.java:124) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.Logger.buildLoggingEventAndAppend(Logger.java:440) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.Logger.filterAndLog_0_Or3Plus(Logger.java:396) ~[logback-classic-1.1.3.jar:na]
at ch.qos.logback.classic.Logger.info(Logger.java:616) ~[logback-classic-1.1.3.jar:na]
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:763) ~[dremio-common-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.planner.sql.SqlConverter.parse(SqlConverter.java:185) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.planner.sql.DremioSqlToRelConverter.expandView(DremioSqlToRelConverter.java:86) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.planner.sql.ExtendedToRelContext.expandView(ExtendedToRelContext.java:71) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.planner.logical.ViewTable.toRel(ViewTable.java:116) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.catalog.DremioPrepareTable.toRel(DremioPrepareTable.java:89) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewriteRel(RelStructuredTypeFlattener.java:657) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
at org.apache.calcite.util.ReflectUtil.invokeVisitorInternal(ReflectUtil.java:257) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.util.ReflectUtil.invokeVisitor(ReflectUtil.java:214) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.util.ReflectUtil$1.invokeVisitor(ReflectUtil.java:464) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit(RelStructuredTypeFlattener.java:721) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.rel.SingleRel.childrenAccept(SingleRel.java:72) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.rel.RelVisitor.visit(RelVisitor.java:44) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit(RelStructuredTypeFlattener.java:716) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewrite(RelStructuredTypeFlattener.java:177) ~[calcite-core-1.16.0-201812242205090326-0cada7b.jar:1.16.0-201812242205090326-0cada7b]
at com.dremio.exec.planner.sql.DremioSqlToRelConverter.flattenTypes(DremioSqlToRelConverter.java:69) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.planner.sql.SqlConverter.toConvertibleRelRoot(SqlConverter.java:286) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at com.dremio.exec.planner.sql.DremioSqlToRelConverter.expandView(DremioSqlToRelConverter.java:88) ~[dremio-sabot-kernel-3.1.1-201901281837360699-30c9d74.jar:3.1.1-201901281837360699-30c9d74]
at

i cant paste full log so i have attached here

http://s000.tinyupload.com/download.php?file_id=93598889283990172385&t=9359888928399017238541135

@Vikash_Singh, if this is consistently happening with the same VDS, try rebuilding that VDS and all of the VDS it depends on, but with different and unique names for each (ones that you’ve never chosen before). As suggested in the other comment thread, this likely has to do with a duplicate names and some change to the VDS graph.

A “fresh” set of VDS with different names (but basically the same SQL), will give you the same query results, but hopefully not the error.

Hello Ben,

Quick update on issue regrading stackOverFlow ,as i have got this issue whenEver i have been restared Docker Container in that case Visrtual DataSet Can not Find Phisical Path so, when i have edited Full Path From dataSet StackOverFlow Issue solved ,

so,is it the bug that when we create dataSet From physical Source ist not taking full path?

Hello @Vikash_Singh,

I’m not sure I understand the question. When you restart your Dremio Docker container, what is the issue you encounter?