mersenneforum.org  

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

Reply
 
Thread Tools
Old 2014-07-25, 14:34   #298
VictordeHolland
 
VictordeHolland's Avatar
 
"Victor de Hollander"
Aug 2011
the Netherlands

2·587 Posts
Default

She is down again, with SQL error code 08S01 - Communication link failure.
VictordeHolland is offline   Reply With Quote
Old 2014-07-25, 15:13   #299
Uncwilly
6809 > 6502
 
Uncwilly's Avatar
 
"""""""""""""""""""
Aug 2003
101×103 Posts

22B716 Posts
Default

Quote:
Originally Posted by VictordeHolland View Post
She is down again, with SQL error code 08S01 - Communication link failure.
<aol>Me too!</aol> On vacation. Paying for wifi, where it used to be free.
Uncwilly is online now   Reply With Quote
Old 2014-07-25, 15:23   #300
lycorn
 
lycorn's Avatar
 
Sep 2002
Oeiras, Portugal

24·89 Posts
Default

Quote:
Originally Posted by chalsall View Post
From my perspective, the correlation seems to be a large number of "factor found" results being submitted. As an example, just after Oliver submits his weekly queue Primenet seems to stagger a bit.
That seems to be right. But much more than Oliver, we have TJAOI submitting thousands of small factors nearly every day. If there´s really a correlation between factors being checked in and Primenet glitches, it should be easily spotted following TJAOI submissions.

Last fiddled with by lycorn on 2014-07-25 at 15:24
lycorn is offline   Reply With Quote
Old 2014-07-25, 16:43   #301
kladner
 
kladner's Avatar
 
"Kieren"
Jul 2011
In My Own Galaxy!

1004810 Posts
Default

Quote:
Originally Posted by VictordeHolland View Post
She is down again, with SQL error code 08S01 - Communication link failure.
Same at 16:43 UTC.
kladner is offline   Reply With Quote
Old 2014-07-25, 16:46   #302
lycorn
 
lycorn's Avatar
 
Sep 2002
Oeiras, Portugal

24·89 Posts
Default

Down here as well, with:

Warning: odbc_pconnect() [function.odbc-pconnect]: SQL error: [Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation., SQL state 08S01 in SQLConnect in C:\v5\www\2013\v5server\0.96_database.inc.php on line 21
pnErrorResult=3 pnErrorDetail=Database unavailable ==END==
lycorn is offline   Reply With Quote
Old 2014-07-25, 18:24   #303
Prime95
P90 years forever!
 
Prime95's Avatar
 
Aug 2002
Yeehaw, FL

2·3·1,193 Posts
Default

I'm having difficulty logging in to restart the services. I'm pursuing other means of rebooting.
Prime95 is online now   Reply With Quote
Old 2014-07-25, 18:56   #304
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

52·373 Posts
Default

Quote:
Originally Posted by Prime95 View Post
I'm having difficulty logging in to restart the services. I'm pursuing other means of rebooting.
Please forgive me for being annoying, but, for example, 1and1, EC2 and Rackspace provide easy means of rebooting servers without being physically in front of them.

And, further, I earlier today lowered GPU72's spidering against Primenet. No real big downside -- clients for TF'ing and P-1'ing will still be able to get assignments. But their results won't be recognized until Primenet comes back on-line.
chalsall is offline   Reply With Quote
Old 2014-07-25, 19:05   #305
kladner
 
kladner's Avatar
 
"Kieren"
Jul 2011
In My Own Galaxy!

1004810 Posts
Default

17:05 UTC

It's Baaaaack!
kladner is offline   Reply With Quote
Old 2014-07-25, 19:50   #306
Gordon
 
Gordon's Avatar
 
Nov 2008

3·167 Posts
Default

Quote:
Originally Posted by Prime95 View Post
I found the IIS log files. Some random stats:

Server is handling about 14000 prime95 HTTP requests per hour. Each request is a CGI, PHP, and at least a few SQL statements.

Server is also handling about 3000 web requests per hour. This includes GPU72 spider requests. It counts individual CSS/GIF/JPEG/PNG files as well as PHP request that will fire off some SQL statements.

I'm not sure if that is a lot or a little or if that gets me any closer to finding bottlenecks.
So that's 5 i/o requests per second. Even if every one triggers 5 more that's still only 25.

A quick search for MS SQL server throughput suggest even M$ server can manage writes of hundreds per second and reads of up to 15,000 per second.

Is this running on an old IBM-XT or something similar. Even a mobile phone can be a web server nowadays...
Gordon is offline   Reply With Quote
Old 2014-07-26, 02:23   #307
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

29·113 Posts
Default

Quote:
Originally Posted by Gordon View Post
So that's 5 i/o requests per second. Even if every one triggers 5 more that's still only 25.

A quick search for MS SQL server throughput suggest even M$ server can manage writes of hundreds per second and reads of up to 15,000 per second.

Is this running on an old IBM-XT or something similar. Even a mobile phone can be a web server nowadays...
Yeah, it doesn't seem like an excessive amount of activity, but I don't know what the hardware is like. I maintain a bunch of pretty active websites and the MS SQL backend can handle a LOT more IOPS on a system with dual X5550's and 24GB of RAM. The usual bottlenecks are disk subsystem... in our case the size of the database can eventually be cached entirely in that 24GB of RAM (with room to spare), so just getting the disks to read/write as fast as possible is the key. It's on an external storage unit, 12 x 144GB 15K SAS drives. Logs and data are using separate spindles which is another key point.

My guess is the same as others... it could be some delays in checking those "factor found" results... just a bottleneck as it checks a bunch that come in all at once? It should delay checking them or limit that to only half of the available CPU's or something so it doesn't entirely bog down the system.

Without re-architecting the whole process, the "simple" solution is to throw hardware at it. Works every time it's tried... find the bottleneck and instead of making it work better with what it has, just remove the bottleneck by beefing up that subsystem.
Madpoo is offline   Reply With Quote
Old 2014-07-26, 20:08   #308
Prime95
P90 years forever!
 
Prime95's Avatar
 
Aug 2002
Yeehaw, FL

1BF616 Posts
Default

I'm taking the server down to see how long it takes to rebuild some indexes.

I freed up 4GB of server disk space by downloading log files to my computer. This should give me enough disk space to rebuild some indexes which are over 90% fragmented.

Unfortunately, indexes can only be rebuilt online with the Enterprise Edition of SQLServer.
Prime95 is online now   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 17:20.

Sat Nov 28 17:20:36 UTC 2020 up 79 days, 14:31, 4 users, load averages: 1.88, 1.69, 1.49

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.