Created attachment 768207 [details] engine.log Description of problem: GUI is trying to load for long time without Success Checked the logs, I see there "bad SQL grammar" in loop, not sure if this is the root cause 2013-07-03 14:22:46,337 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-8) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 0 and audit_log_id IN (SELECT audit_log.audit_log_id FROM audit_log ) and not deleted) ORDER BY audit_log_id DESC ,audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name call_stack was not found in this ResultSet. Version-Release number of selected component (if applicable): 3.3 (is4) How reproducible: 100% Steps to Reproduce: 1. install is4 2. enter webadmin using "admin" (using workaround from bug 980858) 3. try to create new data center Actual results: GUi trying to load without success, after trying to create DC GUI gets stuck Expected results: GUi should work properly Additional info:
sounds related to bug 966198 (infra) -> moving to infra. Oved - any idea?
Proper upgrade/new installation should have created this field. Was there any failures in the DB upgrade?
Aharon, A few questions: - was this on an upgraded system ? (probably yes). - From what version to what version was it upgraded ? - Can you please provide the upgrade logs & yum log ?
- I am not sure about the upgrade and versions, as it was not part of the upgrade I didn't give it attention also, the system was deleted few times since then so no upgrade logs...
I cannot reproduce this bug. Does it reproduce for you in latest build? If not I suggest we close this bug.
I didn't face it again since then, let's close and I will reopen in case needed.