Primenet Server - Official Maintenance Thread - Page 4

kruoli · 2017-10-16, 09:50

Quote:

Originally Posted by GP2

The Active Assignments page is empty (no assignments listed).

On my end, that's because the maximum exponent is now set to 2 by default. If I change it to 10000 for example, it displays fine (https://www.mersenne.org/assignments...2&exp_hi=10000).

Madpoo · 2017-10-17, 01:58

Quote:

Originally Posted by kruoli

On my end, that's because the maximum exponent is now set to 2 by default. If I change it to 10000 for example, it displays fine (https://www.mersenne.org/assignments...2&exp_hi=10000).

I'm pretty sure it's been set at 2 and 2 for low/high for a long time.

Sorry for the way the exponent report page has been performing the past few days.

I was just working on it (and accidentally left in a debug code that showed me the raw SQL statement...whoops).

I think I've narrowed down the problem to a few possibilities and have hopefully worked around it. The upgrade to SQL apparently took things down a dark path... where some queries used to work okay, they were actually kind of funky and I think SQL just had a hard time working out the past execution plan for them.

Rewriting some of the bits on that report seems to have improved things. Hard to say for sure yet because sometimes it'd run nice and fast, sometimes it was taking 60+ seconds for a single exponent, which really bugged me. Nothing worse than trying to troubleshoot an inconsistent problem.

I have one more technique I can try if needed, and in my testing it cut down the query time even more, so I may do it anyway (using CTEs to limit the exponent set beforehand), but I wanted to see how the stuff I did already is performing.

I still want to do a *total* rewrite of that report because it's just kind of top-heavy anyway in the way it collects all the data. That's why the XML version of that page runs so dang fast, because it's using my own re-written query (which I need to update to include PRP stuff, now that I think about it).

Madpoo · 2017-10-17, 04:12

Credit goes to George for updating that query to basically tell SQL to "just do it in the order it's written" since apparently it was trying to overthink it and shooting itself in the foot.

I came up with an alternate strategy that seemed to accomplish the same thing, but it was relying on SQL to "do the right thing" which you really can't rely on apparently.

Madpoo · 2017-11-25, 22:44

I've taken the Primenet server offline for a quick round of maintenance. I decided it was time to slightly grow one of the virtual disks for the SQL log files. It's not uncommon these days for the log to grow kind of large between full backups and I just wanted to give ourselves more buffer to make sure it's not an issue.

Then just routine updates while I'm at it... back up shortly.

EDIT: Back online

henryzz · 2017-11-29, 11:36

Quote:

Originally Posted by Madpoo

I've taken the Primenet server offline for a quick round of maintenance. I decided it was time to slightly grow one of the virtual disks for the SQL log files. It's not uncommon these days for the log to grow kind of large between full backups and I just wanted to give ourselves more buffer to make sure it's not an issue.

Then just routine updates while I'm at it... back up shortly.

EDIT: Back online

You don't have autogrowing virtual disks?

Madpoo · 2018-02-08, 19:51

The Primenet server is about to get a reboot following some OS/db patches. Should be a short maintenance period.

EDIT: done

Madpoo · 2018-04-01, 18:31

Not an April fools joke...

I'll be doing a handful of updates to the server with a couple reboots.

EDIT: done

Madpoo · 2018-06-14, 03:04

Taking the server offline for a brief maintenance period... will only be about 20-25 minutes.

-- 3:32 AM UTC - all done

Madpoo · 2018-08-05, 05:51

Routine maintenance is happening now... sorry I didn't announce it ahead of time. Just some SQL and other Windows updates.

Should be another 20 minutes or so from now.

EDIT: All done

Madpoo · 2018-10-20, 17:00

The server will be down temporarily for routine maintenance - as usual this may take 20-30 minutes.

UPDATE: all done - looking good.

Madpoo · 2018-12-08, 07:59

I'm about to kick off some regular maintenance. I'd normally let it ride but I forgot to install some SQL updates last time and I wanted to make sure I got those in.

I'm estimating 35 minutes to complete. Starting at 8 AM UTC, should hopefully be done by 8:35'ish UTC

EDIT: all done, 5 minutes early

2017-11-25, 22:44	#37
Madpoo Serpentine Vermin Jar Jul 2014 7²×67 Posts	Maintenance happening now I've taken the Primenet server offline for a quick round of maintenance. I decided it was time to slightly grow one of the virtual disks for the SQL log files. It's not uncommon these days for the log to grow kind of large between full backups and I just wanted to give ourselves more buffer to make sure it's not an issue. Then just routine updates while I'm at it... back up shortly. EDIT: Back online Last fiddled with by Madpoo on 2017-11-25 at 23:00

2018-02-08, 19:51	#39
Madpoo Serpentine Vermin Jar Jul 2014 7²·67 Posts	Server maintenance - 2018-02-18 The Primenet server is about to get a reboot following some OS/db patches. Should be a short maintenance period. EDIT: done Last fiddled with by Madpoo on 2018-02-08 at 20:34

2018-04-01, 18:31	#40
Madpoo Serpentine Vermin Jar Jul 2014 7²·67 Posts	upcoming system maintenance - 2018-04-01 Not an April fools joke... I'll be doing a handful of updates to the server with a couple reboots. EDIT: done Last fiddled with by Madpoo on 2018-04-01 at 19:14

2018-06-14, 03:04	#41
Madpoo Serpentine Vermin Jar Jul 2014 CD3₁₆ Posts	Server maintenance - 2018-06-14 @ 3:15 AM UTC Taking the server offline for a brief maintenance period... will only be about 20-25 minutes. -- 3:32 AM UTC - all done Last fiddled with by Madpoo on 2018-06-14 at 03:32

2018-08-05, 05:51	#42
Madpoo Serpentine Vermin Jar Jul 2014 7²·67 Posts	Maintenance - 2018-08-05 Routine maintenance is happening now... sorry I didn't announce it ahead of time. Just some SQL and other Windows updates. Should be another 20 minutes or so from now. EDIT: All done Last fiddled with by Madpoo on 2018-08-05 at 06:28 Reason: update

2017-10-17, 04:12	#36
Madpoo Serpentine Vermin Jar Jul 2014 CD3₁₆ Posts	Credit goes to George for updating that query to basically tell SQL to "just do it in the order it's written" since apparently it was trying to overthink it and shooting itself in the foot. I came up with an alternate strategy that seemed to accomplish the same thing, but it was relying on SQL to "do the right thing" which you really can't rely on apparently.

2018-10-20, 17:00	#43
Madpoo Serpentine Vermin Jar Jul 2014 7²·67 Posts	Regular maintenance - 2018-10-20 @ 17:00 The server will be down temporarily for routine maintenance - as usual this may take 20-30 minutes. UPDATE: all done - looking good. Last fiddled with by Madpoo on 2018-10-20 at 17:53

2018-12-08, 07:59	#44
Madpoo Serpentine Vermin Jar Jul 2014 7²·67 Posts	I'm about to kick off some regular maintenance. I'd normally let it ride but I forgot to install some SQL updates last time and I wanted to make sure I got those in. I'm estimating 35 minutes to complete. Starting at 8 AM UTC, should hopefully be done by 8:35'ish UTC EDIT: all done, 5 minutes early Last fiddled with by Madpoo on 2018-12-08 at 08:30

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OFFICIAL "SERVER PROBLEMS" THREAD	ewmayer	PrimeNet	2071	2021-01-18 16:24
Official AVX-512 programming thread	ewmayer	Programming	31	2016-10-14 05:49
Primenet maintenance announcements	Madpoo	PrimeNet	7	2015-11-12 05:50
Official Peeved Pets Thread	Prime95	Lounge	32	2015-10-02 04:17
Server maintenance thread	Madpoo	PrimeNet	9	2015-07-25 07:47