[ovirt-users] Testing ovirt 3.6 Beta 3

Tue Sep 1 15:57:20 UTC 2015

On Tue, Sep 1, 2015 at 5:08 PM, wodel youchi <wodel.youchi at gmail.com> 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 at redhat.com>:
>
>>
>>
>> On Tue, Sep 1, 2015 at 12:40 PM, Yedidyah Bar David <didi at redhat.com>
>> wrote:
>>
>>> On Tue, Sep 1, 2015 at 1:25 PM, wodel youchi <wodel.youchi at gmail.com>
>>> 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 at redhat.com>:
>>> >>
>>> >>
>>> >>
>>> >> On Tue, Sep 1, 2015 at 11:46 AM, Yedidyah Bar David <didi at redhat.com>
>>> >> wrote:
>>> >>>
>>> >>> On Tue, Sep 1, 2015 at 11:25 AM, wodel youchi <
>>> wodel.youchi at gmail.com>
>>> >>> 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 at ovirt.org
>>> >>> http://lists.ovirt.org/mailman/listinfo/users
>>> >>
>>> >>
>>> >
>>>
>>>
>>>
>>> --
>>> Didi
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20150901/e5f3bc47/attachment-0001.html>