Hi, We have a failure in CQ on ovirt-master for test 001_upgrade_engine.test_initialize_engine on upgrade suite. *Link and headline of suspected patches: https://gerrit.ovirt.org/#/c/93466/ <https://gerrit.ovirt.org/#/c/93466/> - core: clean stale image_transfer on upgradeLink to Job:https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975 <https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975>Link to all logs:https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975/... <https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975/artif... error snippet from the log: <error>* [ INFO ] Stage: Misc configuration [ INFO ] Upgrading CA [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20180806074534.L73Aa6.dump'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Configuring WebSocket Proxy [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20180806074537.V9dDgr.dump'. [ INFO ] Creating/refreshing Engine database schema [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_03_0270_add_foreign_key_to_image_transfers.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-20180806074537.V9dDgr.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-20180806074515-jb06pl.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180806074550-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-20180806074534.L73Aa6.dump' to database localhost:ovirt_engine_history. [ ERROR ] Errors while restoring ovirt_engine_history database, please check the log file for details [ INFO ] Stage: Pre-termination

*</error>* _______________________________________________ Infra mailing list -- infra(a)ovirt.org To unsubscribe send an email to infra-leave(a)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/infra@ovirt.org/ message/ZGQZ577ZVVHD2X5ZKWW6FWJPL524LCDF/

Hi, We have a failure in CQ on ovirt-master for test 001_upgrade_engine.test_initialize_engine on upgrade suite. *Link and headline of suspected patches: https://gerrit.ovirt.org/#/c/93466/ <https://gerrit.ovirt.org/#/c/93466/> - core: clean stale image_transfer on upgradeLink to Job:https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975 <https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975>Link to all logs:https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975/... <https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975/artif... error snippet from the log: <error>* [ INFO ] Stage: Misc configuration [ INFO ] Upgrading CA [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20180806074534.L73Aa6.dump'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Configuring WebSocket Proxy [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20180806074537.V9dDgr.dump'. [ INFO ] Creating/refreshing Engine database schema [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_03_0270_add_foreign_key_to_image_transfers.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-20180806074537.V9dDgr.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-20180806074515-jb06pl.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180806074550-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-20180806074534.L73Aa6.dump' to database localhost:ovirt_engine_history. [ ERROR ] Errors while restoring ovirt_engine_history database, please check the log file for details [ INFO ] Stage: Pre-termination

*</error>* _______________________________________________ Infra mailing list -- infra(a)ovirt.org To unsubscribe send an email to infra-leave(a)ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/communit y/about/community-guidelines/ List Archives: https://lists.ovirt.org/archiv es/list/infra(a)ovirt.org/message/ZGQZ577ZVVHD2X5ZKWW6FWJPL524LCDF/

Eli, Daniel is on PTO today, as the main DB guy can you please have a look? On Mon, Aug 6, 2018 at 5:38 PM, Tal Nisan <tnisan(a)redhat.com&gt; wrote: > Daniel please check it ASAP tomorrow, we cannot release the async without > being sure the script doesn't fail > ---------- Forwarded message ---------- > From: Sandro Bonazzola <sbonazzo(a)redhat.com&gt; > Date: Mon, Aug 6, 2018 at 3:48 PM > Subject: [ovirt-devel] Re: [ OST Failure Report ] [ oVirt master > (ovirt-engine) ] [ 6-08-2018 ] [ TEST NAME ] > To: Dafna Ron <dron(a)redhat.com&gt; > Cc: devel <devel(a)ovirt.org&gt;, infra <infra(a)ovirt.org&gt; > > > > > 2018-08-06 14:45 GMT+02:00 Dafna Ron <dron(a)redhat.com&gt;: > >> Hi, >> >> We have a failure in CQ on ovirt-master for test >> 001_upgrade_engine.test_initialize_engine on upgrade suite. >> >> >> >> >> >> >> >> >> >> *Link and headline of suspected patches: >> https://gerrit.ovirt.org/#/c/93466/ <https://gerrit.ovirt.org/#/c/93466/> - >> core: clean stale image_transfer on upgradeLink to >> Job:https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975 >> <https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975>Link >> to all >> logs:https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975/... >> <https://jenkins.ovirt.org/job/ovirt-master_change-queue-tester/8975/artif... >> error snippet from the log: <error>* >> >> [ INFO ] Stage: Misc configuration >> [ INFO ] Upgrading CA >> [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20180806074534.L73Aa6.dump'. >> [ INFO ] Creating/refreshing DWH database schema >> [ INFO ] Configuring WebSocket Proxy >> [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20180806074537.V9dDgr.dump'. >> [ INFO ] Creating/refreshing Engine database schema >> [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_03_0270_add_foreign_key_to_image_transfers.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-20180806074537.V9dDgr.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-20180806074515-jb06pl.log >> [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180806074550-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-20180806074534.L73Aa6.dump' to database localhost:ovirt_engine_history. >> [ ERROR ] Errors while restoring ovirt_engine_history database, please check the log file for details >> [ INFO ] Stage: Pre-termination >> >> > > this should have been already fixed https://bugzilla.redhat. > com/show_bug.cgi?id=1609839 > Daniel, can you please cross check? > > > > >> *</error>* >> >> _______________________________________________ >> Infra mailing list -- infra(a)ovirt.org >> To unsubscribe send an email to infra-leave(a)ovirt.org >> Privacy Statement: https://www.ovirt.org/site/privacy-policy/ >> oVirt Code of Conduct: https://www.ovirt.org/communit >> y/about/community-guidelines/ >> List Archives: https://lists.ovirt.org/archiv >> es/list/infra(a)ovirt.org/message/ZGQZ577ZVVHD2X5ZKWW6FWJPL524LCDF/ >> >> > > > -- > > SANDRO BONAZZOLA > > MANAGER, SOFTWARE ENGINEERING, EMEA R&D RHV > > Red Hat EMEA <https://www.redhat.com/> > > sbonazzo(a)redhat.com > <https://red.ht/sig> > <https://www.redhat.com/en/events/red-hat-open-source-day-italia?sc_cid=70... > > _______________________________________________ > Devel mailing list -- devel(a)ovirt.org > To unsubscribe send an email to devel-leave(a)ovirt.org > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: https://www.ovirt.org/communit > y/about/community-guidelines/ > List Archives: https://lists.ovirt.org/archiv > es/list/devel(a)ovirt.org/message/7BRBJFMR52G37BRH7DHRWTLOKRAYVXTC/ > > >