mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > PrimeNet

Reply
 
Thread Tools
Old 2017-10-16, 09:50   #34
kruoli
 
kruoli's Avatar
 
"Oliver"
Sep 2017
Porta Westfalica, DE

24·23 Posts
Default

Quote:
Originally Posted by GP2 View Post
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).
kruoli is online now   Reply With Quote
Old 2017-10-17, 01:58   #35
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29×113 Posts
Default

Quote:
Originally Posted by kruoli View Post
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 is offline   Reply With Quote
Old 2017-10-17, 04:12   #36
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29·113 Posts
Default

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 is offline   Reply With Quote
Old 2017-11-25, 22:44   #37
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29·113 Posts
Default 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
Madpoo is offline   Reply With Quote
Old 2017-11-29, 11:36   #38
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT/BST)

10110011101102 Posts
Default

Quote:
Originally Posted by Madpoo View Post
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?
henryzz is offline   Reply With Quote
Old 2018-02-08, 19:51   #39
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29·113 Posts
Default 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
Madpoo is offline   Reply With Quote
Old 2018-04-01, 18:31   #40
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29·113 Posts
Default 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
Madpoo is offline   Reply With Quote
Old 2018-06-14, 03:04   #41
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29×113 Posts
Default 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
Madpoo is offline   Reply With Quote
Old 2018-08-05, 05:51   #42
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29×113 Posts
Default 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
Madpoo is offline   Reply With Quote
Old 2018-10-20, 17:00   #43
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29×113 Posts
Default 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
Madpoo is offline   Reply With Quote
Old 2018-12-08, 07:59   #44
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

CCD16 Posts
Default

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
Madpoo is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
OFFICIAL "SERVER PROBLEMS" THREAD ewmayer PrimeNet 2037 2020-11-23 02:56
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

All times are UTC. The time now is 18:09.

Fri Nov 27 18:09:52 UTC 2020 up 78 days, 15:20, 4 users, load averages: 1.67, 1.67, 1.46

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

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.