User::getActorId Lock wait timeout exceeded; try restarting transaction (10.64.0.205) INSERT IGNORE INTO `actor` (actor_user,actor_name) VALUES (NULL,[USER])
Please look at the relevant log entries at the time: https://logstash.wikimedia.org/goto/ac63a60619438f0c8b16ffc036d89e1a
There are also at the same time:
Column 'rc_this_oldid' cannot be null (10.64.0.205)
This could be just a consequence of something else, or it causing other issues on fast editing?, but I would like someone to give it a look (even if it is closed immediately as a rare event). I find interesting that get causes an insert, but I am guessing it is a non-http GET, and more like a get-or-create if not exists.
I don't think it is a huge issue (lower priority), but I would like someone to give it a look and see if it is a potential contention issue and a place for performance optimization. Latest server versions has more tools to handle concurrency: https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/