OFFICIAL "SERVER PROBLEMS" THREAD

[James Heinrich]

Originally Posted by Prime95

BTW, does anyone know how to auto-reboot the MS SQLServer and IIS services?

You could use this as a rough guide (it has pretty pictures), substituting the appropriate service name(s). Basically: make a batch file withnet stop servicename and net start servicename and call it with Task Scheduler. For my WAMP development machine the batch file looks like this:

net stop apache2.2
net stop mysql
net start mysql
net start apache2.2

I'm not sure what IIS and MSSQL services are called. Then you can schedule it to restart the services every day (or week or whatever), or when triggered by any number of events as allowed by Task Scheduler.

[snme2pm1]

Originally Posted by Prime95

The problem could just as easily be some other resource leakage

Many process consumption figures could be viewed at the server, and radical growth statistics localised.
I tend to use procexp (process explorer) but other tools exist.
By the way, what OS version is the server?

[Prime95]

Originally Posted by snme2pm1

By the way, what OS version is the server?

Um, Windows Server 2000. Isn't that the latest version?

[science_man_88]

Originally Posted by Prime95

Um, Windows Server 2000. Isn't that the latest version?

windows server 2012

quick search gets these results for an attempt at windows server versions.

[kracker]

Originally Posted by Prime95

Um, Windows Server 2000. Isn't that the latest version?

Heh... Try Wikipedia .

[snme2pm1]

Originally Posted by Prime95

Um, Windows Server 2000. Isn't that the latest version?

I sometimes spend a little time fiddling with a couple of 2003 boxes, which are close to WinXP lineage.
MS so far still issuing updates for server 2003.

[axn]

Originally Posted by science_man_88

windows server 2012

quick search gets these results for an attempt at windows server versions.

Originally Posted by kracker

Heh... Try Wikipedia .

Woosh!

[snme2pm1]

Originally Posted by James Heinrich

It's true, I'm failing.

I did [Nov 2013] rewrite the results-parsing code (basically lifted directly from mersenne.ca) but I had great trouble with troubleshooting the process of inserting results into the database. I speak MySQL, Primenet speaks MS-SQL, and we don't get on. The process looks something like this:

I guess this is my poke to have a 4th look at it and see if I can get somewhere closer than I was before. I used to be optimistic, that has gone, but I'll try taking another look.

I recently lodged TF results with first line ... has a factor, accidentally.
Yet this time such result was properly reported as F rather than F-PM1.
So do we believe this ancient problem is fixed now?

[James Heinrich]

Originally Posted by snme2pm1

So do we believe this ancient problem is fixed now?

Not by anything I've done, unfortunately.
The wrong-factor-type issue only occurs under some circumstances. It is also possible that the ancient code also guesses correctly that it's TF, depending (mostly) on the factor size.

[Prime95]

Originally Posted by snme2pm1

I recently lodged TF results with first line ... has a factor, accidentally.
Yet this time such result was properly reported as F rather than F-PM1.
So do we believe this ancient problem is fixed now?

No. As long as there is one "no factor" line all will be well. The line can appear anywhere in the submission.

[brilong]

Originally Posted by chalsall

Thank you for the detailed bug report. I will try to find cycles to deal with this this weekend, and report when an update is available dealing with this issue.

Any updates on an improved submit_spider script? I've had more issues where submit_spider saves results in a "submitted" file, but the server does not register the factor as completed. If I grab the results from the submitted file, append it to results.txt and rerun the spider, it works. This is a tedious process.