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

2018-08-03 Thread Gianluca Cecchi
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? >>

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

2018-08-03 Thread Jan Siml
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

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

2018-08-03 Thread Gianluca Cecchi
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

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

2018-08-03 Thread Jan Siml
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

2018-08-03 Thread Gianluca Cecchi
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

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

2018-08-03 Thread Gianluca Cecchi
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

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

2018-08-03 Thread Gianluca Cecchi
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

2018-08-03 Thread Gianluca Cecchi
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

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

2018-08-03 Thread Jan Siml
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);"

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

2018-08-03 Thread Daniel Erez
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

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

2018-08-03 Thread Greg Sheremeta
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

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

2018-08-03 Thread Jan Siml
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

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

2018-08-03 Thread Vaibhav Pagar
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

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

2018-08-02 Thread Greg Sheremeta
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 > >