Red Hat Bugzilla – Bug 980862
[engine] The column name call_stack was not found in this ResultSet
Last modified: 2016-02-10 14:14:53 EST
Created attachment 768207 [details]
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):
Steps to Reproduce:
1. install is4
2. enter webadmin using "admin" (using workaround from bug 980858)
3. try to create new data center
GUi trying to load without success, after trying to create DC GUI gets stuck
GUi should work properly
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?
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.