org.postgresql.util.PSQLException

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • PMG - Unable to duplicate Task
    via GitHub by fxaeberhard
    ,
  • GitHub comment 225#23790468
    via GitHub by fxaeberhard
    ,
  • RE: Upgrade 5.2.3 to 6.0.5 - Forums | Liferay
    via by Unknown author,
  • RE: Upgrade 5.2.3 to 6.0.5 - Forums | Liferay
    via by Unknown author,
  • Upgrade 5.2.3 to 6.0.5 - Forums | Liferay
    via by Unknown author,
  • Upgrade 5.2.3 to 6.0.5 - 论坛 | Liferay
    via by Unknown author,
  • RE: Upgrade 5.2.3 to 6.0.5 - Forums | Liferay
    via by Unknown author,
    • org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 )) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1494)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:838)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:191)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:136)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1561)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:447)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:780)[org.eclipse.persistence.jpa.jar:2.3.2.v20111125-r10461] Caused by: org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)[postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)[postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)[postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)[postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)[postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)[postgresql-9.1-901.jdbc4.jar:na] at com.sun.gjc.spi.base.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:125)[__ds_jdbc_ra.jar:na] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:831)[org.eclipse.persistence.core.jar:2.3.2.v20111125-r10461] ... 35 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    jokester
    2 times, last one,
    silex
    5 times, last one,
    Unknown visitor1 times, last one,
    92 more bugmates