Timeout when saving taxon record

[lexiclevenger]

Describe the bug Encountering a timeout after saving a taxon record. Database has 1,492,000 taxa. This could be created in v7 and edge in the Fitz_NHMD_Oct_2023 database.

To Reproduce Steps to reproduce the behavior:

1. Click on Data Entry.
2. Create a new Taxon.
3. Fill out required fields.
4. Save and see loading screen.

Crash Report

Specify 7 Crash Report - 2024-04-09T19_36_04.359Z.txt

Please, also fill out the following information manually:

• OS: Mac
• Browser: Chrome
• Specify 7 Version: edge
• Database Name: Fitz_NHMD_Oct_2023
• Collection name: Vertebrate Paleontology
• User Name: petrifiedroadkill

[grantfitzsimmons]

In MariaDB, the query is as follows:

Id	User	Host	db	Command	Time	State	Info	Progress
243414	root	172.21.0.47:46580	Fitz_NHMD_Oct_2023	Query	58	Sending data	update taxon	0.0

Full command:

update taxon t
join taxontreedefitem d on t.taxontreedefitemid = d.taxontreedefitemid
set t.rankid = d.rankid

Seemingly fails to complete even after killing all other processes on the DB.

[emenslin]

Can recreate in edge (7.9.6)