Edit report at https://bugs.php.net/bug.php?id=61259&edit=1
ID: 61259
Updated by: johan...@php.net
Reported by: uabitesoj at gmail dot com
Summary: "Segment Fault" executing a prepared statement with
PDO-Mysql
-Status: Open
+Status: Feedback
Type: Bug
Package: PDO related
Operating System: Linux 2.6.18 Centos 5.7
PHP Version: 5.3.10
-Assigned To:
+Assigned To: mysql
Block user comment: N
Private report: N
New Comment:
Please try using this snapshot:
http://snaps.php.net/php5.3-latest.tar.gz
For Windows:
http://windows.php.net/snapshots/
Your configure line is confusing.
--with-mysqli=mysqlnd \
--with-pdo-mysql \
--with-mysql-sock=/var/lib/mysql/mysqld.sock \
myslqi is using myslqnd whereas pdo_mysql is using libmysql from it's default
location. Is that really your configuration? It is suggested to use mysqlnd for
both.
--with-mysqli=mysqlnd \
--with-pdo-mysql=myslqnd
your backtrace indicates a conflict there (as it is referring to mysqlnd which
shouldn't be used by PDO with the given configuration)
I couldn't reproduce with a pure myslqnd build. Please verify your
configuration.
Previous Comments:
------------------------------------------------------------------------
[2012-03-03 03:58:24] uabitesoj at gmail dot com
Description:
------------
Now I'm using php-5.3.10.
Executing a prepared sql statemente with pdo-mysql produces a "Segmento Fault"
error.
The configure line used to compile php is:
./configure \
--prefix=/usr/lib/php-5.3.10 \
--exec-prefix=/usr/lib/php-5.3.10 \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-config-file-path=/etc \
--enable-zip \
--enable-debug \
--with-curl=/usr/local \
--with-readline \
--enable-mbstring \
--with-mysqli=mysqlnd \
--with-pdo-mysql \
--with-mysql-sock=/var/lib/mysql/mysqld.sock \
--with-openssl \
--with-zlib \
--with-gd
Test script:
---------------
<?php
$dbh = new PDO('mysql:host=localhost;dbname=acceso', 'dbuser', 'dbpass');
$sql = 'INSERT INTO user (id, nombre, login, passwd) VALUES (?, ?, ?, ?)';
$stm = $dbh->prepare($sql);
$stm->bindValue(1, 0);
$stm->bindValue(2, 'Name, Last Name, etc. etc.');
$stm->bindValue(3, 'log_name');
$stm->bindValue(4, SHA1('log_name', FALSE));
$stm->execute();
echo 'New user record saved in DB';
?>
Expected result:
----------------
Echoed 'New user record saved in DB' and a new record in "user" table.
Actual result:
--------------
GNU gdb (GDB) Red Hat Enterprise Linux (7.0.1-37.el5_7.1)
Copyright (C) 2009 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "i386-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/bin/php...done.
(gdb) run ExecutePrepared.php
Starting program: /usr/bin/php ExecutePrepared.php
warning: .dynamic section for "/lib/libc.so.6" is not at the expected address
warning: difference appears to be caused by prelink, adjusting expectations
[Thread debugging using libthread_db enabled]
Program received signal SIGSEGV, Segmentation fault.
0x08325563 in mysqlnd_cset_escape_slashes (cset=0x0, newstr=0x89db217 "p",
escapestr=0x89dca6c "Name, Last name, etc., etc.",
escapestr_len=27) at
/d/software/Php/php-5.3.10/ext/mysqlnd/mysqlnd_charset.c:718
718 if (cset->char_maxlen > 1 && (len =
cset->mb_valid(escapestr, end))) {
(gdb) bt
#0 0x08325563 in mysqlnd_cset_escape_slashes (cset=0x0, newstr=0x89db217 "p",
escapestr=0x89dca6c "Name, Last name, etc., etc.",
escapestr_len=27) at
/d/software/Php/php-5.3.10/ext/mysqlnd/mysqlnd_charset.c:718
#1 0x081f6a55 in mysql_handle_quoter (dbh=0x89dc118, unquoted=0x89dca6c "Name,
Last name, etc., etc.", unquotedlen=27,
quoted=0x89de1a0, quotedlen=0x89de19c, paramtype=PDO_PARAM_STR) at
/d/software/Php/php-5.3.10/ext/pdo_mysql/mysql_driver.c:337
#2 0x081f5f89 in pdo_parse_params (stmt=0x89ddbec,
inquery=0x89ddd0c "INSERT INTO user (id, nombre, login, passwd) VALUES (?,
?, ?, ?)", inquery_len=64, outquery=0x89ddc38,
outquery_len=0x89ddc3c) at
/d/software/Php/php-5.3.10/ext/pdo/pdo_sql_parser.c:585
#3 0x081f2d59 in zim_PDOStatement_execute (ht=0, return_value=0x89ddeec,
return_value_ptr=0x0, this_ptr=0x89dc1ec,
return_value_used=0) at /d/software/Php/php-5.3.10/ext/pdo/pdo_stmt.c:497
#4 0x083b2619 in zend_do_fcall_common_helper_SPEC (execute_data=0x8a0dcc8)
at /d/software/Php/php-5.3.10/Zend/zend_vm_execute.h:320
#5 0x083b1ca8 in execute (op_array=0x89db224) at
/d/software/Php/php-5.3.10/Zend/zend_vm_execute.h:107
#6 0x0838ced7 in zend_execute_scripts (type=8, retval=0x0, file_count=3) at
/d/software/Php/php-5.3.10/Zend/zend.c:1236
#7 0x0833b5de in php_execute_script (primary_file=0xbfffe5ac) at
/d/software/Php/php-5.3.10/main/main.c:2308
#8 0x0840f37b in main (argc=2, argv=0xbfffe714) at
/d/software/Php/php-5.3.10/sapi/cli/php_cli.c:1184
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=61259&edit=1
