mersenneforum.org Primenet Server - Official Maintenance Thread
 Register FAQ Search Today's Posts Mark Forums Read

 2017-05-12, 23:48 #23 Madpoo Serpentine Vermin Jar     Jul 2014 63238 Posts Server reboot - happening now I'm about to reboot the Primenet server to make sure updates are installed. The ransomware outbreak going on today had me spooked and even though the server is firewalled these things make me nervous when the server hasn't been updated in a couple months. As usual I'll say it'll only take 10 minutes but it will really take 20. So I'm saying it'll take 20 minutes (which means it might take 30?) EDIT: And, back online after just 15 minutes or so. All done. Last fiddled with by Madpoo on 2017-05-13 at 00:12
 2017-07-22, 06:09 #24 Madpoo Serpentine Vermin Jar     Jul 2014 72·67 Posts Primenet reboot coming up I need to do some offline maintenance of Primenet... I did a little SQL shuffling of files and now I need to shut it down and make some changes on the virtualization layer. I'm hoping it'll just be a quick process, maybe 10 minutes downtime max, but I can't really say how long one of the jobs will take. Sorry for the interruption, but we'll have it back up and going before you know it. EDIT: It finished pretty quick... back up and running. Last fiddled with by Madpoo on 2017-07-22 at 06:44
 2017-09-09, 02:59 #25 Madpoo Serpentine Vermin Jar     Jul 2014 72·67 Posts Server maintenance - happening now The Primenet server is going offline right now for about 30-60 minutes. The plan is to make a clone of the system to create a testbed for work on PRP handling code (and we can also, in the future, use it for other system upgrades where we don't want to break the live system accidentally). I'm not sure how long it'll take to make copies of the virtual drives so I can't be more specific... hopefully faster than an hour.
2017-09-09, 04:10   #26
Serpentine Vermin Jar

Jul 2014

1100110100112 Posts

Quote:
 Originally Posted by Madpoo The Primenet server is going offline right now for about 30-60 minutes. The plan is to make a clone of the system to create a testbed for work on PRP handling code (and we can also, in the future, use it for other system upgrades where we don't want to break the live system accidentally). I'm not sure how long it'll take to make copies of the virtual drives so I can't be more specific... hopefully faster than an hour.
Back online... enjoy.

 2017-10-14, 18:24 #27 Madpoo Serpentine Vermin Jar     Jul 2014 1100110100112 Posts Maintenance starting soon I'll be performing some server maintenance soon... a few minor updates but the big one will be updating SQL which will take longer. I'm planning a downtime of 30-60 minutes but hopefully it'll be much less. Weekends are the time for doing such things. Starting at approx 18:30 UTC (~ 5 minutes from now)
2017-10-14, 19:52   #28
Serpentine Vermin Jar

Jul 2014

72·67 Posts

Quote:
 Originally Posted by Madpoo I'll be performing some server maintenance soon... a few minor updates but the big one will be updating SQL which will take longer. I'm planning a downtime of 30-60 minutes but hopefully it'll be much less. Weekends are the time for doing such things. Starting at approx 18:30 UTC (~ 5 minutes from now)
All done. I took a bit over an hour, but with a couple periods of uptime in between. Good to go.

 2017-10-15, 05:34 #29 Madpoo Serpentine Vermin Jar     Jul 2014 72·67 Posts Quick offline maintenance The SQL upgrade revealed some horribly fragmented indexes... took the server offline real quick to rebuild a few that were slowing things down. Should only be a few minutes (knock on wood).
2017-10-15, 08:11   #30
ric

Jul 2004
Milan, Ita

3·61 Posts

Quote:
 Originally Posted by Madpoo The SQL upgrade revealed some horribly fragmented indexes...
This would explain why I'm experiencing
Code:
Fatal error: Maximum execution time of 300 seconds exceeded in C:\inetpub\www\report_exponent\default.php on line 275
and/or
Code:
500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.
while searching for a single exponent. Hope it's transitory...

Last fiddled with by ric on 2017-10-15 at 08:12

2017-10-15, 09:22   #31
GP2

Sep 2003

32×7×41 Posts

Quote:
 Originally Posted by ric while searching for a single exponent. Hope it's transitory...
Yes, checking the exponent status on a single exponent can take a minute or more. Even if "Show full details" is turned off, it can take up to ten seconds.

Seems like some database indexes are not complete.

2017-10-15, 16:02   #32
Serpentine Vermin Jar

Jul 2014

72×67 Posts

Quote:
 Originally Posted by GP2 Yes, checking the exponent status on a single exponent can take a minute or more. Even if "Show full details" is turned off, it can take up to ten seconds. Seems like some database indexes are not complete.
Yeah, I'm running into some horrible query plans. The log file also filled up overnight which was... unexpected. Probably my fault because of all the stuff I'd done and wasn't paying attention to it. Woke up to "out of space"... bleagh.

Fixed, and now I can troubleshoot the poor queries. To be honest, it actually seemed a little better because I nuked the cached query plans while I was at it. Maybe it got its head out of its butt. LOL

 2017-10-16, 02:12 #33 GP2     Sep 2003 A1716 Posts The Active Assignments page is empty (no assignments listed). Exponent Status is still mostly much slower than before.

 Similar Threads Thread Thread Starter Forum Replies Last Post ewmayer PrimeNet 2072 2021-01-18 17:33 ewmayer Programming 31 2016-10-14 05:49 Madpoo PrimeNet 7 2015-11-12 05:50 Prime95 Lounge 32 2015-10-02 04:17 Madpoo PrimeNet 9 2015-07-25 07:47

All times are UTC. The time now is 17:44.

Mon Jan 18 17:44:26 UTC 2021 up 46 days, 13:55, 0 users, load averages: 1.54, 1.62, 1.62

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.