Topic: Sparrow wallet suddenly not connecting to node (Read 391 times)

I tried to reproduce this by purposely corrupting the wallet.dat inside "bitcoin/wallets/sparrow" folder and it indeed failed to connect.
Got this line in sparrow's log file:
So, it appears that sparrow is reliant to a mirrored watching-only wallet.dat file in Bitcoin Core.

But that doesn't mean that your block index/chainstate wasn't corrupted by the abrupt shutdown as well (it's fixed by reindex).
Anyway, since the core issue is the frequent power loss, then a UPS with big backup battery is indeed the best solution.

Ran the reindex but sparrow still wouldn't connect. Also tried rescan also with no luck. I was able to get sparrow to connect again by deleting the sparrow wallet folder in Bitcoin core.

C:\Users\username\AppData\Roaming\Bitcoin/wallet/sparrow

After deleting that and restarting Bitcoin core sparrow is connected again. I've also ordered an ups battery backup to run the node and router/modem off of so hopefully this problem is resolved now.

Especially with a spinning drive, in my experience, a harsh shutdown / power cut, doesn't leave the system enough time to write everything to disk and corrupts your blockchain data.
Bitcoin Core can't recover from that by itself and will give you an error log on the next startup. You will need to reindex the whole blockchain to fix this.

Without Bitcoin Core starting properly, obviously there's no way for Sparrow to connect to it.

If the issue only a corrupted file brought by the abrupt shutdown and only in Bitcoin Core, then --reindex might solve the issue.
It's a command-line option and not a command so; to use it, Bitcoin Core should be started with that parameter (instructions).

So I had a very brief power outage today and now sparrow won't connect to the node again. So strange. My only guess is that because bitcoin core didn't shutdown properly it's causing some issue. Am I just going to have to reinstall bitcoin core everytime my pc shuts down abruptly?

Sure! I'd probably point you to this guide: https://bitcointalksearch.org/topic/bitcoin-electrum-server-block-explorer-under-windows-with-wsl-and-debian-5367296
It actually makes you run it inside WSL, which is a Linux subsystem running on your Windows PC. I think that's a very good way to do it, because doing such things straight in Windows is usually a huge pain.

Eventually I'd like to setup a private electrum server. Is that viable to run on a windows PC? And do you have any recommended guides to setup an electrum server? I also have no experience with tor so any recommendations for that? I'm assuming that's a straight forward verify and install?

An update:

I uninstalled sparrow and Bitcoin core and deleted all associated files. I then reinstalled them and sparrow is now connecting to the node perfectly. I guess we'll see if this issue comes up again in a few weeks. Maybe something got corrupted in Bitcoin core? Idk but thank you everyone for the suggestions!

I just updated sparrow and still won't connect. I think I'm going to try completely uninstalling Bitcoin core and sparrow and then reinstalling them and see if that works.

OP you can try updating Sparrow wallet that just released new version 1.7.0 few hours ago, with lot of bug fixes and new features.
I am not sure if this will fix all your issues, but you could also contact developers or write your issue on their github page.
This is a cool wallet and best alternative for Electrum I found so far:
https://github.com/sparrowwallet/sparrow/releases

Here is all that is in my bitcoin core config file

server=1

rpcuser=bitcoin
rpcpassword=yourpassword

[main]
rpcbind=127.0.0.1
rpcbind=node ip
rpcallowip=127.0.0.1
rpcallowip=sparrow ip

I've triple checked these are correct and they worked before. It's so strange that even sparrow on the same pc as the node won't connect. I might try just reinstalling bitcoin core and see if that fixes it.

This would make sense that AV is causing an issue. I just have windows defender. How would I check that is causing an issue? And any way to resolve apart from waiting for a new windows update to fix?

The node should be all synced. It's been running for a few weeks now. How do I confirm it verifies chain tips and the initial block download has finished?

Here is the last two logs from sparrow.

2022-10-26 19:52:04,426 ERROR [JavaFX Application Thread] c.s.s.p.ServerPreferencesController [null:-1] Connection error
com.sparrowwallet.sparrow.net.ServerException: Check if Bitcoin Core is running, and the authentication details are correct.
   at [email protected]/com.sparrowwallet.sparrow.net.ElectrumServer$ConnectionService$1.call(Unknown Source)
   at [email protected]/com.sparrowwallet.sparrow.net.ElectrumServer$ConnectionService$1.call(Unknown Source)
   at javafx.graphics@18/javafx.concurrent.Task$TaskCallable.call(Unknown Source)
   at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
   at javafx.graphics@18/javafx.concurrent.Service.lambda$executeTask$6(Unknown Source)
   at java.base/java.security.AccessController.doPrivileged(Unknown Source)
   at javafx.graphics@18/javafx.concurrent.Service.lambda$executeTask$7(Unknown Source)
   at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.base/java.lang.Thread.run(Unknown Source)
2022-10-26 19:52:35,664 ERROR [JavaFX Application Thread] c.s.s.n.ElectrumServer [null:-1] Failed to start BWT
dev.bwt.libbwt.BwtException: JSON-RPC error: JSON decode error: missing field `keypoololdest` at line 1 column 334
   at [email protected]/dev.bwt.libbwt.daemon.NativeBwtDaemon.start(Native Method)
   at [email protected]/com.sparrowwallet.sparrow.net.Bwt.start(Unknown Source)
   at [email protected]/com.sparrowwallet.sparrow.net.Bwt.start(Unknown Source)
   at [email protected]/com.sparrowwallet.sparrow.net.Bwt$ConnectionService$1.call(Unknown Source)
   at [email protected]/com.sparrowwallet.sparrow.net.Bwt$ConnectionService$1.call(Unknown Source)
   at javafx.graphics@18/javafx.concurrent.Task$TaskCallable.call(Unknown Source)
   at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
   at javafx.graphics@18/javafx.concurrent.Service.lambda$executeTask$6(Unknown Source)
   at java.base/java.security.AccessController.doPrivileged(Unknown Source)
   at javafx.graphics@18/javafx.concurrent.Service.lambda$executeTask$7(Unknown Source)
   at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.base/java.lang.Thread.run(Unknown Source)

Which IP do you use to connect Sparrow to Bitcoin Core? Your external / WAN IP or your local IP (192.xx... or similar)?
Again; opening ports in your router improves your node, since it can now accept incoming connections - by other Bitcoin Core nodes, speaking Bitcoin protocol. Not by light clients trying to do RPC.

Sparrow can use the RPC interface running on 8332 to connect to a Bitcoin node but you don't (or at least definitely shouldn't) expose that to the public internet, as it would give everyone full access to your node (e.g. spending funds).

Therefore, Sparrow connection to a Bitcoin node (without Electrum) works when both are on the same machine and also if they're on a LAN & the 8332 port is opened in the node's own firewall. Then you can access it through its local IP.
Here are the official instructions by the Sparrow team: https://www.sparrowwallet.com/docs/connect-node.html
Notice how they always mention local IPs; since connecting to Bitcoin Core's RPC interface remotely is basically completely out of the picture, anyway, they don't even mention that.

More on this here: https://bitcoin.stackexchange.com/a/88948/119879

That's very weird. Is Bitcoin Core still running, fully synced and has the settings in its config file that are mentioned in the official guide?

The node is definitely receiving incoming connections. It has 21 inbound right now and bitnodes shows it as accepting incoming. The WAN ip is automatic and has changed since I setup the node. But it looks like the internal ip's for the two PC's are static. Should I change that WAN ip to static?

---

Yes same LAN network. I configured the DHCP on the node PC. The local ip's are correct according to my router. The WAN ip is changing though.

The firewall has allowances for both Bitcoin core and sparrow. Do I need do more indepth config than just the "add program" option? I also just tried installing sparrow on the node PC and it won't connect to node either.

Let's clear out something: Your full node has synced. Right in top. Initial block download has finished, and it now verifies chain tips. Correct?

In Windows 11, the Sparrow application directory should be in %APPDATA%/Sparrow. Can you see a sparrow.log there? Please remove any potentially sensitive information (such as WAN IP addresses) and post it here so we can see the problem.

Also make sure any anti-virus software didn't wake up and decide that the incoming connection is an attack.
This has nothing to do with the firewall. Even after you opened the port and said 'let connections in' some AV software will STILL think that it knows better then you.
I have had this happen at times when a definition update changes something. And then, a while later after the next update, it starts working again with no issues.

-Dave

How about the guide above it about setting a static IP: bitcoin.org/en/full-node#configuring-dhcp?

By saying "still receiving incoming connections", do you mean you're still getting "Inbound" Peers or not?
Because if not, my best guess is your set 'rpcbind' IP address didn't match after getting a new IP address.

Since you mention port forwarding, I assume you set up your node in a home network behind NAT. Such networks sometimes get their IP address reassigned by the ISP.
Can you check whether your external IP address has changed?

Otherwise, I generally recommend against port forwarding and for Tor tunneling instead. Sparrow has built-in Tor support, so you just need to install tor on the node machine and tunnel the Bitcoin port through it.

Something like this (change port number and hidden service name):

If you followed this guide, you just port forwarded port 8333 though, which shouldn't give you remote access from Sparrow. That should require access to the 8332 RPC port, which you should never port forward to the internet. That's why I'm wondering that your setup ever worked in the first place.

I'd recommend to install electrs and tunnel it through Tor as described above, for better security.

I setup a full node a few weeks ago and successfully connected sparrow wallet from a different PC but on same network. It connected fine until yesterday and now sparrow won't connect. When I setup the node I followed the tutorial on bitcoin.org and did the port forwarding. The node I still receiving incoming connections fine. I followed the sparrow tutorial and all info is still correct.

The node is running on a PC with windows 10 and sparrow is on a pc with windows 11. I haven't changed anything but sparrow just won't connect now. Any suggestions?