CKAN version

CKAN 2.8.4

Describe the bug

Updating resources, or adding resources, for a dataset that already has a large number of resources, is unmanageably slow.

Steps to reproduce

• Create a dataset with the resources from https://www.data.qld.gov.au/dataset/ambient-estuarine-water-quality-monitoring-data-near-real-time-sites-2012-to-present-day
• Edit and save a resource

Expected behavior

Resources should update within a few seconds.

Additional details

We recently installed the ckanext-archiver, ckanext-report, and ckanext-qa extensions; it is possible that there is an interaction with these extensions that is causing or exacerbating the problem.

Debugging suggests that the slowness is occurring in ckan/logic/action/update.py, within package_update, when generating a new revision. This may be indicative of a database deadlock.