Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-174

vacuumlo deletes active large objects of jBPM CLOB data

XMLWordPrintable

    • ER4
    • ?
    • Hide
      • Start BPMS with PostgreSQL datasource
      • Run vacuumlo in PostgreSQL
        vacuumlo -h localhost -p 5432 -U postgres -W -v bpms640db
        
      • Restart BPMS
        You will hit the deployment failure
        15:29:34,665 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014612: Operation ("deploy") failed - address: ([("deployment" => "business-central.war")]) - failure description: {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"business-central.war\".WeldStartService" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"business-central.war\".WeldStartService: Failed to start service
            Caused by: org.jboss.weld.exceptions.DeploymentException: Exception List with 1 exceptions:
        Exception 0 :
        org.jboss.weld.exceptions.WeldException: WELD-000049 Unable to invoke [method] @PostConstruct public org.jbpm.services.cdi.impl.query.QueryServiceCDIImpl.init() on org jbpm services cdi impl query QueryServiceCDIImpl 2b2caf06
            at org.jboss.weld.bean.AbstractClassBean.defaultPostConstruct(AbstractClassBean.java:365)
            at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.postConstruct(ManagedBean.java:178)
            at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:298)
            at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:104)
            at org.jboss.weld.bean.proxy.ContextBeanInstance.getInstance(ContextBeanInstance.java:90)
            at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:79)
            at org.jbpm.services.cdi.impl.query.QueryServiceCDIImpl$Proxy$_$$_WeldClientProxy.toString(QueryServiceCDIImpl$Proxy$_$$_WeldClientProxy.java)
            at org.kie.internal.runtime.cdi.BootOnLoadExtension.runPostConstruct(BootOnLoadExtension.java:69)
            ...
        Caused by: java.lang.reflect.InvocationTargetException
            ...
        Caused by: javax.persistence.PersistenceException: org.hibernate.HibernateException: Unable to access lob stream
            at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
            at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
            at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)
            at org.jbpm.shared.services.impl.JpaPersistenceContext.queryInTransaction(JpaPersistenceContext.java:73)
            at org.jbpm.shared.services.impl.commands.QueryNameCommand.execute(QueryNameCommand.java:47)
            at org.jbpm.shared.services.impl.TransactionalCommandService.execute(TransactionalCommandService.java:71)
            at org.jbpm.kie.services.impl.query.QueryServiceImpl.init(QueryServiceImpl.java:103)
            at org.jbpm.services.cdi.impl.query.QueryServiceCDIImpl.init(QueryServiceCDIImpl.java:69)
            ... 43 more
        Caused by: org.hibernate.HibernateException: Unable to access lob stream
            at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:285)
            at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:89)
            at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:39)
            at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60)
            at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
                ...
        Caused by: org.postgresql.util.PSQLException: ERROR: large object 41565 does not exist
            at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
            at org.postgresql.core.v3.QueryExecutorImpl.receiveFastpathResult(QueryExecutorImpl.java:672)
            at org.postgresql.core.v3.QueryExecutorImpl.fastpathCall(QueryExecutorImpl.java:501)
            at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:109)
                ...
        "}}
        
      Show
      Start BPMS with PostgreSQL datasource Run vacuumlo in PostgreSQL vacuumlo -h localhost -p 5432 -U postgres -W -v bpms640db Restart BPMS You will hit the deployment failure 15:29:34,665 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014612: Operation ("deploy") failed - address: ([("deployment" => "business-central.war")]) - failure description: {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"business-central.war\".WeldStartService" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"business-central.war\".WeldStartService: Failed to start service Caused by: org.jboss.weld.exceptions.DeploymentException: Exception List with 1 exceptions: Exception 0 : org.jboss.weld.exceptions.WeldException: WELD-000049 Unable to invoke [method] @PostConstruct public org.jbpm.services.cdi.impl.query.QueryServiceCDIImpl.init() on org jbpm services cdi impl query QueryServiceCDIImpl 2b2caf06 at org.jboss.weld.bean.AbstractClassBean.defaultPostConstruct(AbstractClassBean.java:365) at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.postConstruct(ManagedBean.java:178) at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:298) at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:104) at org.jboss.weld.bean.proxy.ContextBeanInstance.getInstance(ContextBeanInstance.java:90) at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:79) at org.jbpm.services.cdi.impl.query.QueryServiceCDIImpl$Proxy$_$$_WeldClientProxy.toString(QueryServiceCDIImpl$Proxy$_$$_WeldClientProxy.java) at org.kie.internal.runtime.cdi.BootOnLoadExtension.runPostConstruct(BootOnLoadExtension.java:69) ... Caused by: java.lang.reflect.InvocationTargetException ... Caused by: javax.persistence.PersistenceException: org.hibernate.HibernateException: Unable to access lob stream at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277) at org.jbpm.shared.services.impl.JpaPersistenceContext.queryInTransaction(JpaPersistenceContext.java:73) at org.jbpm.shared.services.impl.commands.QueryNameCommand.execute(QueryNameCommand.java:47) at org.jbpm.shared.services.impl.TransactionalCommandService.execute(TransactionalCommandService.java:71) at org.jbpm.kie.services.impl.query.QueryServiceImpl.init(QueryServiceImpl.java:103) at org.jbpm.services.cdi.impl.query.QueryServiceCDIImpl.init(QueryServiceCDIImpl.java:69) ... 43 more Caused by: org.hibernate.HibernateException: Unable to access lob stream at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:285) at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:89) at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:39) at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60) at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) ... Caused by: org.postgresql.util.PSQLException: ERROR: large object 41565 does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) at org.postgresql.core.v3.QueryExecutorImpl.receiveFastpathResult(QueryExecutorImpl.java:672) at org.postgresql.core.v3.QueryExecutorImpl.fastpathCall(QueryExecutorImpl.java:501) at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:109) ... "}}
    • 2018 Week 39-41, 2018 Week 42-44

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-tkobayas Toshiya Kobayashi
              Radovan Synek Radovan Synek (Inactive)
              Radovan Synek Radovan Synek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: