search

GovernIB / rolsac

Gestor de continguts administratius
4 stars 1 forks source link

la versió 1.1.0 es bloqueja en producció #194

Closed kitanibaladmin closed 8 years ago

kitanibaladmin commented 8 years ago

Numero: 382 Creació: 2012-05-10 10:31:39.000 Originally created by: ejaen

Originally owned by: ejaen

El dia 2 de Maig al passar a producció les diferents versions 1.1&nbps; van detectar un bloqueig a base de dades. Només es va usar el back antic.

Desconeixem la causa, i de si té a veure o no amb algun canvi del back2.

---- additional_information ----

Aquest és el correu reportat de base de dades:

La primera bloqueja a la segona, la matam?

SQL_TEXT

update RSC_ARCHIV set ARC_NOMBRE=:1, ARC_MIME=:2, ARC_PESO=:3, A RC_DATOS=:4 where ARC_CODI=:5

SYSTEM@webpro> @ses Introduzca un valor para sid: 189

SQL_TEXT

update RSC_FICHA set FIC_FECPUB=:1, FIC_FECCAD=:2, FIC_FECACT=:3 , FIC_ICONO=:4, FIC_IMAGEN=:5, FIC_BANER=:6, FICVALIDA=:7, FIC INFO=:8, FIC_RESPON=:9, FIC_URLVID=:10, FIC_URLFOR=:11, FIC_FORT EM=:12 where FIC_CODI=:13

kitanibaladmin commented 8 years ago

anonymous 2012-05-10 10:34:52 *Originally by: ejaen

L'Andreu proposa passar a producció rolsac 1.0 amb les llibreries de 1.1

(veure #344)

kitanibaladmin commented 8 years ago

anonymous 2012-05-10 10:41:18 *Originally by: ejaen

El problema és que no tenim cap informació al log que ens doni pistes, i no podem generar el dump del heap perquè no cau per falta de memoria, i generar-lo amb jmap no és&nbps; una opció perquè desde serveis web no volen autrar la web durant minuts (heap ocupa 1.5Gb)

El metrics.log del jboss no ens ajuda perque no permet saber quina petició ha causat el bloqueig, doncs només registre les peticions EJB completades, i tampoc informa dels paràmetres.

En el proper pas a producció activaré el log interceptor que té el rolsac

org.ibit.rol.sac.persistence.util.LogInterceptor

i aquest si que registre totes les peticions encara que no s'hagin completat, i a més dona informació dels paràmetres.

kitanibaladmin commented 8 years ago

anonymous 2012-05-11 08:02:52 *Originally by: ejaen

Algú te experiència amb Jmeter o alguna altre eïna en tests d'estres?

kitanibaladmin commented 8 years ago

anonymous 2012-05-11 11:35:14 *Originally by: ejaen

En vista que ningú té experiència ja els farè jo mateix

kitanibaladmin commented 8 years ago

anonymous 2012-05-25 07:51:54 *Originally by: ejaen

Estic mirant la causa del bloqueig. Encara no sabem la causa. Sabem que són dos sessions diferents. Podria ser que el update en ARXIU no es commiti per algun motiu, i això causa que es bloquegi el update en FITXA.

Cal saber el quan passa i el que. Els logs ara no donen aquesta informació, per tant canviaré els logs per a que surti el ID de la sessió, la traça del commits, i els IDs del objectes afectats.

Els logs de mètriques si mostren que el rolsac estava molt carregat (segurament per la webcaib) i que hi havia operacions en marxa que trigant més de 30 segons (adjunto log)

lucboib/BoibIndexManager.optimitzarIndex org.ibit.rol.sac.persistence.FichaFacade.crearFichaUA es.caib.link.TemaBean.getLinksByUORSS org.ibit.rol.sac.persistence.ArchivoFacade.obtenerArchivo org.ibit.rol.sac.persistence.FichaFacade.grabarFicha org.ibit.rol.sac.persistence.FichaFacade.buscarFichas es.caib.link.TemaBean.getLinksByMat

Si algú vol aportar algo ho pot fer.

kitanibaladmin commented 8 years ago

anonymous 2012-05-28 09:34:28 *Originally by: ejaen

Situació:

El divendres 25 a les 8:13h es va fer un paspro de la versio 1.0.3, i es van tornar a produir bloquejos, i ara amb més taules afectades.

També vam activar el showParams per veure els parametres de les operacions amb time-out. Les operacions amb time-out son, en resum:

(9:05h) buscarFichas&nbps; 4min (10:36h) grabarNormativaLocal&nbps; 250 min!!&nbps; id??? (el log treu malament el toString: org.ibit.rol.sac.model.NormativaLocal@1183dc) reindexarMicrosite&nbps; 1 min borrarFichaUA obtenerSeccion grabarFicha&nbps; 32 min&nbps; ids: 1147987, 1147990, 1147993, 1147996, 1147999, 1148002 TemaBean.getLinksByUORSS&nbps; 1 min BocaibSessionBean.findByua borrarDocumento 40 min&nbps; 57 min 40 min&nbps; ids: 34067, 34068, 34068&nbps; <-- es extrany que hi ha un id repetit, pot indicar que el mateix document s'esta intentant borrar a la vegada.

Divendres a les 14:47 es va tornar a enrera a producció a la versió 1.0.2

Sembla que amb la versió 1.0.2 no es produeix aquests bloquejos.&nbps; Ho compararè amb la versió 1.0.3

Per saber la causa concreta del bloqueig, tinc pendent treure als logs el session ID de cada connexió, i info de les transaccions . El problema es que el session ID és un atribut intern de Oracle i no veig en els sources de Oracle cap API que ho consulti.

kitanibaladmin commented 8 years ago

anonymous 2012-05-29 07:18:06 *Originally by: ejaen

Situació:

S'observa en els server.log dos coses:

A) en diferents dies que ha tingut bloqueig, en el moment de molta càrrega de memoria,&nbps; un time-out de una transacció, i una posterior excepció "javax.transaction.RollbackException: Already marked for rollback"&nbps; en una altre operació que utilitza la mateixa transacció:

2012-05-21 10:58:57,230 INFO&nbps; [es.caib.utilities.cache.CacheUtil] Eliminada cache: caibCacheRPPGB.Archivo 2012-05-21 10:58:57,230 INFO&nbps; [es.caib.utilities.cache.CacheUtil] Eliminada cache: caibCacheRSS.xml 2012-05-21 10:58:57,230 INFO&nbps; [es.caib.utilities.cache.CacheUtil] Eliminada cache: caibCacheProc.buscar 2012-05-21 10:58:57,230 INFO&nbps; [es.caib.utilities.cache.CacheUtil] Eliminada cache: caibCacheRPPGB 2012-05-21 10:58:57,230 INFO&nbps; [es.caib.root.indra.cache.DelegadoCache] Porcentaje de uso de memoria Heap Alto. Vaciado de caché. 2012-05-21 10:59:01,019 WARN&nbps; [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=sweblin1.caib.es//453653, BranchQual=] timed out. status=STATUS_ACTIVE 2012-05-21 10:59:01,040 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract boolean org.ibit.rol.sac.persistence.intf.AccesoManagerLocal.tieneAccesoFicha(java.lang.Long), causedBy: net.sf.hibernate.TransactionException: could not register synchronization with JTA TransactionManager &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3322) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.loader.Loader.doList(Loader.java:1033) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.loader.Loader.list(Loader.java:1024) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3613) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.ejb.HibernateEJB.getUsuario(HibernateEJB.java:176) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.ejb.AccesoManagerEJB.tieneAccesoFicha(AccesoManagerEJB.java:136) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.GeneratedMethodAccessor1099.invoke(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:698) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:198) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.MetricsInterceptor.invoke(MetricsInterceptor.java:142) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:101) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:348) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:206) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:345) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.Container.invoke(Container.java:723) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:434) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at $Proxy196.tieneAccesoFicha(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.ejb.FichaFacadeEJB.buscarFichas(FichaFacadeEJB.java:162) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:698) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:198) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.MetricsInterceptor.invoke(MetricsInterceptor.java:142) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:101) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:348) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:206) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:345) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.Container.invoke(Container.java:723) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:74) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.dispatch(Invocation.java:76) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.dispatch(Invocation.java:68) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.invoke(Invocation.java:96) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:213) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:484) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:111) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:193) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:115) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at $Proxy151.buscarFichas(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl.buscarFichas(FichaDelegateImpl.java:71) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c.CGLIB$buscarFichas$0$12(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c$$FastClassByCGLIB$$98f9dee4.invoke(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:201) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.util.DelegateLogInterceptor.intercept(DelegateLogInterceptor.java:88) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c.buscarFichas(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegate.buscarFichas(FichaDelegate.java:62) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.contenido.ficha.EditarFichaAction.busqueda(EditarFichaAction.java:386) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:252) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.BaseDispatchAction.execute(BaseDispatchAction.java:44) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.indra.actions.BackRequestProcessor.processActionPerform(BackRequestProcessor.java:52) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.indra.actions.LongWaitRequestProcessor.processActionPerform(LongWaitRequestProcessor.java:66) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.CustomRequestProcessor.process(CustomRequestProcessor.java:31) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:81) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:177) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at es.caib.loginModule.auth.FormResourcesValve.invoke(FormResourcesValve.java:34) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at es.caib.loginModule.auth.ClientIPValve.invoke(ClientIPValve.java:72) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.Thread.run(Thread.java:662) Caused by: javax.transaction.RollbackException: Already marked for rollback &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.tm.TransactionImpl.registerSynchronization(TransactionImpl.java:717) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3317) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; ... 126 more

B) En el log del dia 21 també s'observa aquesta excepció:

2012-05-21 13:36:25,416 ERROR [org.jboss.resource.connectionmanager.TxConnectionManager] There is something wrong with the pooling? java.lang.IllegalStateException: afterCompletion called with wrong tx! Expected: null, actual: TransactionImpl:XidImpl [FormatId=257, GlobalId=sweblin1.caib.es//99158, BranchQual=] &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TxRemover.afterCompletion(TxConnectionManager.java:607) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.connectionmanager.TransactionSynchronizer.invokeAfter(TransactionSynchronizer.java:195) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.connectionmanager.TransactionSynchronizer.afterCompletion(TransactionSynchronizer.java:156) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1412) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:476) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:491) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:359) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:206) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:345) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.Container.invoke(Container.java:723) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:74) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.dispatch(Invocation.java:76) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.dispatch(Invocation.java:68) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.invoke(Invocation.java:96) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:213) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:484) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:111) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:193) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:115) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at $Proxy151.grabarFicha(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl.grabarFicha(FichaDelegateImpl.java:60) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c.CGLIB$grabarFicha$0$11(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c$$FastClassByCGLIB$$98f9dee4.invoke(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:201) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.util.DelegateLogInterceptor.intercept(DelegateLogInterceptor.java:88) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c.grabarFicha(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegate.grabarFicha(FichaDelegate.java:57) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.negocio.GrabadorFicha.grabar(GrabadorFicha.java:12) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.negocio.GrabadorBase.guardar(GrabadorBase.java:36) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.contenido.ficha.EditarFichaAction.editar(EditarFichaAction.java:191) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:252) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.BaseDispatchAction.execute(BaseDispatchAction.java:44) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.indra.actions.BackRequestProcessor.processActionPerform(BackRequestProcessor.java:52) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.indra.actions.LongWaitRequestProcessor.processActionPerform(LongWaitRequestProcessor.java:145) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.CustomRequestProcessor.process(CustomRequestProcessor.java:31) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:81) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:177) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at es.caib.loginModule.auth.FormResourcesValve.invoke(FormResourcesValve.java:34) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at es.caib.loginModule.auth.ClientIPValve.invoke(ClientIPValve.java:72) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.Thread.run(Thread.java:662) 2012-05-21 13:36:25,418 WARN&nbps; [net.sf.hibernate.cache.ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): 1130998 2012-05-21 13:36:25,418 WARN&nbps; [net.sf.hibernate.cache.ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): 1142901 2012-05-21 13:36:25,418 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException in method: public abstract java.lang.Long org.ibit.rol.sac.persistence.intf.FichaFacade.grabarFicha(org.ibit.rol.sac.model.Ficha) throws java.rmi.RemoteException, causedBy: net.sf.hibernate.JDBCException: Could not execute JDBC batch update &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:133) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:59) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:656) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:642) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.ejb.HibernateEJB.addOperacion(HibernateEJB.java:379) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.ejb.FichaFacadeEJB.grabarFicha(FichaFacadeEJB.java:119) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:698) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:198) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.MetricsInterceptor.invoke(MetricsInterceptor.java:142) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:101) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:348) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:206) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:345) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.ejb.Container.invoke(Container.java:723) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:74) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.dispatch(Invocation.java:76) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.dispatch(Invocation.java:68) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.Invocation.invoke(Invocation.java:96) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:213) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:484) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:111) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:193) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:179) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:115) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at $Proxy151.grabarFicha(Unknown Source) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl.grabarFicha(FichaDelegateImpl.java:60) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c.CGLIB$grabarFicha$0$11(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c$$FastClassByCGLIB$$98f9dee4.invoke(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:201) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.util.DelegateLogInterceptor.intercept(DelegateLogInterceptor.java:88) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegateImpl$$EnhancerByCGLIB$$f430598c.grabarFicha(<generated>) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.persistence.delegate.FichaDelegate.grabarFicha(FichaDelegate.java:57) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.negocio.GrabadorFicha.grabar(GrabadorFicha.java:12) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.negocio.GrabadorBase.guardar(GrabadorBase.java:36) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.contenido.ficha.EditarFichaAction.editar(EditarFichaAction.java:191) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.reflect.Method.invoke(Method.java:597) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:252) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.BaseDispatchAction.execute(BaseDispatchAction.java:44) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.indra.actions.BackRequestProcessor.processActionPerform(BackRequestProcessor.java:52) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.indra.actions.LongWaitRequestProcessor.processActionPerform(LongWaitRequestProcessor.java:145) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.ibit.rol.sac.back.action.CustomRequestProcessor.process(CustomRequestProcessor.java:31) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:81) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:177) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at es.caib.loginModule.auth.FormResourcesValve.invoke(FormResourcesValve.java:34) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at es.caib.loginModule.auth.ClientIPValve.invoke(ClientIPValve.java:72) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.BatchUpdateException: No more data to read from socket &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:345) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10844) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:554) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126) &nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; ... 107 more

kitanibaladmin commented 8 years ago

anonymous 2012-05-30 07:43:27 *Originally by: ejaen

Situació:

Segueixo preparant els logs per treure traces del sessionId i de les connexions que no es tanquen, i així poder saber exactament la causa dels bloquejos. De moment puc accedir a la OracleConnection. Falta trobar com accedir al sessionId.

kitanibaladmin commented 8 years ago

anonymous 2012-05-31 07:03:47 *Originally by: ejaen

Situació:

Ja tinc accés al sessionId de Oracle. Ara falta fer un metode per obtenir la sessío hibernate actual desde un interceptor hibernate. Amb Hibernate 3 existeix un metode del SessionFactory que ho fà, però no amb Hibernate 2.

kitanibaladmin commented 8 years ago

anonymous 2012-06-01 07:53:00 *Originally by: ejaen

Adjunto el log -generat en local- de un grabarFicha() que mostra informació completa de cada transacció. Li falta posar:

Amb tot això quan es produeixi un bloqueig i desde Base de Dades ens passin els sessionId de Oracle tindrem tota la informació per saber la causa.

kitanibaladmin commented 8 years ago

anonymous 2012-06-04 08:31:24 *Originally by: ejaen

Situació:

Ja es genera el log amb la informació necessaria de sessió i transaccions. Adjunto log de mostra, tret en local, per una peticio grabarFicha.

kitanibaladmin commented 8 years ago

anonymous 2012-06-05 07:51:46 *Originally by: ejaen

Situació:

Estic preparant tests amb jmeter per fer proves de càrrega del rolsac mentres es produeix una càrrega elevada en el webcaib. L'escenari que he pensat serà algo com:

Varis usuaris busquen paraules clau al webcaib. Simultament altre usuaris accedeixen al RSS del webcaib. Simultaneament, un editor graba una fitxa. Simultaneament, un altre editor modifica un document.

kitanibaladmin commented 8 years ago

anonymous 2012-06-07 06:34:40 *Originally by: ejaen

Situació:

A fi de comprobar si es produeix algun bloqueig per causa de la càrrega, commitarè un test jmeter que envia peticions en el buscador del webcaib, peticions de lectura de RSS i pel moment 1 peticio que graba una fitxa en rolsac.&nbps; He obert una tasca per anar ampliant aquests tests (#348)

kitanibaladmin commented 8 years ago

agarcia 2012-06-07 08:50:30 He fet un diff entre 1.0.3 i 1.0.2. Hi ha aquest canvi rellevant al mapeig hibernate de Archivo

@@ -18,7 +18,7 @@ -&nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; <property name="datos" type="binary" column="ARC_DATOS"/> +&nbps;&nbps;&nbps;&nbps;&nbps;&nbps;&nbps; <property name="datos" type="org.ibit.rol.sac.model.types.BinaryBlobType" column="ARC_DATOS"/>

Tot apunta a que ha de ser això.

kitanibaladmin commented 8 years ago

anonymous 2012-06-07 09:09:48 *Originally by: ejaen

Gràcies Toni ja havia vist aquesta diferència.

Però perque en proves no hi ha bloquejos i si en producció? Hi ha alguna cosa/escenari que està passant en producció i no en proves.

Una diferencia és que en proves la base de dades es Oracle 10G i en produccio 9G

Amb el propes pas a produccio que enviarem treurem més logs i es podrar averiguar que passa.

kitanibaladmin commented 8 years ago

agarcia 2012-06-07 09:20:30 El fet diferencial és que 1.0.2 no dona bloquejos i 1.0.3 si. I l'única diferència rellevant és aquesta. Jo faria un pas a producció desfent aquest petit canvi i sortiria de dubtes ràpidament.

kitanibaladmin commented 8 years ago

anonymous 2012-06-07 10:10:08 *Originally by: ejaen

Donat que en produccio tenim Oracle 9G desfarè aquest canvi en el proper a producció.

org.ibit.rol.sac.model.types.BinaryBlobType depen de oracle.sql.BLOB.&nbps; Algú em pot dir si això va en contra de la filosofia del projecte?

kitanibaladmin commented 8 years ago

agarcia 2012-06-07 10:27:48 Pel que veig, no hi depén, sino que hi ha codi més optimitzat per oracle quan s'executa baix aquest entorn.

kitanibaladmin commented 8 years ago

anonymous 2012-06-07 10:39:48 *Originally by: ejaen

Toni no parlo de dependencia funcional, sino que depen per compilar rolsac

Això està relacionat amb el ticket #189

kitanibaladmin commented 8 years ago

agarcia 2012-06-07 11:00:28 Ja veig, al ticket que enllaçes hi ha un pas "(4) comprobar que tot funciona." en el que estariem ara. I no tot funciona. Pareix que a més a més de dependre per compilar, depén per a que l'aplicació funcioni en l'entorn de producció. Així, abans d'eliminar la dependència, s'ha de trobar una solució sense aquesta dependència, que també funcioni.

El maneig de blobs en oracle amb diferents versions de driver i de base de dades és un tema molt delicat; xerra amb la teva gent de sistemes i et confirmaran la de problemes que hi ha en les aplicacions en marxa per simples canvis de driver.

kitanibaladmin commented 8 years ago

anonymous 2012-06-07 11:17:27 *Originally by: ejaen

De todes formes no estic segur que la causa sigui aquest 'binary' perquè en local i en proves (amb 10G) es van provar rolsac 1.0.3 i 1.1 i no hi havia bloquejos.

Hi ha alguna cosa en producció (carrega i/o operativa) que no fem en proves, i això només ho podem veure amb els logs de producció.

Per altre banda, ho hem xerrat aqui i també demanarem migrar a 10G el rolsac de producció, i així ja tindrem els dos entorns iguals.

kitanibaladmin commented 8 years ago

agarcia 2012-06-07 11:50:51 La causa és la combinació de Oracle 9 a un entorn amb bastanta càrrega amb aquest canvi del binary. És més senzill fer el canvi al codi, però si preferiu esperar a poder passar a producció les noves versions a migrar la base de dades, és la vostra decissió.

kitanibaladmin commented 8 years ago

anonymous 2012-06-07 12:03:21 *Originally by: ejaen

Aquest canvi ja he dit anteriorment que el desfarem en el proper pas a producció, independenment que tinguem 9G o 10G en producció.

Però s'ha de modificar la compilació per tal que nomes hagi la dependencia amb ojdbc.jar&nbps; si la base de dades és Oracle.

kitanibaladmin commented 8 years ago

anonymous 2012-06-13 07:31:37 *Originally by: ejaen

Situació:

tinc el ear preparat. Vaig a fer proves de tests abans de pasar-lo al entorn de proves.

kitanibaladmin commented 8 years ago

anonymous 2012-06-22 08:46:19 *Originally by: ejaen

Situació: Encara no puc passar la 1.1 a producció per la dependència amb WEBCAIB-1.0 i les altres aplicacions. Enviaré a producció una versió rolsac-1.0.3 amb les modificacions explicades en aquest ticket i a veure que passa.

Canvis que he fet en la 1.1: http://rolsac.svn.sourceforge.net/rolsac/?rev=588&view=rev http://rolsac.svn.sourceforge.net/rolsac/?rev=589&view=rev http://rolsac.svn.sourceforge.net/rolsac/?rev=590&view=rev