[PHP-DEV] Bug #11895 Updated: total crash of PHP From: tigger <email protected>
Date: 07/05/01

ID: 11895
User Update by: tigger <email protected>
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Operating system: win2k
PHP Version: 4.0.6
Description: total crash of PHP

After adding set_time_limit(60); the following is dumped to
the web browser.

Fatal error: Maximum execution time of 60 seconds exceeded
in c:\websites\tig\sample_report2.php on line 49

and 'Program Error' box is popped up on the server (Dr
Watson) saying 'Apache.exe has generated errors and will be
.... '

When php is run as a CGI the error msg says that 'php.exe
has generated...'

Line 49 of the code is;

$RS = odbc_exec($CON,$query);

The weirdest bit is if I re-run the same query with the same
variables (after the restart of apache) the query is nice
and fast. I think SQL2000 is caching the results somehow.

The variable is required and will be any number between 700
and 9999

Previous Comments:
---------------------------------------------------------------------------

[2001-07-05 02:52:39] derick <email protected>

Can you confirm that it crashes at around 60 seconds if you use set_time_limit(60); at the top of your script?

Derick

---------------------------------------------------------------------------

[2001-07-04 22:24:55] tigger <email protected>

an ODBC query that takes a long time to excute (> 30 sec)
will crash php and requires apache to restart. This is when
loading php as an apache modual or as a CGI

apache 1.3.20 (win2k)
php 4.0.6 (win2k)
SQL2000 (win2k)

The SQL2000 database has over 30 million records and is
performing a scan (on indexed records)

I'm more than willing to test code or help out to fix this btw

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=11895 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>