[Bug]: datanode crash when adding party score

[Sohill-Patel]

Problem encountered

2024-05-14T16:07:08.955Z	ERROR	datanode.sqlstore-broker	broker/sqlstore_broker.go:377	failed to process event id:"328-16" block:"6C87E495F29ACC4B3199ED878DEDF3378A4DAC7226D00B4CFF0D0D55BA316ED9" type:BUS_EVENT_TYPE_GAME_SCORES game_scores:{party_scores:{game_id:"458cb4e88fb84588697da3f6d185e627c9a7b4ae1a994e354c95ae9961b3ff10" party:"54d911dd386f5a48cdb265ae4ce234c2545f5841be193629d0c1a7d27ac8d40e" epoch:24 time:1715702827836830462 score:"0" staking_balance:"0" open_volume:"0" total_fees_paid:"4800000000000000000"} party_scores:{game_id:"458cb4e88fb84588697da3f6d185e627c9a7b4ae1a994e354c95ae9961b3ff10" party:"6f7b442f87b78c1a95b45402c843b5a4b766bbbe5a92b0a84f7e1901d720935b" epoch:24 time:1715702827836830462 score:"1" staking_balance:"0" open_volume:"0" is_eligible:true}} version:1 chain_id:"testnet-001" tx_hash:"6C87E495F29ACC4B3199ED878DEDF3378A4DAC7226D00B4CFF0D0D55BA316ED9" error:ERROR: duplicate key value violates unique constraint "14_14_game_party_scores_pkey" (SQLSTATE 23505)
error adding party score
code.vegaprotocol.io/vega/datanode/sqlsubscribers.(*GameScore).consume
	/jenkins/workspace/common/system-tests-wrapper/vega/datanode/sqlsubscribers/game_scores.go:72
code.vegaprotocol.io/vega/datanode/sqlsubscribers.(*GameScore).Push
	/jenkins/workspace/common/system-tests-wrapper/vega/datanode/sqlsubscribers/game_scores.go:55
code.vegaprotocol.io/vega/datanode/broker.(*SQLStoreBroker).push
	/jenkins/workspace/common/system-tests-wrapper/vega/datanode/broker/sqlstore_broker.go:372
code.vegaprotocol.io/vega/datanode/broker.(*SQLStoreBroker).handleEvent
	/jenkins/workspace/common/system-tests-wrapper/vega/datanode/broker/sqlstore_broker.go:360
code.vegaprotocol.io/vega/datanode/broker.(*SQLStoreBroker).processBlock
	/jenkins/workspace/common/system-tests-wrapper/vega/datanode/broker/sqlstore_broker.go:318
code.vegaprotocol.io/vega/datanode/broker.(*SQLStoreBroker).Receive
	/jenkins/workspace/common/system-tests-wrapper/vega/datanode/broker/sqlstore_broker.go:135
code.vegaprotocol.io/vega/cmd/data-node/commands/start.(*NodeCommand).runNode.func6
	/jenkins/workspace/common/system-tests-wrapper/vega/cmd/data-node/commands/start/node.go:153
golang.org/x/sync/errgroup.(*Group).Go.func1
	/jenkins/GOPATH/pkg/mod/golang.org/x/[email protected]/errgroup/errgroup.go:78
runtime.goexit

https://jenkins.vega.rocks/job/common/job/system-tests-wrapper/58293/artifact/testnet/logs/testnet-nodeset-full-2-full/data-node-2.stdout-2024-05-14T16%3A03%3A47Z.log

Observed behaviour

panic occurs after call to api ListGamePartyScores

Expected behaviour

no panic

Steps to reproduce

1. run system-test `test_spot_distributing_maker_fee_rewards` on branch `0056-REWA-137`
2. Observe the error

Software version

dev branch

Failing test

test_spot_distributing_maker_fee_rewards

Jenkins run

https://jenkins.vega.rocks/job/common/job/system-tests-wrapper/58293/#showFailuresLink

Configuration used

No response

Relevant log output

No response