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 <[email protected] > 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 <[email protected]> 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> >> [email protected] >> >> >> > > > > -- > -------------------------------------------------------------- > Rogan R. Hamby, Data and Project Analyst > Equinox - Open Your Library > [email protected] > 1-877-OPEN-ILS | www.esilibrary.com > > >
