Bug 1276039
Summary: | Postgres upgrade script (bpms-6.0-to-6.1.sql): null value in column "id" violates not-null constraint | ||||||
---|---|---|---|---|---|---|---|
Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | Alexandre Cavalcanti <acavalca> | ||||
Component: | jBPM Core | Assignee: | Kris Verlaenen <kverlaen> | ||||
Status: | CLOSED EOL | QA Contact: | Tibor Zimanyi <tzimanyi> | ||||
Severity: | urgent | Docs Contact: | |||||
Priority: | urgent | ||||||
Version: | 6.1.0 | CC: | alazarot, jperezve, kverlaen | ||||
Target Milestone: | CR1 | ||||||
Target Release: | 6.2.0 | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | |||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2020-03-27 19:13:38 UTC | Type: | Bug | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Bug Depends On: | 1235091 | ||||||
Bug Blocks: | |||||||
Attachments: |
|
Description
Alexandre Cavalcanti
2015-10-28 13:34:57 UTC
Thank you Alexandre. I was able to reproduce the issue. Instead of using the sequence directly in the table definition the best should be using nextval in the INSERT statement to avid any problem with Hibernate. I just created the PR bellow for Postgres and Oracle: https://github.com/droolsjbpm/jbpm/pull/320/files master: http://github.com/droolsjbpm/jbpm/commit/401509ab9 6.3.x: http://github.com/droolsjbpm/jbpm/commit/e77d9c57d Verified in 6.2.0.CR1. The upgrade scripts from supplementary tools passed correctly and table AuditTaskImpl is filled with values. I used the attached PostgreSQL dump. |