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

Sat Dec 19 19:16:49 UTC 2015

On Sat, Dec 19, 2015 at 7:58 PM, Oved Ourfali <oourfali at 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 at 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 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
>>
>>
> _______________________________________________
> 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/b12492cb/attachment-0001.html>