Bug 1371515
| Summary: | Exception on GetUserProfileQuery (unknown cause) : "The column name user_portal_vm_auto_login was not found in this ResultSet" | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Yaniv Kaul <ykaul> |
| Component: | Database.Core | Assignee: | Martin Perina <mperina> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Lucie Leistnerova <lleistne> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.0.2.7 | CC: | bugs, emesika, mgoldboi, mperina, tjelinek |
| Target Milestone: | ovirt-4.0.4 | Flags: | rule-engine:
ovirt-4.0.z+
rule-engine: blocker+ mgoldboi: planning_ack+ mperina: devel_ack+ pstehlik: testing_ack+ |
| Target Release: | 4.0.4 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2016-09-26 12:41:19 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
BTW, it seems to flood the log. Example: 2016-08-30 14:49:20,495 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-142) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:20,946 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-239) [] Query 'GetUserProfileQuery' failed: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:20,946 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-239) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:20,957 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-239) [] Query 'GetUserProfileQuery' failed: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:20,957 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-239) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:22,662 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-117) [] Query 'GetUserProfileQuery' failed: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:22,662 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-117) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:31,434 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-239) [] Query 'GetUserProfileQuery' failed: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:31,434 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-239) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:31,812 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-234) [] Query 'GetUserProfileQuery' failed: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:49:31,812 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-234) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. Marking as blocker, because all user upgrading from 3.6 are affected by this. Only new 4.0 installation (no upgrade) works fine Here is workaround for 4.0.0 - 4.0.3 users who performed upgrade from 3.6 (clean 4.0 installations are not affected by this bug): cd /usr/share/ovirt-engine/dbscripts/upgrade cp 03_06_1790_add_vm_auto_login_column_to_user_profiles_table.sql 04_00_0865_add_vm_auto_login_column_to_user_profiles_table.sql engine-setup Following workaround will cause no issues on future upgrade to 4.0.4, which fixes the issue regularly. engine upgraded 3.6.9 -> 4.0.4 and column user_profiles.user_portal_vm_auto_login created, no setup error verified in ovirt-engine-4.0.4.2-0.1.el7ev.noarch |
Description of problem: Found on RHEV.TLV setup, unknown cause: 2016-08-30 14:43:08,671 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-229) [] Query 'GetUserProfileQuery' failed: PreparedStatementCallback; bad SQL grammar [select * from getuserprofileby userid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. 2016-08-30 14:43:08,673 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-229) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:762) [spring-jdbc.jar:4.2.4.RELEASE] at org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.executeCallInternal(PostgresDbEngineDialect.java:154) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.doExecute(PostgresDbEngineDialect.java:120) [dal.jar:] at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:198) [spring-jdbc.jar:4.2.4.RELEASE] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:147) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeReadList(SimpleJdbcCallsHandler.java:109) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeRead(SimpleJdbcCallsHandler.java:101) [dal.jar:] at org.ovirt.engine.core.dao.UserProfileDaoImpl.getByUserId(UserProfileDaoImpl.java:49) [dal.jar:] at org.ovirt.engine.core.bll.GetUserProfileQuery.executeQueryCommand(GetUserProfileQuery.java:19) [bll.jar:] at org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:103) [bll.jar:] at org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:33) [dal.jar:] at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:558) [bll.jar:] ... Caused by: org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2727) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBoolean(AbstractJdbc2ResultSet.java:2572) at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBoolean(WrappedResultSet.java:843) at org.ovirt.engine.core.dao.UserProfileDaoImpl$UserProfileRowMapper.mapRow(UserProfileDaoImpl.java:31) [dal.jar:] at org.ovirt.engine.core.dao.UserProfileDaoImpl$UserProfileRowMapper.mapRow(UserProfileDaoImpl.java:19) [dal.jar:] at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:693) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629) [spring-jdbc.jar:4.2.4.RELEASE] ... 133 more Version-Release number of selected component (if applicable): [ykaul@nott16 ~]$ rpm -qa |grep ovirt |grep -E "engine|portal" ovirt-engine-kerbldap-migration-1.0.4-1.el7ev.noarch ovirt-engine-setup-plugin-vmconsole-proxy-helper-4.0.2.7-0.1.el7ev.noarch ovirt-engine-setup-4.0.2.7-0.1.el7ev.noarch ovirt-engine-restapi-4.0.2.7-0.1.el7ev.noarch ovirt-engine-extension-aaa-jdbc-1.1.0-1.el7ev.noarch ovirt-engine-extension-aaa-ldap-setup-1.2.1-1.el7ev.noarch ovirt-engine-setup-plugin-ovirt-engine-common-4.0.2.7-0.1.el7ev.noarch ovirt-engine-cli-3.6.8.1-1.el7ev.noarch ovirt-engine-dbscripts-4.0.2.7-0.1.el7ev.noarch ovirt-engine-userportal-debuginfo-4.0.2.7-0.1.el7ev.noarch ovirt-engine-extension-aaa-misc-1.0.1-2.el7ev.noarch ovirt-engine-dwh-setup-4.0.2-1.el7ev.noarch ovirt-engine-websocket-proxy-4.0.2.7-0.1.el7ev.noarch ovirt-engine-extensions-api-impl-4.0.2.7-0.1.el7ev.noarch ovirt-engine-tools-backup-4.0.2.7-0.1.el7ev.noarch ovirt-engine-tools-4.0.2.7-0.1.el7ev.noarch ovirt-engine-webadmin-portal-debuginfo-4.0.2.7-0.1.el7ev.noarch ovirt-engine-webadmin-portal-4.0.2.7-0.1.el7ev.noarch ovirt-engine-lib-4.0.2.7-0.1.el7ev.noarch ovirt-engine-setup-plugin-ovirt-engine-4.0.2.7-0.1.el7ev.noarch ovirt-engine-vmconsole-proxy-helper-4.0.2.7-0.1.el7ev.noarch python-ovirt-engine-sdk4-4.0.0-0.5.a5.el7ev.x86_64 ovirt-engine-userportal-4.0.2.7-0.1.el7ev.noarch ovirt-engine-4.0.2.7-0.1.el7ev.noarch ovirt-engine-extension-aaa-ldap-1.2.1-1.el7ev.noarch ovirt-engine-setup-base-4.0.2.7-0.1.el7ev.noarch ovirt-engine-backend-4.0.2.7-0.1.el7ev.noarch ovirt-engine-dwh-4.0.2-1.el7ev.noarch ovirt-engine-setup-plugin-websocket-proxy-4.0.2.7-0.1.el7ev.noarch ovirt-engine-sdk-python-3.6.8.0-1.el7ev.noarch ovirt-engine-dashboard-1.0.2-1.el7ev.x86_64 Actual results: Expected results: Additional info: