Created attachment 1162608 [details] logs: engine.log, ovirt-engine-dwhd.log, vdsm.log Description of problem: Not really sure why, but audit log shows: "etl service sampling has encountered an error. please consult the service log for more details." Happens every once in a while. Version-Release number of selected component: Engine: ovirt-engine-extension-aaa-jdbc-1.1.0-0.0.master.20160424162911.gitb7a9e39.el7.noarch ovirt-engine-tools-backup-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-tools-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-iso-uploader-4.0.0-0.0.master.20160424162751.git98e29da.el7.centos.noarch ovirt-engine-cli-3.6.2.1-1.el7.centos.noarch ovirt-engine-dwh-4.0.0-0.0.master.20160518051036.git9c6a5cc.el7.centos.noarch ovirt-engine-dbscripts-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-setup-plugin-ovirt-engine-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-log-collector-4.0.0-0.0.master.20160511153619.git3218ba1.el7.centos.noarch ovirt-host-deploy-1.5.0-0.4.master.20160520091409.git4da06da.el7.centos.noarch ovirt-engine-setup-plugin-websocket-proxy-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-vmconsole-proxy-1.0.2-0.0.master.20160518125823.git547e1a7.el7.noarch ovirt-engine-userportal-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-setup-plugin-vmconsole-proxy-helper-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-extension-aaa-ldap-1.1.5-0.0.master.20160520084617.git4acb486.el7.noarch ovirt-setup-lib-1.0.2-0.0.master.20160502125738.gitf05af9e.el7.centos.noarch ovirt-engine-wildfly-10.0.0-1.el7.x86_64 ovirt-engine-lib-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-extensions-api-impl-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-host-deploy-java-1.5.0-0.4.master.20160520091409.git4da06da.el7.centos.noarch ovirt-engine-setup-plugin-ovirt-engine-common-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-websocket-proxy-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-backend-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-restapi-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-setup-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-extension-aaa-misc-1.0.1-0.0.master.20160424162924.git1299e21.el7.noarch ovirt-engine-sdk-python-3.6.5.1-1.el7.centos.noarch ovirt-image-uploader-4.0.0-0.0.master.20160424163606.gita3e72cd.el7.centos.noarch ovirt-release-master-4.0.0-0.3.master.20160518074018.gitec2301a.noarch ovirt-engine-dwh-setup-4.0.0-0.0.master.20160518051036.git9c6a5cc.el7.centos.noarch ovirt-engine-webadmin-portal-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-sdk-java-3.6.5.1-0.1.20160425.gitefe1672.el7.noarch ovirt-engine-wildfly-overlay-10.0.0-1.el7.noarch python-ovirt-engine-sdk4-4.0.0-0.0.20160520git7286a65.el7.centos.x86_64 ovirt-vmconsole-1.0.2-0.0.master.20160518125823.git547e1a7.el7.noarch ovirt-engine-vmconsole-proxy-helper-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch ovirt-engine-extension-aaa-ldap-setup-1.1.5-0.0.master.20160520084617.git4acb486.el7.noarch ovirt-engine-setup-base-4.0.0-0.0.master.20160521171336.git2e1899b.el7.centos.noarch VDSM: vdsm-4.18.0-24.gitc9d65a5.el7.centos.x86_64 How reproducible: Not sure (it happens on it's own). Steps to Reproduce: 1. Insall ovirt engine. 2. Configure hosts and storage domains (block and file). 3. Configure email notifications). Actual results: "etl service sampling has encountered an error. please consult the service log for more details." Happens every once in a while. From ovirt-engine-dwhd.log: 2016-05-22 18:17:05|6BEBwv|9smduv|2RxwTz|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 Exception in component tJDBCInput_7 org.postgresql.util.PSQLException: ERROR: column "vm_disk_interface" does not exist Position: 165 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_7Process(ConfigurationSync.java:31332) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_26Process(ConfigurationSync.java:30429) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_6Process(ConfigurationSync.java:27693) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_24Process(ConfigurationSync.java:24977) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_5Process(ConfigurationSync.java:23034) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_22Process(ConfigurationSync.java:21141) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_4Process(ConfigurationSync.java:18569) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_34Process(ConfigurationSync.java:16044) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_33Process(ConfigurationSync.java:14842) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_20Process(ConfigurationSync.java:13644) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_3Process(ConfigurationSync.java:12272) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_18Process(ConfigurationSync.java:11292) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_1Process(ConfigurationSync.java:9759) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_15Process(ConfigurationSync.java:8329) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_2Process(ConfigurationSync.java:6962) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_11Process(ConfigurationSync.java:6000) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_9Process(ConfigurationSync.java:4235) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync$2.run(ConfigurationSync.java:59653) Expected results: No errors/warnings
Tal, could it be related in any way to your refactoring?
This column was indeed removed as a part of the refactoring, Shirly was notified and if I'm not mistaken there should be a bug for this change in the DWH, Shirly?
Was fixed. Should be in nightly build. *** This bug has been marked as a duplicate of bug 1338495 ***