On Sun, Oct 11, 2020 at 8:40 PM Nir Soffer <nsoffer(a)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