Getting erratically Error 7357 - Connector 8.0.28
Posted by:
Hernan H
Date: March 17, 2023 07:41AM
I'm connecting from SQL Server 2019, through MySQL Connector ODBC 8.0.28
to a MySQL 8.0.17 DB
At night, a job that consist of several steps, is fired. Each step retrieves new rows from a specific table. Steps could retrieve no rows, one row, or 4 million rows
Eventually and erratically, some step fails, giving error 7357 Can't access object, and then following steps finish with error 730 Can't execute the query
Sometimes only happens the first error
At morning, when I get notified about the error, I re-run the job, and it finishes ok
It mostly happens when getting tables of million-scale rows (about 2,3,4,5M rows). However today is happening with small queries too (less than 10K rows)
The MySQL DB is a replica. I don't have much information about the replication method. But I can say that in this replica/slave, tables have AUTO_INCREMENT columns (maybe with this information you can realize what sync method is being used)