php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24587 Segmenation Fault after Batch Insert
Submitted: 2003-07-10 08:44 UTC Modified: 2003-07-10 12:01 UTC
From: isaac dot hopley at morton-fraser dot com Assigned:
Status: Closed Package: Scripting Engine problem
PHP Version: 4.3.2 OS: SuSE Linux 8.2
Private report: No CVE-ID: None
 [2003-07-10 08:44 UTC] isaac dot hopley at morton-fraser dot com
Description:
------------
I am trying to do a batch insert to a MySQL database.
There are rouhyly 78,000 inserts to complete however my script will only insert 65,534 at any one time.

I am running the script using the CLI method - it does not time out but prodces the message 'Segmentation Fault' after doing the 65,534 entries.  I am not sure of the significance it being the highest 16- bit no.


If you need full source code + database structure please let me know and I will put in public where you can download.

Apologies if this is a know MySQL problem - I couldn't see any explanations from this point of view.




Reproduce code:
---------------
Basically

While ( eof )
// Read File
// If certain conditions
$insertSQL = "INSERT INTO entry VALUES ('', '$ip', '$user_name', '$new_date_time', '$new_url', '', '$code') ";
						
//echo $insertSQL . "<br>";
$run = mysql_query($insertSQL);

Expected result:
----------------
Zero Output

Actual result:
--------------
Segmentation fault


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-07-10 12:01 UTC] sniper@php.net
Fixed in PHP 5. (try the beta..)

 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed Jul 16 13:01:31 2025 UTC