php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #26043 pg_lo_import causes crash under all circumstances
Submitted: 2003-10-30 13:48 UTC Modified: 2003-11-27 01:04 UTC
From: dqj at requesttech dot com Assigned:
Status: Not a bug Package: PostgreSQL related
PHP Version: 4.3.3 OS: Redhat 9.0
Private report: No CVE-ID: None
View Developer Edit
 [2003-10-30 13:48 UTC] dqj at requesttech dot com 
Description:
------------
No changes to php.ini distribution.  No output shown in logs.  Just doesn't finish the page.  (I have put echoes and breaks in to narrow it to the pg_lo_import() call).  We have checked file permissions, etc.  This code has worked under PHP 4.2 and other versions.  Have tried switching the pg_lo_import parameters back and forth, just in case, as described in the bug documentation.



Reproduce code:
---------------
<?php
$res = pg_connect( "host=myhost dbname=mytest user=myuser password=zzz" );
pg_exec( $res, "BEGIN" );
$oid = pg_lo_import( $res, "/tmp/dqj.tmp" );
pg_exec( $res, "COMMIT" );
echo "RES: $res, OID: $oid<br/>"; flush();
?>


Expected result:
----------------
$oid should have a value. Echoed results should appear.


Actual result:
--------------
Blank page.  (Or echoed results prior to subroutine call, if debug is included.)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-10-30 14:26 UTC] dqj at requesttech dot com 
I was wrong about there not being anything in the logs.  In the httpd error_log, there was the following:

[Thu Oct 30 14:25:10 2003] [notice] child pid 16877 exit signal Segmentation fault (11)

This occurs whenever a valid filename is given to pg_lo_import.
 [2003-10-30 14:32 UTC] dqj at requesttech dot com 
Forgot to mention that the Postgres version is 7.3.4.
 [2003-10-31 16:45 UTC] iliaa@php.net 
if you can provide the file used to replicate the crash, it may be possible for us to test and see if the issue was in fact resolved.
 [2003-10-31 20:49 UTC] dqj at requesttech dot com 
Thank you!  To make it really simple and rule out file contents problems, I just did:

% echo "1" > /tmp/dqj.tmp

to create the file.

It also had failed with a .wav file prior to that.
 [2003-11-02 16:16 UTC] iliaa@php.net 
Cannot replicate using latest CVS.
 [2003-11-26 17:18 UTC] jtate@php.net 
It's not just pg_lo_import, but also pg_lo_create.  The backtrace is as follows:

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread -1226627936 (LWP 28034)]
0xb69f7987 in CC_send_function () from /usr/lib/libodbcpsql.so.2
(gdb) where
#0  0xb69f7987 in CC_send_function () from /usr/lib/libodbcpsql.so.2
#1  0xb6a06940 in lo_creat () from /usr/lib/libodbcpsql.so.2
#2  0xb69c6c23 in lo_import () from /usr/lib/libpq.so.3
#3  0xb69e4121 in zif_pg_lo_import (ht=2, return_value=0x8307424,
    this_ptr=0x0, return_value_used=1)
    at /usr/src/debug/php-4.3.2/ext/pgsql/pgsql.c:2099
#4  0xb697a542 in zend_assign_to_variable_reference ()
   from /usr/local/Zend/lib/Optimizer-2.1.0/php-4.3.x/ZendOptimizer.so
#5  0x00000002 in ?? ()
#6  0x08307424 in ?? ()

I can't tell yet whether this is a bug in PHP or in the pgsqlodbc libraries.

This backtrace is using the cli version of PHP on the test script provided (modified for my database).
 [2003-11-26 17:57 UTC] jtate@php.net 
This crash happens only when pgsql and odbc modules are installed and enabled together.
 [2003-11-27 01:04 UTC] sniper@php.net 
Not PHP bug.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Mon Oct 27 20:00:01 2025 UTC