[Spacewalk-list] osad and 'No more data to read from socket'
Adrián Márques
amarques at geocom.com.uy
Wed Sep 10 16:58:44 UTC 2008
Fixed!
I'm sorry to have bothered you all with this, I found a solution at the
bottom of the oracle-xe installation guide in the spacewalk wiki. Hadn't
thought to check there because I'd tried the page several times after
installation with no problems.
Thanks.
Adrián.
Adrián Márques escribió:
> Hi all,
>
> I've broken my spacewalk...
> I get an internal server error when I go to the 'Install' page of any
> of my systems, caused by a SQLException: No more data to read from
> socket.
>
> Things worked fine until I tried to install osa. I couldn't get it to
> work, tinkered with the configuration files a bit and encountered the
> problem when I tried installing packages again. Uninstalling
> osa-dispatcher and jabberd hasn't fixed anything.
> Looking around I found that this problem is usually related to stale
> connections in connection pools, but restarting both database and
> spacewalk did nothing, and furthermore it's only this particular page
> that I've seen afflicted so far.
>
> As a side comment: I think the osa-dispatcher package should be made
> to depend on jabberd, it wasn't hard, but I had to rummage a bit to
> find out jabberd was also necessary. Also, I found the documentation
> on osa a bit obscure, with no clear mention in the satellite docs nor
> the wiki on how to set it up on client and server. The previous osa
> discussion on the list was a big help, but not enough. It'd be great
> if anyone with the knowledge could get to write a mini how-to on the
> wiki. If no one does I'll try to once I get it work (if I can :)).
>
> Back on topic: I'm posting the traceback in case anyone knows how to
> fix the 'Install' page problem.
>
> Thanks.
>
> Adrián
>
> The following exception occurred while executing this request:
> GET /rhn/systems/details/packages/InstallPackages.do
>
> Date:9/9/08 1:52:29 PM UYT
> Headers:
> host: spacewalk.geocom.com.uy
> user-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES;
> rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
> accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
> accept-language: en,en-us;q=0.8,es-es;q=0.5,es;q=0.3
> accept-encoding: gzip,deflate
> accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
> Keep-Alive: 300
> connection: keep-alive
> referer:
> https://spacewalk.geocom.com.uy/rhn/systems/details/packages/Packages.do?sid=1000010021
>
> cookie: JSESSIONID=6814803DDF6A1C5D415A37991947EF16;
> __utmz=185197503.1216226747.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none);
> __utma=185197503.407703998778250940.1216226747.1218763063.1220116666.6;
> pxt-session-cookie=504xbb8b0863dbef84473c1540b0ee0d36c4
> Max-Forwards: 10
>
> Request:
> Local Name = spacewalk.geocom.com.uy
> Server Name = spacewalk.geocom.com.uy
> Requested Session Id came from Cookie
> Requested Session Valid = true
> Session =
> org.apache.catalina.session.StandardSessionFacade at 1f20541[session=StandardSession[6814803DDF6A1C5D415A37991947EF16]]
>
> Protocol = https
> Request Locale = en_US
> Request Character Encoding = UTF-8
> Attribute Names = rhnActiveLang, __sitemesh__page,
> javax.servlet.jsp.jstl.fmt.timeZone.request,
> javax.servlet.error.status_code, javax.servlet.error.servlet_name,
> javax.servlet.request.key_size, requestedUri,
> javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE,
> javax.servlet.error.message, session, __sitemesh__filterapplied,
> javax.servlet.request.cipher_suite, javax.servlet.error.exception,
> org.apache.struts.action.mapping.instance,
> javax.servlet.error.request_uri, org.apache.struts.action.MODULE,
>
> User Information:
> User spacewalk (id 1, org_id 1)
>
> Exception:
> javax.servlet.ServletException: No more data to read from socket
> at
> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
>
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
>
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
>
> at
> com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)
>
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:73)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
>
> at
> com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:107)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>
> at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
> at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
> at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>
> at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>
> at java.lang.Thread.run(Thread.java:636)
> Caused by: com.redhat.rhn.common.db.WrappedSQLException: No more data
> to read from socket
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
>
> at
> oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1123)
> at
> oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1075)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:480)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
>
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
>
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1072)
>
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
>
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
>
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
>
> at
> com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:137)
>
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:448)
>
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:425)
>
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:329)
>
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:334)
>
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:274)
>
> at
> com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:105)
>
> at
> com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
> at
> com.redhat.rhn.manager.rhnpackage.PackageManager.systemAvailablePackages(PackageManager.java:232)
>
> at
> com.redhat.rhn.frontend.action.rhnpackage.InstallPackageSetupAction.getDataResult(InstallPackageSetupAction.java:84)
>
> at
> com.redhat.rhn.frontend.action.rhnpackage.InstallPackageSetupAction.execute(InstallPackageSetupAction.java:62)
>
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
>
> ... 40 more
> Caused by: java.sql.SQLException: No more data to read from socket
> ... 66 more
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list