as creepy as the subject is, I've just configured a postgis datastore on a trunk's instance, added a layer and went browse it with the openlayers preview. After a little while it complained with "Unable to obtain connection" exception.
NOTE: the datastore is configured with "validate connections" and "prepared statements". I thought it might be either of those options causing the problem, but after trying the different combinations, it seems to happen with any. I happens after a bunch of GetFeatureInfo requests (by clicking on the OL demo page). ps shows a bunch of postgres processes "idle in transaction", and I wonder why would they be in transaction for a GetFeatureInfo: $ ps ax|grep postgres 13331 ? Ss 0:00 postgres: groldan 127.0.0.1(44594) idle 13339 ? Ss 0:00 postgres: medford 127.0.0.1(44596) idle in transaction 13547 ? Ss 0:01 postgres: medford 127.0.0.1(44608) idle in transaction 13705 ? Ss 0:00 postgres: medford 127.0.0.1(44617) idle in transaction 13710 ? Ss 0:00 postgres: medford 127.0.0.1(44618) idle in transaction 13711 ? Ss 0:00 postgres: medford 127.0.0.1(44619) idle in transaction 13712 ? Ss 0:00 postgres: medford 127.0.0.1(44620) idle in transaction 23 May 19:24:27 WARN [geotools.jdbc] - There is code leaving feature readers/iterators open, this is leaking statements and connections! 23 May 19:25:29 WARN [geotools.jdbc] - Error occurred closing connection Here's the full stack trace: <http://pastebin.com/vFURbHQw> Does anyone saw this already or can confirm? Cheers, Gabriel ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
