Hello,
one of my source A is in red, but I am sure the host and port are fine so I create another source AA use the same host and port, source AA works fine.
But I cannot remove source A, it gives:
Failure creating/updating source [A]
Why I am not able to remove it?
Hi @carol
Can you try and remove the source again and attach the Dremio server.log to this thread?
hello, server.log as shown below:
2018-10-30 12:22:06,851 [scheduler-22] WARN c.d.s.r.MaterializationCache - couldn’t expand materialization 453ab064-7283-4f1a-9c41-b3155b5b2075
com.dremio.common.exceptions.UserException: Failure while retrieving dataset ["__accelerator".“6daed871-efa0-4e7f-ab3f-ec618fd5ebc6”.“453ab064-7283-4f1a-9c41-b3155b5b2075”].
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:746) ~[dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.DatasetManager.getTableFromPlugin(DatasetManager.java:271) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.DatasetManager.getTable(DatasetManager.java:191) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.CatalogImpl.getTable(CatalogImpl.java:135) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.DelegatingCatalog.getTable(DelegatingCatalog.java:58) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.CachingCatalog.getTable(CachingCatalog.java:66) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.DremioCatalogReader.getTable(DremioCatalogReader.java:94) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.planner.sql.MaterializationExpander.expandSchemaPath(MaterializationExpander.java:174) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.planner.sql.MaterializationExpander.expand(MaterializationExpander.java:78) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.planner.sql.MaterializationDescriptor.getMaterializationFor(MaterializationDescriptor.java:136) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.ReflectionServiceImpl$CacheHelperImpl.expand(ReflectionServiceImpl.java:876) ~[dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.ReflectionServiceImpl$CacheHelperImpl.expand(ReflectionServiceImpl.java:857) ~[dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.MaterializationCache.updateEntry(MaterializationCache.java:172) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.MaterializationCache.safeUpdateEntry(MaterializationCache.java:164) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.MaterializationCache.updateCache(MaterializationCache.java:127) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.MaterializationCache.compareAndSetCache(MaterializationCache.java:99) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.MaterializationCache.refresh(MaterializationCache.java:92) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.ReflectionServiceImpl.refreshCache(ReflectionServiceImpl.java:339) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.ReflectionServiceImpl$CacheRefresher.run(ReflectionServiceImpl.java:922) [dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.scheduler.LocalSchedulerService$CancellableTask.run(LocalSchedulerService.java:95) [dremio-services-scheduler-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_181]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_181]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_181]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_181]
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: java.lang.IllegalStateException: Unable to retrieve selection for path.6daed871-efa0-4e7f-ab3f-ec618fd5ebc6/453ab064-7283-4f1a-9c41-b3155b5b2075
at com.dremio.service.reflection.materialization.AccelerationStoragePlugin$1.apply(AccelerationStoragePlugin.java:168) ~[dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.service.reflection.materialization.AccelerationStoragePlugin$1.apply(AccelerationStoragePlugin.java:160) ~[dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.google.common.collect.Iterators$7.transform(Iterators.java:750) ~[guava-20.0.jar:na]
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47) ~[guava-20.0.jar:na]
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47) ~[guava-20.0.jar:na]
at com.google.common.collect.MultitransformedIterator.hasNext(MultitransformedIterator.java:52) ~[guava-20.0.jar:na]
at com.google.common.collect.MultitransformedIterator.hasNext(MultitransformedIterator.java:50) ~[guava-20.0.jar:na]
at com.google.common.collect.ImmutableList.copyOf(ImmutableList.java:249) ~[guava-20.0.jar:na]
at com.google.common.collect.ImmutableList.copyOf(ImmutableList.java:209) ~[guava-20.0.jar:na]
at com.google.common.collect.FluentIterable.toList(FluentIterable.java:614) ~[guava-20.0.jar:na]
at com.dremio.service.reflection.materialization.AccelerationStoragePlugin.getDataset(AccelerationStoragePlugin.java:172) ~[dremio-services-accelerator-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.ManagedStoragePlugin.getTable(ManagedStoragePlugin.java:413) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.DatasetManager.getTableFromPlugin(DatasetManager.java:269) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
… 25 common frames omitted
Hi @carol
What type of source is this? Also, can you attach the complete log?