JON 2.4.1 to upgrade to 3.0.0 fails
Issue
I'm running into what looks to be a postgres issue when upgrading JON from 2.4.1 to 3.0.0
We see multiple messages like the below in our log files:
Cause: /opt/jboss/jon-server-3.0.0.GA/logs/db-upgrade.xml:27: Failed to upgrade - error in spec version [2.94]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_DirectSQL] in schema spec version [2.94]. Cause: The schema spec task [DirectSQL] has encountered an error. Cause: org.postgresql.util.PSQLException: ERROR: insert or update on table "rhq_permission" violates foreign key constraint "rhq_permission_role_id_fkey"
Detail: Key (role_id)=(2) is not present in table "rhq_role".
Environment
JON 2.4.1 upgrading to 3.0.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.