vacuumlo deletes active large objects of jBPM CLOB data

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) ... "}}