Page 2 of 2
Re: PostgreSQL Deadlocks
Posted: Fri Jan 25, 2013 4:21 pm
by Gavin
That seems to have done the trick. Any idea what might be eating up all of the connections? Or is the default just set too low?
Thanks for your help on this.
Thanks,
Gavin
Re: PostgreSQL Deadlocks
Posted: Sat Jan 26, 2013 4:23 pm
by scottwilkerson
By default persistent connections are made, if you have more than a handful of users that connect & have your XI open this could do it, especially if they are on a dashboard page with many items constantly refreshing in the background.
The default for MySQL is pretty low too, you may want to consider adding the following to /etc/my.cnf and then restarting mysqld
Re: PostgreSQL Deadlocks
Posted: Sat Jan 26, 2013 4:36 pm
by Gavin
Great, thanks for that. That would probably explain the 'cannot connect to database' errors we've seen in CCM.
We haven't any reoccurrence of the deadlock errors since making the change, so I think that problem is now solved.
Thanks for your help, this can be closed off.
Gavin