Re: Mysql select * Quary fails

[Peter Brawley]

What's the isolation level on the slave? Would a dirty read be acceptable? Is there a real need to retrieve all rows and columns at once from this table?

As a last resort you could write an sproc that retries the query when such an error occurs, but usually judicious tweaking of isolation level and query retrieval volume avoids most such problems.