python-ibmdb: Bug Report: V3.1.4 on z/OS abends S0C4 for function fetch_both() and returns a python UTF decode error for function field_name()
The errors described in this issue are occurring on the IBM Zxplore open learning system for z/OS (anyone can register to join at Zxplore Learning System). I am not an admin of that system and have no access to any software on that system except what the IBM Zxplore admins provide. I have no authority to install or upgrade software on that system, only the IBM Zxplore admins have that authority.
Please advise what I can communicate to the Zxplore admins to get assistance in resolving these issues.
-
Operating System Name: z/OS V2.4
-
db2level output from clidriver if in use:
-
Target Db2 Server Version: V12
-
Python Version: Python 3.9.2
-
ibm_db version: 3.1.4
-
For non-Windows, output of below commands: uname OS/390 uname -m 3931
-
Value of below environment variables if set: IBM_DB_HOME: DSNC10 PATH: /usr/lpp/IBM/cvg/go/bin:/usr/lpp/IBM/cyp/v3r9/pyz/bin:/usr/lpp/IBM/zoautil/bin:/usr/lpp/db2c10/jdbc/bin:/bin:/z/bin:.:/usr/lpp/java/J8.0_64/bin:/usr/lpp/zLiberty/V8R5/wlp/bin:/z/z02446/bin:/z/rocket/tools/bin:/usr/lpp/ported/bin:/usr/lpp/IBM/cnj/v18r0/IBM/node-latest-os390-s390x/bin:/usr/lpp/IBM/cnj/v18r0/njsc/bin:/global/node/bin:/usr/lpp/mqm/V9R1M1/web/bin:/usr/lpp/IBM/cobol/igyv6r4/bin LIB/LD_LIBRARY_PATH/DYLD_LIBRARY_PATH: /usr/lpp/db2c10/jdbc/lib
-
Test script to reproduce the problem.
-
For fetch_both() attached script db_fetch_both_err.py as text file
-
For field_name() attached script db_fetch_name_err.py as text file
Steps to Reproduce:
- python3.9 db_fetch_both_err.py
- python3.9 db_fetch_name_err.py
Output from test scripts for functions fetch_both() and field_name() (Zxplore userid masked) pasted below. Also uploaded here is the CEEDUMP output from the S0C4 abend as a zip fille.
CEEDUMP.20230528.175140.16842984.zip
/z/zxxxxx > python3.9 db_fetch_both_err.py
Test start fetch_both
Connection done
exec_immediate done
CEE3204S The system detected a protection exception (System Completion Code=0C4).
From compile unit TOROLABA:./Objects/object.c at entry point PyObject_Hash at statement 769 at compile unit offset +000000001C3A89B4 at entry offset +0000000000000074 at address 000000001C3A89B4.
Segmentation fault
/z/zxxxxx > python3.9 db_fetch_name_err.py
Test start field_name
Connection done
exec_immediate done
first fetch done
row 1 returned 3 columns: Traceback (most recent call last):
File "/z/zxxxxx/db_fetch_name_err.py", line 41, in <module>
colname = ibm_db.field_name(stmt, _i)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc5 in position 0: invalid continuation byte
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 63 (2 by maintainers)
Status report from Zxplore: Their
/etc/odbc.ini
file has been changed to the “mixed” tag and all my scripts are operating correctly without using my private copy of that fle, so at least no one else at Zxplore will run into the same issue that I did.Again, my thanks to everyone here for your patience and help.
I’ll reach out to my Db2 ODBC z/OS contact at SVL