services/horizon: Duplicate key error in LiquidityPoolsChangeProcessor

[urvisavla]

What version are you using?

Latest from master branch.

What did you do?

Ran Horizon in ingest mode.

What did you expect to see?

Horizon to ingest without errors.

What did you see instead?

Horizon ingestion halted with the following error during ingestion of ledger 49247417:

ERRO[2023-11-30T15:59:26.921Z] Error in ingestion state machine current_state="resume(latestSuccessfullyProcessedLedger=49247416)" error="Error running processors on ledger: Error committing changes from processor: error in *processors.LiquidityPoolsChangeProcessor.Commit: error executing LiquidityPoolsBatchInsertBuilder: pq: duplicate key value violates unique constraint "liquidity_pools_pkey"" next_state="resume(latestSuccessfullyProcessedLedger=49247416)" pid=1647120 service=ingest

This error indicates that a duplicate key value was found while inserting data into the liquidity_pools table.