On Sun, Oct 11, 2020 at 8:40 PM Nir Soffer <nsoffer@redhat.com> wrote: Looks like an issue on my side, I built an old branch by mistake. Building again the correct branch engine-setup succeeded. Sorry for the noise.

Trying to setup engine from master (+some patches) fails now with:

[ INFO ] Backing up database localhost:engine to '/home/nsoffer/ovirt-engine/var/lib/ovirt-engine/backups/engine-20201011203045.ttdi_77z.dump'. [ INFO ] Creating/refreshing Engine database schema [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/home/nsoffer/ovirt-engine/share/ovirt-engine/dbscripts/create_views.sql [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed

Setup log show:

psql:/home/nsoffer/ovirt-engine/share/ovirt-engine/dbscripts/create_views.sql:2799: ERROR: column network.port_isolation does not exist LINE 22: network.port_isolation AS port_isolation, ^ FATAL: Cannot execute sql command: --file=/home/nsoffer/ovirt-engine/share/ovirt-engine/dbscripts/create_views.sql

2020-10-11 20:30:51,712+0300 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:530 schema.sh: FATAL: Cannot execute sql command: --file=/home/nsoffer/ovirt-engine/share/ovirt-engine/dbscripts/create_views.sql 2020-10-11 20:30:51,713+0300 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/home/nsoffer/ovirt-engine/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 532, in _misc raise RuntimeError(_('Engine schema refresh failed'))

I guess this is related to latest networking changes, maybe some patches were wrong, breaking my database?

Do we have a way to fix this? I don't want to clear my database, it has useful storage and host setup.

Thanks, Nir