<div dir="ltr">Hi<div><br></div><div>What does it mean when a connection in Postgres has last query DISCARD ALL for several days? All timeouts settings are for max 300 seconds.</div><div>I am planning to migrate 3.3.3-->3.3.4 but it takes time on production so I am trying to understand if this issue is known. Note that pgpool does not know anything about this connection anymore so it is different than defect #107 which 3.3.4 fix.</div><div><br></div><div><br></div><div>SELECT * FROM pg_stat_activity LIMIT 1</div><div><br>
<div><br></div><div><div> datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | query</div><div>---------+------------+------+----------+-----------------+------------------+----------------+-----------------+-------------+-------------------------------+------------+-------------------------------+------------------------------+---------+-------+--------------</div><div> 2124078 | db_name | 8508 | 16395 | user_name | | 11.134.32.116 | | 49032 | 2014-09-22 01:23:18.694586-07 | | 2014-09-22 01:28:20.474515-07 | 2014-09-22 01:28:20.47483-07 | f | idle | DISCARD ALL</div></div><div><br></div><div>Thanks,</div><div>Yaron</div></div></div>