Skip to content

Instantly share code, notes, and snippets.

@dsilvam
Created January 3, 2019 17:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dsilvam/c6e9c8d191c982c17b58f3ea1e53afad to your computer and use it in GitHub Desktop.
Save dsilvam/c6e9c8d191c982c17b58f3ea1e53afad to your computer and use it in GitHub Desktop.
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "contentlet" violates foreign key constraint "content_identifier_fk"
Detail: Key (identifier)=(asd) is not present in table "identifier".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132) ~[postgresql-42.2.2.jar:42.2.2]
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_144]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_144]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
at com.sun.proxy.$Proxy26.executeUpdate(Unknown Source) ~[?:?]
at com.dotcms.repackage.net.sf.hibernate.persister.NormalizedEntityPersister.insert(NormalizedEntityPersister.java:454) ~[dot.hibernate-2.1.7_3.jar:?]
at com.dotcms.repackage.net.sf.hibernate.persister.NormalizedEntityPersister.insert(NormalizedEntityPersister.java:426) ~[dot.hibernate-2.1.7_3.jar:?]
at com.dotcms.repackage.net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) ~[dot.hibernate-2.1.7_3.jar:?]
at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) ~[dot.hibernate-2.1.7_3.jar:?]
at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) ~[dot.hibernate-2.1.7_3.jar:?]
at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) ~[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:544) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.save(ESContentFactoryImpl.java:1678) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.save(ESContentFactoryImpl.java:1664) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.internalCheckin(ESContentletAPIImpl.java:3102) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.lambda$16(ESContentletAPIImpl.java:2838) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.concurrent.lock.StripedLockImpl.tryLock(StripedLockImpl.java:79) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.concurrent.lock.StripedLockImpl.tryLock(StripedLockImpl.java:47) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.concurrent.lock.IdentifierStripedLock.tryLock(IdentifierStripedLock.java:19) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.checkin_aroundBody118(ESContentletAPIImpl.java:2837) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl$AjcClosure119.run(ESContentletAPIImpl.java:1) ~[dotcms_5.0.0_3518e35.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:43) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:40) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.checkin(ESContentletAPIImpl.java:2813) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.checkin(ESContentletAPIImpl.java:6228) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.checkin(ESContentletAPIImpl.java:6244) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.portlets.contentlet.business.ContentletAPIInterceptor.checkin(ContentletAPIInterceptor.java:175) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.portlets.workflows.actionlet.SaveContentActionlet.executeAction_aroundBody0(SaveContentActionlet.java:75) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.portlets.workflows.actionlet.SaveContentActionlet$AjcClosure1.run(SaveContentActionlet.java:1) ~[dotcms_5.0.0_3518e35.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:43) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:40) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.portlets.workflows.actionlet.SaveContentActionlet.executeAction(SaveContentActionlet.java:50) ~[dotcms_5.0.0_3518e35.jar:?]
at com.dotmarketing.portlets.workflows.business.WorkflowAPIImpl.fireWorkflowPostCheckin_aroundBody148(WorkflowAPIImpl.java:2000) ~[dotcms_5.0.0_3518e35.jar:?]
... 118 more
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment