Prevent SQLSTATE[HY000] more than ‘max_user_connections’

  • MailPoet threw a fatal exception due to too many database connections. In this related issue, I read that it is not critical, as MP will retry. Is that correct?

    The SQLSTATE[HY000]: General error is a temporary error that happens when MailPoet could not establish a database connection at that time. It is automatically retried later and doesn’t affect how the plugin works.

    Is MailPoet making multiple concurrent MySQL connections?

    The error message states that WordPress exceeded the maximum number of database connections per user, but it does not state how many these are and which other processes took how many of them.

    Can we, as WordPress users, do anything to prevent this problem? My customer’s installation has a lot of plugins doing their cron jobs, including WooCommerce + Germanized, MailPoet, JetPack etc.

    Excerpt from the verbose error message:

    Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [1203] User ... already has more than 'max_user_connections' active connections in .../wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
Stacktrace: 
... MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->__construct()

    Can we, as WordPress users, do anything to prevent this problem? Can we be sure that MailPoet is still functioning correctly?

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Prevent SQLSTATE[HY000] more than ‘max_user_connections’’ is closed to new replies.