Get ContentletVersionInfo out of hibernate #18550

wezell · 2020-05-26T21:30:00Z

We have issues with the ContentletVersionInfo table - we need to create a DBTransformer class for the ContentletVersionInfo data and remove it from the hibernate.hbm.xml

This is on a normal content push. The stack trace looks like this. Why could this be happening?

[22/05/20 16:21:06:215 GMT] ERROR handler.ContentHandler: Error on File /data/shared/assets/bundles/01E8YK08NNPVQKDYBPNQ1J4CM3/working/dotcms.com/1/2-content.e75d6ddb-cc41-4080-988a-a2b8bf0f83e0.content.xml, content id:61231477-b081-4dee-92c0-265e4e2e3198 :Unable to save/update Object to Hibernate Session
com.dotmarketing.exception.DotHibernateException: Unable to save/update Object to Hibernate Session
        at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:549) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotmarketing.business.VersionableFactoryImpl.saveContentletVersionInfo(VersionableFactoryImpl.java:349) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotmarketing.business.VersionableAPIImpl.saveContentletVersionInfo_aroundBody44(VersionableAPIImpl.java:671) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotmarketing.business.VersionableAPIImpl$AjcClosure45.run(VersionableAPIImpl.java:1) ~[dotcms_5.3.0_999999.jar:?]
        at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
        at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:42) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:59) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotmarketing.business.VersionableAPIImpl.saveContentletVersionInfo(VersionableAPIImpl.java:656) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotcms.enterprise.publishing.remote.handler.ContentHandler.a(SourceFile:422) ~[ee-5.3.0.jar:?]
        at com.dotcms.enterprise.publishing.remote.handler.ContentHandler.handle(SourceFile:163) ~[ee-5.3.0.jar:?]
        at com.dotcms.enterprise.publishing.remote.handler.ContentHandler.handle(SourceFile:138) ~[ee-5.3.0.jar:?]
        at com.dotcms.publisher.receiver.BundlePublisher.process(BundlePublisher.java:203) ~[dotcms_5.3.0_999999.jar:?]
        at com.dotcms.rest.PublishThread.run(PublishThread.java:42) ~[dotcms_5.3.0_999999.jar:?]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]
Caused by: com.dotcms.repackage.net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        at com.dotcms.repackage.net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:62) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:547) ~[dotcms_5.3.0_999999.jar:?]
        ... 15 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 update contentlet_version_info set working_inode='4ab29e0f-30c2-4df6-89d8-1ccf2231bcd9', live_inode='4ab29e0f-30c2-4df6-89d8-1ccf2231bcd9', deleted='FALSE', locked_by=NULL, locked_on='2020-05-21 10:54:00.428-04', version_ts='2020-05-22 12:21:06.208-04' where identifier='61231477-b081-4dee-92c0-265e4e2e3198' and lang=1 was aborted: ERROR: insert or update on table "contentlet_version_info" violates foreign key constraint "fk_contentlet_version_info_live"
  Detail: Key (live_inode)=(4ab29e0f-30c2-4df6-89d8-1ccf2231bcd9) is not present in table "contentlet".  Call getNextException to see other errors in the batch.
        at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2234) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:510) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:853) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1546) ~[postgresql-42.2.8.jar:42.2.8]
        at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128) ~[HikariCP-3.4.2.jar:?]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:547) ~[dotcms_5.3.0_999999.jar:?]
        ... 15 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "contentlet_version_info" violates foreign key constraint "fk_contentlet_version_info_live"
  Detail: Key (live_inode)=(4ab29e0f-30c2-4df6-89d8-1ccf2231bcd9) is not present in table "contentlet".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:510) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:853) ~[postgresql-42.2.8.jar:42.2.8]
        at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1546) ~[postgresql-42.2.8.jar:42.2.8]
        at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128) ~[HikariCP-3.4.2.jar:?]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) ~[dot.hibernate-2.1.7_3.jar:?]
        at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:547) ~[dotcms_5.3.0_999999.jar:?]
        ... 15 more

The text was updated successfully, but these errors were encountered:

dsilvam · 2020-09-23T19:03:37Z

PR: #19294

dsilvam · 2020-09-29T22:41:54Z

PR ee: https://github.com/dotCMS/enterprise-2.x/pull/752

* #18550 first draft * #18550 cast to String to preserve null * #18550 try with new factory impl * #18550 create cvi migrated to dotconnect * #18550 fix transformer * #18550 return empty object instead of null, like hibernate did * #18550 codacy feedback * #18550 proper doc * #18550 include deprecated annotation * #18550 change signature of getContentletVersion info part I * #18550 custom ee jar to run tests * #18550 fix wrong return * #18550 fixing beanutils call * #18550 fix red in jsps * #18550 fix usage of optional * #18550 fix behavior when CVI not present * #18550 remove throws from method signature * #18550 remove commeted out code * #18550 code-review * Update gradle.properties * Update it-dotcms-config-cluster.properties * Update it-dotmarketing-config.properties * Update it-dotmarketing-config.properties * Update it-dotmarketing-config.properties * Update oracle-db-config.properties * Update postgres-db-config.properties * Update ESContentFactoryImpl.java * Update DependencySet.java * Update it-dotcms-config-cluster.properties * Update oracle-db-config.properties * #18550 remove new linews * #18550 git rid of CVI definition in hbm files * #18550 changes after removing CVI from hbm files * #18550 migrate deleteContentByStructure to dotConnect * #18550 fat-contentlet db transformer * #18550 fix failing tests * #18550 fix more failing tests * #18550 create pp-filter fot test * #18550 replace hibernate call with new one * #18550 remove unneeded validation * Update gradle.properties

dsilvam · 2020-10-14T22:57:10Z

Note to QA: Test the following actions:

Create new content
Create multiple versions of existing content
Delete content

victoralfaro-dotcms · 2020-10-16T20:16:41Z

Both Page and Banner contents were created and modified several times to generate a version for each.
then both were unpublished, archived and finally deleted.

bryanboza · 2020-11-19T17:43:05Z

Fixed, tested on release-20.11 // Postgres // FF

wezell added Type : Defect dotCMS : Push Publishing labels May 26, 2020

dsilvam added this to the Falcon Current milestone May 27, 2020

dsilvam modified the milestones: 060220_FALCON, Falcon Current Jun 4, 2020

erickgonzalez modified the milestones: Falcon Current, Bug Sprint Jun 18, 2020

dsilvam modified the milestones: 061620_FALCON, Falcon Current Jun 19, 2020

dsilvam modified the milestones: 072820_FALCON, Falcon Current Jul 29, 2020

wezell changed the title ~~We have seen this PP error on dotcms.com~~ Get ContentletVersionInfo out of hibernate Jul 30, 2020

dsilvam modified the milestones: 081220_FALCON, Falcon Current, 082520_FALCON Aug 25, 2020

dsilvam added a commit that referenced this issue Sep 17, 2020

#18550 first draft

36912d8

dsilvam self-assigned this Sep 18, 2020

dsilvam added a commit that referenced this issue Sep 18, 2020

#18550 cast to String to preserve null

936a8f7

dsilvam added a commit that referenced this issue Sep 18, 2020

#18550 try with new factory impl

8cd2b23

dsilvam added a commit that referenced this issue Sep 21, 2020

#18550 create cvi migrated to dotconnect

714a2df

dsilvam added a commit that referenced this issue Sep 22, 2020

#18550 fix transformer

c591c3f

dsilvam added a commit that referenced this issue Sep 23, 2020

#18550 return empty object instead of null, like hibernate did

abcf437

dsilvam added a commit that referenced this issue Sep 23, 2020

#18550 codacy feedback

bc0f3a6

dsilvam added a commit that referenced this issue Sep 23, 2020

#18550 proper doc

b479eed

dsilvam added a commit that referenced this issue Sep 23, 2020

#18550 include deprecated annotation

7cfda68

dsilvam added a commit that referenced this issue Sep 24, 2020

#18550 change signature of getContentletVersion info part I

84e99da

dsilvam added a commit that referenced this issue Sep 29, 2020

#18550 remove throws from method signature

f63850e

dsilvam added a commit that referenced this issue Sep 29, 2020

#18550 remove commeted out code

29fd8c3

dsilvam added a commit that referenced this issue Sep 30, 2020

#18550 code-review

926fc58

dsilvam added a commit that referenced this issue Sep 30, 2020

#18550 remove new linews

e454cf5

dsilvam added a commit that referenced this issue Oct 1, 2020

#18550 git rid of CVI definition in hbm files

bde7ec2

dsilvam added a commit that referenced this issue Oct 1, 2020

#18550 changes after removing CVI from hbm files

30027d1

dsilvam added a commit that referenced this issue Oct 2, 2020

#18550 migrate deleteContentByStructure to dotConnect

a246caa

dsilvam added a commit that referenced this issue Oct 2, 2020

#18550 fat-contentlet db transformer

329efa2

dsilvam added a commit that referenced this issue Oct 6, 2020

#18550 fix failing tests

3c40d0a

dsilvam added a commit that referenced this issue Oct 7, 2020

#18550 fix more failing tests

3fcd04d

dsilvam modified the milestones: Falcon Current, Maintenance Sprint Oct 8, 2020

dsilvam added a commit that referenced this issue Oct 8, 2020

#18550 create pp-filter fot test

f77653a

dsilvam added a commit that referenced this issue Oct 8, 2020

#18550 replace hibernate call with new one

3093bc5

dsilvam added a commit that referenced this issue Oct 12, 2020

#18550 missing the owner of the contentlet

420525e

dsilvam added a commit that referenced this issue Oct 14, 2020

#18550 remove unneeded validation

5dcc89a

dsilvam added the Merged label Oct 14, 2020

dsilvam removed their assignment Oct 14, 2020

dsilvam added QA : Needs Internal Note to QA labels Oct 14, 2020

dsilvam added the Release : 20.11 label Oct 14, 2020

victoralfaro-dotcms added QA : Passed Internal and removed QA : Needs Internal labels Oct 16, 2020

bryanboza added the QA : Approved label Nov 19, 2020

wezell closed this as completed Nov 24, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Get ContentletVersionInfo out of hibernate #18550

Get ContentletVersionInfo out of hibernate #18550

wezell commented May 26, 2020 •

edited

Loading

dsilvam commented Sep 23, 2020

dsilvam commented Sep 29, 2020

dsilvam commented Oct 14, 2020

victoralfaro-dotcms commented Oct 16, 2020

bryanboza commented Nov 19, 2020

Get ContentletVersionInfo out of hibernate #18550

Get ContentletVersionInfo out of hibernate #18550

Comments

wezell commented May 26, 2020 • edited Loading

dsilvam commented Sep 23, 2020

dsilvam commented Sep 29, 2020

dsilvam commented Oct 14, 2020

victoralfaro-dotcms commented Oct 16, 2020

bryanboza commented Nov 19, 2020

wezell commented May 26, 2020 •

edited

Loading