[ovirt-users] After update to 3.6.1 profile internal does not exist message

[Gianluca Cecchi]

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
              http://www.ovirt.org/Ovirt_Reports
          Web access is enabled at:
              http://ractorshe.mydomain:80/ovirt-engine
              https://ractorshe.mydomain:443/ovirt-engine

          --== 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20151219/b35d5c8a/attachment.html>