MySQL Forums
Forum List  »  Connector/ODBC

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)

Options: ReplyQuote


Subject
Written By
Posted
Getting erratically Error 7357 - Connector 8.0.28
March 17, 2023 07:41AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.