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 <bill.james(a)j2.com>
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(a)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.