Forgot reply-all sending to ovirt-users as well.<br>-DHC<br><br><div class="gmail_quote">On Wed, Jul 18, 2012 at 6:03 PM, Dead Horse <span dir="ltr"><<a href="mailto:deadhorseconsulting@gmail.com" target="_blank">deadhorseconsulting@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">3.0 engine database dump attached as: "engine.sql.tar.gz"<br>- DHC<div><div><br><br>
<div class="gmail_quote">On Wed, Jul 18, 2012 at 1:05 PM, Eli Mesika <span dir="ltr"><<a href="mailto:emesika@redhat.com" target="_blank">emesika@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><br>
<br>
----- Original Message -----<br>
> From: "Dead Horse" <<a href="mailto:deadhorseconsulting@gmail.com" target="_blank">deadhorseconsulting@gmail.com</a>><br>
> To: <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
> Sent: Wednesday, July 18, 2012 9:08:55 AM<br>
> Subject: [Users] ovirt-engine upgrade 3.0 to 3.1 issue<br>
><br>
><br>
> Steps taken:<br>
><br>
> Load up bare metal or a VM with FC16<br>
> Install 3.0 from <a href="http://www.ovirt.org/releases/stable/fedora/16/" target="_blank">http://www.ovirt.org/releases/stable/fedora/16/</a><br>
> Setup up something minimal (EG: engine-setup then setup a basic<br>
> datacenter/cluster/etc)<br>
> Add a FC16 or EL based node for fun as well and some VM's if feeling<br>
> ambitious.<br>
><br>
> Back up database:<br>
> systemctl stop jboss-as.service<br>
> pg_dump -C -E UTF8 --column-inserts --disable-dollar-quoting<br>
> --disable-triggers -U postgres --format=p -f "/temp/engine.sql"<br>
> engine<br>
><br>
> Back up the following files within /etc/pki/ovirt-engine from a 3.0<br>
> install (preserve owner/group).<br>
> /etc/pki/ovirt-engine/cacert.conf<br>
> /etc/pki/ovirt-engine/ca.pem<br>
> /etc/pki/ovirt-engine/cert.conf<br>
> /etc/pki/ovirt-engine/certs/01.pem<br>
> /etc/pki/ovirt-engine/certs/02.pem<br>
> /etc/pki/ovirt-engine/certs/ca.der<br>
> /etc/pki/ovirt-engine/certs/engine.cer<br>
> /etc/pki/ovirt-engine/certs/engine.der<br>
> /etc/pki/ovirt-engine/database.txt<br>
> /etc/pki/ovirt-engine/database.txt.attr<br>
> /etc/pki/ovirt-engine/database.txt.attr.old<br>
> /etc/pki/ovirt-engine/database.txt.old<br>
> /etc/pki/ovirt-engine/keys/engine_id_rsa<br>
> /etc/pki/ovirt-engine/keys/engine.ssh.key.txt<br>
> /etc/pki/ovirt-engine/private/ca.pem<br>
> /etc/pki/ovirt-engine/requests/ca.csr<br>
> /etc/pki/ovirt-engine/requests/engine.req<br>
><br>
> Load up bare metal or a VM with FC17 (Upgrade from FC16 --> FC17 is<br>
> still rather messy)<br>
> Install 3.1 from <a href="http://www.ovirt.org/releases/beta/fedora/17/" target="_blank">http://www.ovirt.org/releases/beta/fedora/17/</a><br>
><br>
> Run engine-setup to get an initial setup.<br>
> stop ovirt-engine (systemctl stop ovirt-engine.service)<br>
><br>
> Copy the previously backed up /etc/pki/ovirt-engine files from above<br>
> over top of the ones just generated (be sure to preserve owner/group<br>
> EG: cp -a)<br>
><br>
> Drop the existing engine database: dropdb -U postgres engine<br>
> Create a new blank database: createdb -U postgres engine<br>
> Populate with with the backup of the above 3.0 database:<br>
> psql -U postgres -d engine -w < "/temp/engine.sql"<br>
<br>
</div></div>Can you please attach the engine.sql file so I will be able to reproduce , thanks<br>
<div><div><br>
<br>
><br>
> Attempt to upgrade the DBschema via<br>
> /usr/share/ovirt-engine/dbscripts/upgrade.sh<br>
> upgrade.sh -u postgres<br>
><br>
> The DB schema upgrade will fail like so:<br>
><br>
> Running upgrade script upgrade/03_01_0260_add_job_table.sql<br>
> psql:upgrade/03_01_0260_add_job_table.sql:29: NOTICE: CREATE TABLE /<br>
> PRIMARY KEY will create implicit index "pk_jobs" for table "job"<br>
> CONTEXT: SQL statement "CREATE TABLE job<br>
> (<br>
> job_id UUID NOT NULL,<br>
> action_type VARCHAR(50) NOT NULL,<br>
> description TEXT NOT NULL,<br>
> status VARCHAR(32) NOT NULL,<br>
> owner_id UUID,<br>
> visible BOOLEAN NOT NULL DEFAULT true,<br>
> start_time TIMESTAMP WITH TIME ZONE NOT NULL,<br>
> end_time TIMESTAMP WITH TIME ZONE default NULL,<br>
> last_update_time TIMESTAMP WITH TIME ZONE default NULL,<br>
> correlation_id VARCHAR(50) NOT NULL,<br>
> CONSTRAINT pk_jobs PRIMARY KEY(job_id)<br>
> )<br>
> WITH OIDS"<br>
> PL/pgSQL function "__temp_upgrade_add_job_table" line 6 at SQL<br>
> statement<br>
> psql:/tmp/tmp.mXz8U4xpWr:3: ERROR: column "comment" of relation<br>
> "schema_version" does not exist<br>
> LINE 1:<br>
> ...ksum,installed_by,started_at,ended_at,state,current,comment)<br>
><br>
> My assumption here is that if the DB schema upgrade would work, that<br>
> this should be the cleanest way to upgrade from 3.0 to 3.1.<br>
><br>
> - DHC<br>
><br>
</div></div>> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
><br>
</blockquote></div><br>
</div></div></blockquote></div><br>