Dear Björn,

While i don't see the direct connection between your changed settings and error with EAGAIN, there are apparently misconfiguration in the snippet of your config file which are related to the changed settings:

1) If you have maxthreads defined as 10, then your first db-pool should have at least 10 db-connections. Note, that you might have in your app as well scheduled procs that will use as well db-connections; 15 might be a good value.

2) In the pools parameter, you have to enlist you pools (pools "*" is not allowed for new aolservers, use in your example "pool1,pool2,pool3" instead of the "*").

For an example of the config file, see:
http://cvs.openacs.org/browse/OpenACS/openacs-4/etc/config.tcl?r=HEAD

-gustaf neumann

On 01.12.10 16:25, Björn Þór Jónsson wrote:
Hi,

The server has been rock stable since I changed

ns_param   maxconnections     5

to

ns_param   maxconnections     100


and from

ns_param   maxthreads         5

to

ns_param   maxthreads         10


"ulimit -u" says:  unlimited
and /etc/security/limits.conf has all lines commented out.


Thanks for the help :)
/Björn

2010/11/22 Gustaf Neumann <neum...@wu.ac.at <mailto:neum...@wu.ac.at>>

    Dear Björn,

    The error indicates that /pthread_create /returned EAGAIN
    (paraphrased as "Resource temporarily unavailable").
    This error indicates that

       "the system lacked the necessary resources to create
        another thread, or the system-imposed limit on the
    total
        number of threads in a process {PTHREAD_THREADS_MAX}
        would be exceeded. " (from
    http://linux.die.net/man/3/pthread_create).

    so, for the user, under which the server runs, check
    "ulimit -u",
    limits.conf, etc. Can it be that you switched to a new
    machine with lower
    limits than before?

    What is you setting of maxthreads?

    -gustaf neumann

    Am 18.11.10 17:13, schrieb Björn Þór Jónsson:
    Hi,

    After recently upgrading from AOLserver 4.5.0 to
    4.5.1 and from nspostgres-4.0 to nspostgres-4.1 the
    server is repeatedly crashing (when it gets hammered
    by the google bots).  The error.log has many entries
    like these before the server dies:


    [17/Nov/2010:02:18:42][700.3218660208][-default:6195-] Notice:
    exiting: exceeded max connections per thread
    [17/Nov/2010:02:18:43][700.3217636208][-default:6193-] Notice:
    exiting: exceeded max connections per thread
    [17/Nov/2010:02:18:44][700.3219172208][-default:6196-] Notice:
    exiting: exceeded max connections per thread
    [17/Nov/2010:02:18:45][700.3218148208][-default:6194-] Error:
    Tcl exception:
    adp flush failed: connection closed
        abort exception raised
        while processing connection #31907:
            GET ...
            Host: localhost:8006
    ...
    nsthreads: pthread_create failed in NsCreateThread:
    Resource temporarily unavailable   [this is the last
    line in the log before the crash]


    This is the database section of the AOLserver config
    file:

    ns_section "ns/db/drivers"
    ns_param postgres nspostgres.so

    ns_section ns/db/pools
        ns_param   pool1              "Pool 1"
        ns_param   pool2              "Pool 2"
        ns_param   pool3              "Pool 3"

    ns_section ns/db/pool/pool1
        ns_param   maxidle            1000000000
        ns_param   maxopen            1000000000
        ns_param   connections        5
        ns_param   extendedtableinfo  true
        ns_param   driver             postgres
        ns_param   datasource         localhost::${db_name}
        ns_param   user               $user_account

    ns_section ns/db/pool/pool2
        ns_param   maxidle            1000000000
        ns_param   maxopen            1000000000
        ns_param   connections        5
        ns_param   extendedtableinfo  true
        ns_param   driver             postgres
        ns_param   datasource         localhost::${db_name}
        ns_param   user               $user_account

    ns_section ns/db/pool/pool3
        ns_param   maxidle            1000000000
        ns_param   maxopen            1000000000
        ns_param   connections        5
        ns_param   extendedtableinfo  true
        ns_param   driver             postgres
        ns_param   datasource         localhost::${db_name}
        ns_param   user               $user_account

    ns_section ns/server/${server}/db
        ns_param   pools              "*"
        ns_param   defaultpool        pool1


    The server is running on Ubuntu 10.04.1 LTS
    2.6.32-25-generic-pae #45-Ubuntu SMP Sat Oct 16
    21:01:33 UTC 2010 i686 GNU/Linux


    Is there anything I should configure differently or
    has any other ideas what might be causing this?


    /Björn


-- Björn Þór Jónsson
    http://bthj.is

    -- AOLserver - http://www.aolserver.com/

    To Remove yourself from this list, simply send an
    email to <lists...@listserv.aol.com>
    <mailto:lists...@listserv.aol.com> with the body of
    "SIGNOFF AOLSERVER" in the email message. You can
    leave the Subject: field of your email blank.



-- Univ.Prof. Dr. Gustaf Neumann
    Institute of Information Systems and New Media
    WU Vienna
    Augasse 2-6, A-1090 Vienna, AUSTRIA

    -- AOLserver - http://www.aolserver.com/

    To Remove yourself from this list, simply send an
    email to <lists...@listserv.aol.com
    <mailto:lists...@listserv.aol.com>> with the body of
    "SIGNOFF AOLSERVER" in the email message. You can
    leave the Subject: field of your email blank.




--
Björn Þór Jónsson
http://bthj.is

-- AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to <lists...@listserv.aol.com> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.




--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to 
<lists...@listserv.aol.com> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: 
field of your email blank.

Reply via email to