mersenneforum.org  

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

Reply
 
Thread Tools
Old 2015-04-15, 15:22   #947
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

1100110011012 Posts
Default

Quote:
Originally Posted by Madpoo View Post
... Tomorrow is "patch Tuesday" anyway and it may be a good opportunity to get the server caught up on updates and reboot to clear out any gremlins.
I've looked over the April fixes from Microsoft and tried them out on some dev systems (I try to do that and avoid some of the nastier surprises). Looks good and a few worthwhile patches in there.

I'm going to apply these and reboot Primenet in about 30 minutes from now... let's call it 15:50 UTC.

Downtime will be about 20 minutes since I'm also going to apply some firmware updates on the host machine and a SQL rollup patch.

Last fiddled with by Madpoo on 2015-04-15 at 15:23
Madpoo is offline   Reply With Quote
Old 2015-04-15, 16:06   #948
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

23·359 Posts
Default

It turns out one of those fixes is a remote root hole in IIS: https://ma.ttias.be/remote-code-exec...is-on-windows/
Mark Rose is offline   Reply With Quote
Old 2015-04-15, 16:15   #949
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

327710 Posts
Default

Quote:
Originally Posted by Mark Rose View Post
It turns out one of those fixes is a remote root hole in IIS: https://ma.ttias.be/remote-code-exec...is-on-windows/
Yes, precisely. :) Bugs in HTTP.SYS are never good.

Well, I have half of the patches installed, but in typical MS fashion, since I skipped updating last month, Windows Update is making me reboot and then install more and reboot again.

So it's taking me longer than the 20 minutes I had planned for. The virtual host machine is done at least and the firmware patches applied. Now I'm just waiting on getting the Primenet server itself caught up. It's up for now so it's handling web requests for the moment.

In a few more minutes I'll shut down the website again and finish it off.
Madpoo is offline   Reply With Quote
Old 2015-04-15, 16:36   #950
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29×113 Posts
Default

Quote:
Originally Posted by Madpoo View Post
In a few more minutes I'll shut down the website again and finish it off.
All done and everything back up and running.
Madpoo is offline   Reply With Quote
Old 2015-04-18, 04:37   #951
LaurV
Romulan Interpreter
 
LaurV's Avatar
 
Jun 2011
Thailand

100010101001112 Posts
Default Grrr.. strange PN error

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 56) was deadlocked on trial factoring (huh? haha)
lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL state 40001 in SQLExecDirect in C:\inetpub\www\report_top_500_custom\default.php on line 92

Last fiddled with by LaurV on 2015-04-18 at 04:38
LaurV is offline   Reply With Quote
Old 2015-04-18, 06:50   #952
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

327710 Posts
Default

Quote:
Originally Posted by LaurV View Post
Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 56) was deadlocked on trial factoring (huh? haha)
lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL state 40001 in SQLExecDirect in C:\inetpub\www\report_top_500_custom\default.php on line 92
Yeah, I think some of the SQL queries that the website does could/should be updated to avoid locks when possible.

It also wouldn't hurt to hide the error messages, but hey, we're all friends here, and seeing the errors helps figure out the problem.
Madpoo is offline   Reply With Quote
Old 2015-04-26, 05:32   #953
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

23·359 Posts
Default

Something odd is happening for me with mersenne.org.

When I'm not logged in, it goes fast.

When I am logged in, all requests eventually time out after several minutes with a 500 error.

This is happening on browsers on two different machines as well as using mfloop.py on four different machines. I can't submit any results right now.

Last fiddled with by Mark Rose on 2015-04-26 at 05:34
Mark Rose is offline   Reply With Quote
Old 2015-04-26, 16:28   #954
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

1011001110002 Posts
Default

Okay, I stopped my minutely spider, and it now responds again. I guess some kind of database lock kept piling up.
Mark Rose is offline   Reply With Quote
Old 2015-04-26, 18:39   #955
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

327710 Posts
Default

Quote:
Originally Posted by Mark Rose View Post
Something odd is happening for me with mersenne.org.

When I'm not logged in, it goes fast.

When I am logged in, all requests eventually time out after several minutes with a 500 error.

This is happening on browsers on two different machines as well as using mfloop.py on four different machines. I can't submit any results right now.
Weird. I don't know what pages you're crawling exactly, but it's weird that being logged in or not makes such a difference. There are pages where a logged in user will display more information, and the SQL query takes a different set of parameters. In that sense, if what you're crawling doesn't change whether you're logged in or not and it works faster logged out, then go with that.
Madpoo is offline   Reply With Quote
Old 2015-04-26, 18:51   #956
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

54708 Posts
Default

Quote:
Originally Posted by Madpoo View Post
Weird. I don't know what pages you're crawling exactly, but it's weird that being logged in or not makes such a difference. There are pages where a logged in user will display more information, and the SQL query takes a different set of parameters. In that sense, if what you're crawling doesn't change whether you're logged in or not and it works faster logged out, then go with that.
I have spiders that submit results every minute, if there are any. I was also trying to look at the full details of M1277 when the error started. All my logged in requests would hang, until I stopped the spiders for a while, and whatever was locking things got released.

Bleh. Looks like I lost 825 GHz-days of work or so. Ah well :/

I keep about 300 GHz-d/d in reserve (where I have to pay for power)... so I'll press that into service.

Last fiddled with by Mark Rose on 2015-04-26 at 18:55
Mark Rose is offline   Reply With Quote
Old 2015-04-26, 20:44   #957
Prime95
P90 years forever!
 
Prime95's Avatar
 
Aug 2002
Yeehaw, FL

2×43×83 Posts
Default

Quote:
Originally Posted by Madpoo View Post
Weird. I don't know what pages you're crawling exactly, but it's weird that being logged in or not makes such a difference.
There is a field in the user record that is updated each web page. I think its called dt_last_visited. I guess that locks the row for too long a period, although why it doesn't autocommit it I don't know. One quick change might be to update that query to only update dt_last_visited if it has been at least an hour since the last update. Something like "where dt_last_visited < dateadd (hour, getdate(), -1)"
Prime95 is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Official "Faits erronés dans de belles-lettres" thread ewmayer Lounge 39 2015-05-19 01:08
Official "all-Greek-to-me Fiction Literature and Cinema" Thread ewmayer Science & Technology 41 2014-04-16 11:54
Official "Lasciate ogne speranza" whinge-thread cheesehead Soap Box 56 2013-06-29 01:42
Official "Ernst is a deceiving bully and George is a meanie" thread cheesehead Soap Box 61 2013-06-11 04:30
Official "String copy Statement Considered Harmful" thread Dubslow Programming 19 2012-05-31 17:49

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

Tue Oct 27 06:17:52 UTC 2020 up 47 days, 3:28, 0 users, load averages: 1.27, 4.02, 4.31

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.