mersenneforum.org

mersenneforum.org (https://www.mersenneforum.org/index.php)
-   PrimeNet (https://www.mersenneforum.org/forumdisplay.php?f=11)
-   -   Primenet Server - Official Maintenance Thread (https://www.mersenneforum.org/showthread.php?t=21648)

kruoli 2017-10-16 09:50

[QUOTE=GP2;469913]The [URL="https://mersenne.org/assignments/"]Active Assignments page[/URL] is empty (no assignments listed).[/QUOTE]

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 ([url]https://www.mersenne.org/assignments/?exp_lo=2&exp_hi=10000[/url]).

Madpoo 2017-10-17 01:58

[QUOTE=kruoli;469931]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 ([url]https://www.mersenne.org/assignments/?exp_lo=2&exp_hi=10000[/url]).[/QUOTE]

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. :smile:

Madpoo 2017-11-25 22:44

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

henryzz 2017-11-29 11:36

[QUOTE=Madpoo;472431]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[/QUOTE]

You don't have autogrowing virtual disks?

Madpoo 2018-02-08 19:51

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

Madpoo 2018-04-01 18:31

upcoming system maintenance - 2018-04-01
 
Not an April fools joke... :smile:

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

EDIT: done

Madpoo 2018-06-14 03:04

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

Madpoo 2018-08-05 05:51

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

Madpoo 2018-10-20 17:00

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.

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 :smile:


All times are UTC. The time now is 08:33.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.