Database Crash and Recovery

Message boards : News : Database Crash and Recovery
Message board moderation

To post messages, you must log in.

Previous · 1 · 2

AuthorMessage
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 655
Credit: 456,868
RAC: 1
Message 3985 - Posted: 31 Jan 2020, 21:16:39 UTC
Last modified: 31 Jan 2020, 21:17:57 UTC

Messages of type "i am leaving this project" are not welcome. They add nothing to the discussion, and are discouraging. If you want to leave, the do so.
Yes, my time is better spent actually doing the science and making sure that this does not happen again rather than dealing with amount of credit that you can rack up in a day.
ID: 3985 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Dirk Broer

Send message
Joined: 21 Feb 19
Posts: 20
Credit: 769,049
RAC: 2,585
Message 3992 - Posted: 4 Feb 2020, 19:46:14 UTC - in response to Message 3983.  

I think that what I done, is the most I can do. The lost or aborted results and credits are lost.
Still, it was less than 22 hours worth of data. What if it was three days? I think my time will be better spent on getting those incremental xtradb backups to work, which would allow faster backup period (perhaps twice a day). And loading more tasks from the new search interval.
If somebody really wants their credits back, go ahead and make a program that turns the xml stat files (diffs!) into sql update statements.
The project will be operating normally from now. Hit the update button in your manager, abort ghost tasks if any.


I've got the xml files prior to the crash if you'd like to use them to restore credits ??
https://stats.free-dc.org/files/brada.zip


It would be wise to ask Bok for the content of what he can supply before stating 'all is lost'
ID: 3992 · Rating: 0 · rate: Rate + / Rate - Report as offensive
[AF>Le_Pommier] Jerome_C2005

Send message
Joined: 29 Jul 19
Posts: 5
Credit: 703,771
RAC: 9,604
Message 4002 - Posted: 5 Feb 2020, 23:13:24 UTC

Thanks for your hard work Tomas :)
ID: 4002 · Rating: 0 · rate: Rate + / Rate - Report as offensive
UBT - Timbo

Send message
Joined: 14 Jul 19
Posts: 3
Credit: 841,688
RAC: 1,639
Message 4026 - Posted: 3 Mar 2020, 4:55:38 UTC
Last modified: 3 Mar 2020, 4:56:08 UTC

Glad to see the project website back up and running. Well done to Tomas for all his efforts.

Hopefully a new backup policy can be implemented so that *IF* a future failure occurs then less data will be lost.

But computers are funny beasts and can fail at the worst times...but in the end it is the data that is most important rather than a few lost credits (which I understand does suck, but no point crying over spilt milk...just crunch a few more tasks and you'll make up the loss soon enough ;-) )..
ID: 4026 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 655
Credit: 456,868
RAC: 1
Message 4029 - Posted: 3 Mar 2020, 14:22:16 UTC
Last modified: 24 Apr 2020, 21:43:27 UTC

Somewhere around 20.02.2020 another database crash occurred. This time we did not loose any data (all was backed up). After a disk swap, most of the functionality has been restored. I am still slowly working on restoring the science result database and work generator.
Natalia Makarova: The spt results reported on the website are incomplete, until I say. (they are complete now)
ID: 4029 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Previous · 1 · 2

Message boards : News : Database Crash and Recovery

©2021 Tomáš Brada