That fixed it. Learning new things everyday. Thank you.
NOTE: I searched the internet for 'Geoserver Poolable Connection' and that page didn't come up - maybe it would be advantageous to have pages have keywords that match possible errors. At least they can find this ticket now. Abe. On 5/3/2011 8:26 PM, Andrea Aime wrote: > On Wed, May 4, 2011 at 5:57 AM, Richard (Abe) Coughlin<[email protected]> > wrote: >> A power failure last night lead to a Geoserver problem this morning. Errors >> are listed below. >> >> Unable to obtain connection: Cannot create PoolableConnectionFactory >> (Connection refused. Check that the hostname and port are correct and >> that the postmaster is accepting TCP/IP connections.) >> >> ERROR [geotools.jdbc] - There's code using JDBC based datastore and not >> disposing them. This may lead to temporary loss of database >> connections. Please make sure all data access code calls DataStore.dispose() >> before freeing all references to it. >> >> Postgres works perfectly. >> PSQL can access postgres with same login details from the same server. (so >> hba.conf is fine) >> Geoserver will list layers that come from postgres, but with the 'not >> enabled' icon, BUT, the enable tickbox is checked. >> Standard windows server 2003 install, v2.0.2. >> >> I believe that the issue lies within Geoserver, possibly the jdbc datastore >> needs to be emptied. Do others agree? How would I do this? Any other ideas? > A power failure will make all connections in the pool invalid. > Did you enable the connection validation flag in the pool? > With it enabled on every connection grab a quick query will be made to make > sure the connection is still usable (so there is overhead), if it's no > longer valid > it will be thrown away and another one in the pool will be attempted, > eventually > leading to grab new fresh connections. > > Cheers > Andrea > ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
