ID: 39448 Comment by: quentinjs at gmail dot dom Reported By: jschwabik at koop dot cz Status: No Feedback Bug Type: Performance problem Operating System: CentOS release 4.3 PHP Version: 5.2.0 New Comment:
I'm using IIS, MySQL, and PHP 5.1.1. This problem starting happening randomly within the code, and there doesn't seem to be a reason for it other then it seems to be related to MySQL calls... but I haven't taken the time yet to test that theory. Its also is random which makes it VERY hard to create a reproducable version. I'll be upgrading PHP and MySQL tonight and will then spend some time building a test case to reproduce this problem as its becoming more frequent as of late. Previous Comments: ------------------------------------------------------------------------ [2006-11-17 01:00:01] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2006-11-10 19:29:35] christoph at ziegenberg dot de Perhaps this has to do with the problem in Bug #39361, where ini settings which are valid for a directory only are still active when leaving the directory (although ini_get() returns the correct value). I tested some settings and they worked, so I though this problem is a mbstring problem - but it possibly occurs also with other ini settings... ------------------------------------------------------------------------ [2006-11-09 17:10:02] [EMAIL PROTECTED] Not reproducible. ------------------------------------------------------------------------ [2006-11-09 12:39:24] jschwabik at koop dot cz Description: ------------ I've got script running from linux shell and sometimes it crashes with "Maximum execution time of 30 seconds exceeded in some line" error in the script. The command on which it crashes is unpredictable. The script is runnig sometimes 10 minutes, sometimes 30 minutes and crashes on different lines. (It never runs 30 seconds). I am running it from command line (CLI) (max_execution_time should be 0) an I set it with set_time_limit(0) to 0. I've tried two servers 4 php versions (4.4.2, 4.4.4,5.1.6,5.2.0) In my php.ini is max_execution_time set to 0. Sometimes it ends on ifx_fetch_row(). Sometimes it ends on mktime(). My configure './configure' '--with-config-file-path=/etc/php.ini' '--with-apache=../apache_1.3.37/' '--with-informix=/opt/informix' '--with-mysql=/usr/local/mysql/' '--enable-ftp' '--with-gd' '--enable-gd-native-ttf' '--enable-gd-imgstrttf' '--with-zlib' '--with-jpeg-dir=/usr/' '--with-freetype-dir=/usr' '--with-dom=./ext' '--with-ldap' '--with-mssql=/usr/local/' '--enable-dbase' '--with-iconv=/usr/local' PHP Core Info . . . max_execution_time => 0 => 30 max_input_time => -1 => 60 open_basedir => no value => no value output_buffering => 0 => no value output_handler => no value => no value post_max_size => 8M => 8M precision => 12 => 12 safe_mode => Off => Off . . . Reproduce code: --------------- <? set_time_limit(0); //connection to MYsql database //connection to Informix database //running Informix query (10 queries) //doing some transformations and inserting into MYsql database (multiple insert every 100 rows) echo "End"; ?> Expected result: ---------------- "End" is echoed or some meaningful error message. Actual result: -------------- Fatal error:Maximum execution time of 30 seconds exceeded in ... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39448&edit=1
