Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7

From: "Marcelo Leandro" <marceloltmm(a)gmail.com&gt; To: "Darrell Budic" <budic(a)onholyground.com&gt; Cc: "Martin Perina" <mperina(a)redhat.com&gt;, "Eli Mesika" <emesika(a)redhat.com&gt;, "users" <users(a)ovirt.org&gt; Sent: Friday, February 5, 2016 2:44:16 AM Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7 i try update, but the problem persists and now the ovirt not start. attached the setup.log, I tried three times: 1- i have problem with connection and the process closed 2-return erro : [ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/schema.sh' failed to execute i see that que yum have problem : run command: yum clean expire-cache and yum it's ok now. 3- return erro: [ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/schema.sh' failed to execute now the ovirt not start. erro the boot.log 22:15:55,237 INFO [org.jboss.modules] JBoss Modules version 1.1.1.GA 22:16:05,538 INFO [org.jboss.msc] JBoss MSC version 1.0.2.GA 22:16:05,614 INFO [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting 22:16:05,988 ERROR [org.jboss.as.server] JBAS015956: Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceException: JBAS014676: Failed to parse configuration at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:141) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.server.ServerService.boot(ServerService.java:266) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:155) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_95] Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[4,1] Message: Unexpected element '{urn:jboss:domain:2.1}server' at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:108) [staxmapper-1.1.0.Final.jar:1.1.0.Final] at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:69) [staxmapper-1.1.0.Final.jar:1.1.0.Final] at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:133) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] ... 3 more 22:16:06,012 FATAL [org.jboss.as.server] JBAS015957: Server boot has failed in an unrecoverable manner; exiting. See previous messages for details. 22:16:06,040 INFO [org.jboss.as] JBAS015950: JBoss AS 7.1.1.Final "Brontes" stopped in 3ms additional information: [root@srv-ovirt01 ~]# cat /etc/ovirt-engine/engine.conf.d/10-setup-jboss.conf JBOSS_HOME="/usr/share/ovirt-engine-jboss-as" i try this https://bugzilla.redhat.com/show_bug.cgi?id=1062318 but no have success thanks. 2016-02-04 18:40 GMT-03:00 Darrell Budic <budic(a)onholyground.com&gt;: > I suspect that’s my problem, my database isn’t owned by engine: > > engine=# \l > List of databases > Name | Owner | Encoding | Collation | Ctype | Access > privileges > > -----------+----------+----------+-------------+-------------+-------------------- > --- > engine | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > > This is almost certainly my fault though, one too many upgrades from old > versions and/or a slightly botched restore process. Would I be better off > setting “engine” as the owner of the engine database then (thinking > forward here)? > > -Darrell > > >> On Feb 4, 2016, at 10:22 AM, Martin Perina <mperina(a)redhat.com&gt; wrote: >> >> >> >> ----- Original Message ----- >>> From: "Eli Mesika" <emesika(a)redhat.com&gt; >>> To: "Martin Perina" <mperina(a)redhat.com&gt; >>> Cc: "Marcelo Leandro" <marceloltmm(a)gmail.com&gt;, "Darrell Budic" >>> <budic(a)onholyground.com&gt;, "users" <users(a)ovirt.org&gt; >>> Sent: Thursday, February 4, 2016 5:17:24 PM >>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>> 6.2.6-1.el7 >>> >>> >>> >>> ----- Original Message ----- >>>> From: "Martin Perina" <mperina(a)redhat.com&gt; >>>> To: "Marcelo Leandro" <marceloltmm(a)gmail.com&gt; >>>> Cc: "Darrell Budic" <budic(a)onholyground.com&gt;, "Eli Mesika" >>>> <emesika(a)redhat.com&gt;, "users" <users(a)ovirt.org&gt; >>>> Sent: Thursday, February 4, 2016 6:12:34 PM >>>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>> 6.2.6-1.el7 >>>> >>>> Hi, >>>> >>>> so it seems, that for some strange reason, user 'engine' cannot create >>>> schema in 'engine' database although it should be an owner of this db. >>>> I double checked that on all our testing databases this works fine and >>>> also if you created engine db according to doc (either automatically >>>> by engine-setup or manually in case of remote db) this should work. >>>> >>>> So you can try to execute following command which adds proper >>>> permissions to 'engine' db user (please adapt according to you setup): >>>> >>>> >>>> su - postgres -c "psql --command=\"GRANT ALL ON DATABASE >>>> @ENGINE_DB_DATABASE@ TO @ENGINE_DB_USER@;\"" >>>> >>>> The correct output should be: >>>> >>>> GRANT >>>> >>>> If it's successful, please execute engine-setup again to verify that >>>> above step fixed the issue. >>> >>> Martin, should that be added to engine-setup ? >> >> I don't this so, because for all other users I know of this works fine >> (if engine db is created according to doc, engine db user is an owner >> of db so he can create new schemas). >> >> But let's wait for reply ... >> >>> >>>> >>>> Thanks >>>> >>>> Martin Perina >>>> >>>> ----- Original Message ----- >>>>> From: "Marcelo Leandro" <marceloltmm(a)gmail.com&gt; >>>>> To: "Martin Perina" <mperina(a)redhat.com&gt; >>>>> Sent: Thursday, February 4, 2016 1:40:36 PM >>>>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>>> 6.2.6-1.el7 >>>>> >>>>> Hello Martin, >>>>> >>>>> Indeed there´s an issue here. Runnig your command, I got this error: >>>>> ERROR: permission denied for database engine , I'm investigating >>>>> deeper >>>>> >>>>> Thanks >>>>> >>>>> 2016-02-04 6:18 GMT-03:00 Martin Perina <mperina(a)redhat.com&gt;: >>>>>> Hi, >>>>>> >>>>>> I just verified that upgrades on both Centos 6.7 and Centos 7.2 works >>>>>> fine, >>>>>> so there's something bad with psql on you machines :-( >>>>>> >>>>>> Could you please execute following steps and send me result? >>>>>> >>>>>> 1. Please take a look at your engine db configuration in >>>>>> /etc/ovirt-engine/engine.conf.d/10-setup-database.conf >>>>>> >>>>>> 2. Please replace variables (@VAR@) with real values according to your >>>>>> db setup and execute following command on engine host (or VM in >>>>>> case of hosted engine): >>>>>> >>>>>> LC_ALL="C" PGPASSWORD="@ENGINE_DB_PASSWORD@" psql -w >>>>>> --pset=tuples_only=on --host="@ENGINE_DB_HOST@" >>>>>> --port="@ENGINE_DB_PORT@" --username="@ENGINE_DB_USER@" >>>>>> --dbname="@ENGINE_DB_DATABASE@" --set ON_ERROR_STOP=1 --no-psqlrc >>>>>> --command="CREATE SCHEMA aaa_jdbc_x AUTHORIZATION @ENGINE_DB_USER@;" >>>>>> || >>>>>> die "Cannot execute sql command" >>>>>> >>>>>> Correct output should be: >>>>>> >>>>>> CREATE SCHEMA >>>>>> >>>>>> >>>>>> Thanks a lot >>>>>> >>>>>> Martin Perina >>>>>> >>>>>> ----- Original Message ----- >>>>>>> From: "Darrell Budic" <budic(a)onholyground.com&gt; >>>>>>> To: "Marcelo Leandro" <marceloltmm(a)gmail.com&gt; >>>>>>> Cc: "Martin Perina" <mperina(a)redhat.com&gt;, "users" <users(a)ovirt.org&gt; >>>>>>> Sent: Thursday, February 4, 2016 6:17:21 AM >>>>>>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>>>>> 6.2.6-1.el7 >>>>>>> >>>>>>> I just hit a similar problem, but on Centos 6.7, postgres >>>>>>> (PostgreSQL) >>>>>>> 8.4.20. Looks like a permission error for me? >>>>>>> >>>>>>> 2016-02-03 22:52:42 DEBUG otopi.context context._executeMethod:142 >>>>>>> Stage >>>>>>> misc >>>>>>> ME >>>>>>> THOD >>>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.aaajdbc.Plugin._misc >>>>>>> 2016-02-03 22:52:42 INFO >>>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.aa >>>>>>> ajdbc aaajdbc._setupSchema:97 Creating/refreshing Engine 'internal' >>>>>>> domain >>>>>>> datab >>>>>>> ase schema >>>>>>> 2016-02-03 22:52:42 DEBUG >>>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>>> aajdbc plugin.executeRaw:828 execute: >>>>>>> ['/usr/share/ovirt-engine-extension-aaa-jd >>>>>>> bc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>>> 'engine', >>>>>>> '-d', >>>>>>> 'engine', '-e', 'aaa_jdbc', '-l', >>>>>>> '/var/log/ovirt-engine/setup/ovirt-engine-setu >>>>>>> p-20160203224629-uy91s0.log', '-c', 'apply'], executable='None', >>>>>>> cwd='None', >>>>>>> env >>>>>>> ={'LESSOPEN': '||/usr/bin/lesspipe.sh %s', 'LOGNAME': 'root', 'USER': >>>>>>> 'root', >>>>>>> 'P >>>>>>> ATH': '/sbin:/bin:/usr/sbin:/usr/bin', 'HOME': '/root', 'LANG': >>>>>>> 'en_US.UTF-8', ' >>>>>>> TERM': 'xterm-color', 'SHELL': '/bin/bash', 'SHLVL': '1', >>>>>>> 'G_BROKEN_FILENAMES': >>>>>>> '1', 'HISTSIZE': '1000', 'SUDO_USER': 'telsin', 'USERNAME': 'root', >>>>>>> 'PYTHONPATH' >>>>>>> : '/usr/share/ovirt-engine/setup/bin/..::', 'SUDO_UID': '699600001', >>>>>>> 'KRB5CCNAME >>>>>>> ': 'FILE:/tmp/krb5cc_699600001_5oRWEw', 'MAIL': >>>>>>> '/var/spool/mail/telsin', >>>>>>> 'DBFUN >>>>>>> C_DB_PGPASSFILE': '/tmp/tmpqzrQIw', 'SUDO_COMMAND': '/bin/bash', >>>>>>> 'SUDO_GID': >>>>>>> '69 >>>>>>> 9600001', 'HOSTNAME': 'ovirt.int.ohgnetworks.com', 'PWD': >>>>>>> '/home/telsin', >>>>>>> 'OTOPI >>>>>>> _LOGFILE': >>>>>>> '/var/log/ovirt-engine/setup/ovirt-engine-setup-20160203224629-uy91s0 >>>>>>> .log', 'LS_COLORS': >>>>>>> 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd= >>>>>>> 40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30 >>>>>>> ;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:* >>>>>>> .lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31: >>>>>>> *.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31 >>>>>>> :*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01; >>>>>>> 31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif >>>>>>> =01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:* >>>>>>> .xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=0 >>>>>>> 1;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*. >>>>>>> ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;3 >>>>>>> 5:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli= >>>>>>> 01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cg >>>>>>> m=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36: >>>>>>> *.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=0 >>>>>>> 1;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xs >>>>>>> pf=01;36:', 'OTOPI_EXECDIR': '/home/telsin'} >>>>>>> ********* QUERY ********** >>>>>>> select 1; >>>>>>> ************************** >>>>>>> >>>>>>> 1 >>>>>>> >>>>>>> ********* QUERY ********** >>>>>>> copy ( >>>>>>> SELECT COUNT(schema_name) >>>>>>> FROM information_schema.schemata >>>>>>> WHERE schema_name = 'aaa_jdbc' >>>>>>> ) to stdout with delimiter as '|'; >>>>>>> ************************** >>>>>>> >>>>>>> ********* QUERY ********** >>>>>>> CREATE SCHEMA aaa_jdbc AUTHORIZATION engine; >>>>>>> ************************** >>>>>>> >>>>>>> 2016-02-03 22:52:43 DEBUG >>>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>>> aajdbc plugin.executeRaw:878 execute-result: >>>>>>> ['/usr/share/ovirt-engine-extension >>>>>>> -aaa-jdbc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', >>>>>>> '-u', >>>>>>> 'engine', >>>>>>> '-d', 'engine', '-e', 'aaa_jdbc', '-l', >>>>>>> '/var/log/ovirt-engine/setup/ovirt-engi >>>>>>> ne-setup-20160203224629-uy91s0.log', '-c', 'apply'], rc=1 >>>>>>> 2016-02-03 22:52:43 DEBUG >>>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>>> aajdbc plugin.execute:936 execute-output: >>>>>>> ['/usr/share/ovirt-engine-extension-aa >>>>>>> a-jdbc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>>> 'engine', >>>>>>> '- >>>>>>> d', 'engine', '-e', 'aaa_jdbc', '-l', >>>>>>> '/var/log/ovirt-engine/setup/ovirt-engine- >>>>>>> setup-20160203224629-uy91s0.log', '-c', 'apply'] stdout: >>>>>>> Creating custom schema aaa_jdbc ... >>>>>>> >>>>>>> 2016-02-03 22:52:43 DEBUG >>>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>>> aajdbc plugin.execute:941 execute-output: >>>>>>> ['/usr/share/ovirt-engine-extension-aa >>>>>>> a-jdbc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>>> 'engine', >>>>>>> '- >>>>>>> d', 'engine', '-e', 'aaa_jdbc', '-l', >>>>>>> '/var/log/ovirt-engine/setup/ovirt-engine- >>>>>>> setup-20160203224629-uy91s0.log', '-c', 'apply'] stderr: >>>>>>> ERROR: permission denied for database engine >>>>>>> FATAL: Cannot execute sql command: --no-psqlrc --command=CREATE >>>>>>> SCHEMA >>>>>>> aaa_jdbc >>>>>>> AUTHORIZATION engine; >>>>>>> >>>>>>> 2016-02-03 22:52:43 DEBUG otopi.context context._executeMethod:156 >>>>>>> method >>>>>>> except >>>>>>> ion >>>>>>> Traceback (most recent call last): >>>>>>> File "/usr/lib/python2.6/site-packages/otopi/context.py", line 146, >>>>>>> in >>>>>>> _execut >>>>>>> eMethod >>>>>>> method['method']() >>>>>>> File >>>>>>> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-en >>>>>>> gine/config/aaajdbc.py", line 379, in _misc >>>>>>> self._setupSchema() >>>>>>> File >>>>>>> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-en >>>>>>> gine/config/aaajdbc.py", line 138, in _setupSchema >>>>>>> oenginecons.EngineDBEnv.PGPASS_FILE >>>>>>> File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 946, >>>>>>> in >>>>>>> execute >>>>>>> command=args[0], >>>>>>> RuntimeError: Command >>>>>>> '/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/sche >>>>>>> ma.sh' failed to execute >>>>>>> 2016-02-03 22:52:43 ERROR otopi.context context._executeMethod:165 >>>>>>> Failed >>>>>>> to >>>>>>> exe >>>>>>> cute stage 'Misc configuration': Command >>>>>>> '/usr/share/ovirt-engine-extension-aaa- >>>>>>> jdbc/dbscripts/schema.sh' failed to execute >>>>>>> >>>>>>> This hosted engine has been through several upgrades if it makes a >>>>>>> difference. Any workarounds available? >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> -Darrell >>>>>>> >>>>>>> >>>>>>>> On Feb 3, 2016, at 4:17 AM, Marcelo Leandro <marceloltmm(a)gmail.com&gt; >>>>>>>> wrote: >>>>>>>> >>>>>>>> Hello Martin, >>>>>>>> >>>>>>>> SO version: >>>>>>>> CentOS Linux release 7.2.1511 (Core) >>>>>>>> >>>>>>>> >>>>>>>> Postgresql version: >>>>>>>> postgres=# SELECT version(); >>>>>>>> >>>>>>>> version >>>>>>>> >>>>>>>> -------------------------------------------------------------------------------------------------------------- >>>>>>>> >>>>>>>> PostgreSQL 9.2.14 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) >>>>>>>> 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit >>>>>>>> >>>>>>>> >>>>>>>> Thanks. >>>>>>>> >>>>>>>> 2016-02-03 4:40 GMT-03:00 Martin Perina <mperina(a)redhat.com&gt;: >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> what distribution are you using? What is postgresql version? >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> Martin Perina >>>>>>>>> >>>>>>>>> ----- Original Message ----- >>>>>>>>>> From: "Marcelo Leandro" <marceloltmm(a)gmail.com&gt; >>>>>>>>>> To: "users" <users(a)ovirt.org&gt; >>>>>>>>>> Sent: Wednesday, February 3, 2016 3:39:58 AM >>>>>>>>>> Subject: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>>>>>>>> 6.2.6-1.el7 >>>>>>>>>> >>>>>>>>>> hello, >>>>>>>>>> i have problem for update with ovirt. >>>>>>>>>> erro msg: >>>>>>>>>> >>>>>>>>>> [ ERROR ] Failed to execute stage 'Misc configuration': Command >>>>>>>>>> '/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/schema.sh' >>>>>>>>>> failed to execute >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> setup.log: >>>>>>>>>> https://copy.com/nOhoxwI8kPzm6fO0 >>>>>>>>>> >>>>>>>>>> anybody can help me ? >>>>>>>>>> >>>>>>>>>> Thanks. >>>>>>>>>> _______________________________________________ >>>>>>>>>> Users mailing list >>>>>>>>>> Users(a)ovirt.org >>>>>>>>>> http://lists.ovirt.org/mailman/listinfo/users >>>>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Users mailing list >>>>>>>> Users(a)ovirt.org >>>>>>>> http://lists.ovirt.org/mailman/listinfo/users >