search

hoprnet / hoprnet

HOPR is an open incentivized mixnet which enables privacy-preserving point-to-point data exchange. HOPR is similar to Tor but actually private, decentralized and economically sustainable.
https://hoprnet.org
GNU General Public License v3.0
208 stars 90 forks source link

Failed to insert the winning ticket unique constraint failed #6361

Open ausias-armesto opened 2 months ago

ausias-armesto commented 2 months ago

Description

While executing the load tests in version 2.1.1 nodes, hoprd-core-rotsee-5 started to write error logs constantly for every message relayed.

hopr_db_api::ticket_manager: failed to insert the winning ticket and update the ticket stats: Execution Error: error returned from database: (code: 2067) UNIQUE constraint failed: ticket.channel_id, ticket.channel_epoch, ticket.index

More logs can be seen here

The database folder can be downloaded here

The data to start the node locally is in hoprnet-ci The identity password is stored in bitwarden as Hoprd Node - core-team staging

QYuQianchen commented 3 weeks ago

@ausias-armesto is this issue still relevant?

ausias-armesto commented 2 weeks ago

@QYuQianchen Yes, this is a bottle-neck found during load testing, so I assume that it is something we should optimise to be able to improve throughput