Hi all, some times i'm having a "Too many connections" message on my ISP panel, and when this message appear the website doesn't respond correctly, emails don't work, and so. In the error log i got this message: Code: Jul 29 13:05:34 server1 dovecot: auth: Error: auth worker: Aborted PASSV request for [email protected]: Internal auth worker failure Jul 29 13:05:34 server1 dovecot: auth-worker(3276): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:05:34 server1 dovecot: auth-worker(3276): Error: sql([email protected],187.162.100.216,<MSn2Zpirp967omTY>): Password query failed: Not connected to database Jul 29 13:05:34 server1 dovecot: auth-worker(3277): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:05:34 server1 dovecot: auth: Error: auth worker: Aborted PASSV request for [email protected]: Internal auth worker failure Jul 29 13:05:34 server1 dovecot: auth-worker(3277): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:05:34 server1 dovecot: auth-worker(3277): Error: sql([email protected],187.162.100.216,<PS72Zpirot67omTY>): Password query failed: Not connected to database Jul 29 13:05:34 server1 dovecot: auth-worker(3278): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:05:34 server1 dovecot: auth: Error: auth worker: Aborted PASSV request for [email protected]: Internal auth worker failure Jul 29 13:05:34 server1 dovecot: auth-worker(3278): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:05:34 server1 dovecot: auth-worker(3278): Error: sql([email protected],187.162.100.216,<CTD2ZpirpN67omTY>): Password query failed: Not connected to database Jul 29 13:05:35 server1 dovecot: auth-worker(3274): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:05:35 server1 dovecot: auth-worker(3274): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:05:40 server1 dovecot: auth-worker(3274): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 25 seconds before retry Jul 29 13:06:05 server1 dovecot: auth-worker(3274): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 125 seconds before retry Jul 29 13:20:52 server1 dovecot: auth-worker(5516): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:20:52 server1 dovecot: auth-worker(5516): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:20:53 server1 dovecot: auth-worker(5516): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:20:53 server1 dovecot: auth-worker(5516): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:20:58 server1 dovecot: auth-worker(5516): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 25 seconds before retry Jul 29 13:22:14 server1 dovecot: auth-worker(5716): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:22:14 server1 dovecot: auth-worker(5716): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:22:14 server1 dovecot: auth-worker(5718): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:22:14 server1 dovecot: auth: Error: auth worker: Aborted PASSV request for [email protected]: Internal auth worker failure Jul 29 13:22:14 server1 dovecot: auth-worker(5718): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:22:14 server1 dovecot: auth-worker(5718): Error: sql([email protected],187.162.100.216,<pVmNopirst+7omTY>): Password query failed: Not connected to database Jul 29 13:22:15 server1 dovecot: auth-worker(5716): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:22:15 server1 dovecot: auth-worker(5716): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:22:20 server1 dovecot: auth-worker(5716): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 25 seconds before retry Jul 29 13:25:54 server1 dovecot: auth-worker(6251): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:25:54 server1 dovecot: auth-worker(6251): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:25:54 server1 dovecot: auth-worker(6253): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:25:54 server1 dovecot: auth: Error: auth worker: Aborted PASSV request for [email protected]: Internal auth worker failure Jul 29 13:25:54 server1 dovecot: auth-worker(6253): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:25:54 server1 dovecot: auth-worker(6253): Error: sql([email protected],187.162.100.216,<jlOzr5irM+C7omTY>): Password query failed: Not connected to database Jul 29 13:25:55 server1 dovecot: auth-worker(6251): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:25:55 server1 dovecot: auth-worker(6251): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:28:05 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:28:05 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:28:06 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:28:06 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:28:11 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 25 seconds before retry Jul 29 13:28:11 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 25 seconds before retry Jul 29 13:28:36 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 125 seconds before retry Jul 29 13:28:36 server1 dovecot: auth-worker(6596): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 125 seconds before retry Jul 29 13:29:05 server1 dovecot: auth: Error: auth worker: Aborted PASSV request for [email protected]: Lookup timed out Jul 29 13:29:05 server1 dovecot: auth-worker(6596): Error: sql([email protected],187.162.100.216,<xMZ6t5irdeC7omTY>): Password query failed: Not connected to database Jul 29 13:31:29 server1 dovecot: auth-worker(7219): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:31:29 server1 dovecot: auth-worker(7219): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 1 seconds before retry Jul 29 13:31:30 server1 dovecot: auth-worker(7219): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 5 seconds before retry Jul 29 13:31:35 server1 dovecot: auth-worker(7219): Error: mysql(localhost): Connect failed to database (dbispconfig): Too many connections - waiting for 25 seconds before retry Obviously this is a mysql error for what can i see, but how is it produce?, and how can i solve it? Thanks for all
You can solve it using Internet Search Engines with Code: mysql Too many connections Are those attempts to connect to database coming from your host? If they are from somewhere else, it would be good to deny database use from elsewhere, only allow form host itself and hosts you trust.
Set a higher value for max_connections and max_user_connections in the mysql/mariadb config, e.g. try to set them to 1000. The values need to be set in the [mysqld] section of the config file: max_connections = 1000 max_user_connections = 1000
The first thing I check it was if the Mysql port was blocked and there was not external connections. My problem is more with the limit that Mysql has as default "151", that is what i need to change.
Thanks @till , the file that i need to change is my.cnf?, and another question is this located in /etc/mysql?
Depends on your setup and Linux distribution. Search for the file in /etc/mysql/ or /etc/mariadb/ that contains the [mysqld] section of the config and then add it in that config section (means, somewhere below that line but before the next block.
Little detail I never said my linux distribution ,I'm using Debian 9 with the perfect installation guide. having said that, under /etc/... I don't have a mariadb folder so by deduction is in mysql , and looking in the files the one that has the section [mysqld] is called 50-server.cnf, and is placed under mariadb.conf.d So i assume is in that file where should i add those lines.