[Sqlrelay-discussion] Too many listeners

[John K. <kl...@gm...>]

Decided to punt on Solaris (my Solaris box appears to have issues)...
Built SQL Relay on linux, and it seems to perform pretty nicely.  One
thing we see, though, when we throw a lot of simultaneous connections
at it, is "Too many listeners".  That's from perl code that does this:

    die "ERROR: Couldn't prime the connection: " . $cursor->errorMessage()
        unless $cursor->sendQuery("select sysdate from dual");

Once this happens, SQL Relay is mostly toast.  With light load, you
can get data through it.  Once you up the load even slightly, it's
back to "Too many listeners".

My settings include:

            connections="5"
            maxconnections="50"
            maxqueuelength="2"
            growby="5"
            ttl="60"
            endofsession="rollback"
            sessiontimeout="600"
            runasuser="qddts"
            runasgroup="qddts"
            cursors="5"
            authtier="listener"
            handoff="pass"
            deniedips=""
            allowedips=""
            debug="none"
            maxquerysize="65536"
            maxstringbindvaluelength="4000"
            maxlobbindvaluelength="71680"
            idleclienttimeout="5"
            maxlisteners="5"
            listenertimeout="5"
            reloginatstart="false"

(This is actually the same error I saw on Solaris, but under a much lower load.)

Anyway, I searched this list, and this doesn't appear to have come up
in the past...

The box claims to be:

Linux linuxdb4 2.6.9-22.0.2.ELsmp #1 SMP Thu Jan 5 17:11:56 EST 2006
x86_64 x86_64 x86_64 GNU/Linux

Thanks.