Bug 1340639 - ovirt-engine-dwhd.log: ERROR: column "vm_disk_interface" does not exist (among with other errors)
Summary: ovirt-engine-dwhd.log: ERROR: column "vm_disk_interface" does not exist (amon...
Keywords:
Status: CLOSED DUPLICATE of bug 1338495
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: ETL
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: ---
Assignee: Shirly Radco
QA Contact: Pavel Stehlik
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-05-29 12:23 UTC by Natalie Gavrielov
Modified: 2016-05-29 17:55 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-05-29 17:55:08 UTC
oVirt Team: Metrics
Embargoed:
ngavrilo: planning_ack?
ngavrilo: devel_ack?
ngavrilo: testing_ack?


Attachments (Terms of Use)
logs: engine.log, ovirt-engine-dwhd.log, vdsm.log (498.59 KB, application/x-gzip)
2016-05-29 12:23 UTC, Natalie Gavrielov
no flags Details

Description Natalie Gavrielov 2016-05-29 12:23:46 UTC
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

Comment 1 Yaniv Kaul 2016-05-29 13:55:26 UTC
Tal, could it be related in any way to your refactoring?

Comment 2 Tal Nisan 2016-05-29 15:55:19 UTC
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?

Comment 3 Shirly Radco 2016-05-29 17:55:08 UTC
Was fixed. Should be in nightly build.

*** This bug has been marked as a duplicate of bug 1338495 ***


Note You need to log in before you can comment on or make changes to this bug.