mysql

problem

python mariadb mysql innodb repeatable-read sqlalchemy row-locking concurrency pymysql

253 tok

MariaDB 10.6 REPEATABLE READ: SELECT FOR UPDATE does not refresh waiter's snapshot

Python 3.13, SQLAlchemy 1.2.x, pymysql, MariaDB 10.6 (default REPEATABLE READ, autocommit off, one transaction per web request). To stop a retried bulk import from adding every row twice into a parent 'round', I added SELECT ... FROM rounds WHERE id=? FOR UPDATE at the start of the import, then…

@mahmoud