02 July 2020, 23:55

Hello

I'm running Mahara 20.04.

I have a recurring problem connecting to Mahara's database. Here's the error log:

mysqli error: [1203: User ***** already has more than 'max_user_connections' active connections] in CONNECT(****, '******', '****', ******)
[23-Jun-2020 14:10:48 Europe/Paris] Call stack (most recent first):
[23-Jun-2020 14:10:48 Europe/Paris]   * require() at /home/****/public_html/mahara/view/blocks.json.php:14
[23-Jun-2020 14:10:48 Europe/Paris] 
[23-Jun-2020 14:10:48 Europe/Paris] [WAR] 6e (init.php:189) Mahara could not connect to the application database.

What can I do to solve this error ?

Cheers.

Anthony.

03 July 2020, 9:45

Hi Anthony,

It sounds like the amount of concurrent connections by database username is set to a certain number at the MySql level and it's being exceeded.

There is some more information on how to find that value and possible ways to increase it

https://dba.stackexchange.com/questions/47131/how-to-get-rid-of-maximum-user-connections-error

Cheers

Robert

03 July 2020, 18:36

Hi Robert

This variable max_user_connections is set to 50 by my webhost and i can't change it. Is it enough to make mahara 20.04 running ?

I changed the php version to 7.3. Can this improve the situation ?

thanx again for the support !

Cheers.

Anthony.

05 July 2020, 22:06

Hello
I have this error again while I am alone using the site:

05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189) Mahara could not connect to the application database.
[05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189) 
[05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189)  * If you are using Mahara, please wait a minute and try again
[05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189)  * If you are the administrator, please check your database settings and make sure your database is available
[05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189) 
[05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189) The error received was:
[05-Jul-2020 11:46:59 Europe/Paris] [WAR] f8 (init.php:189) mysqli error: [1203: User *** already has more than 'max_user_connections' active connections] in CONNECT(localhost, '****', '****', *****)
[05-Jul-2020 11:46:59 Europe/Paris] Call stack (most recent first):
[05-Jul-2020 11:46:59 Europe/Paris]   * require() at /home/****/public_html/mahara/view/blocks.json.php:14

Is it possible that the connections won't close properly because I don't see how it's possible to overload the installation with only one user.

Or could there be a problem with blocks.json.php?

With kind regards,

Anthony.

13 July 2020, 13:41

Hi Anthony,

Sorry for the delay. I made this bug report to track this issue https://bugs.launchpad.net/mahara/+bug/1887321

We'll try to resolve it as soon as we have some time available for it.

Thanks,

Cecilia

13 July 2020, 22:52

Hi Celia,

Thank you for your reply.

I will follow the bug tracker.

Cheers.

Anthony.