Error reading metadata of file .gt

dimitri_p

we've encountered the following error in vertica.log:

[SAL] Error getting size of bundle file of [02a721fad4f563423014de7edc0fa6b900b000005d30ab8f]: StorageBundleReader: Error reading metadata of file [/data/xxxxxxxx/v_xxxxxxxx_data/191/02a721fad4f563423014de7edc0fa6b900b000005d30ab8f_0.gt]: No files in the bundle

as usual in case of any issues with .gt files I proceeded to looking for those files like so:

vsql -c "select projection_name from storage_containers where sal_storage_id like '%02a721fad4f563423014de7edc0fa6b900b000005d30ab8f%'"

and that returned 0 rows.

So I just went ahead and deleted the file, assuming it wasn't in use. But upon next start attempt vertica complained of it being missing.
My question is: is there a place other than storage_containers where I should have searched for the file before deleting it?

dimitri_p

I think I have found the answer by myself:

https://docs.vertica.com/24.4.x/en/sql-reference/system-tables/v-monitor-schema/storage-bundles/

so the query would have been something like:

vsql -c "select projection_name from v_monitor.storage_bundles where sal_storage_id like '%02a721fad4f563423014de7edc0fa6b900b000005d30ab8f%'"

EXCEPT: I don't see such a view in Vertica v12. Is there another table/view I could use instead?