humhub-contrib / gallery

7 stars 11 forks source link

DB-Error with max_user_connections #50

Closed klauswagner closed 4 years ago

klauswagner commented 4 years ago

I use

Procedure:

After some time, "An internal server error occurred" appears in the frontend.

If I start e.g. "yii integrity/run" via CLI, I get the following error message: Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [1203] User db23***** already has more than 'max_user_connections' active connections'. And in php error.log: PDOException: SQLSTATE[HY000] [1203] User db236519_118 already has more than 'max_user_connections' active connections in /kunden/23*****/humhub/protected/vendor/yiisoft/yii2/db/Connection.php:703

max_user_connections is set to 150 (and unfortunately cannot be increased).

I think the module generates a lot of DB-queries without a limitation of the user_connections because of the already existing content.

buddh4 commented 4 years ago

Does this problem still occure with the latest module version?

klauswagner commented 4 years ago

In my new test with HumHub 1.5.2 and Gallery Version: 1.1.2 it works without Problem.