Maximum number of database connections exceeded

Product Support Mautic 5 Install/Upgrade Support
1

Your software
My Mautic version is: 5.1
My PHP version is: 8.1
My Database type and version is: Mysql

Your problem
My problem is:
I have configured and installed Mautic without issues and it runs approx. for 10 days. After that the site goes offline with the message: “The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.”

The crownjobs throw the message:
User webXXX_Y already has more than ‘max_user_connections’ active connections.

Checking with the administration support of my server mautic is leaving the database connections open and the number of connections permitted by my hoster is a maximum of 10 connections at a time. Closing them the will get reopend right away.
Deactivating the crone jobs doesn’t change the situation that the connections will be reopened.
Database is only used from Mautic and can only be accessed locally.

Cronjobs running:
php /home/www/Mautic/bin/console mautic:segments:update
php /home/www/Mautic/bin/console mautic:campaigns:update
php /home/www/Mautic/bin/console mautic:campaigns:trigger
php /home/www/Mautic/bin/console mautic:iplookup:download
php /home/www/Mautic/bin/console messenger:consume email
php /home/www/Mautic/bin/console mautic:email:fetch
php /home/www/Mautic/bin/console mautic:maintenance:cleanup --days-old=365 --dry-run --gdpr
php /home/www/Mautic/bin/console mautic:donotsell:download
php /home/www/Mautic/bin/console mautic:max-mind:purge
php /home/www/Mautic/bin/console mautic:import

2

Database: 10.5.26-MariaDB ; mysql Ver 15.1

3

Have you checked the MySQL active connections?

You may have reached the maximum/limit of your SQL server.

If that’s the case, you’ll need to modify your my.cnf configuration file to allow more connections.

4

Thank you for your reply!

How do mean to check the active connections? As described above there are always 10 connections open that will instantly get reopend when closed by server administration.

The SQL Server it self is running without issues, as the other services using the server are perfoming without issues. Each of the services has its own user and the user is limited to 10 open connections at once, which can’t be changed.

5

You have answered your question… Can’t be changed

Your solution would be to ditch that MySQL service provider and your own self-hosted DB server.