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

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