Plutus
Plutus copied to clipboard
Isaacdelly
Why some old adresses are missing from the database ?
Hi,
First: thanks for your work, Plutus is great.
After a little mod to your script, I've tested 11 adresses i was watching and I don't understand why 5 of them aren't in the database, those adresses have each 50 btc on it and the last transactions are from 2010 (so surely lost keys/wallet). The other 6 that are on the database have last transactions in 2019...
One missing adress is: 14YT1JzhvpX4Sz9eAfzVABTprVxKzQFd1g
https://www.blockchain.com/btc/address/14YT1JzhvpX4Sz9eAfzVABTprVxKzQFd1g
If the db had all the adresses with a positive balance, this one (and the others, I imagine there is plenty others missing if I can spot 5 out of 12...) should be in it... can you figure out why ?
I haven't looked at btcposbal2csv yet, did you update with special params or use it as it is ?
Is there a simple way for me to add my own list to my local database ?
Thanks, regards, Mike.
@MikeFlush which DB file are you using? I haven’t checked the current one in there, but that might have the addresses in question and instructions on how to create/load a more current one.
@alwaysminingbtc the last one available (MAR_23_2019)... for now i've added my 5 missing adresses in the code, but i'm pretty sure there is plenty others adresses missing, don't you think ?
@MikeFlush sorry, I accidentally didn’t provide a link to the newest DB. See here https://github.com/Isaacdelly/Plutus/issues/151#issuecomment-573555860. Download that and see if your addresses are in there. They should be.
@alwaysminingbtc Thanks for the new DB but unfortunatly all 5 adresses are still missing in the new DB...
@MikeFlush I searched the Jan 13, 2020 DB as well and couldn't find 14YT1JzhvpX4Sz9eAfzVABTprVxKzQFd1g. Odd.
@alwaysminingbtc Yeah very odd. That make me wonder how many are still missing...
@alwaysminingbtc I think the script making the DB is missing all adresses like this one, by looking closely on the blockchain for this adress, you see it contain 50BTC from newly generated coin (mining), but no transactions... I think the script scan for transactions to find adresses, and so didn't find all thoses adresses...
I've just grabbed 37 pages of adresses with 50 BTC from https://bitkeys.work/ and not a single one of the 5 adresses is on it... (yeah all 5 have exactly 50 btc on it since 2010... what a waste !)
Someone have an idea where I can find all those "missing" adresses ?
Thanks.
to grab addresses and balances from https://bitkeys.work/ give it a try https://github.com/zioneo/webscrapper. Worked for me with use of Python
Hmm, that is indeed weird. The only addresses removed from the database are ones starting with number "3", since the script only generates uncompressed key/pairs, which start with "1" and there's no need to keep the others around. I'm not 100% sure, but both chainstate parsers generated same results iirc. Time to investigate...
As it says in NOTICE of https://github.com/graymauser/btcposbal2csv/blob/master/btcposbal2csv.py, That the output may not be complete as there are some transactions which are not understood by the decoding lib, or that which do not have "address" at all. Such transactions are not processed. Number of them and the total ammount is displayed after the analysis., so, only addresses wit transactions will be saved. That's why addresses with balance and no transactions will not be saved... :(
You could always send a little bit of dust (547 satoshis OR 0.00000547 BTC) towards those addresses to get a transaction for it. Then it'll be counted in the database :) I'll be glad to do that for you if you can send a few more addresses to me.
