2011-11-21 21:44:02 |
Gor Martsen |
bug |
|
|
added bug |
2011-11-21 21:44:02 |
Gor Martsen |
attachment added |
|
my.cnf file https://bugs.launchpad.net/bugs/893348/+attachment/2604287/+files/my.cnf.txt |
|
2011-12-29 02:54:50 |
Patrick Crews |
percona-server: importance |
Undecided |
Medium |
|
2011-12-29 02:54:52 |
Patrick Crews |
percona-server: assignee |
|
Patrick Crews (patrick-crews) |
|
2012-01-13 02:35:30 |
Patrick Crews |
percona-server: status |
New |
Triaged |
|
2012-01-13 02:35:34 |
Patrick Crews |
percona-server: assignee |
Patrick Crews (patrick-crews) |
|
|
2012-01-13 13:27:00 |
Alexey Kopytov |
percona-server: status |
Triaged |
Confirmed |
|
2012-01-13 18:41:23 |
Gor Martsen |
attachment added |
|
sql_acl.cc.patch https://bugs.launchpad.net/percona-server/+bug/893348/+attachment/2672978/+files/sql_acl.cc.patch |
|
2012-01-16 03:03:35 |
yinfeng |
description |
Hello
We are using max_user_connections=30 to prevent too many connections by user mistake.
Three weeks ago we upgraded 6 servers to Percona-Server-5.5 from 5.1.
And right after upgrade we noticed a problem with max_user_connections on all upgraded servers.
Users that connects to database very often, started to experience problem:
User ***** already has more than 'max_user_connections' active connections
But "SHOW PROCESSLIST" did not list any active connections for this user!
How you know, 5.5 has max_user_connections in mysql.user table.
We put max_user_connections=30 into this table, instead of global variable and nothing changes.
Known symptoms:
- Problem does not come up after mysql restart. It takes some time.
- "flush privileges" helps to reset counter, but after few hours issue is active again.
It fills like max_user_connections counter for specific (very active) users doesn't reset for some bug reason.
Server hardware:
32GB RAM. 4x4 core CPUs, SAS HDDS in RAID1 for /var/lib/mysql.
OS: centos5 x86_64
I am ready to provide any information that will help to find and resolve this issue.
Thank you.
Regards,
Gor |
Hello
We are using max_user_connections=30 to prevent too many connections by user mistake.
Three weeks ago we upgraded 6 servers to Percona-Server-5.5 from 5.1.
And right after upgrade we noticed a problem with max_user_connections on all upgraded servers.
Users that connects to database very often, started to experience problem:
User ***** already has more than 'max_user_connections' active connections
But "SHOW PROCESSLIST" did not list any active connections for this user!
How you know, 5.5 has max_user_connections in mysql.user table.
We put max_user_connections=30 into this table, instead of global variable and nothing changes.
Known symptoms:
- Problem does not come up after mysql restart. It takes some time.
- "flush privileges" helps to reset counter, but after few hours issue is active again.
It fills like max_user_connections counter for specific (very active) users doesn't reset for some bug reason.
Server hardware:
32GB RAM. 4x4 core CPUs, SAS HDDS in RAID1 for /var/lib/mysql.
OS: centos5 x86_64
I am ready to provide any information that will help to find and resolve this issue.
Thank you.
Regards,
Gor |
|
2012-02-04 15:29:44 |
Alexey Kopytov |
nominated for series |
|
percona-server/5.1 |
|
2012-02-04 15:29:44 |
Alexey Kopytov |
bug task added |
|
percona-server/5.1 |
|
2012-02-04 15:29:44 |
Alexey Kopytov |
nominated for series |
|
percona-server/5.5 |
|
2012-02-04 15:29:44 |
Alexey Kopytov |
bug task added |
|
percona-server/5.5 |
|
2012-02-04 15:29:55 |
Alexey Kopytov |
percona-server/5.1: milestone |
|
5.1.61-13.2 |
|
2012-02-04 15:29:58 |
Alexey Kopytov |
percona-server/5.5: milestone |
|
5.5.21-24.1 |
|
2012-02-04 15:30:02 |
Alexey Kopytov |
percona-server/5.1: status |
New |
Confirmed |
|
2012-02-04 15:30:05 |
Alexey Kopytov |
percona-server/5.1: importance |
Undecided |
Medium |
|
2012-02-07 02:59:32 |
Stewart Smith |
percona-server/5.1: milestone |
5.1.61-13.2 |
5.1.62-13.3 |
|
2012-03-23 07:22:17 |
Stewart Smith |
percona-server/5.5: milestone |
5.5.21-25.0 |
5.5.22-25.2 |
|
2012-03-27 05:19:28 |
Stewart Smith |
percona-server/5.1: milestone |
5.1.62-13.3 |
5.1.63-13.4 |
|
2012-04-22 16:55:51 |
Stewart Smith |
percona-server/5.5: milestone |
5.5.22-25.2 |
5.5.23-25.3 |
|
2012-04-25 17:24:02 |
Olivier Doucet |
bug |
|
|
added subscriber Olivier Doucet |
2012-04-25 18:52:51 |
Olivier Doucet |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=65104 |
|
2012-04-26 03:08:04 |
Laurynas Biveinis |
bug task added |
|
mysql-server |
|
2012-04-27 05:46:44 |
Stewart Smith |
percona-server/5.5: milestone |
5.5.23-25.3 |
5.5.24-25.4 |
|
2012-05-17 02:49:08 |
Stewart Smith |
percona-server/5.1: milestone |
5.1.63-13.4 |
5.1.64-13.5 |
|
2012-05-19 00:25:32 |
Stewart Smith |
percona-server/5.5: milestone |
5.5.24-26.0 |
5.5.25-27.0 |
|
2012-05-21 18:55:54 |
Marcos Albe |
tags |
|
i23110 |
|
2012-06-05 14:39:32 |
Inwaar |
bug |
|
|
added subscriber Inwaar |
2012-06-13 06:33:28 |
Stewart Smith |
percona-server/5.5: milestone |
5.5.25-27.0 |
|
|
2012-06-13 06:33:31 |
Stewart Smith |
percona-server/5.1: milestone |
5.1.64-13.5 |
|
|
2012-06-25 05:53:13 |
Stewart Smith |
percona-server/5.1: status |
Confirmed |
Triaged |
|
2012-06-25 05:53:15 |
Stewart Smith |
percona-server/5.5: status |
Confirmed |
Triaged |
|
2012-08-01 11:45:54 |
Laurynas Biveinis |
tags |
i23110 |
contribution i23110 |
|
2012-10-09 12:56:48 |
Alexey Kopytov |
percona-server/5.5: status |
Triaged |
Fix Released |
|
2012-10-09 12:57:10 |
Alexey Kopytov |
percona-server/5.5: milestone |
|
5.5.27-28.0 |
|
2016-03-30 12:03:58 |
Laurynas Biveinis |
percona-server/5.1: status |
Triaged |
Won't Fix |
|