SIGSEGV on Instantclient 12.2+ (18.5, 19.6) with OCI8-2.2.0

I tried on OL8.

dnf install -y php-xml php-devel php-cli php php-mbstring php-gd php-common php-pear php-json php-process

dnf install -y oracle-instantclient-release-el8

dnf install -y oracle-instantclient-basic oracle-instantclient-devel

echo "instantclient,/usr/lib/oracle/21/client64/lib" | pecl install oci8-2.2.0

Created the oci8 config file, as shown:

# cat /etc/php.d/99-oci8.ini 

extension=oci8.so

oci8.connection_class=W3POOL

;oci8.events=on

oci8.statement_cache_size = 250

oci8.persistent_timeout = 3600

oci8.ping_interval = 10

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

I used the script:

<?php

error_reporting(E_ALL);

ini_set('display_errors', 'On');

$connection = oci_connect('cj', 'cj', 'mdt/orclpdb1:pooled', 'AL32UTF8');

$per_id = null;

$sql = "SELECT count(*) FROM dual WHERE (:p_per_id IS NULL OR :p_per_id = :p_per_id) AND :p_right_level_code = 'RA'";

$bax = array(

  'p_per_id' => $per_id

  ,'p_right_level_code' => 'RA'

);

if ($connection === false) {

  $m = oci_error($connection);

  trigger_error('Could not connect to database: '. $m['message'], E_USER_ERROR);

}

$ociStatement = oci_parse($connection, $sql);

if ($ociStatement === false) {

  $m = oci_error($connection);

  trigger_error('Could not parse statement: '. $m['message'], E_USER_ERROR);

}

foreach ($bax as $param => &$value) {

  if (!oci_bind_by_name($ociStatement, $param, $value, -1, SQLT_CHR )) {

    $m = oci_error($ociStatement);

    trigger_error('Could not bind a parameter: '. $m['message'], E_USER_ERROR);

  }

}

if (!oci_execute($ociStatement, OCI_NO_AUTO_COMMIT)) {

  $m = oci_error($ociStatement);

  trigger_error('Could not execute statement: '. $m['message'], E_USER_ERROR);

}

oci_fetch_all($ociStatement, $r);

var_dump($r);

print("End\n")

?>

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

Ran the script:

php t.php

array(1) {

 ["COUNT(*)"]=>

 array(1) {

  [0]=>

  string(1) "1"

 }

}

End

I tried both a 19.3 DB and a 21c DB.

At this stage, you need to continue working on it. You need to share enough info about your environment so I can spot what is going on. (E.g. to check that you don't have ORACLE_HOME set when you are using Instant Client). You have to 'prove' it to me by showing me.

At the same time, work on the test script and triple-check any possible weak point even if you 'know' it is not a problem: eliminate DRCP. Unroll the bind loop to eliminate the reference use; change the bind to let the type default; see if it is an issue with repeated use of the bind name, etc. etc.