GitLab

I run HAF and only track virtual operations (op_type_id > 49). HAF ignores my filters and puts certain operations into account_operations table.
These are the operations:

account_create_operation
pow_operation
create_claimed_account_operation
pow2_operation
account_create_with_delegation_operation

According to blocktrades, this is by design and HAF needs these data. The problem is, it filters out these operations from the operations table so it fails to create the indexes and shuts down hived.

So basically the operation 1095 in this error message exists in account_operations but doesn't exist in operations table.
The easy fix seems to be overriding filters and adding the above operations.