server outage / db crash again - 2nd
log in

Advanced search

Message boards : News : server outage / db crash again - 2nd

Author Message
Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 5423
Credit: 23,900,068
RAC: 12,139
Message 7032 - Posted: 29 Nov 2020, 0:02:03 UTC
Last modified: 29 Nov 2020, 1:19:57 UTC

Due a win10 issue identified now, the VSS service which has restarted the PC automatically and in hope that is fixed with a MS solution found in the web the database crashed before I could do a backup. As always a good timing and sadly lost around 13h of work (results which were already done are not affected).

You will get a lot of download errors but can be ignored while they were already processed.

As always let me know how many credits you have lost and post it in the other thread.

All latest win10 updates were also installed.

Iam very sad about the current situation, it was not the first time related all biggest theads to the new OS.

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 5423
Credit: 23,900,068
RAC: 12,139
Message 7033 - Posted: 29 Nov 2020, 0:29:50 UTC

The latest restored backup was from Sat 28 Nov 2020 08:53:32 AM CET.

I will try to have 3 backups per day depends on Iam at homework.

Profile Michael Goetz
Avatar
Send message
Joined: 1 Jan 15
Posts: 25
Credit: 1,197,466
RAC: 362
Message 7034 - Posted: 29 Nov 2020, 1:03:10 UTC

The MLC@Home BOINC server is literally running on a Raspberry Pi.

Have you considered setting up a database replication server to protect against problems like this? If he can run a whole server on a Raspberry Pi, you might be able to run a database replica. It might be worth looking into as a low cost reliability upgrade.
____________
Want to find one of the largest known primes? Try PrimeGrid. Or help cure disease at WCG.

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 5423
Credit: 23,900,068
RAC: 12,139
Message 7035 - Posted: 29 Nov 2020, 1:11:45 UTC - in response to Message 7034.

The MLC@Home BOINC server is literally running on a Raspberry Pi.

Have you considered setting up a database replication server to protect against problems like this? If he can run a whole server on a Raspberry Pi, you might be able to run a database replica. It might be worth looking into as a low cost reliability upgrade.


no, if the windows is running stable then there is a minimal chance for a crash.
Only more backups will help.

Hal Bregg
Send message
Joined: 7 Aug 19
Posts: 23
Credit: 4,832,984
RAC: 2,878
Message 7047 - Posted: 29 Nov 2020, 12:25:16 UTC - in response to Message 7032.

Please, fix the credit.

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 5423
Credit: 23,900,068
RAC: 12,139
Message 7048 - Posted: 29 Nov 2020, 13:00:17 UTC - in response to Message 7047.

Please, fix the credit.


Let me know what you are missing.

Hal Bregg
Send message
Joined: 7 Aug 19
Posts: 23
Credit: 4,832,984
RAC: 2,878
Message 7057 - Posted: 29 Nov 2020, 13:41:44 UTC - in response to Message 7048.
Last modified: 29 Nov 2020, 13:43:56 UTC

I have 59 WUs in progress (Riesel Base - short). They were all finished and uploaded before db crash. Host id 200830.

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 5423
Credit: 23,900,068
RAC: 12,139
Message 7059 - Posted: 29 Nov 2020, 13:47:59 UTC - in response to Message 7057.

I have 59 WUs in progress (Riesel Base - short). They were all finished and uploaded before db crash. Host id 200830.


done, added 239cr to total + subproject

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 5423
Credit: 23,900,068
RAC: 12,139
Message 7060 - Posted: 29 Nov 2020, 13:58:02 UTC

To reduce the error rate max_error_results and max_total_results were set to 5 from 10 for all WUs.

Hal Bregg
Send message
Joined: 7 Aug 19
Posts: 23
Credit: 4,832,984
RAC: 2,878
Message 7062 - Posted: 29 Nov 2020, 14:42:54 UTC - in response to Message 7059.

I have 59 WUs in progress (Riesel Base - short). They were all finished and uploaded before db crash. Host id 200830.


done, added 239cr to total + subproject



Thanks. Good luck with contingency backup.


Post to thread

Message boards : News : server outage / db crash again - 2nd


Main page · Your account · Message boards


Copyright © 2014-2021 BOINC Confederation / rebirther