OJS 3.2.1 HTTP error 505 on clicking statistics/editorial activity

I get 505 error while trying to have a look on editorial activity (newly introduced in OJS 3.2.1)

Log:

[01-Jul-2020 08:57:08 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1226] User ‘CCCCCC_XXXXX’ has exceeded the ‘max_user_connections’ resource (current value: 15) in /home/CCCCCC/domains/abc.com/public_html/ojs/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php:70

I have got the same problem on clicking statistics/editorial activity.
In error log received:

[16-Sep-2020 10:56:15 Europe/Belgrade] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000] [1203] User SSS_xxx already has more than ‘max_user_connections’ active connections in /home/SSS/public_html/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php:70
Stack trace:
#0 /home/SSS/public_html/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct(‘mysql:host=loca…’, ‘ijcadsee_ojs853’, ‘W472]Ya-pS’, Array)
#1 /home/SSS/public_html/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection(‘mysql:host=loca…’, ‘SSS_xxx’, ‘W472]Ya-pS’, Array)
#2 /home/SSS/public_html/lib/pkp/lib/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection(‘mysql:host=loca…’, Array, Array)
#3 /home/SSS/public_html/lib/pkp/lib/vendor/illuminate/database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#4 [internal in /home/SSS/public_html/lib/pkp/lib/vendor/illuminate/database/Connection.php on line 664

How to solve that to receive the report? Open Journal Systems 3.2.1.1. installed.

Thanks.
Lazar

Hi all,

The max_user_connections limit is imposed by MySQL. See MySQL :: MySQL 8.0 Reference Manual :: 6.2.20 Setting Account Resource Limits for details. You’ll need to increase the limit.

Regards,
Alec Smecher
Public Knowledge Project Team

Hello

I did tests yesterday. One system, different journals. All tests did on one domain name

OJS system. Journal 1
before
Screenshot_1

after

Screenshot_5

OJS system. Journal 2
Screenshot_4

Some information from database.
Screenshot_100
Screenshot_101
Screenshot_102

And
[Sun Jan 31 15:47:06 2021] [error] [client 46.30.164.252] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1226] User ‘XXXXXXX’ has exceeded the ‘max_user_connections’ resource (current value: 30) in /var/www/dpnlab/data/www/jrnls.ivet.edu.ua/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php:70, referer: https://jrnls.ivet.edu.ua/index.php/1/submissions

How it possible?

hi, is this solved?

and is possible to edit max_user_connections using phpmyadmin?