#39115 [Com]: PDO Crashes Apache with null value in Postgres prepared statement

From: Date: Sat, 01 Mar 2008 02:47:44 +0000
Subject: #39115 [Com]: PDO Crashes Apache with null value in Postgres prepared statement
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-122819@lists.php.net to get a copy of this message 
 ID:               39115
 Comment by:       ruben at lingo dot com dot mx
 Reported By:      opensource at videinfra dot com
 Status:           No Feedback
 Bug Type:         PDO related
 Operating System: MAC OS X
 PHP Version:      5.1.6
 New Comment:

I'm getting the same behavior. When PDO->prepare the thread disconnects

from postgresql.

SQLite works fine.

Mac OS X tiger 10.4.11
PHP 5.2.3 compiled from source
Postgresql 8.1.3

I have syck loaded from PECL and some PEAR stuff.


Previous Comments:
------------------------------------------------------------------------

[2006-10-18 01:00:00] 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-10-10 13:43:35] tony2001@php.net

Please try using this CVS snapshot:

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



------------------------------------------------------------------------

[2006-10-10 13:30:45] opensource at videinfra dot com

Description:
------------
Apache2 crashes when call is made to execute prepared 
statement with null parameters.
Usign PDO-PostgreSQL

Apache 2.0
PostgreSql 8.1
PHP 5,1.6

Reproduce code:
---------------
$dbh=new PDO("pgsql:yourdb");
$sth = $dbh->prepare('SELECT * from "table" WHERE "field1"= ? AND
"field2"= ?');
$sth->execute(array(null,null));

<crash>

Actual result:
--------------
Crash reporter output:



Thread 7 Crashed:
0   libpq.4.dylib       0x007b161e parseInput + 6
1   libpq.4.dylib       0x007b1eb6 PQgetResult + 31
2   libpq.4.dylib       0x007b2229 PQexecStart + 50
3   libpq.4.dylib       0x007b242d PQexec + 21
4   libphp5.so          0x020f18ab pgsql_stmt_dtor + 111
5   libphp5.so          0x020ed125 free_statement + 214
6   libphp5.so          0x022ebc06 
zend_objects_store_free_object_storage + 58
7   libphp5.so          0x022bddce shutdown_executor + 947
8   libphp5.so          0x022cc63d zend_deactivate + 226
9   libphp5.so          0x0227d4db php_request_shutdown + 
848
10  libphp5.so          0x0236cbcc php_handler + 2003
11  apache2             0x0001e430 ap_run_handler + 59 
(config.c:152)
12  apache2             0x0001e833 ap_invoke_handler + 87 
(config.c:366)
13  apache2             0x0000cb86 ap_process_request + 375 
(http_request.c:249)
14  apache2             0x00006e1d 
ap_process_http_connection + 297 (http_core.c:253)
15  apache2             0x0002ab62 ap_run_process_connection 
+ 59 (connection.c:43)
16  apache2             0x0002ae80 ap_process_connection + 
69 (connection.c:178)
17  apache2             0x0001b509 worker_thread + 545 
(threadpool.c:683)
18  libapr-0.0.dylib    0x00715f51 dummy_worker + 22 
(thread.c:106)
19  libSystem.B.dylib   0x90023d87 _pthread_body + 84


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=39115&edit=1

Thread (3 messages)

« previous php.bugs (#122819) next »