Run automation drains at read committed

Repeatable-read snapshot made TimestampMismatchError retry reread stale rows; MariaDB 11.6+ rejects locking read outright. Drains now run at READ COMMITTED.