Primenet Server - Official Maintenance Thread - Page 3

Madpoo · 2017-05-12, 23:48

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.

Madpoo · 2017-07-22, 06:09

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.

Madpoo · 2017-09-09, 02:59

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.

Madpoo · 2017-09-09, 04:10

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.

Madpoo · 2017-10-14, 18:24

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)

Madpoo · 2017-10-14, 19:52

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.

Madpoo · 2017-10-15, 05:34

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).

ric · 2017-10-15, 08:11

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

GP2 · 2017-10-15, 09:22

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.

Madpoo · 2017-10-15, 16:02

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

GP2 · 2017-10-16, 02:12

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

Exponent Status is still mostly much slower than before.

2017-05-12, 23:48	#23
Madpoo Serpentine Vermin Jar Jul 2014 6332₈ 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 2·5·7·47 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 CDA₁₆ 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-10-14, 18:24	#27
Madpoo Serpentine Vermin Jar Jul 2014 6332₈ 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-15, 05:34	#29
Madpoo Serpentine Vermin Jar Jul 2014 2·5·7·47 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-16, 02:12	#33
GP2 Sep 2003 3²×7×41 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
OFFICIAL "SERVER PROBLEMS" THREAD	ewmayer	PrimeNet	2092	2021-01-25 14:53
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