Metadata for table is not available for the commit

1

Hi team, can you please advise how to solve this error:
Metadata for table [nessie.table] is not available for the commit [5206b6b5]. The metadata files may have expired and been garbage collected based on the table history retention policy.

thanks
Jaro

2

@jaroslav_marko Have you tried to refresh metadata?

3

Hi @balaji.ramaswamy, yes I did.

Table ‘table’ read signature reviewed but source stated metadata is unchanged, no refresh occurred.

J

4

Hi @balaji.ramaswamy, can you please advice how to proceed? Thanks
Jaro

5

Hi @jaroslav_marko. Could you provide some more information about the operation(s) you performed on this table? Did you perform any ROLLBACK, VACUUM, or general table-history/versioning commands?

Or, is this occurring on the most recent snapshot of your table?

6

Hi, this is happening on last snapshot and I’m not aware of doing any special operations. I suspect that there were more concurrent deletes / cancelations of query at one point that have caused it. Jaro

7

it started to happen on another table too. can you please help?
Metadata for table [nessie.table] is not available for the commit [e07b6e35]. The metadata files may have expired and been garbage collected based on the table history retention policy.

at minimum i want to drop the table and load it again. but i’m pretty concerned about such behavior.

thanks
Jaro

8

Just an update on this issue → after upgrading to 25.2 the defect table disappeared :slight_smile:

Jaro