Product and version:
FileMaker Pro 18.104.22.1680
FileMaker Server 22.214.171.124
MySQL Community Server 5.7.22
ODBC driver 8.0.15 Unicode driver
When syncing records from and to the MySQL environment through ESS after x amount of records (less then 100 always) the following error occur: 1408 - Extended error (ODBC) (communication/link error). When this has occurred every ESS action you perform: reading / writing will fail and gives the following error 1413 - Failed communication link (ODBC).
If you close the current script / perform script on server / script schedule and performs the same action again it will work again for x amount of records.
So in fact each action (in a script) you perform with an ESS data source after x amount of records you will receive a communication problem. Terminating the current 'failed script and starting again will work.
How to replicate
Follow the steps from the description above
Workaround (if any)
Split up the work in several script session