Hi,
Am 22.07.2010 um 12:50 schrieb Alexey Kamenchuk:
Trying to create a new alert, I populate If Condition section and click OK button - getting this error
Can you anybody advise me please, whats wrong with my setup and how can I fix it
It looks like your database schema is not up to date:
ERROR: column alertnotif0_.extra_config_id does not exist Position: 798 org.postgresql.util.PSQLException: ERROR: column alertnotif0_.extra_config_id does not exist
Is this a fresh RHQ 3.0.0 install? Or did you upgrade from a previous b0x version? If the latter, you may need to manually adjust the database schema.
CREATE TABLE rhq_alert_notification ( id integer NOT NULL, alert_definition_id integer, sender_name character varying(100) NOT NULL, sender_config_id integer, extra_config_id integer, CONSTRAINT rhq_alert_notification_pkey PRIMARY KEY (id), CONSTRAINT rhq_alert_notification_alert_definition_id_fkey FOREIGN KEY (alert_definition_id) REFERENCES rhq_alert_definition (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_an_extra_config_id_fk FOREIGN KEY (extra_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_an_sender_config_id_fk FOREIGN KEY (sender_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE rhq_alert_notification OWNER TO rhqadmin;
But then this DDL will probably not be enough.
Heiko
If you don't really care about keeping your existing data, the easiest option would be to reinstall 3.0.0 and specify "Overwrite existing data" when running the installer.
On 07/22/2010 08:57 AM, Alexey Kamenchuk wrote:
Hi Heiko
Ive upgraded from B06 (the one which had missing jar's so I had to add them to the classpath myself) Doing an upgrade, I've followed the instruction http://www.rhq-project.org/display/JOPR2/Upgrading+the+Server and kept existing DB
My table currently is looking like this:
CREATE TABLE rhq_alert_notification ( id integer NOT NULL, alert_definition_id integer, sender_config_id integer, sender_name character varying(100) NOT NULL, CONSTRAINT rhq_alert_notification_pkey PRIMARY KEY (id), CONSTRAINT rhq_alert_notification_alert_definition_id_fkey FOREIGN KEY (alert_definition_id) REFERENCES rhq_alert_definition (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_alert_notification_sender_config_id_fkey FOREIGN KEY (sender_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE rhq_alert_notification OWNER TO postgres;
so yes extra_config_id column is missing
What can be done to check what else is missing? (DDL and DB content changes required for B06->300 migration)
Thank you very much for your help, Heiko!
Regards Alexey
On 22.07.2010 15:07, Heiko W.Rupp wrote:
Hi,
Am 22.07.2010 um 12:50 schrieb Alexey Kamenchuk:
Trying to create a new alert, I populate If Condition section and click OK button - getting this error
Can you anybody advise me please, whats wrong with my setup and how can I fix it
It looks like your database schema is not up to date:
ERROR: column alertnotif0_.extra_config_id does not exist Position: 798 org.postgresql.util.PSQLException: ERROR: column alertnotif0_.extra_config_id does not exist
Is this a fresh RHQ 3.0.0 install? Or did you upgrade from a previous b0x version? If the latter, you may need to manually adjust the database schema.
CREATE TABLE rhq_alert_notification ( id integer NOT NULL, alert_definition_id integer, sender_name character varying(100) NOT NULL, sender_config_id integer, extra_config_id integer, CONSTRAINT rhq_alert_notification_pkey PRIMARY KEY (id), CONSTRAINT rhq_alert_notification_alert_definition_id_fkey FOREIGN KEY (alert_definition_id) REFERENCES rhq_alert_definition (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_an_extra_config_id_fk FOREIGN KEY (extra_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_an_sender_config_id_fk FOREIGN KEY (sender_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE rhq_alert_notification OWNER TO rhqadmin;
But then this DDL will probably not be enough.
Heiko
rhq-users mailing list rhq-users@lists.fedorahosted.org https://fedorahosted.org/mailman/listinfo/rhq-users
rhq-users mailing list rhq-users@lists.fedorahosted.org https://fedorahosted.org/mailman/listinfo/rhq-users
Keep in mind, although we make an effort to try and keep upgrade working, we technically do not support upgrades for bXX versions. Considering the fixes that have gone into the release-3.0.0 branch for upgrade-related issues in this last month, I'm not surprised that the upgrade didn't work here. Like Ian said, Alexey, you should rerun the installer fresh.
On 07/22/2010 09:02 AM, Ian Springer wrote:
If you don't really care about keeping your existing data, the easiest option would be to reinstall 3.0.0 and specify "Overwrite existing data" when running the installer.
On 07/22/2010 08:57 AM, Alexey Kamenchuk wrote:
Hi Heiko
Ive upgraded from B06 (the one which had missing jar's so I had to add them to the classpath myself) Doing an upgrade, I've followed the instruction http://www.rhq-project.org/display/JOPR2/Upgrading+the+Server and kept existing DB
My table currently is looking like this:
CREATE TABLE rhq_alert_notification ( id integer NOT NULL, alert_definition_id integer, sender_config_id integer, sender_name character varying(100) NOT NULL, CONSTRAINT rhq_alert_notification_pkey PRIMARY KEY (id), CONSTRAINT rhq_alert_notification_alert_definition_id_fkey FOREIGN KEY (alert_definition_id) REFERENCES rhq_alert_definition (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_alert_notification_sender_config_id_fkey FOREIGN KEY (sender_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE rhq_alert_notification OWNER TO postgres;
so yes extra_config_id column is missing
What can be done to check what else is missing? (DDL and DB content changes required for B06->300 migration)
Thank you very much for your help, Heiko!
Regards Alexey
On 22.07.2010 15:07, Heiko W.Rupp wrote:
Hi,
Am 22.07.2010 um 12:50 schrieb Alexey Kamenchuk:
Trying to create a new alert, I populate If Condition section and click OK button - getting this error
Can you anybody advise me please, whats wrong with my setup and how can I fix it
It looks like your database schema is not up to date:
ERROR: column alertnotif0_.extra_config_id does not exist Position: 798 org.postgresql.util.PSQLException: ERROR: column alertnotif0_.extra_config_id does not exist
Is this a fresh RHQ 3.0.0 install? Or did you upgrade from a previous b0x version? If the latter, you may need to manually adjust the database schema.
CREATE TABLE rhq_alert_notification ( id integer NOT NULL, alert_definition_id integer, sender_name character varying(100) NOT NULL, sender_config_id integer, extra_config_id integer, CONSTRAINT rhq_alert_notification_pkey PRIMARY KEY (id), CONSTRAINT rhq_alert_notification_alert_definition_id_fkey FOREIGN KEY (alert_definition_id) REFERENCES rhq_alert_definition (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_an_extra_config_id_fk FOREIGN KEY (extra_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT rhq_an_sender_config_id_fk FOREIGN KEY (sender_config_id) REFERENCES rhq_config (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE rhq_alert_notification OWNER TO rhqadmin;
But then this DDL will probably not be enough.
Heiko
rhq-users mailing list rhq-users@lists.fedorahosted.org https://fedorahosted.org/mailman/listinfo/rhq-users
rhq-users mailing list rhq-users@lists.fedorahosted.org https://fedorahosted.org/mailman/listinfo/rhq-users
-- Ian Springer Sr. Software Developer JBoss Operations Network Red Hat ian.springer@redhat.com
rhq-users mailing list rhq-users@lists.fedorahosted.org https://fedorahosted.org/mailman/listinfo/rhq-users
rhq-users@lists.stg.fedorahosted.org
-
Alexey Kamenchuk -
Heiko W.Rupp -
Ian Springer -
Joseph Marques