Problem with geonetwork site

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem with geonetwork site

Usman Iqbal
Hello all,
  I have deployed the installation on a server in my network. Everything works fine initially. After a period of time the site doesn't work. When I try to login or search I get the following error.
 
I suspect it is related to database connections. Please advise.
 
Regards,
Usman
 
 
The requested operation could not be performed.

No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software caused connection abort: socket write error STACKTRACE: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at java.io.BufferedOutputStream.flushBuffer(Unknown Source) at java.io.BufferedOutputStream.flush(Unknown Source) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at jeeves.resources.dbms.Dbms.select(Dbms.java:145) at org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75) at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119) at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104) at jeeves.server.dispatchers.ServiceManager.dispatchOutput(ServiceManager.java:579) at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:608) at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:171) at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. STACKTRACE: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software caused connection abort: socket write error STACKTRACE: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at java.io.BufferedOutputStream.flushBuffer(Unknown Source) at java.io.BufferedOutputStream.flush(Unknown Source) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at jeeves.resources.dbms.Dbms.select(Dbms.java:145) at org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75) at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119) at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104) at jeeves.server.dispatchers.ServiceManager.dispatchOutput(ServiceManager.java:579) at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:608) at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:171) at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at jeeves.resources.dbms.Dbms.select(Dbms.java:145) at org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75) at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119) at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104) at jeeves.server.dispatchers.ServiceManager.dispatchOutput(ServiceManager.java:579) at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:608) at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:171) at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **
 
------------------------------------
Muhammad Usman Iqbal
PhD Candidate
EE 413A, G17
School of Surveying and Spatial Information Systems
The University of New South Wales
Sydney NSW 2052, Australia
Phone: +61 2 9385 4206
Fax: +61 2 9313 7493
Email:
<A title=mailto:m.iqbal@student.unsw.edu.au href="blocked::mailto:m.iqbal@student.unsw.edu.au">m.iqbal@...
Web: <A title=http://www.gmat.unsw.edu.au/snap/staff/iqbal_usman.htm href="blocked::http://www.gmat.unsw.edu.au/snap/staff/iqbal_usman.htm">http://users.tpg.com.au/usmani/
 
Reply | Threaded
Open this post in threaded view
|

Re: Problem with geonetwork site

Waswa bs
Usman
 
I have experienced the same problem, the short term solution is to restart your apache tomcat server every day, this works fine. You can schedule the automatic restart of the apache tomcat service.
Anyone with a better solution?
 
Waswa Stephen
FAO-SWALIM
NAIROBI.


 
On 9/20/06, Usman Iqbal <[hidden email]> wrote:
Hello all,
  I have deployed the installation on a server in my network. Everything works fine initially. After a period of time the site doesn't work. When I try to login or search I get the following error.
 
I suspect it is related to database connections. Please advise.
 
Regards,
Usman
 
 
The requested operation could not be performed.

No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software caused connection abort: socket write error STACKTRACE: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0 (Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at java.io.BufferedOutputStream.flushBuffer(Unknown Source) at java.io.BufferedOutputStream.flush (Unknown Source) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at jeeves.resources.dbms.Dbms.select(Dbms.java:145) at org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at jeeves.server.dispatchers.guiservices.Call.exec( Call.java:75) at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119) at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104) at jeeves.server.dispatchers.ServiceManager.dispatchOutput (ServiceManager.java:579) at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:608) at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java :171) at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. STACKTRACE: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software caused connection abort: socket write error STACKTRACE: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0 (Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at java.io.BufferedOutputStream.flushBuffer(Unknown Source) at java.io.BufferedOutputStream.flush (Unknown Source) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at jeeves.resources.dbms.Dbms.select(Dbms.java:145) at org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at jeeves.server.dispatchers.guiservices.Call.exec( Call.java:75) at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119) at jeeves.server.dispatchers.AbstractPage.invokeGuiServices(AbstractPage.java:104) at jeeves.server.dispatchers.ServiceManager.dispatchOutput (ServiceManager.java:579) at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:608) at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java :171) at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal (PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at jeeves.resources.dbms.Dbms.select(Dbms.java:145) at org.fao.geonet.guiservices.categories.Get.exec (Get.java:52) at jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75) at jeeves.server.dispatchers.AbstractPage.invokeGuiService(AbstractPage.java:119) at jeeves.server.dispatchers.AbstractPage.invokeGuiServices( AbstractPage.java:104) at jeeves.server.dispatchers.ServiceManager.dispatchOutput(ServiceManager.java:579) at jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch (JeevesEngine.java:608) at jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:171) at jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java :689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **
 
------------------------------------
Muhammad Usman Iqbal
PhD Candidate
EE 413A, G17
School of Surveying and Spatial Information Systems
The University of New South Wales
Sydney NSW 2052, Australia
Phone: +61 2 9385 4206
Fax: +61 2 9313 7493
Email:
[hidden email]
Web: <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://users.tpg.com.au/usmani/" target="_blank">http://users.tpg.com.au/usmani/
 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.techsay.com/default.php?page=join.php&amp;p=sourceforge&amp;CID=DEVDEV" target="_blank"> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
<a onclick="return top.js.OpenExtLink(window,event,this)" href="https://lists.sourceforge.net/lists/listinfo/geonetwork-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://sourceforge.net/projects/geonetwork" target="_blank">http://sourceforge.net/projects/geonetwork





--
Stephen B. Waswa
Somalia Water and Land Information Management System,
Food and Agriculture Organization of the United Nations,
P.O. Box 30470 -00100 Nairobi (Kenya)

Office:
3rd Floor Kalson Tower, Crescent Road,
Parklands, Nairobi

Tel: + 254 20 3743464
Fax: +254 20 3743498
Cellphone +254 721 826 320

e-mail: [hidden email]
           [hidden email]
           [hidden email]
           www.faoswalim.org
Reply | Threaded
Open this post in threaded view
|

Re: [GeoNetwork-devel] Problem with geonetwork site

Roberto Giaccio
The cause may be that mysql drops the connection after some time (I  
think 8 hours) if there is no activity.
You can use the <reconnectTime> parameter of the mysql database  
resource in the config.xml file to force a reconnection if more than  
a given time elapsed since last activity. For instance, the following  
entry forces a reconnection after one hour:

                <resource enabled="false">
                        <name>main-db</name>
                        <provider>jeeves.resources.dbms.DbmsPool</provider>
                        <config>
                                <user>admin</user>
                                <password>admin</password>
                                <driver>com.mysql.jdbc.Driver</driver>
                                <url>jdbc:mysql://$WEBSERVER_HOST/geonetwork</url>
                                <poolSize>4</poolSize>
                                <reconnectTime>3600</reconnectTime>
                        </config>
                </resource>

Regards,

                                Roberto Giaccio




On 20 Sep 2006, at 7:11, Waswa bs wrote:

> Usman
>
> I have experienced the same problem, the short term solution is to  
> restart your apache tomcat server every day, this works fine. You  
> can schedule the automatic restart of the apache tomcat service.
> Anyone with a better solution?
>
> Waswa Stephen
> FAO-SWALIM
> NAIROBI.
> [hidden email]
> www.faoswalim.org
>
>
>
> On 9/20/06, Usman Iqbal <[hidden email]> wrote:
> Hello all,
>   I have deployed the installation on a server in my network.  
> Everything works fine initially. After a period of time the site  
> doesn't work. When I try to login or search I get the following error.
>
> I suspect it is related to database connections. Please advise.
>
> Regards,
> Usman
>
>
> The requested operation could not be performed.
>
> No operations allowed after connection closed.Connection was  
> implicitly closed due to underlying exception/error: ** BEGIN  
> NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE:  
> Communications link failure due to underlying exception: ** BEGIN  
> NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software  
> caused connection abort: socket write error STACKTRACE:  
> java.net.SocketException: Software caused connection abort: socket  
> write error at java.net.SocketOutputStream.socketWrite0 (Native  
> Method) at java.net.SocketOutputStream.socketWrite(Unknown Source)  
> at java.net.SocketOutputStream.write(Unknown Source) at  
> java.io.BufferedOutputStream.flushBuffer(Unknown Source) at  
> java.io.BufferedOutputStream.flush (Unknown Source) at  
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) at  
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at  
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at  
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666) at  
> com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at  
> com.mysql.jdbc.PreparedStatement.executeInternal
> (PreparedStatement.java:936) at  
> com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1030) at  
> jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at  
> jeeves.resources.dbms.Dbms.select(Dbms.java:145) at  
> org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at  
> jeeves.server.dispatchers.guiservices.Call.exec( Call.java:75) at  
> jeeves.server.dispatchers.AbstractPage.invokeGuiService
> (AbstractPage.java:119) at  
> jeeves.server.dispatchers.AbstractPage.invokeGuiServices
> (AbstractPage.java:104) at  
> jeeves.server.dispatchers.ServiceManager.dispatchOutput  
> (ServiceManager.java:579) at  
> jeeves.server.dispatchers.ServiceManager.dispatch
> (ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch
> (JeevesEngine.java:608) at  
> jeeves.server.sources.http.JeevesServlet.execute
> (JeevesServlet.java :171) at  
> jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:
> 100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:
> 689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:
> 802) at  
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter  
> (ApplicationFilterChain.java:252) at  
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:173) at  
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213) at  
> org.apache.catalina.core.StandardContextValve.invoke  
> (StandardContextValve.java:178) at  
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126) at  
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105) at  
> org.apache.catalina.core.StandardEngineValve.invoke  
> (StandardEngineValve.java:107) at  
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148) at  
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869) at  
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:
> 664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:527) at  
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:80) at  
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run  
> (ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) **  
> END NESTED EXCEPTION ** Last packet sent to the server was 0 ms  
> ago. STACKTRACE: com.mysql.jdbc.CommunicationsException:  
> Communications link failure due to underlying exception: ** BEGIN  
> NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software  
> caused connection abort: socket write error STACKTRACE:  
> java.net.SocketException: Software caused connection abort: socket  
> write error at java.net.SocketOutputStream.socketWrite0 (Native  
> Method) at java.net.SocketOutputStream.socketWrite(Unknown Source)  
> at java.net.SocketOutputStream.write(Unknown Source) at  
> java.io.BufferedOutputStream.flushBuffer(Unknown Source) at  
> java.io.BufferedOutputStream.flush (Unknown Source) at  
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) at  
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at  
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at  
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666) at  
> com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at  
> com.mysql.jdbc.PreparedStatement.executeInternal
> (PreparedStatement.java:936) at  
> com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1030) at  
> jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at  
> jeeves.resources.dbms.Dbms.select(Dbms.java:145) at  
> org.fao.geonet.guiservices.categories.Get.exec(Get.java:52) at  
> jeeves.server.dispatchers.guiservices.Call.exec( Call.java:75) at  
> jeeves.server.dispatchers.AbstractPage.invokeGuiService
> (AbstractPage.java:119) at  
> jeeves.server.dispatchers.AbstractPage.invokeGuiServices
> (AbstractPage.java:104) at  
> jeeves.server.dispatchers.ServiceManager.dispatchOutput  
> (ServiceManager.java:579) at  
> jeeves.server.dispatchers.ServiceManager.dispatch
> (ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch
> (JeevesEngine.java:608) at  
> jeeves.server.sources.http.JeevesServlet.execute
> (JeevesServlet.java :171) at  
> jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:
> 100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:
> 689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:
> 802) at  
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter  
> (ApplicationFilterChain.java:252) at  
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:173) at  
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213) at  
> org.apache.catalina.core.StandardContextValve.invoke  
> (StandardContextValve.java:178) at  
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126) at  
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105) at  
> org.apache.catalina.core.StandardEngineValve.invoke  
> (StandardEngineValve.java:107) at  
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148) at  
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869) at  
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:
> 664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:527) at  
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:80) at  
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run  
> (ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) **  
> END NESTED EXCEPTION ** Last packet sent to the server was 0 ms  
> ago. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710) at  
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java :2621) at  
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at  
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at  
> com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at  
> com.mysql.jdbc.PreparedStatement.executeInternal  
> (PreparedStatement.java:936) at  
> com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1030) at  
> jeeves.resources.dbms.Dbms.executeQuery(Dbms.java:372) at  
> jeeves.resources.dbms.Dbms.select(Dbms.java:145) at  
> org.fao.geonet.guiservices.categories.Get.exec (Get.java:52) at  
> jeeves.server.dispatchers.guiservices.Call.exec(Call.java:75) at  
> jeeves.server.dispatchers.AbstractPage.invokeGuiService
> (AbstractPage.java:119) at  
> jeeves.server.dispatchers.AbstractPage.invokeGuiServices
> ( AbstractPage.java:104) at  
> jeeves.server.dispatchers.ServiceManager.dispatchOutput
> (ServiceManager.java:579) at  
> jeeves.server.dispatchers.ServiceManager.dispatch
> (ServiceManager.java:382) at jeeves.server.JeevesEngine.dispatch  
> (JeevesEngine.java:608) at  
> jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:
> 171) at jeeves.server.sources.http.JeevesServlet.doGet
> (JeevesServlet.java:100) at javax.servlet.http.HttpServlet.service
> (HttpServlet.java :689) at javax.servlet.http.HttpServlet.service
> (HttpServlet.java:802) at  
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:252) at  
> org.apache.catalina.core.ApplicationFilterChain.doFilter  
> (ApplicationFilterChain.java:173) at  
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213) at  
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:178) at  
> org.apache.catalina.core.StandardHostValve.invoke  
> (StandardHostValve.java:126) at  
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105) at  
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:107) at  
> org.apache.catalina.connector.CoyoteAdapter.service  
> (CoyoteAdapter.java:148) at  
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869) at  
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
> 664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:527) at  
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:80) at  
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run  
> (ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) **  
> END NESTED EXCEPTION **
>
> ------------------------------------
> Muhammad Usman Iqbal
> PhD Candidate
> EE 413A, G17
> School of Surveying and Spatial Information Systems
> The University of New South Wales
> Sydney NSW 2052, Australia
> Phone: +61 2 9385 4206
> Fax: +61 2 9313 7493
> Email: [hidden email]
> Web: http://users.tpg.com.au/usmani/
>
>
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys -- and earn  
> cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/ 
> projects/geonetwork
>
>
>
>
>
> --
> Stephen B. Waswa
> Somalia Water and Land Information Management System,
> Food and Agriculture Organization of the United Nations,
> P.O. Box 30470 -00100 Nairobi (Kenya)
>
> Office:
> 3rd Floor Kalson Tower, Crescent Road,
> Parklands, Nairobi
>
> Tel: + 254 20 3743464
> Fax: +254 20 3743498
> Cellphone +254 721 826 320
>
> e-mail: [hidden email]
>            [hidden email]
>            [hidden email]
>            www.faoswalim.org
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys -- and earn  
> cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV________________________________
> _______________
> GeoNetwork-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
> GeoNetwork OpenSource is maintained at http://sourceforge.net/ 
> projects/geonetwork