maria-discuss team mailing list archive

[Staffan <solsson@xxxxxxxxx>]

I've found a simple repro case so I reported
https://jira.mariadb.org/browse/MDEV-17852

/Staffan

On Mon, Nov 26, 2018 at 9:14 PM Staffan <solsson@xxxxxxxxx> wrote:

> Hi,
>
> I've tried to change a user's max_connections after the limit has been
> reached (connection attempts return "has exceeded the
> 'max_connections_per_hour' resource").
>
> With MariaDB 10.2.18, running using the official docker image, we have
> "select @@max_connections;" returning 100.
>
> We have a user created "WITH MAX_CONNECTIONS_PER_HOUR 50".
>
> Now if we bump in to this limit I fail to allow more connections by
> increasing it. I've tried the following methods (using both 0 and a high
> value):
>
> ALTER USER 'site_devkit_live_index'@'%' WITH MAX_CONNECTIONS_PER_HOUR 0;
>
> UPDATE mysql.user SET max_connections = 0 WHERE
> user='site_devkit_live_index';
> FLUSH PRIVILEGES;
>
> GRANT USAGE ON *.* TO 'site_devkit_live_index'@'%'
>   WITH MAX_CONNECTIONS_PER_HOUR 0;
>
> The following indicates that the updates work:
>
> USE mysql;
> SELECT host, user, max_user_connections, max_connections FROM user;
>
> I've also tried deleting and re-creating the user.
>
> What would it take to make these updates affect the current instance? We'd
> like to avoid restarts.
>
> regards
> /Staffan
>
>