#26043 [Opn-Csd]: pg_lo_import causes crash under all circumstances
ID: 26043 Updated by: [EMAIL PROTECTED] Reported By: dqj at requesttech dot com -Status: Open +Status: Closed Bug Type: PostgreSQL related Operating System: Redhat 9.0 PHP Version: 4.3.3 New Comment: This crash happens only when pgsql and odbc modules are installed and enabled together. Previous Comments: [2003-11-26 17:18:40] [EMAIL PROTECTED] 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 0x0002 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-02 16:16:30] [EMAIL PROTECTED] Cannot replicate using latest CVS. [2003-10-31 20:49:06] 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-10-31 16:45:17] [EMAIL PROTECTED] 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-30 14:32:24] dqj at requesttech dot com Forgot to mention that the Postgres version is 7.3.4. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/26043 -- Edit this bug report at http://bugs.php.net/?id=26043edit=1
#26043 [Opn-Csd]: pg_lo_import causes crash under all circumstances
ID: 26043 Updated by: [EMAIL PROTECTED] Reported By: dqj at requesttech dot com -Status: Open +Status: Closed Bug Type: PostgreSQL related Operating System: Redhat 9.0 PHP Version: 4.3.3 New Comment: Cannot replicate using latest CVS. Previous Comments: [2003-10-31 20:49:06] 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-10-31 16:45:17] [EMAIL PROTECTED] 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-30 14:32:24] dqj at requesttech dot com Forgot to mention that the Postgres version is 7.3.4. [2003-10-30 14:26:13] 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 13:48:23] 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: $oidbr/; 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.) -- Edit this bug report at http://bugs.php.net/?id=26043edit=1
