Bitcoin Forum
August 25, 2019, 07:37:21 PM *
News: Latest Bitcoin Core release: 0.18.0 [Torrent] (New!)
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Database Corrupt and recovering question  (Read 168 times)
gabrio81
Jr. Member
*
Offline Offline

Activity: 36
Merit: 5


View Profile
March 31, 2019, 09:01:02 AM
Merited by ETFbitcoin (1)
 #1

hi there,

I am running bitcoin-0.17.1-win64-setup, the other day I sent a transaction, went in the pool and stayed there for a while (I was a bit stingy with the fee have to say), anyway, after that, while waiting Bitcoin core to catch up, had a database corruption on the external hdd since i had to unplug it or something (shut down Core of course, but it was not finished with the syncing) where I keep bitcoin files and the blockchain's stuff... btw i got that transaction where it had to be so it's in the chain OK.

Long story short, after a few re-starts to see if it would catch up, it would say database corrupt, so I hit OK and is reprocessing all blocks starting with a 0 balance wallet - not re downloading the entire blockchain - have seen the log, and it's about 1.5 days, I reckon today it will complete....wallet balance is weird right now.

Main thing is how to handle the wallet, is it going to catch up when it picks up last transaction before I got the corruption in the database and all be back OK?

OR shall I restore the last wallet (pre latest transaction) when it finishes catching up?

many thanks,
Gabrio
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1566761841
Hero Member
*
Offline Offline

Posts: 1566761841

View Profile Personal Message (Offline)

Ignore
1566761841
Reply with quote  #2

1566761841
Report to moderator
nc50lc
Hero Member
*****
Offline Offline

Activity: 686
Merit: 505


Self-proclaimed Genius ㊙️


View Profile WWW
March 31, 2019, 09:28:00 AM
Merited by Jet Cash (2), vapourminer (1)
 #2

You just need to wait for Core to re-sync, that's all.
1.5 days, so that's about 210+ blocks and if the previous transaction was new, that might be the cause of the "weird balance".

If you want some assurance about you wallet's balance, check the address' balance on an online blockexplorer like: liveblockcypher.com or blockchain.com/explorer.

 Newbies and Newbies at heart! Remember to Lock your Thread(s) after receiving enough replies/sufficient answers||                                    
39EKeFj43inkH6Ctkosh9E7oskx3tvhSXi ∙ Do not buy non-mainstream ASICs at second-batch onward, you know the risk!||Like Art?: MetalPosters Set1 / Set2
NeuroticFish
Legendary
*
Offline Offline

Activity: 1946
Merit: 1282


There are no mistakes. Only opportunities wasted.


View Profile
March 31, 2019, 09:33:03 AM
 #3

OR shall I restore the last wallet (pre latest transaction) when it finishes catching up?

Just wait it finish catching up. There's a very high chance that will be enough.
However, if it'll still be odd, before doing anything else (eg. restore), make sure you backup even that current wallet.

gabrio81
Jr. Member
*
Offline Offline

Activity: 36
Merit: 5


View Profile
March 31, 2019, 01:11:52 PM
 #4

thanks guys, it's still processing blocks.... argh..takes forever, 95% now.... and still strange numbers on the wallet, let's hope for this evening, I just came back!

Gabrio
gabrio81
Jr. Member
*
Offline Offline

Activity: 36
Merit: 5


View Profile
March 31, 2019, 01:16:31 PM
 #5

You just need to wait for Core to re-sync, that's all.
1.5 days, so that's about 210+ blocks and if the previous transaction was new, that might be the cause of the "weird balance".

If you want some assurance about you wallet's balance, check the address' balance on an online blockexplorer like: liveblockcypher.com or blockchain.com/explorer.

btw how do I check my wallet's balance on the blockchain.com ? shall I use the last address I sent payment to?

thanks
ETFbitcoin
Legendary
*
Offline Offline

Activity: 1736
Merit: 1990

Use SegWit and enjoy lower fees.


View Profile WWW
March 31, 2019, 04:08:00 PM
 #6

You just need to wait for Core to re-sync, that's all.
1.5 days, so that's about 210+ blocks and if the previous transaction was new, that might be the cause of the "weird balance".

If you want some assurance about you wallet's balance, check the address' balance on an online blockexplorer like: liveblockcypher.com or blockchain.com/explorer.

btw how do I check my wallet's balance on the blockchain.com ? shall I use the last address I sent payment to?

thanks

1. Open list of bitcoin address generated by your wallet (You can find it by select File > Receiving addresses)
2. Copy each bitcoin address listed and paste into blockchain.com (or other block explorer) search bar

gabrio81
Jr. Member
*
Offline Offline

Activity: 36
Merit: 5


View Profile
March 31, 2019, 05:07:01 PM
 #7

You just need to wait for Core to re-sync, that's all.
1.5 days, so that's about 210+ blocks and if the previous transaction was new, that might be the cause of the "weird balance".

If you want some assurance about you wallet's balance, check the address' balance on an online blockexplorer like: liveblockcypher.com or blockchain.com/explorer.

btw how do I check my wallet's balance on the blockchain.com ? shall I use the last address I sent payment to?

thanks

1. Open list of bitcoin address generated by your wallet (You can find it by select File > Receiving addresses)
2. Copy each bitcoin address listed and paste into blockchain.com (or other block explorer) search bar

thanks, sent you a PM.
gabrio81
Jr. Member
*
Offline Offline

Activity: 36
Merit: 5


View Profile
March 31, 2019, 10:23:51 PM
 #8

Everything back to normal - correct balance updated at the end of the sync!

It's the 3rd time I get the database corrupt though, is there anything that can be done as a maintenance to prevent this? Or is it due to the fact that I keep it on external hdd and sometimes that happens? With that plug/unplug devices, etc

thanks,
Gabrio
NeuroticFish
Legendary
*
Offline Offline

Activity: 1946
Merit: 1282


There are no mistakes. Only opportunities wasted.


View Profile
April 01, 2019, 08:44:20 AM
Merited by bones261 (2), HCP (2)
 #9

Everything back to normal - correct balance updated at the end of the sync!

Great news!

It's the 3rd time I get the database corrupt though, is there anything that can be done as a maintenance to prevent this? Or is it due to the fact that I keep it on external hdd and sometimes that happens? With that plug/unplug devices, etc

I'm 99% sure that the issue is caused by the external HDD.

Two things to start with would be:
1. After closing Bitcoin wallet, check with task manager it was indeed closed (check, but not kill).
2. Use the "safely eject" functionality and wait for "it's now safe to" before unplugging.

Maybe some will hate me for this advice, but if you don't need Bitcoin core wallet, maybe you could use a SPV wallet (Electrum), or at lest use Bitcoin wallet in pruned mode (much smaller blockchain), on the internal HDD.
I think that you can also set in your system for external HDD (or USBs) to make it safer for unplugging, but I expect that'll make the data transfer much slower (and not sure how it can be done).

gabrio81
Jr. Member
*
Offline Offline

Activity: 36
Merit: 5


View Profile
April 01, 2019, 05:55:57 PM
 #10

Everything back to normal - correct balance updated at the end of the sync!

Great news!

It's the 3rd time I get the database corrupt though, is there anything that can be done as a maintenance to prevent this? Or is it due to the fact that I keep it on external hdd and sometimes that happens? With that plug/unplug devices, etc

I'm 99% sure that the issue is caused by the external HDD.

Two things to start with would be:
1. After closing Bitcoin wallet, check with task manager it was indeed closed (check, but not kill).
2. Use the "safely eject" functionality and wait for "it's now safe to" before unplugging.

Maybe some will hate me for this advice, but if you don't need Bitcoin core wallet, maybe you could use a SPV wallet (Electrum), or at lest use Bitcoin wallet in pruned mode (much smaller blockchain), on the internal HDD.
I think that you can also set in your system for external HDD (or USBs) to make it safer for unplugging, but I expect that'll make the data transfer much slower (and not sure how it can be done).

thanks for the tips!
Jet Cash
Legendary
*
Online Online

Activity: 1344
Merit: 1718


Rubbish at predicting Bitcoin price movements.


View Profile WWW
April 05, 2019, 02:19:51 PM
 #11

It's the 3rd time I get the database corrupt though, is there anything that can be done as a maintenance to prevent this? Or is it due to the fact that I keep it on external hdd and sometimes that happens? With that plug/unplug devices, etc


Eject the drive before you shut down the computer. If I remember correctly, you right click on the drive letter in file manager, and then select eject.

If Bitcoin didn't exist, bankers would have to invent it.
HCP
Legendary
*
Offline Offline

Activity: 1064
Merit: 1771

<insert witty quote here>


View Profile
April 05, 2019, 11:26:59 PM
 #12

Ejecting the drive may not be necessary... as long as you ensure you shutdown Bitcoin Core properly before disconnecting the drive or shutting down the computer.

In general, keeping the database on a removable drive isn't recommended as the chances for corruption are a lot higher than on a "fixed" drive. Even a slight accidental knock of the cable could be enough to unseat the plug from the socket enough that it disconnects/reconnects and could lead to corruption.

You could also try turning off "write caching" for that specific device... Right click the drive in explorer, select properties... click the "Hardware" tab, select the device from the list, then click the "Properties" button. Click "Change Settings" button... you'll get yet another properties window that has a "Policies" tab... select the "Policies" tab... and you should see the following "Removal Policies"...

Make sure it is set to "Quick Removal":



Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!