Le 05/11/2013 22:21, Attila Heidrich a écrit :
_______________________________________________Hi!
Am I still the only one on the planet using Pg9.2 as the backend?
It constantly grows the number of open files, the only workaroung I have
found, that I restart the RHQ servers once in every day - the two server
restart are shifted 12 hours. The number of open files ranges between
approximately 6K and 12K after and before restart.
Yes, I use postgres plugin - but I have tried without it, and there's no
difference at all. It is clear for me thet the server itself causes the
problem.
Should I really use another version of Pg? Or a different Database?
What's the recommendation?
Regards,
Attila
p.s. It is a fresh install... Debian 7, as the previous one, Pg is from
Pg repo, RHQ is 4.9
rhq-users mailing list
rhq-users@lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/rhq-users
Hi Attila,
Please read my previous reply to the same topic.
https://lists.fedorahosted.org/pipermail/rhq-users/2013-September/000911.html
I use Pg9.2 (for development) and have no problem of this kind. But there are many parameters which can interfere (load, sysconfig parameters,... etc).
Most likely you hit Bug 1009640 - "JDBC connections leaked during baseline calculations". We can help you rebuild RHQ 4.9 with the necessary patch, or build the master branch.
One good way to determine if the version of Postgres is the problem is to install Pg 9.1 on your system. As you're already pulling the database server binaries from Pg Debian repository, this should not be too difficult.
Regards,
Thomas
_______________________________________________
rhq-users mailing list
rhq-users@lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/rhq-users