On Sat, Dec 19, 2015 at 7:58 PM, Oved Ourfali <oourfali@redhat.com> wrote:

Reading it again, I'm not sure the engine was even tested with centos 7.
As far as I know only centos 6 is supported/tested for the engine machine.

Our ovirt-engine-appliance is already based on Centos 7 so I think that a consistent part of our 3.6 upstream user is already on that.

[root@enginevm ~]# cat /etc/redhat-release 
CentOS Linux release 7.2.1511 (Core) 

 

CC-ing Eli to try and help with the DB issue, but if you have any backup I guess it would be safer.

Oved

On Dec 19, 2015 15:15, "Gianluca Cecchi" <gianluca.cecchi@gmail.com> wrote:
Hello.

I updated my test self hosted engine vm to 3.6.1 and to CentOS 7.2.

Now it seems it isn't able to to login to webadmin due to this in engine.log
(field is empty in web admin gui)
 
2015-12-19 13:59:05,182 ERROR [org.ovirt.engine.core.bll.aaa.LoginBaseCommand] (default task-17) [] 
Can't login because authentication profile 'internal' doesn't exist.

Is it an already known problem?

The first ERRROR message I find in it is dated 13:34 and it is an SQL one:

2015-12-19 13:34:39,882 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 42) [] Failed to run compensation on startup for Command 'org.ovirt.engine.core.bll.storage.AddExistingFileStorageDomainCommand', Command Id 'bb7ee4a3-6b35-4c62-9823-a434a40e5b38': CallableStatementCallback; SQL [{call insertstorage_domain_dynamic(?, ?, ?)}]; ERROR: insert or update on table "storage_domain_dynamic" violates foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
  Detail: Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".
  Where: SQL statement "INSERT INTO storage_domain_dynamic(available_disk_size, id, used_disk_size)
        VALUES(v_available_disk_size, v_id, v_used_disk_size)"
PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line 3 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "storage_domain_dynamic" violates foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
  Detail: Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".
  Where: SQL statement "INSERT INTO storage_domain_dynamic(available_disk_size, id, used_disk_size)
        VALUES(v_available_disk_size, v_id, v_used_disk_size)"
PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line 3 at SQL statement
2015-12-19 13:34:39,882 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 42) [] Exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCallback; SQL [{call insertstorage_domain_dynamic(?, ?, ?)}]; ERROR: insert or update on table "storage_domain_dynamic" violates foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
  Detail: Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".


I think it is not related to update from CentOS 7.1 to 7.2 that generates an update of PostgreSQL too because it is 10 minutes later:
from installed one
Nov 04 12:55:30 Installed: postgresql-server-9.2.13-1.el7_1.x86_64
to 7.2 one
Dec 19 13:45:51 Updated: postgresql-server-9.2.14-1.el7_1.x86_64

BTW: my order was

yum update "ovirt-engine-setup-*"
engine-setup

the engine-setup completed successfully with 
...
[ INFO  ] Stage: Misc configuration
[ INFO  ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20151219132925.5OoFQA.dump'.
[ INFO  ] Creating/refreshing Engine database schema
[ INFO  ] Creating/refreshing Engine 'internal' domain database schema
[ INFO  ] Upgrading CA
[ INFO  ] Configuring WebSocket Proxy
[ INFO  ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'
[ INFO  ] Stage: Transaction commit
[ INFO  ] Stage: Closing up
         
          --== SUMMARY ==--
         
          SSH fingerprint: 19:56:8d:3e:50:fc:90:37:5a:ba:6c:57:30:b1:7d:93
          Internal CA DA:E6:04:34:99:A0:DB:CE:3F:0A:7B:A2:96:67:4C:7F:19:CA:95:5F
          Note! If you want to gather statistical information you can install Reports and/or DWH:
              http://www.ovirt.org/Ovirt_DWH
          Web access is enabled at:
         
          --== END OF SUMMARY ==--
         
[ INFO  ] Starting engine service
[ INFO  ] Restarting httpd
[ INFO  ] Restarting ovirt-vmconsole proxy service
[ INFO  ] Stage: Clean up
          Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20151219132415-2pfee1.log
[ INFO  ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20151219133045-setup.conf'
[ INFO  ] Stage: Pre-termination
[ INFO  ] Stage: Termination
[ INFO  ] Execution of setup completed successfully

Strangely the VM was shutdown...
In /var/log/libvirt/qemu/HostedEngine.log I saw (in UTC)
2015-12-19 12:31:19.494+0000: shutting down

So I exited from global maintenance, the VM was started and I verified that admin web gui was ok with new version.

Then I put maintenance again and run on engine VM

systemctl stop ovirt-engine
yum update (I forgot to also shutdown POstgreSQL before... )
shutdown -r now

As it was in maintenance it wasn't started again so I exited from maintenance and VM was started, but now I'm not able to see the internal profile....

Let me know if you need further info.

Gianluca



_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users