mersenneforum.org  

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

Reply
 
Thread Tools
Old 2014-07-06, 01:23   #254
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

2×4,657 Posts
Default

Quote:
Originally Posted by Prime95 View Post
Money is not the issue. Converting from Windows to Linux, SQLServer to MySQL, transferring the database, volunteer time to get all that done is the issue.

Even if we leased, it would take time to do all the above work. In the meantime, we are stuck with the current server. If I can upgrade the disks for peanuts and buy time, it seems like a no-brainer.

Basically, we need both a short-term solution and a long-term solution.
George...

With all due respect...

There have been many people willing to pay for the new server.

And many people willing to do the work to migrate from a M$ stack to a LAMP stack.

James has already invested a great deal of time wrapping his head around the M$ stack, and clearly understands LAMP stacks well.

Perhaps we can take the next step forward?
chalsall is offline   Reply With Quote
Old 2014-07-06, 13:25   #255
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

13·233 Posts
Default

Quote:
Originally Posted by chalsall View Post
James has already invested a great deal of time wrapping his head around the M$ stack, and clearly understands LAMP stacks well.
I more-or-less gave up on revitalizing the existing WIMP mersenne.org because I couldn't wrap my head around MSSQL, more wrapping my head into it

That said, give me the MSSQL database and six hours and I'll give you a MySQL version. Possibly not counting any stored procedures, I don't have a clear picture of what's involved there -- I know there are some (e.g. for hourly report generation) but I'm not sure how extensively they're used).

PHP is generally very nicely platform-independent, there should be very little needed in the way of PHP code modification.
James Heinrich is offline   Reply With Quote
Old 2014-07-06, 15:02   #256
VictordeHolland
 
VictordeHolland's Avatar
 
"Victor de Hollander"
Aug 2011
the Netherlands

23·3·72 Posts
Default Offline (Offsite) Backup

Just a general question/remark: Is there a (recent) offline backup in case these server issues get worse and the database won't rebuild itself? External HDDs are so cheap and it would be such a pitty if we lose days/weeks of work...
VictordeHolland is offline   Reply With Quote
Old 2014-07-06, 20:23   #257
Prime95
P90 years forever!
 
Prime95's Avatar
 
Aug 2002
Yeehaw, FL

22·1,789 Posts
Default

Quote:
Originally Posted by VictordeHolland View Post
Just a general question/remark: Is there a (recent) offline backup in case these server issues get worse and the database won't rebuild itself? External HDDs are so cheap and it would be such a pitty if we lose days/weeks of work...
Scott is in charge of backup strategy. I know he is saving the daily transaction log on another disk. I don't know how often he creates full backups.
Prime95 is offline   Reply With Quote
Old 2014-07-06, 23:48   #258
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

2×4,657 Posts
Default

Quote:
Originally Posted by Prime95 View Post
Scott is in charge of backup strategy. I know he is saving the daily transaction log on another disk. I don't know how often he creates full backups.
One of the most important "take-a-ways" for me from the president of the United States of America's Ronald Reagan was "Trust, but verify.
chalsall is offline   Reply With Quote
Old 2014-07-08, 09:12   #259
Gordon
 
Gordon's Avatar
 
Nov 2008

50010 Posts
Default

Gone again....

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==
Gordon is offline   Reply With Quote
Old 2014-07-08, 12:04   #260
beduzar
 
Apr 2014
France

22 Posts
Default Again, problem downloading a result

Hello,

A failure occurred again this morning sending result to server for number M61637711.

Code:
[Comm thread Jul 8 08:19] Sending result to server: UID: beduzar/vega, M61637711 is not prime. Res64: 044D5FA731574B8A. We8: 7A9A216C,49492046,00000000, AID: B6DEB7FAB2B4D88B39817D5124750817
[Comm thread Jul 8 08:19] 
[Worker #1 Jul 8 08:19] Starting primality test of M33352387 using AVX FFT length 1728K, Pass1=384, Pass2=4608
[Comm thread Jul 8 08:22] CURL library error: Operation timed out after 180000 milliseconds with 0 bytes received
[Comm thread Jul 8 08:22] CURL library error: Operation timed out after 180000 milliseconds with 0 bytes received
[Comm thread Jul 8 08:22] Visit http://mersenneforum.org for help.
[Comm thread Jul 8 08:22] Will try contacting server again in 70 minutes.
[Worker #2 Jul 8 08:29] Iteration: 37400000 / 61992289 [60.33%].  Per iteration time: 0.023 sec.
[Worker #1 Jul 8 08:39] Iteration: 100000 / 33352387 [0.29%].  Per iteration time: 0.012 sec.
[Worker #1 Jul 8 08:59] Iteration: 200000 / 33352387 [0.59%].  Per iteration time: 0.012 sec.
[Worker #2 Jul 8 09:08] Iteration: 37500000 / 61992289 [60.49%].  Per iteration time: 0.023 sec.
[Worker #1 Jul 8 09:18] Iteration: 300000 / 33352387 [0.89%].  Per iteration time: 0.012 sec.
[Comm thread Jul 8 09:32] Sending result to server: UID: beduzar/vega, M61637711 is not prime. Res64: 044D5FA731574B8A. We8: 7A9A216C,49492046,00000000, AID: B6DEB7FAB2B4D88B39817D5124750817
[Comm thread Jul 8 09:32] 
[Comm thread Jul 8 09:32] PrimeNet error 40: No assignment
[Comm thread Jul 8 09:32] This computer has already sent in this LL result for M61637711
[Comm thread Jul 8 09:32] Done communicating with server.
The problem is the same as on 07 Apr 14,

http://www.mersenneforum.org/showthr...469#post370469

The result is well recorded but it is not credited to my account.

Last time Prime95 fixed the problem by deleting the row from the LL results table and resubmitting the result manually. I don't think I can do that myself so please, could you help me again?
beduzar is offline   Reply With Quote
Old 2014-07-08, 12:52   #261
ric
 
ric's Avatar
 
Jul 2004
Milan, Ita

22·32·5 Posts
Default

Quote:
Originally Posted by Gordon View Post
Gone again....

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==
Same thing happening to me, when trying to retrieve manual assignments from the site page...
ric is offline   Reply With Quote
Old 2014-07-08, 18:27   #262
TheMawn
 
TheMawn's Avatar
 
May 2013
East. Always East.

11×157 Posts
Default

Quote:
Sending result to server: UID: beduzar/vega, M61637711 is not prime. Res64: 044D5FA731574BXX. We8: 7A9A216C,49492046,00000000, AID: B6DEB7FAB2B4D88B39817D5124750817
[Comm thread Jul 8 09:32]
For anyone reading this, I would like to remind you that it is not a good idea to post full 64 bit residues in a public place. I wasn't paying attention and made the same mistake myself a few days ago.

I have grabbed M61637711 as a DC assignment to make sure that this assignment is done properly. Otherwise, someone could fake the test and submit the same result line as you and get free credit for an assignment that was not done, and potentially miss any error you might have had during the test.

Normally, the last two digits of the residue are masked so I would not be able to do that.

Last fiddled with by TheMawn on 2014-07-08 at 18:27
TheMawn is offline   Reply With Quote
Old 2014-07-08, 18:56   #263
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

2×4,657 Posts
Default

Quote:
Originally Posted by TheMawn View Post
Normally, the last two digits of the residue are masked so I would not be able to do that.
Fast learn you do.
chalsall is offline   Reply With Quote
Old 2014-07-09, 19:24   #264
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

2×1,637 Posts
Default

Quote:
Originally Posted by Prime95 View Post
BTW, does anyone know how to auto-reboot the MS SQLServer and IIS services?
So, I know I'm SUPER late with this boring reply, and George probably figured it out by now, but...

Restarting SQL can be accomplished by:
net stop /y mssqlserver
net start mssqlserver
(if SQL agent is used add this line too)
net start sqlserveragent

The first stop command with /y will stop the service and any dependencies as well, like SQL Agent. I'm also partial to the "psservice.exe" from the SysInternals set of tools... with that it's as easy as running "psservice restart mssqlserver" which will restart it and all dependencies in one tidy command.

Resetting IIS is just running this:
iisreset

It takes care of restarting the web service and WAS if there's any .NET stuff involved.

If George or anyone wants any help with server junk, let me know. George and Scott are probably still familiar with me, from a certain incident back in 1998 or so. :)

Right now I only have a single system contributing to GIMPS, but besides that I'm still doing system admin things in the Windows world, including extensive IIS and MS SQL work. I'd be more than happy to look over anything and see if I have anything useful to add. Optimization in the Microsoft world is one of my specialties.

From my 30,000 foot level, without knowing squat about how SQL is setup, it sounds like there's not enough disk space but that could be from the transaction log growing uncontrollably. Maybe it's due to transactions being stalled while factors are being checked by an external process?

Maybe it already does this but if I were designing a system to accept submissions like factor results and then check them, I'd put them in a pending column and send the factor job off on it's own to handle them as needed where that job would independently move them from pending to confirmed. Could be a totally different machine or the same...whatever. So long as it doesn't tie up SQL in the meantime.

Maybe it means newly submitted requests are "pending" for a while, even days in the case of that person who submits thousands at a time, but it won't take down the site. And the processing could be scheduled by user, so one user submitting thousands has it's own queue of "one at a time" and won't block other users who submit one or two.
Madpoo 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 01:43.

Fri Sep 25 01:43:51 UTC 2020 up 14 days, 22:54, 0 users, load averages: 1.12, 1.24, 1.35

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.