server outage / db crash again
log in

Advanced search

Message boards : News : server outage / db crash again

Previous · 1 · 2 · 3 · Next
Author Message
Hal Bregg
Send message
Joined: 7 Aug 19
Posts: 23
Credit: 6,059,933
RAC: 0
Message 6421 - Posted: 17 May 2020, 20:10:13 UTC - in response to Message 6395.

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


Just to clarify. Do we have to remind you about lost credits in another topic or are you going to add them regardless users reported it or not?

Good luck with finding solution to avoid any further crashes.

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 6422 - Posted: 17 May 2020, 20:35:22 UTC - in response to Message 6421.

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


Just to clarify. Do we have to remind you about lost credits in another topic or are you going to add them regardless users reported it or not?

Good luck with finding solution to avoid any further crashes.


yes, post it in the other thread, I will check both threads later next week, 1/2 of the checks are done and Iam tired, worked since 8am to fix things.

Profile mattozan
Avatar
Send message
Joined: 28 Dec 14
Posts: 7
Credit: 10,363,376
RAC: 0
Message 6423 - Posted: 17 May 2020, 20:39:25 UTC - in response to Message 6408.
Last modified: 17 May 2020, 20:40:15 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


Yes, that is where I see my missing credit from also: Free-DC.

Sierpinski Base -5,880 Sierpinski Base - short -3,080 Sierpinski / Riesel Base - average -65,490 Riesel Base - short -16,080 Sierpinski / Riesel Base -8,050


Thanks for all your work, Reb! You deserve a nice drink or a nice vacation! :)
____________

Hal Bregg
Send message
Joined: 7 Aug 19
Posts: 23
Credit: 6,059,933
RAC: 0
Message 6424 - Posted: 17 May 2020, 20:59:27 UTC - in response to Message 6422.

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


Just to clarify. Do we have to remind you about lost credits in another topic or are you going to add them regardless users reported it or not?

Good luck with finding solution to avoid any further crashes.


yes, post it in the other thread, I will check both threads later next week, 1/2 of the checks are done and Iam tired, worked since 8am to fix things.


No problem. Take your time.

Joe
Send message
Joined: 20 Dec 14
Posts: 9
Credit: 384,600,234
RAC: 530,557
Message 6425 - Posted: 17 May 2020, 21:28:38 UTC - in response to Message 6395.

Sorry for your troubles but I'm gone...again

Saw I lost a bunch of credit a couple months ago and then a bunch today...

I'm to old for projects that continuously suffer problems :)

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 6458 - Posted: 21 May 2020, 9:32:27 UTC - in response to Message 6397.

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


done

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 6459 - Posted: 21 May 2020, 9:33:52 UTC - in response to Message 6398.

Mine is TF plus 69,500.


done

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 6460 - Posted: 21 May 2020, 9:35:41 UTC - in response to Message 6399.

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


done

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 6461 - Posted: 21 May 2020, 9:38:44 UTC - in response to Message 6405.

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.


done

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 6462 - Posted: 21 May 2020, 9:40:44 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?


done

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 6463 - Posted: 21 May 2020, 9:42:57 UTC - in response to Message 6410.

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

Please and thanks :-)


done

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 6464 - Posted: 21 May 2020, 9:45:07 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


done

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 6465 - Posted: 21 May 2020, 9:49:00 UTC - in response to Message 6423.

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


Yes, that is where I see my missing credit from also: Free-DC.

Sierpinski Base -5,880 Sierpinski Base - short -3,080 Sierpinski / Riesel Base - average -65,490 Riesel Base - short -16,080 Sierpinski / Riesel Base -8,050


Thanks for all your work, Reb! You deserve a nice drink or a nice vacation! :)


done

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 6466 - Posted: 21 May 2020, 9:51:55 UTC - in response to Message 6425.

Sorry for your troubles but I'm gone...again

Saw I lost a bunch of credit a couple months ago and then a bunch today...

I'm to old for projects that continuously suffer problems :)

Good luck


sorry to hear that, thats life, total credits restored.

Profile PDW
Send message
Joined: 15 Oct 15
Posts: 41
Credit: 1,273,331,594
RAC: 810,532
Message 6467 - Posted: 21 May 2020, 9:53:12 UTC - in response to Message 6395.

Thanks reb :)

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 6468 - Posted: 21 May 2020, 9:53:34 UTC

All the requested lost credits are restored. We are now back on track.

Profile mattozan
Avatar
Send message
Joined: 28 Dec 14
Posts: 7
Credit: 10,363,376
RAC: 0
Message 6469 - Posted: 21 May 2020, 10:24:09 UTC - in response to Message 6465.
Last modified: 21 May 2020, 10:26:10 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


Yes, that is where I see my missing credit from also: Free-DC.

Sierpinski Base -5,880
Sierpinski Base - short -3,080
Sierpinski / Riesel Base - average -65,490
Riesel Base - short -16,080
Sierpinski / Riesel Base -8,050


Thanks for all your work, Reb! You deserve a nice drink or a nice vacation! :)


done


Thanks Reb!

It looks like the 5,880 credit for Sierpinski Base was mistakenly given to Riesel Base instead?

If you can change the 5,880 from Riesel Base to Sierpinksi Base where it belongs, that's great.

If not, it is no big deal. As soon as there is work available for both I'll be going for the silver badge :)
____________

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 6470 - Posted: 21 May 2020, 12:41:33 UTC - in response to Message 6469.

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


Yes, that is where I see my missing credit from also: Free-DC.

Sierpinski Base -5,880
Sierpinski Base - short -3,080
Sierpinski / Riesel Base - average -65,490
Riesel Base - short -16,080
Sierpinski / Riesel Base -8,050


Thanks for all your work, Reb! You deserve a nice drink or a nice vacation! :)


done


Thanks Reb!

It looks like the 5,880 credit for Sierpinski Base was mistakenly given to Riesel Base instead?

If you can change the 5,880 from Riesel Base to Sierpinksi Base where it belongs, that's great.

If not, it is no big deal. As soon as there is work available for both I'll be going for the silver badge :)


ok, corrected.

Profile mattozan
Avatar
Send message
Joined: 28 Dec 14
Posts: 7
Credit: 10,363,376
RAC: 0
Message 6472 - Posted: 21 May 2020, 14:01:28 UTC - in response to Message 6470.


Thanks Reb!

It looks like the 5,880 credit for Sierpinski Base was mistakenly given to Riesel Base instead?

If you can change the 5,880 from Riesel Base to Sierpinksi Base where it belongs, that's great.

If not, it is no big deal. As soon as there is work available for both I'll be going for the silver badge :)


ok, corrected.


Thanks! :)

Stef42
Send message
Joined: 22 Dec 14
Posts: 15
Credit: 74,777,547
RAC: 14
Message 6572 - Posted: 9 Jun 2020, 6:07:04 UTC

Hi Reb! I hope you are on the lookout that new mandatory updates will be coming this week?

Previous · 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