Integrity constraint violation

Description

Bit stuck here. After taking a production db dump and importing it locally Im getting the following integrity constraint violation error when trying to create a new entry via the CP (/admin/entires/section/new). This error seems to disappear after refreshing the page a few times (the amount seems to change from dump to dump) but on each refresh the listed elementId appears to increment.

Another colleague has tried and is experiencing the same issue in their environment. We stumbled into an older issue but when checking the AUTO_INCREMENT values on the db dumps they seem to be correct:

SELECT id FROM elements
ORDER BY id DESC
LIMIT 1

SHOW CREATE TABLE elements

SELECT id FROM elements_sites
ORDER BY id DESC
LIMIT 1

SHOW CREATE TABLE elements_sites

Hoping this is something familiar or something I can receive some assistance/direction with.

Additional info

• Craft version: Craft Pro 3.5.17.1
• PHP version: 7.4.15
• Database driver & version: MySQL 5.7.33

Start by reproducing the integrity constraint violation when creating a new entry in the CP after importing a production MySQL dump, and inspect the reported elementId as it changes across refreshes. Compare the elements and elements_sites IDs and AUTO_INCREMENT definitions shown in the issue; done means identifying the cause and preventing the failed entry creation.