Crash fetching CLOB columns with Oracle Client 21 about oracle_fdw HOT 9 CLOSED

What are you trying to tell me?

from oracle_fdw.

MAIN LOG PARTS - DEBUG2_LEVEL.txt
TABLE_DATA_INFORMATION.txt
HARDWARE_INFORMATION.txt
ORACLE_FDW_DIAG.txt
TABLE_DESCRIPTION.txt

from oracle_fdw.

Excuse me Laurenz.

I'm using oracle_fdw to migrate an Oracle XE 21c database to Postgreql 16.2.
When I select the first or the last 100 records of a table with CLOB column it is functioning perfectly. But, when I select all records Postgres does an unexpected shutdown.
This occurs with other tables that contain CLOB columns, but I think better to focuse at that one.
The table has 233831 and the longest CLOB record length is 155747.

All the details are at the attached files.

I'm ready If you need more information about the case.

Thank you for your prompted attention.

Best Regrds,

Cláudio Ruiz.

from oracle_fdw.

The database was renamed to DATABASE_NAME because a NDA.

from oracle_fdw.

I see no crash in the log.

Does the oracle_fdw snapshot you are using have commit d62b876 in it?

There is pretty little I can do about that without a reproducible test case, or at least a stack trace from the crash (if there is a crash).

from oracle_fdw.

I'll try to grab a crash dump.

from oracle_fdw.

Hi Laurenz,

I read in one of our colleagues' post that the problem could be in version 21 of the Oracle client. I followed the instructions in the post, removed version 21, installed version 19 and the problem was resolved.

Thank you!

Best Regards,

Cláudio Ruiz

from oracle_fdw.

Thanks for letting me know.
The current README has a warning not to use Oracle client 21.

from oracle_fdw.

Duplicate of #643 and #614.

from oracle_fdw.