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:
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