Delete "Dangling" Materializations

1

Guys,

I’m using those sys tables to track my reflections update via API, but some of the materializations records are without no connections between reflections or refreshes. There is some way to delete these materializations?

image
image.png1004×334 39 KB

2

Hey @allan.sene, those “dangling” materializations are unexpected. A few questions:

  1. What version of Dremio is this?
  2. Did you upgrade recently and thus run the upgrade script on your Dremio db dir?
  3. If you go to your acceleration store (on whatever distributed filesystem you’re using with Dremio) do you find directories or files with those materialization ids?
3

Actually, I’ve noticed something: the reflection_id exists, but only on the sys.materializations table, look:

image
image.png798×542 65.6 KB

  1. Version 3.1.6
  2. I didn’t upgrade, but I’d migrated my single node to a cluster deployment (performing the backup/restore operation)
  3. Yes, they are there.