Possible PHP bug -- Time of script execution not working for browser mode

[cesarovich]

Hi,
I have found that when you are running a very long process (let's say 5-10 minutes) in web browser mode (i.e., calling to the script via HTTP), the PHP interpreter re-starts the script several times. (The set_time_limit function is properly set to 0)...

This can be checked in many different ways, one of them being a script which inserts 1000 000 rows in a database if the table is empty or delete them if it is full of data.

The behaviour does not depend on the script, OS of server, just on the time of execution.

When you run the script in console mode, it goes perfectly and only executes the code ONCE. However, in browser mode, it ALWAYS re-starts around 5 minutes from beginning.

This seems a very strange and annoying behaviour, maybe a bug in the PHP interpreter itself????

Any comment will be welcomed.
Thank you very much.

Cesar

[PHPThorsten]

Sorry, but I can't reproduce your error.

I have the following script:

<?php 

for($i = 1; $i < 1500000; $i++) {
  set_time_limit (20);

  $arr_data["field1"] = "$i";
  $arr_data["field2"] = "$i";
  $arr_data["field3"] = "$i";
  $arr_data["field4"] = "$i";
  $arr_data["field5"] = "$i";
  $arr_data["field6"] = "$i";
  $arr_data["field7"] = "$i";
  $arr_data["field8"] = "$i";
  $arr_data["field9"] = "$i";

  $query = "
            INSERT INTO 
              table 
              (
                `field1`, 
                `field2`, 
                `field3`,
                `field4`,
                `field5`, 
                `field6`,
                `field7`,
                `field8`,
                `field9`, 
                `field10`
              )
            VALUES  

              (
                '{$arr_data["field1"]}',
                '{$arr_data["field2"]}',
                '{$arr_data["field3"]}',
                '{$arr_data["field4"]}',
                '{$arr_data["field5"]}', 
                '{$arr_data["field6"]}', 
                '{$arr_data["field7"]}',
                '{$arr_data["field8"]}',
                '{$arr_data["field9"]}', 
                now()
              )
            ;";

  $obj_db->obj_db->Execute("SET AUTOCOMMIT = 0");

  $obj_db->obj_db->BeginTrans();

  $db_query = $obj_db->obj_db->Execute($query);

  $obj_db->obj_db->CommitTrans($db_query);
}

?>

The real script with which I tested looks a little bit different. It writes the data into 3 tables.

The DB is mysql-max 3.23.56, table-type is InnoDB.

$obj_db is an DB Class depending on AdoDB.
$obj_db->obj_db is the DB connection ressource.

The DB fields "field1", "field2" and "field3" are unique.
"field0" is auto_incrementing primary key and not specified in the query.

PHP version is 4.3.x (4.3.0 I think, but not sure).

Script called from MS Internet Explorer, Server is in the LAN with a 100MBit connection.

You might try to reproduce your error with a simple script like mine above.
If the error will not appear again, its an false in your real script.

Bye

Thorsten

PS: (The sript runs for 30 minutes now, no error, not stopping...
It insertet 750.000 rows (in 3 tables) with 110MB of data)

[cesarovich]

Of course it runs perfectly!!! It only makes INSERT's, so there is no way you can know if it has re-started!!!!!

You should make INSERT and DELETE. First, a DELETE if the number of rows > 1000 (for example). Second 1000 000 INSERTS.

If you check with MySQLAdmin you will see what I mean. If you begin with all tables empty, it will start to insert rows, and before reaching 1 000 000, it will make the DELETE, so it will start again with 0 rows, and will re-run again...

The behaviour in my scripts is:

Insert till 300 000 or so rows.

Delete all rows

Insert till 700 000 rows and suddenly stops...

NOTICE THAT 300 000 + 700 000 = 1 000 000 !!!!!!!!!!!!!!

However, in console mode it makes 1 000 000 inserts directly. So clearly there is a problem here, and it is not on the side of the code.