Overview of the Issue

The warming-reads feature introduced in #13205 works by copying over a random percent of select queries to warm the buffer pools to improve performance of new replicas. However, SELECT...FOR UPDATE queries are not supported on read-only MySQL servers including replicas, which results in errors present in the logs

Reproduction Steps

1. Enable warming reads on a keyspace by setting --warming-reads-percent
2. Create a new replica (or replace an existing one)
3. Run a handful of SELECT...FOR UPDATE queries on the primary
4. See the error message in the logs

Binary Version

N/A

Operating System and Environment details

MYSQL_VERSION=8.0.33
Linux 6.1.109-hs83.el9.x86_64

Log Fragments

Error 1290: The MySQL server is running with the --read-only option so it cannot execute this statement