Hi, we have Dremio 25.0.0 deployed on k8s. I’m not able to create any reflections. Creation fails with this error “The option ‘reflections.planning.exclude.file_based_incremental.iceberg.accelerations’ does not exist.”
Can you please help me to resolve this issue, thanks.
@jaroslav_marko Looks like reflections.planning.exclude.file_based_incremental.iceberg.accelerations has been set that Dremio is complaining about. Are you able to send the profile as I would like to see the non-default values for support keys
@balaji.ramaswamy thank you for your reply. can you please navigate me what exactly should I send you? i’m not quite sure what profile you mean. thank you. jaro
sorry for late reply. in the meantime I have managed to fix the original error (by adjusting the Dremio source code, compiling it and replacing couple of .jar files in our running Dremio deployment).
So i was able to create a simple reflection on one field, then on another one. (attaching the query profiles for both).
the jobs look like they have finished successfully, but I don’t see any acceleration
effect and there is a following error in table section:
Reflection cannot accelerate, 2 refresh jobs attempts failed, will reattempt.
Hi @balaji.ramaswamy, we tried to redeploy the server to have clear logs, created a test table and tried to create reflection on this table. the job suceeded, but the reflection was not created as before.
unfortunately we have not found any error in server.log file.
btw. we are using bitnami image, are you perhaps aware of any issues with this image?
thanks, Jaro
Hi @balaji.ramaswamy,
we redeployed the entire instance using official oss 25 image, deleted all storages and nessie catalogues to avoid some potential conflicts with old data. i have loaded some tables back and tried to create reflection and have the same problem.
can you please help me with finding the issue?
reflections in dremio are key element for performance and without them i’m blocked with the project.
thanks a lot for help.
Jaro
we have found this in logs:
WARN c.d.s.reflection.ReflectionManager - Successful REFLECTION REFRESH but already expired for materialization 401a2235-97f9-4f55-a586-715696150917/146881e2-4ca7-4142-b711-07d7a27f4c05
Hi @Benny_Chow, yes I have found your solution, we have corrected the code, recompiled and included in the image. the original error is not longer appearing, but as i describe above the reflection job looks like finishing successfully, the reflection files appear to be in the storage, but the reflection itself shows error. there are no errors in server.log. i’m really struggling to resolve that and would very much appreciate any help.
thanks
Jaro
I have changed the refresh settings to 1 hour and Expire setting to 3 hours and i was able to create one reflection successfully. however afterwards any other reflection, even table update ends with “Failure getting source [nessie].”.
attaching the profile: 097b4031-5128-41ff-b6e2-8f9de39ecf18.zip (24.1 KB)
How did you create the source “nessie”? Was it through the REST APIs? I’m aware of an issue where if the source is created through REST APIs the Refresh Settings show zero. That issue is being fixed right now. Do you have some background process updating the “nessie” source? That’s what the error in the query profile says.
Yes during re-deployment (as a last CICD job) we are uploading the sources and also users using API to keep the setup. (is there more consistent way to keep the setup after redeployment?)
But there are no other processing running other that this one.
The strange behavior is that after I have created my first reflection successfully the entire connection to nessie is not working. The setup is ok, i can see all tables and metadata, but whatever I run fails. i have restarted the deployment and it did not help.
any ideas, please?
Hi @Benny_Chow, just want to provide you with update. Originally I have simultaneously running 2 nessie instances on two separated storages. So I have tried to keep only one and remove the second one. It works for now. Thanks.