Postgres pg_large_object Size

[jose luis tapias florez]

Hi,

I have JBPM 6.4 installed and i´m having the problem that our database is growing unexpectedly, almost 20 gb in less than 2 hours, what we saw was that the postgres table pg_large_object is the one causing the problem, in the wildfly server log we are getting this error:

2016-09-01 14:41:51,399 ERROR [org.jbpm.kie.services.impl.store.DeploymentSynchronizer] (EJB default - 10) Error while synchronizing deployments: org.hibernate.exception.SQLGrammarException: could not execute query: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] at org.jbpm.shared.services.impl.JpaPersistenceContext.queryStringWithParameters(JpaPersistenceContext.java:190) [jbpm-shared-services-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.shared.services.impl.JpaPersistenceContext.queryWithParametersInTransaction(JpaPersistenceContext.java:57) [jbpm-shared-services-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.shared.services.impl.commands.QueryNameCommand.execute(QueryNameCommand.java:49) [jbpm-shared-services-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.shared.services.impl.TransactionalCommandService.execute(TransactionalCommandService.java:57) [jbpm-shared-services-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.kie.services.impl.store.DeploymentStore.getEnabledDeploymentUnits(DeploymentStore.java:65) [jbpm-kie-services-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.kie.services.impl.store.DeploymentSynchronizer.synchronize(DeploymentSynchronizer.java:83) [jbpm-kie-services-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.services.cdi.impl.store.DeploymentSynchronizerCDIImpl$Proxy$_$$_WeldClientProxy.synchronize(Unknown Source) [jbpm-services-cdi-6.3.0.Final.jar:6.3.0.Final] at org.jbpm.services.cdi.impl.store.DeploymentSynchronizerCDInvoker.synchronize(DeploymentSynchronizerCDInvoker.java:77) [jbpm-services-cdi-6.3.0.Final.jar:6.3.0.Final] at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) [:1.7.0_45] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_45] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_45] at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.1.0.Final.jar:8.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:95) [wildfly-weld-8.1.0.Final.jar:8.1.0.Final] at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) at org.jboss.as.ejb3.concurrency.ContainerManagedConcurrencyInterceptor.processInvocation(ContainerManagedConcurrencyInterceptor.java:104) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:104) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:56) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:55) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:52) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448) at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ejb3.timerservice.TimedObjectInvokerImpl.callTimeout(TimedObjectInvokerImpl.java:104) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.as.ejb3.timerservice.TimedObjectInvokerImpl.callTimeout(TimedObjectInvokerImpl.java:114) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.as.ejb3.timerservice.task.CalendarTimerTask.callTimeout(CalendarTimerTask.java:63) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at org.jboss.as.ejb3.timerservice.task.TimerTask.run(TimerTask.java:168) [wildfly-ejb3-8.1.0.Final.jar:8.1.0.Final] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_45] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_45] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_45] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_45] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45] at org.jboss.threads.JBossThread.run(JBossThread.java:122) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.doList(Loader.java:2557) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.doList(Loader.java:2540) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.list(Loader.java:2365) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] ... 75 more Caused by: org.postgresql.util.PSQLException: ERROR: large object 667445 does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.core.v3.QueryExecutorImpl.receiveFastpathResult(QueryExecutorImpl.java:650) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.core.v3.QueryExecutorImpl.fastpathCall(QueryExecutorImpl.java:480) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:72) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:112) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.fastpath.Fastpath.getInteger(Fastpath.java:124) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.largeobject.LargeObject.<init>(LargeObject.java:91) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:200) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:170) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc2.AbstractJdbc2BlobClob.<init>(AbstractJdbc2BlobClob.java:45) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc2.AbstractJdbc2Clob.<init>(AbstractJdbc2Clob.java:23) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc3.AbstractJdbc3Clob.<init>(AbstractJdbc3Clob.java:18) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc4.AbstractJdbc4Clob.<init>(AbstractJdbc4Clob.java:18) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc4.Jdbc4Clob.<init>(Jdbc4Clob.java:16) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc4.Jdbc4ResultSet.getClob(Jdbc4ResultSet.java:40) [postgresql-9.1-902.jdbc4.jar:] at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getClob(AbstractJdbc2ResultSet.java:393) [postgresql-9.1-902.jdbc4.jar:] at org.jboss.jca.adapters.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:783) at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:61) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:267) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:338) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1696) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1628) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.getRow(Loader.java:1515) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:726) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.processResultSet(Loader.java:953) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:921) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] at org.hibernate.loader.Loader.doList(Loader.java:2554) [hibernate-core-4.3.11.Final.jar:4.3.11.Final] ... 85 more


Can you please tell me if i have something wrong with my configuration, or what migth be the problem.

Thanks.

[jose luis tapias florez]

I just found that there is a problem with the columns with the oid type, so if anybody needs it, this is what worked for me:

Change the types for bytea in the database:

-- ALTER TABLE processinstanceinfo DROP COLUMN processinstancebytearray;

ALTER TABLE processinstanceinfo ADD COLUMN processinstancebytearray bytea;

--ALTER TABLE content DROP COLUMN content;

ALTER TABLE content ADD COLUMN content bytea;

-- ALTER TABLE requestinfo DROP COLUMN requestdata;

ALTER TABLE requestinfo ADD COLUMN requestdata bytea;


-- ALTER TABLE requestinfo DROP COLUMN responsedata;

ALTER TABLE requestinfo ADD COLUMN responsedata bytea;


-- ALTER TABLE WorkItemInfo DROP COLUMN workitembytearray;

ALTER TABLE sessioninfo ADD COLUMN rulesbytearray bytea;

ALTER TABLE WorkItemInfo ADD COLUMN workitembytearray bytea;



Create this file in jbpm-console.war\WEB-INF\classes\META-INF


<?xml version="1.0" encoding="UTF-8" ?>  
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"  
                     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
                     xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"  
                     version="2.0">  
<description>Workaround for PostgreSQL and JPA annotation type @Lob</description>  
<package>org.jbpm.persistence.processinstance</package>  
<entity class="ProcessInstanceInfo" name="ProcessInstanceInfo" access="FIELD">  
<table name="processinstanceinfo"/>  
<attributes>  
<basic name="processInstanceByteArray" access="FIELD">  
<column name="processInstanceByteArray" column-definition="bytea"/>  
</basic>  
</attributes>  
</entity>
<entity class="org.jbpm.services.task.impl.model.ContentImpl" name="ContentImpl" access="FIELD">  
<table name="content"/>  
<attributes>  
<basic name="content" access="FIELD">  
<column name="content" column-definition="bytea"/>  
</basic>  
</attributes>  
</entity>  
<entity class="org.jbpm.executor.entities.RequestInfo" name="RequestInfo" access="FIELD">  
<table name="requestinfo"/>  
<attributes>  
<basic name="requestData" access="FIELD">  
<column name="requestdata" column-definition="bytea"/>  
</basic>  
<basic name="responseData" access="FIELD">  
<column name="responsedata" column-definition="bytea"/>  
</basic>  
</attributes>  
</entity>  
<entity class="org.drools.persistence.info.SessionInfo" name="SessionInfo" access="FIELD">  
<table name="sessioninfo"/>  
<attributes>  
<basic name="rulesByteArray" access="FIELD">  
<column name="rulesbytearray" column-definition="bytea"/>  
</basic>  
</attributes>  
</entity> 
<entity class="org.drools.persistence.info.WorkItemInfo" name="WorkItemInfo" access="FIELD">  
<table name="workiteminfo"/>  
<attributes>  
<basic name="workItemByteArray" access="FIELD">  
<column name="workitembytearray" column-definition="bytea"/>  
</basic>  
</attributes>  
</entity> 
 
</entity-mappings> 



Edit the jbpm-console.war\WEB-INF\classes\META-INF\persistence.xml 

persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0"
  xmlns="http://java.sun.com/xml/ns/persistence" 
  xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd">

  <persistence-unit name="org.jbpm.domain" transaction-type="JTA">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source>
    <mapping-file>META-INF/Taskorm.xml</mapping-file>
    <mapping-file>META-INF/JBPMorm.xml</mapping-file>
    <mapping-file>META-INF/Executor-orm.xml</mapping-file>
    <mapping-file>META-INF/Servicesorm.xml</mapping-file>
    <mapping-file>META-INF/TaskAuditorm.xml</mapping-file>
	<mapping-file>META-INF/orm.xml</mapping-file>

    <!-- task service -->
    <class>org.jbpm.services.task.impl.model.AttachmentImpl</class>
    <class>org.jbpm.services.task.impl.model.ContentImpl</class>
    <class>org.jbpm.services.task.impl.model.BooleanExpressionImpl</class>
    <class>org.jbpm.services.task.impl.model.CommentImpl</class>
    <class>org.jbpm.services.task.impl.model.DeadlineImpl</class>
    <class>org.jbpm.services.task.impl.model.DelegationImpl</class>
    <class>org.jbpm.services.task.impl.model.EscalationImpl</class>
    <class>org.jbpm.services.task.impl.model.GroupImpl</class>
    <class>org.jbpm.services.task.impl.model.I18NTextImpl</class>
    <class>org.jbpm.services.task.impl.model.NotificationImpl</class>
    <class>org.jbpm.services.task.impl.model.EmailNotificationImpl</class>
    <class>org.jbpm.services.task.impl.model.EmailNotificationHeaderImpl</class>
    <class>org.jbpm.services.task.impl.model.PeopleAssignmentsImpl</class>
    <class>org.jbpm.services.task.impl.model.ReassignmentImpl</class>
    <class>org.jbpm.services.task.impl.model.TaskImpl</class>
    <class>org.jbpm.services.task.impl.model.TaskDefImpl</class>
    <class>org.jbpm.services.task.impl.model.TaskDataImpl</class>
    <class>org.jbpm.services.task.impl.model.UserImpl</class>
    <class>org.jbpm.executor.entities.ErrorInfo</class>
    <class>org.jbpm.executor.entities.RequestInfo</class>
    <!-- Event Classes -->
    <class>org.jbpm.services.task.audit.impl.model.TaskEventImpl</class>
     
    <!-- Task Audit Classes --> 
    <class>org.jbpm.services.task.audit.impl.model.AuditTaskImpl</class>
    <class>org.jbpm.services.task.audit.impl.model.TaskVariableImpl</class>
      
    <!--BAM for task service -->
    <class>org.jbpm.services.task.audit.impl.model.BAMTaskSummaryImpl</class>

    <!-- engine -->
    <class>org.drools.persistence.info.SessionInfo</class>
    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
    <class>org.drools.persistence.info.WorkItemInfo</class>
    <class>org.jbpm.persistence.correlation.CorrelationKeyInfo</class>
    <class>org.jbpm.persistence.correlation.CorrelationPropertyInfo</class>
    <!-- manager -->
    <class>org.jbpm.runtime.manager.impl.jpa.ContextMappingInfo</class>

    <!-- bam -->
    <class>org.jbpm.process.audit.ProcessInstanceLog</class>
    <class>org.jbpm.process.audit.NodeInstanceLog</class>
    <class>org.jbpm.process.audit.VariableInstanceLog</class>
    
    <!-- deployment store -->
    <class>org.jbpm.kie.services.impl.store.DeploymentStoreEntry</class>
    <!--  query service storage -->
    <class>org.jbpm.kie.services.impl.query.persistence.QueryDefinitionEntity</class>

    <properties>
     <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />

      <property name="hibernate.max_fetch_depth" value="3" />
      <property name="hibernate.hbm2ddl.auto" value="update" />
      <property name="hibernate.show_sql" value="false" />      
      <!-- BZ 841786: AS7/EAP 6/Hib 4 uses new (sequence) generators which seem to cause problems -->
      <property name="hibernate.id.new_generator_mappings" value="false" />
      <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" />
    </properties>
  </persistence-unit>

</persistence>

I found some info in this link, https://developer.jboss.org/thread/249922?start=0&tstart=0&_sscc=t