In Clickhouse tables, some transactions are present in sourcelogs but not in transaction table

[facuzeta]

Problem

While running mempool-dumpster and storing the output into ClickHouse, we noticed an unexpected inconsistency between the tables.

Some transaction hashes appear in:
• sourcelogs

but are missing from:
• transactions

This was surprising because (as far as we understand) every transaction observed in sourcelogs should eventually be represented in the transactions table.

We did not find anything unusual in the ClickHouse logs that would explain the missing data. However, it is still possible that the issue is related to ingestion or persistence on the ClickHouse side.