Aborting PHP scripts with infinite loops - URGENT

[monkle]

Hello

I need to know if there is a way to kill a php script that is caught in an infinite loop after it has started. Somehow I missed incrementing in the loop before I started running it.

This is extremely urgent, as it is adding records to the database. I caught on when I realized that there were still lots of records in the database immediately after I deleted them

Yes, I feel like an idiot for missing this. I'm currently searching the web for any info on it, but if anyone knows of a way to do it, I would greatly appreciate it.

 

[DRJ478]

Usually PHP installations have a timeout for maximum script execution.
Please supply more details:
- OS
- do you have shell access?
- what database server?

You can check with phpinfo() what the max_eexecution_time is.

 

[monkle]

Windows 2000
I have complete access to the machine
MSSQL

 

[DRJ478]

So - is it that you want to stop the script now?

 

[monkle]

max_execution_time = 64000

 

[monkle]

yes, I would like to stop the script now

 

[DRJ478]

You have 2 options:
a) stop/restart the web server - this will certainly kill the script if it was invoked from a browser
b) stop MSSQL server - should make the script fail with an dberror

Your timeout allows 17.777 hrs of execution time

 

[monkle]

I've tried stopping the web server

 

[DRJ478]

Worst scenario is to kill the process through the Task Manager. First, however, I'd try to force the service down through Administrative Tools>Services

 

[monkle]

I've tried killing it through the task manager, and it returns "Access Denied". I am logged into the server as Administrator

 

[sleipnir214]

If you're running PHP through a web server, severing the connection from the browser to the server should kill the script. On most browsers, hitting escape kills the connection.



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[monkle]

I closed the browser that initiated the offending script

 

[sleipnir214]

Help me help you....

I closed the browser that initiated the offending script, and that

did did not

kill the script.



How are you running PHP? As a ISAPI filter or as a CGI?

Have you tried stopping and restarting the web server?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[monkle]

I closed the browser that initiated the offending script, and that did not fix the problem.

I have tried stopping and restarting the web server, and that did not fix the problem

It is running as a cgi

Some of the urgency has abated, as I have written a second script to clean up after the first. Every 30 seconds, this new script deletes all of the offending data. If none of the offending records are found, the new script is set to terminate.

Worst case scenario: The first script runs for 17.777 hours before timing out, and the second script runs behind it cleaning up the mess until the mess is gone, then terminates itself. At least I won't run the HD full, and I don't have to keep manually deleting the records.

That said, I still want to figure out how to terminate offending scripts.

 

[monkle]

Problem completely solved

I renamed the table temporarily, and both scripts died.

 

[sleipnir214]

Is this a plain CGI, or is your CGI script spawning another script which does the work?

How is the script accessing MSSQL? What PHP function-family are you using?

Is there any reason why you could not run PHP as an ISAPI filter?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[DRJ478]

{b]sleipnir214[/b]

I find it quite amusing to see two threads next to each other where one is asking how to prevent timeout and the other how to kill something that does not timeout. The irony of life.

 

[sleipnir214]

DRJ478:
You're too right.




Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[monkle]

DRJ478:
I agree, I was rather amused when I noticed that earlier.

sleipner214:
This is just a plain cgi

I access the database with the built-in mssql functions, ex. mssql_query()

I don't know that there's a reason why I could not run php as an ISAPI filter.

 

[sleipnir214]

monkle:
Maybe you and ruffy should compare notes.



I don't know why the script would continue to run when the web server is shut down. I've primarily run PHP with Apache on Linux.

But the way I figure it, if you're running PHP as an ISAPI filter, the script would have to shut down when the web server does.



Want the best answers? Ask the best questions!

TANSTAAFL!!