[ovirt-users] dwhd error: host_interface_samples_history_pkey

[Bill James]

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 at 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 at 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.