Actions
Bug #790
closedjava.sql.SQLException: Operation not allowed after ResultSet closed
Start date:
06/24/2010
Due date:
% Done:
0%
Estimated time:
Description
DESCRIPTION :
Certaines vues, à priori celles qui ont un ou plusieurs paramètres, ne sont plus accessibles via le client SOAP du portail et nous font remonter un exception.
- On note qu'un update de la page web appelante suffit le plus souvent à rafraîchir la vue correctement et à récupérer les données.
- On note aussi que le test sur la modification du plugin avec un rajout d'un Result Close potentiellement manquant à eu
pour effet de ne plus rafraîchir les données dans la BDD.
LAVOISIER : http://cclavoisierfr.in2p3.fr:9000/LavoisierService/view/index
INDICE : http://eswars.blogspot.com/2006/03/javasqlsqlexception-operation-not.html (synchronize)
STACK TRACE :
[2010-06-18 09:33:21,576] WARN fr.in2p3.lavoisier.adapter.AggregatorAdapter : Failed to aggregate view: site_nagios[@name='INFN-NAPOLI-ARGO'] 59911 fr.in2p3.lavoisier.engine.SerializationException: Exception raised for view 'site_nagios' 59912 at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsElement(InvokedDataView.java:70) 59913 at fr.in2p3.lavoisier.adapter.AggregatorAdapter.writeToOutputStream(AggregatorAdapter.java:75) 59914 at fr.in2p3.lavoisier.engine.AdapterReader.getAndValidateInputStreamFromStreamAdapter(AdapterReader.java:50) 59915 at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.buildRecursive(OnDiskInvokedTree.java:36) 59916 at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.build(OnDiskInvokedTree.java:24) 59917 at fr.in2p3.lavoisier.engine.view.InvokedDataView.generateViewAsStream(InvokedDataView.java:119) 59918 at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsSource(InvokedDataView.java:88) 59919 at fr.in2p3.lavoisier.engine.view.DataView.getAsString(DataView.java:227) 59920 at fr.in2p3.lavoisier.LavoisierEngine.getViewAsString(LavoisierEngine.java:131) 59921 at fr.in2p3.lavoisier.service.impl.LavoisierServiceImpl.getView(LavoisierServiceImpl.java:177) 59922 at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source) 59923 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 59924 at java.lang.reflect.Method.invoke(Method.java:597) 59925 at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:136) 59926 at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82) 59927 at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:54) 59928 at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68) 59929 at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:56) 59930 at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) 59931 at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:92) 59932 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220) 59933 at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78) 59934 at org.apache.cxf.transport.http_jetty.JettyHTTPDestination.serviceRequest(JettyHTTPDestination.java:278) 59935 at org.apache.cxf.transport.http_jetty.JettyHTTPDestination.doService(JettyHTTPDestination.java:252) 59936 at org.apache.cxf.transport.http_jetty.JettyHTTPHandler.handle(JettyHTTPHandler.java:70) 59937 at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726) 59938 at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206) 59939 at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 59940 at org.mortbay.jetty.Server.handle(Server.java:324) 59941 at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) 59942 at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842) 59943 at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648) 59944 at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) 59945 at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) 59946 at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) 59947 at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) 59948 Caused by: fr.in2p3.lavoisier.engine.SerializationException: Exception raised for view 'nagios_notification' 59949 at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsSource(InvokedDataView.java:95) 59950 at fr.in2p3.lavoisier.engine.tree.DependenciesMapFactory.getViewContent(DependenciesMapFactory.java:52) 59951 at fr.in2p3.lavoisier.engine.tree.DependenciesMapFactory.createDependenciesMap(DependenciesMapFactory.java:41) 59952 at fr.in2p3.lavoisier.engine.tree.InMemoryInvokedTree.build(InMemoryInvokedTree.java:34) 59953 at fr.in2p3.lavoisier.engine.view.InvokedDataView.generateViewAsDOM(InvokedDataView.java:106) 59954 at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsElement(InvokedDataView.java:67) 59955 ... 35 more 59956 Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed 59957 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 59958 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 59959 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 59960 at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:768) 59961 at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:812) 59962 at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5528) 59963 at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5448) 59964 at fr.in2p3.lavoisier.adapter.DatabaseAdapter.writeToOutputStream(DatabaseAdapter.java:189) 59965 at fr.in2p3.lavoisier.engine.AdapterReader.getAndValidateInputStreamFromStreamAdapter(AdapterReader.java:50) 59966 at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.buildRecursive(OnDiskInvokedTree.java:36) 59967 at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.build(OnDiskInvokedTree.java:24) 59968 at fr.in2p3.lavoisier.engine.view.InvokedDataView.generateViewAsStream(InvokedDataView.java:119) 59969 at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsSource(InvokedDataView.java:88) 59970 ... 40 more
Updated by Reynaud Sylvain over 12 years ago
- Status changed from New to Rejected
Lavoisier 1.x is not supported anymore.
Actions