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

[Oved Ourfali]

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.

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 at 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
>               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
>
>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20151219/969b45e1/attachment-0001.html>