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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: isaac dot hopley at morton-fraser dot com
New email:
PHP Version: OS:

 

 [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 18:01:31 2025 UTC