Cache table not cleared properly (bug in garbage collection)

[jenlampton]

Problem/Motivation
DB server stopped working, disk full due to large views export cache table 47G .ibd file mariadb
compleet DB export is 300MB

When doing a large view export to csv

Steps to reproduce
Do a lot of exports

Proposed resolution
Limit on some way, not logical the cache is larger than the complete DB itself

This is a copy of https://www.drupal.org/node/3186214 where there is a patch.