The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Case 159129] Upgrade to MariaDB MAX_USER_CONNECTIONS problem

Discussion in 'Database Discussions' started by kernow, Feb 4, 2015.

  1. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Tried to upgrade to mariaDB through WHM but get a warning that
    Code:
    Your server’s MySQL/MariaDB MAX_USER_CONNECTIONS value is larger then 2147483647. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state.
    OK, so I check :
    Code:
    SHOW VARIABLES LIKE 'max_user_connections';
    +----------------------+------------+
    | Variable_name        | Value      |
    +----------------------+------------+
    | max_user_connections | 4294967295 |
    +----------------------+------------+
    1 row in set (0.00 sec)
    Wow that seems a lot! so I try to change it:
    Code:
    SET GLOBAL max_user_connections = 2147483647;
    Query OK, 0 rows affected (0.00 sec)
    Nothing happens. The original figure still shows up and the upgrade through WHM also shows the same high figure;
    Code:
    SHOW VARIABLES LIKE 'max_user_connections';
    +----------------------+------------+
    | Variable_name        | Value      |
    +----------------------+------------+
    | max_user_connections | 4294967295 |
    +----------------------+------------+
    1 row in set (0.00 sec)
    Any suggestions please?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,704
    Likes Received:
    658
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Internal case number 159129 is open to address this issue. In the meantime, try this workaround:

    Thank you.
     
  3. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hi,
    Thanks but it didn't work. After edit we get:
    Code:
    mysql -e "SELECT Host,User,max_questions,max_updates,max_connections,max_user_connections FROM mysql.user WHERE User='root' \G"
    *************************** 1. row ***************************
                    Host: localhost
                    User: root
           max_questions: 2147483647
             max_updates: 2147483647
         max_connections: 2147483647
    max_user_connections: 2147483647
    But:
    Code:
    mysql> SHOW VARIABLES LIKE 'max_user_connections';                                                                                                                                         +----------------------+------------+
    | Variable_name        | Value      |
    +----------------------+------------+
    | max_user_connections | 4294967295 |
    +----------------------+------------+
    1 row in set (0.00 sec)
    I think your suggestion only changed roots connection limit which I belive was already fixed?
     
    #3 kernow, Feb 4, 2015
    Last edited: Feb 4, 2015
  4. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Update
    max_user_connections is now showing the adjusted figure and so we can now use the WHM MySQL/MariaDB upgrade tool.
    Thank you :)
     
Loading...

Share This Page