Re: [ovirt-users] dwhd error: host_interface_samples_history_pkey
That fixed it, Thank you. On 05/29/2016 12:39 AM, Yedidyah Bar David wrote: On Fri, May 27, 2016 at 9:03 PM, Bill James wrote: Ovirt events keeps saying "ETL service sampling has encountered an error. Please consult the service log for more details." ovirt-engine-dwhd.log says: 2016-05-27 10:55:00|UWxd1W|48u96S|MjrqV0|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: root page 3 of index "host_interface_samples_history_pkey" has level 0, expected 1|1 This error message is from postgresql, unrelated to a specific feature/table/etc of ovirt. It most likely means you had some corruption in your database, either due to bad hardware (RAM, disk, etc) or temporary issues (power failure, kernel panic etc). If you think it was a temporary issue and just want to fix this specific bad index, you can recreate it with the command "reindex". Search for e.g. 'postgresql "ignore_system_indexes" reindex' to find more relevant information. Best, Exception in component tJDBCOutput_3 org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) (see attached) I double checked all my VMs, they all have an interface assigned. Not sure what host_interface_samples_history_pkey is referring to. Thanks. ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users Cloud Services for Business www.j2.com j2 | eFax | eVoice | FuseMail | Campaigner | KeepItSafe | Onebox This email, its contents and attachments contain information from j2 Global, Inc. and/or its affiliates which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is prohibited. If you have received this email in error please notify the sender by reply e-mail and delete the original message and any copies. (c) 2015 j2 Global, Inc. All rights reserved. eFax, eVoice, Campaigner, FuseMail, KeepItSafe, and Onebox are registered trademarks of j2 Global, Inc. and its affiliates. ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] dwhd error: host_interface_samples_history_pkey
On Fri, May 27, 2016 at 9:03 PM, Bill James wrote: > Ovirt events keeps saying > "ETL service sampling has encountered an error. Please consult the service > log for more details." > > > ovirt-engine-dwhd.log says: > 2016-05-27 > 10:55:00|UWxd1W|48u96S|MjrqV0|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java > Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: root page > 3 of index "host_interface_samples_history_pkey" has level 0, expected 1|1 This error message is from postgresql, unrelated to a specific feature/table/etc of ovirt. It most likely means you had some corruption in your database, either due to bad hardware (RAM, disk, etc) or temporary issues (power failure, kernel panic etc). If you think it was a temporary issue and just want to fix this specific bad index, you can recreate it with the command "reindex". Search for e.g. 'postgresql "ignore_system_indexes" reindex' to find more relevant information. Best, > Exception in component tJDBCOutput_3 > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > commands ignored until end of transaction block > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) > > (see attached) > > I double checked all my VMs, they all have an interface assigned. Not sure > what host_interface_samples_history_pkey is referring to. > > > Thanks. > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] dwhd error: host_interface_samples_history_pkey
Ovirt events keeps saying "ETL service sampling has encountered an error. Please consult the service log for more details." ovirt-engine-dwhd.log says: 2016-05-27 10:55:00|UWxd1W|48u96S|MjrqV0|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: root page 3 of index "host_interface_samples_history_pkey" has level 0, expected 1|1 Exception in component tJDBCOutput_3 org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) (see attached) I double checked all my VMs, they all have an interface assigned. Not sure what host_interface_samples_history_pkey is referring to. Thanks. ovirt-engine-dwhd.log.gz Description: GNU Zip compressed data ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users