too many connections using pool

[guypaskar]

Hi there,

I'm using pool connections of 100 connections.
Once in awhile I'm getting the following error:

doSql pool.getConnection failed with error:Error: Host 'xxxxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Any idea on how to fix this?

Best,
Guy

[sidorares]

hi @guypaskar , could you try my suggestion from #270 ?

[guypaskar]

I'm not sure I understand what the issue there and what was the suggestion. Let me add a code snippet of how I use.

pool.getConnection(function(err, connection) {
            // Use the connection
            if(err){
                console.log('doSql pool.getConnection failed with error:' +err);
            }else{
                if(connection && 'query' in connection){
                    connection.query(stmt, function(err, rows) {
                        // And done with the connection.
                        if (err != null) {
                            console.log(err);
                        }
                        connection.release();
                        // The connection is terminated now
                        callback(rows, err);


                        // Don't use the connection here, it has been returned to the pool.
                    });
                }
            }


        }); 

[sidorares]

hm, #270 is about Pool.query() shortcut, looks like your issue is different as you are using getConnection() + connection.queue()

[sidorares]

@guypaskar looks like this it not directly related to pool, see for example http://stackoverflow.com/questions/2395654/mysql-phpmyadmin-many-connection-errors

Do you see this error for all connections or you are able to connect initially?

[guypaskar]

Yeah I know this issue.
I thought it might be related to the pool. I'm not sure that is the case yet.
Maybe the pool it creating the "interrupted connect requests" somehow.

[sidorares]

can you post debug log here ( create pool with debug option set to true ) ?

[guypaskar]

Sure. But I have to wait until the issue happens again no and only then send the log. No?

[sidorares]

yes, I need to see log around connection time.

[guypaskar]

Ok. I will try to catch it and report back.

[Kennytian]

SET GLOBAL wait_timeout = 60;

run this command in mysql client command terminal, the timeout unit is seconds