[4.x]: Endless growth of resourcepaths table

[thomas-jaeger]

What happened?

Description

In our test environments with nightly builds, the resourcepaths table grows significantly (>6.5 million rows). It appears to be a path cache for assets; the assets are regenerated each night. We haven’t found a way to delete it via the CLI or console.
Can the table be safely truncated (it’s not included in the backup)? Is there a way to do this via the CLI or console?

Craft CMS version

4.13.10

PHP version

8.2

Operating system and version

Linux Container

Database type and version

Postgreql 15.10

Image driver and version

No response

Installed plugins and versions

[brandonkelly]

It’s safe to truncate, yes. It will get repopulated when assets are re-published as needed.

[brandonkelly]

I thought the table was getting automatically truncated when control panel resources were cleared (either using the Caches utility or clear-caches/cp-resources command, but apparently not. So just made that the case for Craft 4.15 and 5.7 (37fdca9).