I get a “Duplicate entry” error in the php_errors.log at the same time my platform goes into throwing many HTTP 500 errors.
Error excerpt:
“Error in Matomo (tracker): Error query: Mysqli statement execute error : Duplicate entry ‘4760532-ctl00$ContentPlaceHolder1$Surveydetails1$gvSurvey$ctl02$’ for key ‘PRIMARY’ In query: INSERT INTO matomo_log_form_field …”
We are running Matomo version: 3.13.5; MySQL version: 5.7.29; PHP version: 7.3.23.
A few days ago we migrated our system from dedicated servers to cloud. Runs good most of the time except after this error. We are not yet doing any deletion of raw data or aggregate data.
Will doing aging on raw and/or aggregate data help this? Or do I need some SQL to fix this in some way?
I can attach full error if that would be helpful.
Thanks,