Search content
Sort by

Showing 8 of 8 results by Rexall
Post
Topic
Board Bitcoin Technical Support
Re: electrs panic, what to do ?
by
Rexall
on 10/07/2024, 09:22:29 UTC
I agree with @ABCbits your electrs (and core) are both out of date. We are talking about your money here why run software that is so far from current?

Also run smartctl  (or similar) on the disk that is holding the data to make sure that it's not drive related.

What hardware (and how old) are you running it on. Just because you can install and run it all on a 4th gen i3 does not mean you should.....

-Dave

Thanks Dave.
Its a Dell Optiplex MicroPC, i5 processor, 8GB RAM, new 2TB SSD.

Guessing it's not a hardware issue -- we have had power outages -- so I'm upgrading electrs and will upgrade bitcoind as soon as it's functional.
Thanks for the tips.
Rex
Post
Topic
Board Bitcoin Technical Support
Re: electrs panic, what to do ?
by
Rexall
on 08/07/2024, 09:22:37 UTC
Thanks ABCbits,
I do see that command now on github.
And if it only takes a couple of hours, might be the way to go.
 Smiley
Post
Topic
Board Bitcoin Technical Support
Merits 1 from 1 user
Topic OP
electrs panic, what to do ?
by
Rexall
on 08/07/2024, 05:37:34 UTC
⭐ Merited by ABCbits (1)
Hi All,

I am running bitcoin-25.1 and electrs 0.1.0 on an ubuntu-server linux box.
Something has gotten corrupted, perhaps due to a power outage.
I can look up blocks in mempool but not addresses.
When I try to look up an address mempool returns:

Error loading address data.
(Connection to server lost, please retry)

bitcoind seems to be ok:
{
  "chain": "main",
  "blocks": 851208,
  "headers": 851208,
  "bestblockhash": "00000000000000000002ccc5f0d8854b61026a419c8930e6b92106158fc028f7",
  "difficulty": 79495195323031.48,
  ...

Looking in /var/log/syslog I see:

Jul  8 00:00:18 nodebox electrs[109893]: thread 'main' panicked at 'called `Result::unwrap()` on an `Err` value: Error { message: "Corruption: block checksum mismatch: stored = 2965610381, computed = 3759059513, type = 1  in /home/satoshi/electrs/bitcoin/232529.sst offset 73693426 size 2770" }', src/db.rs:279:44

Then it seems that electrs restarts itself and the same thing happens again. Over and over.
What do I have to do to sort this?  Is there a way to re-index everything?

Thanks in advance for any tips.

Rex
Post
Topic
Board Beginners & Help
Re: Blockchain data download
by
Rexall
on 30/11/2023, 08:21:58 UTC
I would like to analyze zombie addresses with a balance, sometimes called dormant addresses.
I don't think this is the data you're looking for. It doesn't have any information on when addresses were funded. You'll need the full blockdata.
[/quote]
Correct.  I should have said something like address, input, output, net and final TX date.
I'm actually trying to find a way to get similar output to this defunct google code project:
https://docs.google.com/spreadsheets/d/1xTROekDerP1TPOB3SOD_1bbQr580BPqbhF3YHdO96pw/edit?pli=1#gid=189298223
But that method looks useless without 2TB of memory.
 Smiley
So I was thinking to manipulate previously dumped data.
Post
Topic
Board Beginners & Help
Re: Blockchain data download
by
Rexall
on 30/11/2023, 08:09:52 UTC
Bonus: LoyceV's small Linux commands for handling big data. If you have anything to add, please post there!
Aha... good stuff!  Thanks
 Smiley
Post
Topic
Board Beginners & Help
Re: Blockchain data download
by
Rexall
on 30/11/2023, 07:58:49 UTC
As an alternative to having to download stuff, I took a brief look to see if it was feasible to do using dune.com. There is a table there with bitcoin balance (balances_bitcoin.satoshi_day), and there are tables with inputs, outputs and TXs, so theoretically, using these tables, and filtering the joins with date intervals and minimum balance values, one should be able to derive the information on the platform.
Thanks for mentioning dune.  I have a login there but thought it was just ETH.  I will have another look. 

Post
Topic
Board Beginners & Help
Re: Blockchain data download
by
Rexall
on 27/11/2023, 11:00:46 UTC
Wow! Thanks to everyone for responding so quickly.
Yes, I do plan to run my own node, but it seems like parsing my own blockchain data may be not the best way to go.
I've got lots to work with now.
 Smiley
Post
Topic
Board Beginners & Help
Merits 7 from 4 users
Topic OP
Blockchain data download
by
Rexall
on 27/11/2023, 04:36:29 UTC
⭐ Merited by hugeblack (4) ,nc50lc (1) ,ETFbitcoin (1) ,Husna QA (1)
Hi All,

I'm looking for pre-parsed blockchain data downloads.  Ascii.  So I can use Awk, grep and sed. ;^)
I found http://addresses.loyce.club.
Is this the best/a really good site or are there other repositories to draw from?

I would like to analyze zombie addresses with a balance, sometimes called dormant addresses.
I did see some python code that might be helpful.

Any suggestions?
Thanks.