search

OdyseeTeam / chainquery

Chainquery parses and syncs the LBRY blockchain data into structured SQL
https://lbry.tech
MIT License
2.26k stars 42 forks source link

Wrong claim state in database #145

Open tzarebczan opened 4 years ago

tzarebczan commented 4 years ago

Not sure how many other claims this affects: https://chainquery.lbry.com/api/sql?query=select+*+from+claim+where+name=%22sxiv-the-suckless-image-viewer-for-gnu%22

jarvisexploit commented 4 years ago

https://chainquery.lbry.com/api/sql?query=select+*+from+claim+where+name=%22sxiv-the-suckless-image-viewer-for-gnu%22

tzarebczan commented 3 years ago

Another one: 69460dd5fd81976e16172d1c8e76a0455196bb6a

tzarebczan commented 3 years ago

Here's one that shows controlling but is spent:

1095b7dee28fa98142a6b0be7223cf66a437bc5d

btzr-io commented 3 years ago

https://chainquery.lbry.com/api/sql?query=%20Select%20bid_state,%20license%20from%20claim%20where%20claim_id%20=%20%229c20eec1c3d2069cfe9ba20b12e2f7fd56de4af1%22

btzr-io commented 3 years ago

Reposts also affected: https://chainquery.lbry.com/api/sql?query=select%20*%20from%20claim%20where%20claim_reference%20=%20%226fe4a218b494d630c225bc2c12462cc52c609494%22

tzarebczan commented 3 years ago

This is affecting many more claims than we thought and should be looked into ASAP. We've been updating manually.

btzr-io commented 2 years ago

Any updates on this ?