Hi Andrea,
Thanks for pointing me towards that article - very interesting and learnt
something new!
Whilst I didn't implement the suggested fixes it did cause me to look closer at
what was running on the server. In this case the server is a development server
so of course there are lots of things running that are not in our production
environment - in particular this server is also running Microsoft SQL Server
2005 and ArcGIS Server 9.2. Shutting down all services related to them seems to
have fixed the issue and the server is now happily seeding away.
Looks like it is related to the number of ephemeral ports being opened causing
the server to reach a maximum number. I guess editing the registry will fix
this issue permanently but I'll save that for another day - shutting down
ArcGIS Server and SQL Server works for now.
Many thanks for all the help provided!
Colin
From: [email protected] [mailto:[email protected]] On Behalf Of Andrea
Aime
Sent: 05 July 2012 09:18
To: Henderson, Colin (GIS)
Cc: [email protected]
Subject: Re: [Geoserver-devel] PSQLException: An I/O error occured while
sending to the backend.
On Thu, Jul 5, 2012 at 12:38 AM, Henderson, Colin (GIS)
<[email protected]<mailto:[email protected]>>
wrote:
Hi All,
I am not sure whether this question should be posed in the GeoWebCache or
GeoServer lists. My issue arises when using the built-in GeoWebCache
functionality but it seems the error is occuring in GeoServer - hence posting
in this list but please tell me if it would be more appropriate to post to
GeoWebCache list.
With that said here is my issue. I am trying to seed a Group Layer whose
individual layers come from a PostGIS database. I am seeding at zoom level 17
with an EPSG:900913 gridset. The threads start running and then one by one each
thread is terminated - this happens no matter how many threads are set running.
Inspecting the log file I see that the threads have been running and requesting
data from GeoServer. At the point where the threads start terminating I see a
number of the following errors:
Caused by: java.net.SocketException: No buffer space available (maximum
connections reached?): recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:209)
at org.postgresql.core.PGStream.Receive(PGStream.java:445)
at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:350)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1774)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
... 109 more
</ServiceException></ServiceExceptionReport>
If I interpret this correctly then it would seem that GeoServer is running out
of connections? I am also seeing the following error message in the log file:
"No buffer space available (maximum connections reached?): recv failed"
This error seems to be common on Windows (just googled for it) and may affect a
variety of database (including sql server).
This article seems to be helpful, give it a shot:
http://technology-for-human.blogspot.it/2011/05/postgresql-strange-database-server.html
Cheers
Andrea
--
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
________________________________
This email and any attached files are confidential and copyright protected. If
you are not the addressee, any dissemination of this communication is strictly
prohibited. Unless otherwise expressly agreed in writing, nothing stated in
this communication shall be legally binding.
The ultimate parent company of the Atkins Group is WS Atkins plc. Registered in
England No. 1885586. Registered Office Woodcote Grove, Ashley Road, Epsom,
Surrey KT18 5BW. A list of wholly owned Atkins Group companies registered in
the United Kingdom and locations around the world can be found at
http://www.atkinsglobal.com/site-services/group-company-registration-details
Consider the environment. Please don't print this e-mail unless you really need
to.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
