On 11.07.17 09:13, Alex Balashov wrote:
On Tue, Jul 11, 2017 at 09:12:51AM +0200, Daniel-Constantin Mierla wrote:
Hello,
On 11.07.17 08:49, Alex Balashov wrote:
On Tue, Jul 11, 2017 at 08:41:24AM +0200, Daniel-Constantin Mierla wrote:
are the connections to the same database or to different databases? Even on the same server, the database name matters.
Hi,
Same database, same server, same database name.
are you doing xmlrpc/jsonrpc over http?
In fact, I am. xhttp + jsonrpcs is the only reason for the TCP listener.
There are some rpc commands that open database connection, do the operation, and then close it. Normally, it still should reuse an existing connection, as the "open connection" should search for existing one first.
Can you see if all the connections are in open state or some are pending close? Is the number of connections stable or fluctuates over the time?
From your summary, I noticed that the tcp workers (which handle also
http) had two db connections, not sure it was only because of what you selected to put in the mail or that's the rule.
Cheers, Daniel