bug: duplicate and erroneous db entries

[siobh9]

as of 1735947100 unix timestamp (6:38pm ET on 1/3/25), the attached CSV was the result of the below query in our db:

select * from analytics_contest_participants_v3
where contest_address = '0xf49164f40a71352c0976108fd19a786fbdd00b35'
and user_address = '0xe77B4E1cd04a96c23B9e3294804d65ed503b35D8'

it shows 31 duplicate entries in addition to the correct 2, and one of the duplicates has an entirely erroneous value for amount_sent (ETH because this was on base) of 1000.

what actually happened onchain can be verified here - only 2 vote transactions were actually sent.

not necessarily urgent and I have deleted the duplicate records in the db for now to make our data clean, but def important to look into, diagnose, and see if there's anything we can do to prevent in the future.

duplicate_and_erroneous_analytics_entries.csv