<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--&gt;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>