Hi all

I see them same bug when updating ovirt-engine-4.2.6.1_SNAPSHOT-89.g295078e.0.scratch.master.el7ev.noarch to
4.2.6.3_SNAPSHOT-93.g584f531.0.scratch.master.el7ev

[ INFO  ] Creating/refreshing Engine database schema
[ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1220_default_all_search_engine_string_fields_to_not_null.sql
[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed

[WARNING] Rollback of DWH database postponed to Stage "Clean up"
[ INFO  ] Rolling back database schema
[ INFO  ] Clearing Engine database engine
[ INFO  ] Restoring Engine database engine
[ INFO  ] Restoring file '/var/lib/ovirt-engine/backups/engine-20180814093847.cVgLOk.dump' to database localhost:engine.
[ ERROR ] Errors while restoring engine database, please check the log file for details
[ INFO  ] Stage: Clean up
          Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20180814093241-7qpel8.log
[ INFO  ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180814094223-setup.conf'
[WARNING] Rollback of DWH database started
          This might be a long process, but it should be safe to start the engine service before it finishes, if needed.
[ INFO  ] Clearing DWH database ovirt_engine_history
[ INFO  ] Restoring DWH database ovirt_engine_history
[ INFO  ] Restoring file '/var/lib/ovirt-engine-dwh/backups/dwh-20180814093834.8oBh4G.dump' to database localhost:ovirt_engine_history.
[ INFO  ] Stage: Pre-termination
[ INFO  ] Stage: Termination
[ ERROR ] Execution of setup failed

Thanks,

On Tue, Aug 14, 2018 at 10:13 AM, Martin Perina <mperina@redhat.com> wrote:

Adding Eli

On Tue, Aug 14, 2018 at 9:03 AM, Yedidyah Bar David <didi@redhat.com> wrote:

On Tue, Aug 14, 2018 at 9:27 AM, Maton, Brett <matonb@ltresources.co.uk> wrote:
>
> Just tried to update my test cluster to 4.2.6.2 :
>
>
> [ INFO  ] Stage: Misc configuration
> [ INFO  ] Running vacuum full on the engine schema
> [ INFO  ] Running vacuum full elapsed 0:00:04.523561
> [ INFO  ] Upgrading CA
> [ INFO  ] Backing up database localhost:ovirt_engine_history to
> '/var/lib/ovirt-engine-dwh/backups/dwh-20180814071815.xVSlda.dump'.
> [ INFO  ] Creating/refreshing DWH database schema
> [ INFO  ] Configuring Image I/O Proxy
> [ INFO  ] Configuring WebSocket Proxy
> [ INFO  ] Backing up database localhost:engine to
> '/var/lib/ovirt-engine/backups/engine-20180814071825.af3Hq2.dump'.
> [ INFO  ] Creating/refreshing Engine database schema
> [ ERROR ] schema.sh: FATAL: Cannot execute sql command:
> --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1220_default_all_search_engine_string_fields_to_not_null.sql
> [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema
> refresh failed
> [ INFO  ] Yum Performing yum transaction rollback
>
>
> May or may not be relevant in this case but /tmp and /var/tmp are mounted
> noexec.

I do not think this is tested regularly, but I guess it should be ok.

> Any more logs you need let me know.

Can you please check/share full setup log? engine-setup should output the
full path, it should be in /var/log/ovirt-engine/setup . Thanks.
--
Didi
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/KQGLRAXYPMUBZMIMWDISVUHBNLV4BLHX/

--

Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.

_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/

List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/HEUCWGSLJNGIWWG3JRW3TZMN4L7UCUHB/

--

Michael Burman

Senior Quality engineer - rhv network - redhat israel

Red Hat

mburman@redhat.com    M: 0545355725     IM: mburman

_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/NLDOWGXPDOHZCZGHLNDVK3JZLXLC6KPR/