Tmp table doesn't exist error when tables are dropped during accessing information_schema

Help
1

When I execute a SELECT query to INFORMATION_SCHEMA.TABLE_STATISTICS, it sometimes throws the below message when tables are dropped in the background. Any solutions to fix it except for retry?

SQLSyntaxErrorException: (conn=391) Leaf Error (127.0.0.1:3307): Table 'tpch_5.tmp_trino_0dbdfd484b934bb78480923ab10cf56e' doesn't exist

I’m testing in memsql/cluster-in-a-box:centos-7.5.6-9e799dbf4f-3.2.11-1.11.10 docker image.

2

Thanks for reporting this. I’ve open a task internally to have someone take a look at what going on - ideally we wouldn’t have the info schema view error when a table is dropped concurrently. Likely retrying is the only way to deal with it on your end right now.

-Adam

1 Like