Topic: Core v0.12.1 database error (Read 1596 times)

I have the same error. My OS is ubuntu 14.04.1 Linux 4.2.0.37, HDD Western Digital Red 1TB. I have performed extensive surface testing through SMART, it has taken 3 hours /with linux distro Parted Magic "DISK HEALTH"/ - no problem was found. I do not use encryption. I think my hardware is O.K. I have performed reindex but in "16-th weeks" the reindex was extreme slow my debug log files was growing and growing and now it has more than 57 MB size.

2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing transaction
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing output
2016-06-01 17:13:57 ERROR: ApplyTxInUndo: undo data overwriting existing output

When I started bitcoin-qt again without reindex then reindex was not continue, I had to reindex again from first block. I plan  to unnistall bitcoin 12.1 and its dependencies. I know, that in last version the libraries was updated and optimalized for bitcoin - and bitcoin should run much more quicker - it was true - bitcoin-qt was quicker but after last sync I am not able to perform full reindex. More over I always do backup of entire blockchain to second partition on the same WD RED. I use ext4 filesystem. I always do backup and when "copy" is finished I always type in terminal command "sync". Then I ran litecoin 10.4 without any problem.
So I feel really frustrated by this "bitcoin-qt" problem.

So something is bad, but I think not with my hardware. Please let me give some advice. I wish to have full blockchain on my computer.



UPDATE:
So my system: 4GB RAM, WD 1TB, 2 partitions exclusively for blockchain. I do not use default bitcoin-qt directory .bitcoin. I have it on separate partition. The second "blockchain" partition is for backup purpose.
My OS is Xubuntu 14.04.1 64bit. I have tested RAM with memmtest /running 4 hours/ - no problem. I have tested WD 1TB with utility "DISK HEALTH", which I have found in Parted Magic distro /running 3 hours 33 minutes/, this test has examined disk surface - so called built in SMART test - no problem was found. My PSU is Seasonic so the voltage stability is great. My motherboard is is Gigabyte with ULTRA DURABLE 4. So my hardware is O.K.

Bitcoin-qt client 12.01. I have not problem with previous version. I have installed bitcoin-qt in linux with PPA.

I have reinstalled bitcoin-qt client 12.01 with all dependencies with apt-get. My last reindex after reinstallation was successfull. But problem was with RAM. Bitcoin-qt has consumed 3340 MB of RAM. My settings for "SIZE OF DATABASE CACHE" was 2000MB. My PC was slow such as old 486 with Win95. I have stopped bitcoin-qt in standard way. The next start ended with message: "Database is corrupted, do you wish rebuilt". I have pressed yes and now I am reindexing. But my new settings for "SIZE OF DATABASE" is now only 500MB. So now I am reindexing. I will write here the result. When someone has similar problem please let us to know about it, maybe together find some solution. But I can not imagine the situation, when the blockchain grows after years for example over 300 GB and then I  need to do reindex with HDD spinner and with my celeron cpu.


I always perform HDD optimalization. I run bitcoin-qt with "custom blockchain directory", which is on separate partition. The synchronization with network is done - I close bitcoin-qt. Then I reboot PC with Parted Magic. I format the second "blockchain partition" and copy all data from updated "blockchain partition" to second formated "blockchain partition". I copy data with standard file manager and then I type in terminal sync.

When this operation is done. I format the first updated "blockchain partition" and copy data back from second "blockchain partition" and type sync in terminal. The main reason is: I have fresh ex4 file system without fragments. This solutions worked perfectly up to 12.01 bitcoin-qt  /database is corrupted/. I have litecoin 10.4 which has its default directory on my "blockchain partition", too and it works perfectly without any problem.

blockchain partition = is the partition in which I have all files which should be in default .bitcoin directory located in /home directory. I have of course in this partition directories such as "BITCOIN BLOCKS", "LITECOIN BLOCKS" and so on.  



UPDATE: I have performed full reindex. My last sync with bitcoin network was 16 weeks ago. My settings for RAM ussage by database cache in bitcoin-qt is 1000MB. My total RAM 4096MB - 128MB for graphic memmory. I was 33 hours behind with bitcoin-qt client, and suddenly error occured and bitcoin-qt closed unexpectedly, due to small amount of free RAM the problem could not be analysed and sent to developers. So with bitcoin-qt 12.1 is something wrong.

Now, when I imagine, that buggy bitcoin-qt client reindexed my entire blockchain 4 times - wau maybe I will need to download entire blockchain once again. Next time I will wait with update or I will use litecoin instead.
Bitcoin costs now 520 USD its alltime high is cca 1100 USD. Litecoin now costs 4.12 USD its all-time high is about 43 USD. Maybe I should change my BTC to LTC with higher potential. So please repair bitcoin-qt.



 

I reloaded the whole Blockchain until it was synced, then I closed the wallet and unmounted the external HDD.
Now I mounted it again and started the wallet  it synced up to 3 hours and then got a fatal error.
It's not the same error. It doesn't say "database error" it just said "A major error occured".

I'm fed up with this shit...

Yes - I already deleted the old one completely and installed it new to another folder and now download the blockchain. Let's see if this works.

Thanks for you help.

Honestly, then, I'm not sure what is wrong. You should open a issue on the github: https://github.com/bitcoin/bitcoin/issues. Or if you don't want, I can do it for you. You will need to include the debug.log and mention that you are using an encrypted external hard drive.

Also, software changes over time so newer versions may not behave the same way as a version from 2 or 3 years ago.

Yes, you just need the wallet.dat. You can try to do that, and if it doesn't help, then open a issue.

The HDD is fine - I use it for several tasks - never had any Problems.

I reindexed 4 times in the past 6 Weeks and the problem came back 2-3 days later.

The HDD is encrypted - I reindex - after that the wallet syncs and works fine.
Then I close the wallet and unmount the external HDD.
I mount it again and open the wallet again - and I will get the database error again.

But that's exactely how I did it before - and before it worked fine for 2-3 years.

Maybe I try to delete the whole Wallet and reinstall it and just download the blockchain again.

Do I need to save anything else than the wallet.dat file ?

This is interesting. You will have to reindex again. However, since this has occurred multiple times, you might actual have hardware errors. I would suggest that you run some diagnostics on your hard drive and see if there are any problems.

Hey guys,

I use Core v0.12.1 as wallet on my external hdd with datadir to the folder on the external hdd. This has worked just fine so far... but some weeks ago it started to make trouble..

I used v0.11.0 and got "error while reading the database" - so I reindext - all worked fine. I closed the wallet and restarted it - same problem again.

So I updated to v0.12.1 and reindexed - all worked fine - I closed it and restarted and I have the exact same error again....