On Tue, Sep 1, 2015 at 5:08 PM, wodel youchi <wodel.youchi(a)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(a)redhat.com>:
>
>
> On Tue, Sep 1, 2015 at 12:40 PM, Yedidyah Bar David <didi(a)redhat.com>
> wrote:
>
>> On Tue, Sep 1, 2015 at 1:25 PM, wodel youchi <wodel.youchi(a)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(a)redhat.com>:
>> >>
>> >>
>> >>
>> >> 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>
>> >>> 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
>>
>
>