[OPEN-ILS-GENERAL] Clark Kent - the reporter - keeps quiting - why?

[Patrick Gardella]

Looks like we're fine, Jennifer, for Blake's question:

max_connections=160
numbackends = 37 (at this moment in time)

Patrick+

On Tue, Sep 20, 2016 at 3:28 PM, Blake Henderson <blake at mobiusconsortium.org
> wrote:

> Jennifer,
>
> We had that issue and it turned out to be database connections. We had a
> limit of 100 postgres connections, and we were hitting that limit. Clark
> died all the time!
>
> Run this on your database and compare to the number of allowed connections
> that you have configured on postgres:
>
> SELECT sum(numbackends) FROM pg_stat_database;
>
>
> -Blake-
> Conducting Magic
> MOBIUS
>
> On 9/20/2016 1:56 PM, Rogan Hamby wrote:
>
> Hi Jennifer,
>
> That's a very broad symptom.  Between the software, server, and hardware
> we could list thousands of theoretical causes.  Whatever your IT staff have
> discovered in investigating and troubleshooting it so far would be a good
> starting point for what should probably be shared to get some insight.
>
> But no, it's definitely not normal.  :(
>
>
>
>
>
> On Tue, Sep 20, 2016 at 2:51 PM, Walz, Jennifer <jlwalz at asbury.edu> wrote:
>
>> All –
>>
>>
>>
>> We are having enormous problems with Clark.  He keeps getting stuck and
>> quitting.   Constantly needs to be restarted.  I mean every five minutes it
>> seems.  At least every day.   What would be causing this?   This cannot be
>> normal.
>>
>>
>>
>> Any suggestions?    What should we be looking for?
>>
>>
>>
>> Thanks!
>>
>>
>>
>> Jennifer
>>
>> --------------------------------------------------
>> Jennifer Walz, MLS - Head of Reports
>> Kinlaw Library  - Asbury University
>> 1 Macklem Drive, Wilmore, KY 40390
>> 859-858-3511 ext. 2269 <859-858-3511%20ext.%202269>
>> jlwalz at asbury.edu
>>
>>
>>
>
>
>
> --
> --------------------------------------------------------------
> Rogan R. Hamby, Data and Project Analyst
> Equinox - Open Your Library
> rogan at esilibrary.com
> 1-877-OPEN-ILS | www.esilibrary.com
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160920/5281b614/attachment.html>