PHP :: Bug #36402 :: PDO_MYSQL prepared statements cause Out of memory or data corruption

Bug #36402

PDO_MYSQL prepared statements cause Out of memory or data corruption

Submitted:

2006-02-15 15:02 UTC

Modified:

2006-04-19 01:00 UTC

Votes:	14
Avg. Score:	4.6 ± 0.6
Reproduced:	14 of 14 (100.0%)
Same Version:	8 (57.1%)
Same OS:	9 (64.3%)

From:

joh at deworks dot net

Assigned:

Status:

No Feedback

Package:

PDO related

PHP Version:

5CVS-2006-02-15 (snap)

OS:

Linux

Private report:

CVE-ID:

None

View Developer Edit

Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.

php.net Username: php.net Password:

Quick Fix:	(description)
	Block user comment
Status:		Assign to:
Package:
Bug Type:
Summary:
From:	joh at deworks dot net
New email:
PHP Version:		OS:

New/Additional Comment:

[2006-02-15 15:02 UTC] joh at deworks dot net

Description:
------------
PDO_MYSQL prepared statement INSERTs either result in corrupt data or SQLSTATE[HY000]: General error: 5 Out of memory (Needed 4261477896 bytes)

This works perfectly with PDO_SQLITE.

Reproduce code:
---------------
CREATE TABLE test (id INT PRIMARY KEY AUTO_INCREMENT, col1 VARCHAR(255), col2 VARCHAR(255), col3 VARCHAR(255), col4 VARCHAR(255), col5 VARCHAR(255));



$dbh = new PDO('mysql:host=localhost;dbname=...', '...', '...');
$sql = 'INSERT INTO test(col1, col2, col3, col4, col5) VALUES(:col1, :col2, :col3, :col4, :col5)';
$stmt = DB::$dbh->prepare($sql);
$col1 = 'TestCol1';
$col2 = 'TestCol2';
$col3 = 'TestCol3';
$col4 = 'TestCol4';
$col5 = 'TestCol5';
$stmt->bindParam(':col1', $col1);
$stmt->bindParam(':col2', $col2);
$stmt->bindParam(':col3', $col3);
$stmt->bindParam(':col4', $col4);
$stmt->bindParam(':col5', $col5);
$stmt->execute();

Expected result:
----------------
No outupt, mysql table test contains rows according to the query.

Actual result:
--------------
Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query' in file.php:125
Stack trace:
#0 file.php(125): PDOStatement->execute()
#1 {main}
  thrown in file.php on line 125

Decreasing the number of parameters to 4 (col1, col2, col3, col4) results in:
Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 5 Out of memory (Needed 4261477896 bytes)' in file.php:141
Stack trace:
#0 file.php(141): PDOStatement->execute()
#1 {main}
  thrown in file.php on line 141

Decreasing the number of parameters to 3 or less (here: col1, col2, col3) results in a successfull query, but corrupt inserted data:

mysql> SELECT * FROM test;
+----+------+------+------+------+------+
| id | col1 | col2 | col3 | col4 | col5 |
+----+------+------+------+------+------+
|  2 |      | \uffff    |      | NULL | NULL |
+----+------+------+------+------+------+
1 row in set (0.00 sec)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports

[2006-02-15 15:04 UTC] joh at deworks dot net

Forgot to mention that I'm running MySQL 4.1.12

[2006-02-15 16:45 UTC] iliaa@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip

[2006-02-15 22:20 UTC] joh at deworks dot net

I've tried the latest snapshot (I tried it before I reported this bug), and the problem still persists. Sorry.

[2006-02-23 00:07 UTC] joh at deworks dot net

So was anything done about this, or was it forgotten? Status report?

[2006-04-06 13:48 UTC] czw at home dot se

Got the same error: PHP 5.1.2, MySQL 4.1.14. This error is 
NOT present in PHP 5.1.1. I would suggest downgrading.

[2006-04-09 07:52 UTC] wez@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip

[2006-04-09 14:10 UTC] joh at deworks dot net

Just tested with the latest snapshot (php5.1-200604091030), and the problem still persists.

[2006-04-11 02:32 UTC] wez@php.net

Please try configuring PHP using:
  --disable-zend-memory-manager
and then run the PHP script under valgrind from the CLI:

% ./configure ... --disable-zend-memory-manager --enable-cli
% make
% valgrind --tool=memcheck ./sapi/cli/php myscript.php

You can find valgrind at http://valgrind.org/.

This should highlight memory corruption issues.

[2006-04-19 01:00 UTC] 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-09-20 05:46 UTC] ayuzhakov at swsoft dot com

Have the same problem.

OS:
------------
root@c-ubn51:~/php/php5.2-200609200230# uname -a
Linux c-ubn51.sbvz.plesk.ru 2.6.8-022stab070.9-smp #1 SMP Thu Apr 20 10:35:42 MSD 2006 i686 GNU/Linux
root@c-ubn51:~/php/php5.2-200609200230# cat /etc/issue
Ubuntu 5.10 "Breezy Badger" \n \l

PHP version:
------------
PHP 5.1.1
PHP 5.1.4
PHP 5.1.6
PHP 5.2-200609200230 (snapshot)

All these versions have this bug.

MySQL server version:
------------
4.1.12-1ubuntu3.7 (native).

If I try to use MySQL 4.0.24-10ubuntu2.3 (native) or MySQL 4.1.12 (binaries from mysql.com), then it works fine.

[2006-09-20 05:53 UTC] ayuzhakov at swsoft dot com

PHP configured with --disable-zend-memory-manager

root@c-ubn51:~/php/php5.2-200609200230# valgrind --tool=memcheck ./sapi/cli/php ./test.php

==30665== Memcheck, a memory error detector.
==30665== Copyright (C) 2002-2005, and GNU GPL'd, by Julian Seward et al.
==30665== Using LibVEX rev 1367, a library for dynamic binary translation.
==30665== Copyright (C) 2004-2005, and GNU GPL'd, by OpenWorks LLP.
==30665== Using valgrind-3.0.1, a dynamic binary instrumentation framework.
==30665== Copyright (C) 2000-2005, and GNU GPL'd, by Julian Seward et al.
==30665== For more details, rerun with: -v
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C7D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EA24D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E483C: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4908: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E72F0: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C8C: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EA24D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E483C: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4908: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E72F0: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C9B: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EA24D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E483C: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4908: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E72F0: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
--30665-- DWARF2 CFI reader: unhandled CFI instruction 0:50
--30665-- DWARF2 CFI reader: unhandled CFI instruction 0:50
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC82D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E6403: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC852: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E6403: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC6F7: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E6455: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC700: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E6455: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC852: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E6455: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8F254A: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4CE6: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8E4796: (within /lib/ld-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C3E: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EA24D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BD4ECEC: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BD4F2FA: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1BD4ED3C: dlopen (in /lib/tls/libdl-2.3.5.so)
==30665==    by 0x822F15C: php_dl (dl.c:140)
==30665==    by 0x82AB133: php_load_function_extension_cb (php_ini.c:235)
==30665==    by 0x82DCDB8: zend_llist_apply (zend_llist.c:191)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C4D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EA24D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BD4ECEC: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BD4F2FA: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1BD4ED3C: dlopen (in /lib/tls/libdl-2.3.5.so)
==30665==    by 0x822F15C: php_dl (dl.c:140)
==30665==    by 0x82AB133: php_load_function_extension_cb (php_ini.c:235)
==30665==    by 0x82DCDB8: zend_llist_apply (zend_llist.c:191)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C5C: (within /lib/ld-2.3.5.so)
==30665==    by 0x1B8EA24D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BD4ECEC: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BD4F2FA: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1BD4ED3C: dlopen (in /lib/tls/libdl-2.3.5.so)
==30665==    by 0x822F15C: php_dl (dl.c:140)
==30665==    by 0x82AB133: php_load_function_extension_cb (php_ini.c:235)
==30665==    by 0x82DCDB8: zend_llist_apply (zend_llist.c:191)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC82D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DF79: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BD4ECEC: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BD4F2FA: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1BD4ED3C: dlopen (in /lib/tls/libdl-2.3.5.so)
==30665==    by 0x822F15C: php_dl (dl.c:140)
==30665==    by 0x82AB133: php_load_function_extension_cb (php_ini.c:235)
==30665==    by 0x82DCDB8: zend_llist_apply (zend_llist.c:191)
==30665==    by 0x82AB259: php_ini_register_extensions (php_ini.c:563)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8EC852: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DF79: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BD4ECEC: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BD4F2FA: (within /lib/tls/libdl-2.3.5.so)
==30665==    by 0x1BD4ED3C: dlopen (in /lib/tls/libdl-2.3.5.so)
==30665==    by 0x822F15C: php_dl (dl.c:140)
==30665==    by 0x82AB133: php_load_function_extension_cb (php_ini.c:235)
==30665==    by 0x82DCDB8: zend_llist_apply (zend_llist.c:191)
==30665==    by 0x82AB259: php_ini_register_extensions (php_ini.c:563)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4CE3: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2ACFE: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4CEE: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2ACFE: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4CF9: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2ACFE: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4D04: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2ACFE: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C3E: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AD26: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C4D: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AD26: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C5C: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AD26: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
==30665== 
==30665== Conditional jump or move depends on uninitialised value(s)
==30665==    at 0x1B8F4C6B: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4DE15: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE4EAB7: _dl_open (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE5002C: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1B8EF105: (within /lib/ld-2.3.5.so)
==30665==    by 0x1BE5010D: __libc_dlopen_mode (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AB75: __nss_lookup_function (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2AD26: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE2C562: (within /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30B15: getprotobyname_r (in /lib/tls/libc-2.3.5.so)
==30665==    by 0x1BE30930: getprotobyname (in /lib/tls/libc-2.3.5.so)
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query' in /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php:156
Stack trace:
#0 /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php(156): PDOStatement->execute(Array)
#1 /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php(227): Zend_Db_Adapter_Abstract->query('INSERT INTO log...', Array)
#2 /root/php/php5.2-200609200230/test.php(24): Zend_Db_Adapter_Abstract->insert('log', Array)
#3 {main}
  thrown in /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php on line 156
==30665== 
==30665== ERROR SUMMARY: 61 errors from 21 contexts (suppressed: 0 from 0)
==30665== malloc/free: in use at exit: 51908 bytes in 1248 blocks.
==30665== malloc/free: 15865 allocs, 14617 frees, 2032501 bytes allocated.
==30665== For counts of detected errors, rerun with: -v
==30665== searching for pointers to 1248 not-freed blocks.
==30665== checked 862980 bytes.
==30665== 
==30665== LEAK SUMMARY:
==30665==    definitely lost: 32704 bytes in 8 blocks.
==30665==      possibly lost: 0 bytes in 0 blocks.
==30665==    still reachable: 19204 bytes in 1240 blocks.
==30665==         suppressed: 0 bytes in 0 blocks.
==30665== Use --leak-check=full to see details of leaked memory.

[2006-09-20 06:04 UTC] ayuzhakov at swsoft dot com

Also as reported in first comment if I have in INSERT:
  * 1,2,3 params - all ok
  * 4 params - failed with 'SQLSTATE[HY000]: General error: 5 Out of memory (Needed 4261477896 bytes)'
  * 5 or more params - failed with 'SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query'

[2006-09-21 11:19 UTC] ayuzhakov at swsoft dot com

Reproduced on Ubuntu 6.06 with MySQL 4.1.15-1ubuntu5 (native).

[2006-11-11 11:40 UTC] alexandre at objectdata dot com dot br

Fedora 1
kernel 2.4.22-1.2115.nptlsmp, glibc-2.3.2-101, mysql 4.1.21 compiled from source, php 5.1.4 compiled from source => no problem

Fedora 3
kernel 2.6.9-1.667, glibc-2.3.3-74, mysql 4.1.21 compiled from source, php 5.1.4 compiled from source => no problem

Fedora 5
kernel 2.6.17-1.2157_FC5, glibc-2.4-11, mysql 4.1.21 compiled from source, php 5.1.4 compield => reproduced problem

Fedora 6
kernel 2.6.18-1.2798.fc6, glibc-2.5-3, mysql 4.1.21 compield from source, php 5.1.4 compield from source => reproduced problem

SOLUTION
Fedora 6
install mysql-standrad-4.1.21 => compiled glibc 2.2 static <=
IS NOT A BUG FROM PHP, IS BUG FROM mysql client + glibc

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2025 The PHP Group All rights reserved.	Last updated: Fri May 09 15:01:27 2025 UTC