Re: [ovirt-users] Testing ovirt 3.6 Beta 3

On Tue, Sep 1, 2015 at 5:08 PM, wodel youchi <wodel.youchi(a)gmail.com&gt; wrote: > Hi again, > > I tried with the snapshot repository, but I am having this error while > executing engine-setup > > [ INFO ] Creating/refreshing Engine database schema > [ ERROR ] Failed to execute stage 'Misc configuration': Command > '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execu > te > [ INFO ] DNF Performing DNF transaction rollback > [ INFO ] Rolling back database schema > [ INFO ] Clearing Engine database engine > [ ERROR ] Engine database rollback failed: must be owner of schema > pg_catalog > [ INFO ] Stage: Clean up > Log file is located at > /var/log/ovirt-engine/setup/ovirt-engine-setup-20150901153202-w0ds25.log > [ INFO ] Generating answer file > '/var/lib/ovirt-engine/setup/answers/20150901153939-setup.conf' > [ INFO ] Stage: Pre-termination > [ INFO ] Stage: Termination > [ ERROR ] Execution of setup failed > > > > and in the deployement log I have these errors > > Saving custom users permissions on database objects... > upgrade script detected a change in Config, View or Stored Procedure... > Running upgrade shell script > '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql'... > Running upgrade shell script > '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql'... > Running upgrade shell script > '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql'... > Running upgrade shell script > '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql'... > Running upgrade shell script > '/usr/share/ovirt-engine/dbscripts/pre_upgrade/0040_extend_installed_by_column.sql'... > > > 2015-09-01 15:39:35 DEBUG > otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:941 > execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', > 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log > > > > > > > > > > > > > > > > > */ovirt-engine/setup/ovirt-engine-setup-20150901153202-w0ds25.log', '-c', > 'apply'] > stderr:/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 1: /bin : is a > directory/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 2: DATABASE : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 4: This : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 5: The : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 6: Add : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 7: syntax error near the symbole unexpected « ( > »/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql: > ligne 7: ` Update section (w/o overriding current > value)'/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 1: /bin : is a > directory/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 2: Currently : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 3: This : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 4: This : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 5: So, : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 6: Since : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 7: bin/ : is a > directory/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 9: update : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 10: * > > > *syntax error near the symbole unexpected « ( > »/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql: > ligne 10: `and exists(select 1 from schema_version where version = > '03010250' and current = > true);'/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql: > ligne 1: -- : command not > found/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql: > ligne 2: **syntax error near the symbole unexpected « ( »* > /usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql: > ligne 2: `CREATE FUNCTION __temp__0030_add_materialized_views_table()' > /usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql: > ligne 1: -- : commande introuvable > /usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql: > ligne 2: erreur de syntaxe près du symbole inattendu « ( » > /usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql: > ligne 2: `select fn_db_add_column('materialized_views', > 'min_refresh_rate_in_sec', 'int default 0');' > /usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0040_extend_installed_by_column.sql: > ligne 1: erreur de syntaxe près du symbole inattendu « ( » > /usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0040_extend_installed_by_column.sql: > ligne 1: `ALTER TABLE schema_version ALTER COLUMN installed_by TYPE > varchar(63);' > 2015-09-01 15:39:35 DEBUG otopi.context context._executeMethod:156 method > exception > Traceback (most recent call last): > File "/usr/lib/python2.7/site-packages/otopi/context.py", line 146, in > _executeMethod > method['method']() > File > "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", > line 291, in _misc > oenginecons.EngineDBEnv.PGPASS_FILE > File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 946, in > execute > command=args[0], > RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/schema.sh' > failed to execute > 2015-09-01 15:39:35 ERROR otopi.context context._executeMethod:165 Failed > to execute stage 'Misc configuration': Command > '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute > 2015-09-01 15:39:35 DEBUG otopi.transaction transaction.abort:134 > aborting 'DNF Transaction' > 2015-09-01 15:39:35 DEBUG otopi.plugins.otopi.packagers.dnfpackager > dnfpackager.verbose:90 DNF Closing transaction with rollback > 2015-09-01 15:39:35 INFO otopi.plugins.otopi.packagers.dnfpackager > dnfpackager.info:94 DNF Performing DNF transaction rollback > It was an issue with package building: all the sql files where executable and so the issue. We fixed it and tomorrow build should be OK. If you prefer to continue right now simply recursively remove the x attribute on each sql file under /usr/share/ovirt-engine/dbscripts > > 2015-09-01 13:04 GMT+01:00 Simone Tiraboschi <stirabos(a)redhat.com&gt;: > >> >> >> On Tue, Sep 1, 2015 at 12:40 PM, Yedidyah Bar David <didi(a)redhat.com&gt; >> wrote: >> >>> On Tue, Sep 1, 2015 at 1:25 PM, wodel youchi <wodel.youchi(a)gmail.com&gt; >>> wrote: >>> > Hi, >>> > >>> > I am using the repo of the 3.6 version >>> > (http://plain.resources.ovirt.org/pub/ovirt-3.6-pre/rpm/fc22/) >>> > >>> > I installed the ovirt-hosted-engine-setup with it's dependencies,and >>> the >>> > ovirt-hosted-engine-ha package is one of them. >>> > >>> > Correction: The problem with this version >>> > >>> ovirt-hosted-engine-ha-1.3.0-0.0.master.20150819082341.20150819082338.git183a4ff.fc22.noarch.rpm, >>> > is that after the installation is done, the service ovirt-ha-agent >>> crashes >>> > after being started, see the bug : >>> > >>> > https://bugzilla.redhat.com/show_bug.cgi?id=1254745 >>> > >>> > A new version was produced, I downloaded it manually a few days ago, >>> this is >>> > it : >>> > >>> ovirt-hosted-engine-ha-1.3.0-0.0.master.20150820064645.20150820064642.git02529e0.fc22.noarch.rpm >>> > >>> > This one did correct the problem, but it's not present anymore on the >>> > repository. >>> >>> Was this on ovirt-3.6-pre? >>> >>> ovirt-3.6-snapshot has a newer version. >>> >>> > >>> > For Simone: yes I did added an NFS4 data domain, but no success so >>> far, no >>> > VM engine present. >>> > >>> > Regards. >>> > >>> > 2015-09-01 11:15 GMT+01:00 Simone Tiraboschi <stirabos(a)redhat.com&gt;: >>> >> >>> >> >>> >> >>> >> On Tue, Sep 1, 2015 at 11:46 AM, Yedidyah Bar David <didi(a)redhat.com >>> > >>> >> wrote: >>> >>> >>> >>> On Tue, Sep 1, 2015 at 11:25 AM, wodel youchi < >>> wodel.youchi(a)gmail.com&gt; >>> >>> wrote: >>> >>> > Hi, >>> >>> > >>> >>> > Another test of ovirt hosted-engine on FC22 using ovirt 3.6 Beta3. >>> >>> > VM engine is also a FC22 >>> >>> > >>> >>> > Problem: >>> >>> > - No VM engine on webui >>> >>> >>> >>> This is still not supported, see/follow [1]. >>> >>> >>> >>> [1] https://bugzilla.redhat.com/show_bug.cgi?id=1224889 >>> >> >>> >> >>> >> ? :-) >>> >>> Sorry :-( >>> >>> https://bugzilla.redhat.com/show_bug.cgi?id=1160094 >> >> >> This is just about editing the VM from the web GUI but in order to be >> able to edit the engine VM you should be able at least to find the engine >> VM in the engine as it was also in 3.5 >> >> I'll try to reproduce verifying another patch >> >> >>> I see that all patches there are merged, but bug is in POST. >>> >>> >> >>> >> Did you also try adding an additional storage domain for regular VMs? >>> >> engine-VM will be shown on the engine only when you add at least one >>> >> additional storage domain for regulars VM and the whole datacenter >>> goes up: >>> >> https://bugzilla.redhat.com/show_bug.cgi?id=1222010#c1 >>> >> >>> >> >>> >>> >>> >>> > Test Environment >>> >>> > Just two machines: >>> >>> > >>> >>> > 1 - Machine 1 used as storage : >>> >>> > - iscsi target with a raw file for the VM engine storage >>> >>> > - NFS4 for other data domains >>> >>> > >>> >>> > 2 - Machine 2 used as hypervisor >>> >>> > >>> >>> > >>> >>> > The installation went without problem, but as always, the VM >>> engine is >>> >>> > not >>> >>> > present on the webui. >>> >>> > >>> >>> > >>> >>> > PS: >>> >>> > 1- I gave the VM engine just 2Gb of memory since I don't have too >>> much >>> >>> > RAM >>> >>> > on hypervisor, could that be the cause of the problem? >>> >>> >>> >>> Shouldn't be related >>> >>> >>> >>> > 2- This version of >>> >>> > >>> >>> > >>> ovirt-hosted-engine-ha-1.3.0-0.0.master.20150424113926.20150424113923.git7c14f4c.fc22.noarch.rpm >>> >>> > package is causing the ovirt-ha-agent to crash, it was replaced >>> with >>> >>> > another >>> >>> > which I still have >>> >>> > >>> >>> > >>> ovirt-hosted-engine-ha-1.3.0-0.0.master.20150820064645.20150820064642.git02529e0.fc22.noarch.rpm, >>> >>> > but it's not present on the repository, I had to update the >>> package >>> >>> > manually >>> >>> > at the end of ovirt-hosted-engine-setup installation. >>> >>> >>> >>> Not sure I follow. >>> >>> >>> >>> What exact repo was used? >>> >>> >>> >>> hosted-engine --deploy does not update/install packages for you (as >>> >>> does engine-setup), >>> >>> it's up to you to make sure what you want/need is installed prior to >>> >>> running it. >>> >>> >>> >>> Best, >>> >>> -- >>> >>> Didi >>> >>> _______________________________________________ >>> >>> Users mailing list >>> >>> Users(a)ovirt.org >>> >>> http://lists.ovirt.org/mailman/listinfo/users >>> >> >>> >> >>> > >>> >>> >>> >>> -- >>> Didi >>> >> >> >