Memory allocation error: pdo-odbc

[ALPBRCH]

Hello,

Since php version 8.1, the following error occurs when writing to the DB:
Fehler SQL: SQLSTATE[HY001]: Memory allocation error: [IBM][System i Access ODBC-Treiber]Speicherzuordnungsfehler. (SQLPrepare[0] at /builddir/build/BUILD/php-8.2.21/ext/pdo_odbc/odbc_driver.c:200).

Situation:
Linux-Oracle-Server:
PHP 8.3.9 (x86_64)
IBM iSeries:
ibm-iaccess-1.1.0.28-1.0.x86_64

No problems with php-8.0!

Best regards
Jürgen Immel

[cmb69]

This is the repository of the German translation – I'm transferring to php-src.

[cmb69]

The mentioned line would be

php-src/ext/pdo_odbc/odbc_driver.c

Line 200 in 482ca6c

pdo_odbc_stmt_error("SQLPrepare");

Maybe @NattyNarwhal has an idea what might be wrong there. Other than that, we probably need a small self-contained reproduce script, and perhaps an ODBC trace would also be helpful.

[ALPBRCH]

test_odbc.txt
This is a simple example of a script. Out of 10 inserts, 3 work.

[NattyNarwhal]

Do you have the CREATE TABLE definition?

[ALPBRCH]

bestkopf.sql.txt

[ALPBRCH]

Hi,
some additional information:
Linux Server->
unixODBC.x86_64 2.3.7-1.el8

IBM Power 9
Release V7R3M0

[NattyNarwhal]

I'll take a look at this this week; I was on vacation last week.

[NattyNarwhal]

I'm confused because I look at that CREATE TABLE definition and it's for MySQL, but the driver issue is for Db2i.

[ALPBRCH]

Hi, Sorry, you're right. The create is from Mysql. The DB2 database was created with a DDL description which unfortunately I cannot provide. Regards, Jürgen Von: Calvin Buckley ***@***.***> Gesendet: Donnerstag, 8. August 2024 16:47 An: php/php-src ***@***.***> Cc: Jürgen Immel ***@***.***>; Author ***@***.***> Betreff: Re: [php/php-src] Memory allocation error: pdo-odbc (Issue #15113) I'm confused because I look at that CREATE TABLE definition and it's for MySQL, but the driver issue is for Db2i. — Reply to this email directly, view it on GitHub<#15113 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A3DGO54UVRB4G42V4CDSG73ZQOAH5AVCNFSM6AAAAABLQEVUKOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENZWGAYTMMBTG4>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[ALPBRCH]

Hello,
I asked the developer to give me a create or DDL of the tables.

best regards-Jürgen

[ALPBRCH]

bestpos.txt
bestkopf.txt
Hi,
here the DDL of the tables.
Regards