When I try to log into mysql on sql-s1, I get the following:
ERROR 1226 (42000): User 'jason' has exceeded the 'max_user_connections' resource (current value: 15)
Now I can't get in to kill the items in the processlist. Any suggestion how to get around that? I did ps -ef on the box I work from, nightshade, but saw no rogue processes.
Thanks,
Jason
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 5/22/2010 3:27 AM, Ja Ga wrote:
Now I can't get in to kill the items in the processlist. Any suggestion how to get around that? I did ps -ef on the box I work from, nightshade, but saw no rogue processes.
You wont. Something hosed the databases, so all queries are stuck in 'Opening tables' status. Connecting from the commandline without specifying -A will also get stuck, so it'll likely be fubar until A) it unstuffs itself (unlikely) B) a root beats it with a blunt object.
toolserver-l@lists.wikimedia.org