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

Traces are here : https://drive.google.com/file/d/1w3yW8WbS7VLkAxv23m0OfwxSmmz21XG2/view?usp=sharing

Regards,

Stanislav

Hi.

Phpinfo here : https://drive.google.com/file/d/1cpwdNarX4AR6ejKE2BBT1AvzBhPmbHAx/view?usp=sharing

I'm still working on reproductible and public testcase. Codebase is quite big and I need to minimize to be as small as possible. Running simple single SQL (which is failing) is not sufficient, because it doesn't reproduce problem. It looks like several conditions must be met and also identified to provide successfull testcase.

Regards,

Stanislav

Okay, after some time of settling down here is the testcase. Actually it's about binding NULL.

It will SIGSEGV all clients (instant and full) from version 12.2. to 21.1.

Reported in SR 3-25065306931 : 19.9. Instantclient SIGSEGV (__intel_ssse3_rep_memcpy) @ libclntsh.so.19.1

putenv("ORACLE_BASE=/u01/app/oracle");

putenv("LD_LIBRARY_PATH=/u01/app/oracle/client/lib:/usr/lib:/lib");

putenv("ORACLE_HOME=/u01/app/oracle/client");

putenv("NLS_LANG=AMERICAN_AMERICA.AL32UTF8");

putenv("NLS_SORT=BINARY");

putenv("TNS_ADMIN=/u01/app/oracle/client/network/admin");

putenv("ORA_CLIENTTRACE_DIR=/tmp");

putenv("EVENT_10842=server=all;user=W3;stmt=all;level=15");

$per_id = null;

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

$bax = array(

'p_per_id' => $per_id

,'p_right_level_code' => 'RA'

);

$connection = oci_pconnect('DB_USERNAME', 'DB_PASSWORD', 'POOLED_DB_DSN', 'AL32UTF8');

if ($connection === false) {

if (isset($connection)) {

$error = oci_error($connection);

} else {

$error = oci_error();

}

die("ERROR connection : $error");

}

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

if ($ociStatement === false) {

$error = oci_error($connection);

oci_close($connection);

$connection = null;

die("oci_prepare error: $error");

}

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

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

$error = oci_error($ociStatement);

oci_free_statement($ociStatement);

oci_close($connection);

$connection = null;

die("oci_bin_by_name error: $error");

}

}

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

$error = oci_error($ociStatement);

oci_free_statement($ociStatement);

oci_close($connection);

$connection = null;

die("oci_execute error: $error");

}

oci_free_statement($ociStatement);

oci_close($connection);

$connection = null;

PHP 7.2 + OCI8 2.2.0