<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Dec 19, 2015 at 7:58 PM, Oved Ourfali <span dir="ltr"><<a href="mailto:oourfali@redhat.com" target="_blank">oourfali@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><p dir="ltr">Reading it again, I'm not sure the engine was even tested with centos 7. <br>
As far as I know only centos 6 is supported/tested for the engine machine.</p></blockquote><div><div>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.</div><div><br></div><div>[root@enginevm ~]# cat /etc/redhat-release </div><div>CentOS Linux release 7.2.1511 (Core) </div></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><p dir="ltr"> </p>
<p dir="ltr">CC-ing Eli to try and help with the DB issue, but if you have any backup I guess it would be safer. </p>
<p dir="ltr">Oved <br>
</p>
<div class="gmail_quote"><div><div class="h5">On Dec 19, 2015 15:15, "Gianluca Cecchi" <<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.com</a>> wrote:<br type="attribution"></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Hello.<div><br></div><div>I updated my test self hosted engine vm to 3.6.1 and to CentOS 7.2.</div><div><br></div><div>Now it seems it isn't able to to login to webadmin due to this in engine.log</div><div>(field is empty in web admin gui)</div><div> </div><div><div>2015-12-19 13:59:05,182 ERROR [org.ovirt.engine.core.bll.aaa.LoginBaseCommand] (default task-17) [] </div><div>Can't login because authentication profile 'internal' doesn't exist.</div></div><div><br></div><div>Is it an already known problem?</div><div><br></div><div>The first ERRROR message I find in it is dated 13:34 and it is an SQL one:</div><div><br></div><div><div>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"</div><div> Detail: Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".</div><div> Where: SQL statement "INSERT INTO storage_domain_dynamic(available_disk_size, id, used_disk_size)</div><div> VALUES(v_available_disk_size, v_id, v_used_disk_size)"</div><div>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"</div><div> Detail: Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".</div><div> Where: SQL statement "INSERT INTO storage_domain_dynamic(available_disk_size, id, used_disk_size)</div><div> VALUES(v_available_disk_size, v_id, v_used_disk_size)"</div><div>PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line 3 at SQL statement</div><div>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"</div><div> Detail: Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".</div></div><div><br></div><div><br></div><div>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:</div><div>from installed one<br></div><div><div>Nov 04 12:55:30 Installed: postgresql-server-9.2.13-1.el7_1.x86_64</div></div><div>to 7.2 one</div><div><div>Dec 19 13:45:51 Updated: postgresql-server-9.2.14-1.el7_1.x86_64</div></div><div><br></div><div>BTW: my order was</div><div><br></div><div>yum update "ovirt-engine-setup-*"</div><div>engine-setup<br></div><div><br></div><div>the engine-setup completed successfully with </div><div>...</div><div><div>[ INFO ] Stage: Misc configuration</div><div>[ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20151219132925.5OoFQA.dump'.</div><div>[ INFO ] Creating/refreshing Engine database schema</div><div>[ INFO ] Creating/refreshing Engine 'internal' domain database schema</div><div>[ INFO ] Upgrading CA</div><div>[ INFO ] Configuring WebSocket Proxy</div><div>[ INFO ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'</div><div>[ INFO ] Stage: Transaction commit</div><div>[ INFO ] Stage: Closing up</div><div> </div><div> --== SUMMARY ==--</div><div> </div><div> SSH fingerprint: 19:56:8d:3e:50:fc:90:37:5a:ba:6c:57:30:b1:7d:93</div><div> Internal CA DA:E6:04:34:99:A0:DB:CE:3F:0A:7B:A2:96:67:4C:7F:19:CA:95:5F</div><div> Note! If you want to gather statistical information you can install Reports and/or DWH:</div><div> <a href="http://www.ovirt.org/Ovirt_DWH" target="_blank">http://www.ovirt.org/Ovirt_DWH</a></div><div> <a href="http://www.ovirt.org/Ovirt_Reports" target="_blank">http://www.ovirt.org/Ovirt_Reports</a></div><div> Web access is enabled at:</div><div> <a href="http://ractorshe.mydomain:80/ovirt-engine" target="_blank">http://ractorshe.mydomain:80/ovirt-engine</a></div><div> <a href="https://ractorshe.mydomain:443/ovirt-engine" target="_blank">https://ractorshe.mydomain:443/ovirt-engine</a></div><div> </div><div> --== END OF SUMMARY ==--</div><div> </div><div>[ INFO ] Starting engine service</div><div>[ INFO ] Restarting httpd</div><div>[ INFO ] Restarting ovirt-vmconsole proxy service</div><div>[ INFO ] Stage: Clean up</div><div> Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20151219132415-2pfee1.log</div><div>[ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20151219133045-setup.conf'</div><div>[ INFO ] Stage: Pre-termination</div><div>[ INFO ] Stage: Termination</div><div>[ INFO ] Execution of setup completed successfully</div></div><div><br></div><div>Strangely the VM was shutdown...</div><div>In /var/log/libvirt/qemu/HostedEngine.log I saw (in UTC)</div><div><div>2015-12-19 12:31:19.494+0000: shutting down</div></div><div><br></div><div>So I exited from global maintenance, the VM was started and I verified that admin web gui was ok with new version.</div><div><br></div><div>Then I put maintenance again and run on engine VM</div><div><br></div><div>systemctl stop ovirt-engine</div><div>yum update (I forgot to also shutdown POstgreSQL before... )</div><div>shutdown -r now</div><div><br></div><div>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....</div><div><br></div><div>Let me know if you need further info.</div><div><br></div><div>Gianluca</div><div><br></div><div><br></div></div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br></blockquote></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div>