The following error is visible on the production system each day.
 

{"severity":"ERROR","logger":"org.candlepin.subscriptions.retention.TallyRetentionController","thread":"purge-tally-snapshots-1","message":"2025-09-15T03:14:45.862+0000 [thread=purge-tally-snapshots-1] [level=ERROR] [category=org.candlepin.subscriptions.retention.TallyRetentionController] - Unable to purge tally snapshots: JDBC exception executing SQL [select count(*) FROM tally_measurements m inner join tally_snapshots ts on m.snapshot_id=ts.id where ts.org_id=? and ts.granularity=? and ts.snapshot_date < ?] [ERROR: canceling statement due to statement timeout] [n/a]; SQL [n/a]\n","properties":{"org_id":"5412495"}}

It can be found with the url:

https://rhcorporate.splunkcloud.com/en-US/app/search/search?q=search%20index%3Drh_rhsm%20namespace%3Drhsm-prod%20%20%22Unable%20to%20purge%20tally%20snapshots%22%20%22properties.org_id%22%3D5412495&display.page.search.mode=verbose&dispatch.sample_ratio=1&workload_pool=&earliest=-5d%40d&latest=now&display.page.search.tab=events&display.general.type=events&sid=1757940801.77739_D162B515-B94D-46EF-84E1-BFAE58DB8F3F