For T186689 I want to test capturing the max_user_connections error. Using an account with a low quota will greatly assist with this.
u11106 is the user for my personal home account, musikanimal, on Toolforge. I only use it when developing locally.
I may even prefer to keep this account set to 1 open connection, should I need it for testing again. Otherwise I can comment here or create a new ticket to have the default quota restored.
Thanks
Done on the 3 labsdb backends for wikireplicas (not on toolsdb).
SHOW GRANTS FOR 'u11106'; GRANT USAGE ON *.* TO 'u11106'@'%' ... WITH MAX_USER_CONNECTIONS 1;
I had the password reset for u11106 and that apparently put the quota back at 5 connections.
Could we lower it back to 1, once more? Thank you!
Done, on wikireplicas only, as above:
root@cumin1001:~$ for host in labsdb1009 labsdb1010 labsdb1011; do mysql.py -A -h $host mysql -e "select @@hostname, max_user_connections FROM user WHERE user = 'u11106'"; done +------------+----------------------+ | @@hostname | max_user_connections | +------------+----------------------+ | labsdb1009 | 1 | +------------+----------------------+ +------------+----------------------+ | @@hostname | max_user_connections | +------------+----------------------+ | labsdb1010 | 1 | +------------+----------------------+ +------------+----------------------+ | @@hostname | max_user_connections | +------------+----------------------+ | labsdb1011 | 1 | +------------+----------------------+