[QUOTE=Prime95;377477]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.[/QUOTE]

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?

[QUOTE=chalsall;377481]James has already invested a great deal of time wrapping his head around the M$ stack, and clearly understands LAMP stacks well.[/QUOTE]I more-or-less gave up on revitalizing the existing WIMP mersenne.org because I [i]couldn't[/i] wrap my head around MSSQL, more wrapping my head into it :bangheadonwall:

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.

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

[QUOTE=VictordeHolland;377503]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...[/QUOTE]

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.

[QUOTE=Prime95;377530]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.[/QUOTE]

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.

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

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.
[/CODE]The problem is the same as on 07 Apr 14,

[URL]http://www.mersenneforum.org/showthread.php?p=370469#post370469[/URL]

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

Last time Prime95 fixed the problem by [B]deleting the row from the LL results table and resubmitting the result manually[/B]. I don't think I can do that myself so please, could you help me again?

[QUOTE=Gordon;377646]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==[/QUOTE]
Same thing happening to me, when trying to retrieve manual assignments from the site page...

[QUOTE]Sending result to server: UID: beduzar/vega, M61637711 is not prime. Res64: 044D5FA731574B[B]XX[/B]. We8: 7A9A216C,49492046,00000000, AID: B6DEB7FAB2B4D88B39817D5124750817
[Comm thread Jul 8 09:32][/QUOTE]

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.

[QUOTE=TheMawn;377680]Normally, the last two digits of the residue are masked so I would not be able to do that.[/QUOTE]

Fast learn you do.

[QUOTE=Prime95;374615]BTW, does anyone know how to auto-reboot the MS SQLServer and IIS services?[/QUOTE]

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.