Error reading metadata of file .gt
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?
Answers
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?