NYCPHP Meetup

[Joshua Hart]

Hi All!

Does anybody have some hints as to what might be causing a problem
(segfault) with Oracle's instantclient when used in conjunction with PHP
5.2.4 (both the CLI and a webserver -- apache 2.x).

If I run simple queries I get a result -- no problem. (select * from atable
where name='hart')  However if I do any more complicated query (select from
two tables via a join for example) I get a segmentation fault (again both
with the CLI and it segfaults the httpd process).

All programs are built from source (except instantclient which I downloaded
from oracle). I'm running on SLES10 on an ia64 platform.

The info PHP identifies as the system:

Linux ssaturn 2.6.16.21-0.8-default #1 SMP Mon Jul 3 18:25:39 UTC 2006 ia64

Oracle is instantclient ia64-10.2.0.3-20061230

oci8 version 1.2.3  revision 1.269.2.16.2.37

Here's my configure command for PHP:

'./configure' '--with-zlib' '--with-gd' '--with-jpeg' '--with-png'
'--with-libxml2=/usr/bin' '--with-mysql=/usr/local/mysql5120'
'--with-apxs2=/usr/local/apache2/bin/apxs' '--enable-ftp'
'--with-imap-ssl=/usr/include/ssl'
'--with-imap=/space/custom_builds/imap-stuff/' '--with-openssl' '--with-pam'
'--with-dom' '--with-iconv' '--with-mbstring=all' '--with-mbregex'
'--with-domsxlt' '--with-mcrypt' '--with-xml' '--with-mime-magic'
'--enable-exif' '--enable-uploadprogress' '--with-xmlrpc' '--with-gettext'
'--with-pgsql' '--with-oci8=instantclient,/usr/local/oracle'

Again, I can successfully login to the oracle database, and the simplest of
queries works. Anything "complicated" crashes the program.

I saw on php.net messages about memory exhaustion and segfaults.. Since I'm
using the most recent version of PHP I would not think that getting a
updated PECL package is going to do the trick.  I increased the amt of
memory a script can use (in php.ini) to 128Mb but no difference. Is there
somehwere else I should be changing a setting?

Not sure what else to try..

Thanks!

Joshua