Register FAQ Search Today's Posts Mark Forums Read

2014-07-06, 01:23   #254
chalsall
If I May

"Chris Halsall"
Sep 2002

2×4,643 Posts

Quote:
 Originally Posted by Prime95 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?

2014-07-06, 13:25   #255
James Heinrich

"James Heinrich"
May 2004
ex-Northern Ontario

55 Posts

Quote:
 Originally Posted by chalsall 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.

 2014-07-06, 15:02 #256 VictordeHolland     "Victor de Hollander" Aug 2011 the Netherlands 22268 Posts 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...
2014-07-06, 20:23   #257
Prime95
P90 years forever!

Aug 2002
Yeehaw, FL

2×43×83 Posts

Quote:
 Originally Posted by VictordeHolland 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.

2014-07-06, 23:48   #258
chalsall
If I May

"Chris Halsall"
Sep 2002

2×4,643 Posts

Quote:
 Originally Posted by Prime95 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.

 2014-07-08, 09:12 #259 Gordon     Nov 2008 3×167 Posts 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==
 2014-07-08, 12:04 #260 beduzar   Apr 2014 France 22 Posts 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?
2014-07-08, 12:52   #261
ric

Jul 2004
Milan, Ita

2648 Posts

Quote:
 Originally Posted by Gordon 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...

2014-07-08, 18:27   #262
TheMawn

May 2013
East. Always East.

11·157 Posts

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

2014-07-08, 18:56   #263
chalsall
If I May

"Chris Halsall"
Sep 2002

2·4,643 Posts

Quote:
 Originally Posted by TheMawn Normally, the last two digits of the residue are masked so I would not be able to do that.
Fast learn you do.

2014-07-09, 19:24   #264
Serpentine Vermin Jar

Jul 2014

29·113 Posts

Quote:
 Originally Posted by Prime95 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.

 Similar Threads Thread Thread Starter Forum Replies Last Post ewmayer Lounge 39 2015-05-19 01:08 ewmayer Science & Technology 41 2014-04-16 11:54 cheesehead Soap Box 56 2013-06-29 01:42 cheesehead Soap Box 61 2013-06-11 04:30 Dubslow Programming 19 2012-05-31 17:49

All times are UTC. The time now is 04:12.

Tue Oct 27 04:12:17 UTC 2020 up 47 days, 1:23, 0 users, load averages: 1.98, 1.90, 1.85