Some old tables that never get garbage collected

[HeavyHorst]

Describe the problem

I have some old tables that never gets garbage collected.

This doesn’t seem to be a real problem as everything works wonderfully and I have never experienced such a problem since then. Nevertheless, I would like to remove them if it is possible.

Also see: https://forum.cockroachlabs.com/t/some-old-tables-that-never-get-garbage-collected/4302

To Reproduce

I don't know because it only happened once.
I already had some consinstency problems at that time:
#51983, #52422

possibly it is related to one of these problems.
Expected behavior

The tables should be garbage collected and dissapear.

Additional data / screenshots

I've already created the debug.zip.
What is the preferred way to transfer it privately?

Jira issue: CRDB-3053

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I have CC'd a few people who may be able to assist you:

• @lucy-zhang (commented on Webui: click on Databases craches the node running the webui #52422)
• @mattcrdb (commented on Webui: click on Databases craches the node running the webui #52422)
• @spaskob (assigned to Core changefeed: unknown ParentID #51983, commented on Webui: click on Databases craches the node running the webui #52422)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[ajwerner]

I don't know because it only happened once.
I already had some consinstency problems at that time:
#51983, #52422

If this is the same cluster as those, I'm not totally surprised to hear that we've got some cleanup to do. Please share the debug zip with ajwerner@cockroachlabs.com via either email or google drive if that's convenient. If it is not convenient, I'm sure I can work out a private upload link to give you out of band. Email me either way.

[HeavyHorst]

I shared the file with gdrive.

[ajwerner]

One question: how willing are you to upgrade to 20.2? We have added tools in 20.2 to make repair much more robust and much simpler - it can be done in sql without the need for some low level hacks. It's possible in 20.1, but certainly less pleasant.

[HeavyHorst]

That sounds great.
I am running 20.2.5 already.

[ajwerner]

Cool, I'll cook something up. Out of curiosity, does SHOW TABLES work or does it currently give you an error?

[HeavyHorst]

SHOW TABLES works on all databases SHOW DATABASES shows.

[ajwerner]

We added functions to remove these tables and their data with crdb_internal.unsafe_delete_descriptor and crdb_internal. force_delete_table_data. Sorry I didn't deal with this in a more timely manner.

[HeavyHorst]

Great news, thank you very much!
Is there any documentation on how to run these commands?