Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#394 Leaking connections

1.3 Dev Q
open
Takayuki SUTO
5
2013-12-02
2013-02-14
knienart
No

After number of connects/transactions/disconnects using JDBC, coordinator stacks up the queries and non-existing connections in the pg_stat_activity like
..
application_name | pgxc
client_addr | ::1
client_hostname |
client_port | 52413
backend_start | 2013-02-14 13:16:28.183573+01
xact_start |
query_start | 2013-02-14 13:20:41.063212+01
state_change | 2013-02-14 13:20:41.06787+01
waiting | f
state | idle
query | SET SESSION AUTHORIZATION DEFAULT;RESET ALL;

the query is cleary executed from agent_reset_session(PoolAgent *agent) in poolmgr.c.

Transactions are succesfult completed but some connections are never returned to the pool it seems, so after # of cycles system refuses new connections.
The tests are too complicated to post here, hint could be that SET SCHEMA is called for each of the nerw connections - remember there was some bug related to SET.

Discussion

  • Koichi Suzuki
    Koichi Suzuki
    2013-03-12

    Reproduce the problem first to locate what is wrong. Need simple reproduction.

     
  • Koichi Suzuki
    Koichi Suzuki
    2013-03-12

    • assigned_to: nobody --> sudot
     
  • Koichi Suzuki
    Koichi Suzuki
    2013-06-11

    • milestone: 2663467 --> 1,2 Dev Q
     
  • Koichi Suzuki
    Koichi Suzuki
    2013-12-02

    • Group: 1.2 Dev Q --> 1.3 Dev Q