[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

We actually hit this internally too, so looks like a bug. @Eli Mesika On Thu, Aug 2, 2018 at 4:17 AM Jan Siml wrote: > Hello, > > I stumbled across the following bug when upgrading the ovirt engine from > 4.2.4 to 4.2.5 (snippet from upgrade log): > > Running upgrade sql script > > '/usr/share

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

Hello, If there are Disk Uploads that have not completed (i.e: currently Paused or with Error) and were not canceled the upgrade will fail.This is due to a foreign key being added on 4.2.5, relating image_transfers table to command_entities table. When the roll-back to the previous RHV-M versi

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

Hello, If there are Disk Uploads that have not completed (i.e: currently Paused or with Error) and were not canceled the upgrade will fail.This is due to a foreign key being added on 4.2.5, relating image_transfers table to command_entities table. When the roll-back to the previous RHV-M versi

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

On Fri, Aug 3, 2018 at 7:01 AM Jan Siml wrote: > Hello, > > > If there are Disk Uploads that have not completed (i.e: currently > > Paused or with Error) and were not canceled the upgrade will fail.This > > is due to a foreign key being added on 4.2.5, relating image_transfers > > table to comman

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

On Fri, Aug 3, 2018 at 2:01 PM Jan Siml wrote: > Hello, > > > If there are Disk Uploads that have not completed (i.e: currently > > Paused or with Error) and were not canceled the upgrade will fail.This > > is due to a foreign key being added on 4.2.5, relating image_transfers > > table to comman

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

Hello, There are probably some more stale image transfers records, can you please check whether 'image_transfers' table is empty? If not, you can try removing them by executing: "DELETE FROM image_transfers WHERE command_id NOT IN (SELECT command_entities.command_id FROM command_entities);" (yo

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

As the potential user could upgrade from an older version, though not recommended to stay too much below, I simulate this upgrade from 4.2.3.7 (current engine package version is ovirt-engine-4.2.3.7-1.el7.noarch updated on 26/05) to 4.2.5 and I get this in engine-setup [ INFO ] Backing up databa

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

In particular, the log of the db restore, where I can find it? to understand which state of the db I have now on disk... the old, the new, a partial restore or what... at this time the image_transfers table is clearly the old one without the foreign key: engine=# \d image_transfers

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

On Fri, Aug 3, 2018 at 2:14 PM, Jan Siml wrote: > Hello, > > There are probably some more stale image transfers records, >> can you please check whether 'image_transfers' table is empty? >> If not, you can try removing them by executing: >> "DELETE FROM image_transfers WHERE command_id NOT IN (SE

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

On Fri, Aug 3, 2018 at 3:52 PM, Gianluca Cecchi wrote: > On Fri, Aug 3, 2018 at 2:14 PM, Jan Siml wrote: > >> Hello, >> >> There are probably some more stale image transfers records, >>> can you please check whether 'image_transfers' table is empty? >>> If not, you can try removing them by execu

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

Hello, On 03.08.2018 15:52, Gianluca Cecchi wrote: On Fri, Aug 3, 2018 at 2:14 PM, Jan Siml > wrote: Hello, There are probably some more stale image transfers records, can you please check whether 'image_transfers' table is empty? If not,

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

On Fri, Aug 3, 2018 at 4:09 PM, Jan Siml wrote: > Hello, > > On 03.08.2018 15:52, Gianluca Cecchi wrote: > >> On Fri, Aug 3, 2018 at 2:14 PM, Jan Siml > js...@plusline.net>> wrote: >> >> Hello, >> >> There are probably some more stale image transfers records, >> can you please

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

Hello, So your workflow was: - run engine-setup and got failure was it able in your case to restore the engine db in this first run and start engine again? You wrote that there was an upload failure and that you removed it: did you mean you removed it from the GUI, and confirming that after f

[ovirt-users] Re: Schema upgrade error while updating 4.2.4 to 4.2.5

Thanks for your explanation. Just one more clarification. See below On Fri, Aug 3, 2018 at 5:06 PM, Jan Siml wrote: > Hello, > > So your workflow was: >> >> - run engine-setup and got failure >> was it able in your case to restore the engine db in this first run and >> start engine again? >> You