server outage / db crash again
log in

Advanced search

Message boards : News : server outage / db crash again

1 · 2 · 3 · Next
Author Message
Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 7445
Credit: 42,730,867
RAC: 0
Message 6395 - Posted: 17 May 2020, 12:28:44 UTC

The windows update has automatically restarted the PC in the night (was disabled), the database crashed. My 2 big backups of the VM are also corrupt including the last backups of the database. Unfortunately mysqdumper cannot import the correct numbers of tables so I used phpmyadmin with success, the last backup was from 13th so we have lost 4 days (not the reported work). I had no hope to reactivate the project but I did.

Pls stop all your old WUs. I will give credit for all the lost work. If you have registered in the last 4 days and your account is not recognized pls reregister.

I must remove all the current work and recheck all bases which results are missing. Also the TF work need to be resetup (not all I think).

Hard times, shit happens especially Windows10

Profile PDW
Send message
Joined: 15 Oct 15
Posts: 41
Credit: 1,273,331,594
RAC: 810,532
Message 6397 - Posted: 17 May 2020, 13:07:29 UTC - in response to Message 6395.
Last modified: 17 May 2020, 13:15:18 UTC

Hi reb, Windows 10, say no more :(

I stopped when I saw my account was back in olden times !

Fortunately I was only doing TF and SR Average WUs.
From the last Free-DC stats, my highest Boinc client figure which was updating mostly every 30 seconds so would be quite close, plus the completed work on my machines waiting to report can you amend these 3 values please:

TF = 274,795,836
S/R Base Average = 3,035,424
Total = 338,843,676

Completed work not uploaded was 90k for TF and 13,580 for Average.

Thanks

Edit: As you have started new work I have noted that the uplift should be as follows please:

TF plus 24,906,500
S/R Base Average plus 50,080
Total plus 24,956,580

Gigacruncher [TSBTs Pirate]
Send message
Joined: 28 Mar 20
Posts: 48
Credit: 8,419,360
RAC: 0
Message 6398 - Posted: 17 May 2020, 13:39:28 UTC - in response to Message 6397.

Mine is TF plus 69,500.

Profile Vato
Avatar
Send message
Joined: 23 Mar 19
Posts: 8
Credit: 76,617,912
RAC: 217,864
Message 6399 - Posted: 17 May 2020, 14:41:35 UTC

from Free-DC stats, I need +278000 to bring me back to 873003
thanks

Profile Skivelitis2
Avatar
Send message
Joined: 23 May 15
Posts: 4
Credit: 595,320,979
RAC: 0
Message 6400 - Posted: 17 May 2020, 14:47:00 UTC

TF total should be 62472788

Project total should be 71345080

Profile Sir Stooper
Avatar
Send message
Joined: 31 May 15
Posts: 2
Credit: 188,000,958
RAC: 0
Message 6402 - Posted: 17 May 2020, 15:05:31 UTC

TF total to 26862500
Project total to 27136358

Please and thank you

Profile [AF>Amis des Lapins] Bipleouf
Send message
Joined: 20 Sep 16
Posts: 1
Credit: 8,875,173
RAC: 0
Message 6403 - Posted: 17 May 2020, 15:44:11 UTC - in response to Message 6395.

Courage! l'Alliance Francophone is with you ... All our support
____________

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 7445
Credit: 42,730,867
RAC: 0
Message 6404 - Posted: 17 May 2020, 16:00:00 UTC - in response to Message 6403.

Courage! l'Alliance Francophone is with you ... All our support


Thx for all your support, with win7 I had never any problems, a power cut or restart without closing the VM will ever crash the db.

If you know anyone who can write a script to import the latest stats into the db that would be fine, this will spend me a lot of time. BOINC can only export them. I will ask again the devs as in the past.

zlodeck
Send message
Joined: 3 Mar 15
Posts: 4
Credit: 134,094,341
RAC: 172,607
Message 6405 - Posted: 17 May 2020, 16:55:15 UTC

Hi reb, I see a nightmare was happened again!

Lost credits:
TF: 145000.
SR: 214540


I guess it's time to end the experiment with Win 10 as host system for project server VM. Win 10 as a server is poor solution at all. No good in future, we're waiting for permanent trouble, headache and many ribaldry words only.
Maybe it's worth consider migrating the host OS to Windows Server if You don't wanna roll back to Windows 7 (yeah, not all games can be run, but something is better than nothing). Or buying new (and not so powerful) machine for dedicated boinc server. Of course, both solutions will require additional money. But honestly, I don't see anything better.

bluestang
Send message
Joined: 6 Jun 19
Posts: 60
Credit: 2,244,690,070
RAC: 5,182,591
Message 6406 - Posted: 17 May 2020, 17:02:44 UTC

Last Free-DC stat 44,319,701
Currrenton account 44,225,701

What should we do with work waiting to be uploaded but can't?

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 7445
Credit: 42,730,867
RAC: 0
Message 6407 - Posted: 17 May 2020, 17:06:28 UTC - in response to Message 6406.

Last Free-DC stat 44,319,701
Currrenton account 44,225,701

What should we do with work waiting to be uploaded but can't?


I have enabled it again, maybe forgot, lets see. I will change the credits after I have all missing results checked.

Gigacruncher [TSBTs Pirate]
Send message
Joined: 28 Mar 20
Posts: 48
Credit: 8,419,360
RAC: 0
Message 6408 - Posted: 17 May 2020, 17:18:43 UTC

FreeDC-stats has now been updated where you can see all negative values. Maybe there’s a way to request Bok to make an export of all clients so you can cross reference with request over here. Here’s my previously requested 69,500: https://stats.free-dc.org/user/srb/2182

emoga
Send message
Joined: 5 Jan 15
Posts: 2
Credit: 309,639,558
RAC: 0
Message 6410 - Posted: 17 May 2020, 17:35:25 UTC
Last modified: 17 May 2020, 17:35:51 UTC

-1,258,000 TF according to Free-DC.

Please and thanks :-)

[AF>Amis des Lapins] Jean-Luc
Avatar
Send message
Joined: 12 Mar 18
Posts: 21
Credit: 1,426,814,846
RAC: 7,150,542
Message 6411 - Posted: 17 May 2020, 17:40:24 UTC

I hope you're keeping your spirits up in the wake of this disaster ! I support you 100%. I wish you good luck to ensure the continuity of this extraordinary project!

As far as I'm concerned, I would prefer that you don't add the missing credits to me. I prefer to receive credits only for calculations that have been used for something. So I don't want to receive credits for lost calculations.

Can we continue the calculations right away or do we have to wait a few hours or a few days ?

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 7445
Credit: 42,730,867
RAC: 0
Message 6412 - Posted: 17 May 2020, 17:45:43 UTC - in response to Message 6411.

I hope you're keeping your spirits up in the wake of this disaster ! I support you 100%. I wish you good luck to ensure the continuity of this extraordinary project!

As far as I'm concerned, I would prefer that you don't add the missing credits to me. I prefer to receive credits only for calculations that have been used for something. So I don't want to receive credits for lost calculations.

Can we continue the calculations right away or do we have to wait a few hours or a few days ?


Thanks for the good words and yes, scientific results are more useful than the credits, there was only a less lost in WUs which were in progress, the rest are in the results folder.

Iam checking the base results one by one and resetup, this could take some time.

bluestang
Send message
Joined: 6 Jun 19
Posts: 60
Credit: 2,244,690,070
RAC: 5,182,591
Message 6414 - Posted: 17 May 2020, 17:51:23 UTC - in response to Message 6412.

Make sure you have some cold beer for yourself at the ready!

LCB001
Send message
Joined: 29 Nov 14
Posts: 7
Credit: 414,065,676
RAC: 208,744
Message 6415 - Posted: 17 May 2020, 18:04:34 UTC
Last modified: 17 May 2020, 18:04:55 UTC

What version of Win10 are you using and what build, most of mine are Pro/1909 and don't reboot without asking.

Perhaps you missed a reset of one of the three deferral spots.

Creds lost; 6073760 almost all TF.

Thanks and Good Luck

Profile rebirther
Volunteer moderator
Project administrator
Project developer
Project tester
Project scientist
Avatar
Send message
Joined: 2 Jan 13
Posts: 7445
Credit: 42,730,867
RAC: 0
Message 6416 - Posted: 17 May 2020, 18:07:41 UTC - in response to Message 6415.

What version of Win10 are you using and what build, most of mine are Pro/1909 and don't reboot without asking.

Perhaps you missed a reset of one of the three deferral spots.

Creds lost; 6073760 almost all TF.

Thanks and Good Luck


The same version as you but the postponed update reached the time.

LCB001
Send message
Joined: 29 Nov 14
Posts: 7
Credit: 414,065,676
RAC: 208,744
Message 6419 - Posted: 17 May 2020, 18:34:34 UTC - in response to Message 6416.

Strange, mine give me the 'I need to reboot' message and then wait.

Stuff like this is why I've kept win7 on my daily driver.

fzs600
Send message
Joined: 28 Nov 14
Posts: 17
Credit: 1,144,473,134
RAC: 823,251
Message 6420 - Posted: 17 May 2020, 18:47:28 UTC - in response to Message 6411.

I hope you're keeping your spirits up in the wake of this disaster ! I support you 100%. I wish you good luck to ensure the continuity of this extraordinary project!

As far as I'm concerned, I would prefer that you don't add the missing credits to me. I prefer to receive credits only for calculations that have been used for something. So I don't want to receive credits for lost calculations.

Can we continue the calculations right away or do we have to wait a few hours or a few days ?

I agree

1 · 2 · 3 · Next
Post to thread

Message boards : News : server outage / db crash again


Main page · Your account · Message boards


Copyright © 2014-2024 BOINC Confederation / rebirther