Python Kernel dies when using ibm_db.connect

[parodayco]

Issue Type: Bug

My python kernel dies when I run ibm_db.connect() or ibm_db_dbi.connect() in VS Code Jupyter notebook cells. Here is the console output:

Error 08:48:19: Disposing session as kernel process died ExitCode: undefined, Reason: /usr/local/lib/python3.9/site-packages/traitlets/traitlets.py:2202: FutureWarning: Supporting extra quotes around strings is deprecated in traitlets 5.0. You can use 'hmac-sha256' instead of '"hmac-sha256"' if you require traitlets >=5.
  warn(
/usr/local/lib/python3.9/site-packages/traitlets/traitlets.py:2157: FutureWarning: Supporting extra quotes around Bytes is deprecated in traitlets 5.0. Use 'b13bc39e-6f5f-4a5e-b875-93a86653eb31' instead of 'b"b13bc39e-6f5f-4a5e-b875-93a86653eb31"'.
  warn(

Info 08:48:19: Dispose Kernel process
Error 08:48:19: Raw kernel process exited code: undefined

I cannot reproduce the issue outside of the VS Code Jupyter renderer; the same function runs fine as a python script in VS Code and in a local Jupyterlab environment. In all cases, I'm using the same python environment and packages.

MacOS 12.2.1
Python 3.9.10
python3 -m pip install ipykernel jupyterlab pandas ibm-db

Extension version: 2022.2.1924087327
VS Code version: Code 1.65.2 (c722ca6c7eed3d7987c0d5c3df5c45f6b15e77d1, 2022-03-10T14:33:49.188Z)
OS version: Darwin x64 21.3.0
Restricted Mode: No

System Info

Item	Value
CPUs	Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz (16 x 2400)
GPU Status	2d_canvas: enabled gpu_compositing: enabled metal: disabled_off multiple_raster_threads: enabled_on oop_rasterization: enabled opengl: enabled_on rasterization: enabled skia_renderer: disabled_off_ok video_decode: enabled webgl: enabled webgl2: enabled
Load (avg)	2, 2, 2
Memory (System)	32.00GB (3.73GB free)
Process Argv	--crash-reporter-id 91bde56a-ddbf-4e4b-9ab2-5db38b83b07e
Screen Reader	no
VM	0%

Extensions (11)

Extension	Author (truncated)	Version
gather	ms-	2022.3.0
python	ms-	2022.2.1924087327
vscode-pylance	ms-	2022.3.1
jupyter	ms-	2022.2.1030672458
jupyter-renderers	ms-	1.0.6
remote-containers	ms-	0.224.2
remote-ssh	ms-	0.76.1
remote-ssh-edit	ms-	0.76.1
autodocstring	njp	0.6.1
vscode-data-preview	Ran	2.3.0
vscodeintellicode	Vis	1.2.17

A/B Experiments

vsliv368cf:30146710
vsreu685:30147344
python383:30185418
vspor879:30202332
vspor708:30202333
vspor363:30204092
vswsl492cf:30256860
vstes627:30244334
pythonvspyl392:30443607
pythontb:30283811
pythonptprofiler:30281270
vshan820:30294714
vstes263:30335439
vscorecescf:30445987
pythondataviewer:30285071
vscod805cf:30301675
pythonvspyt200:30340761
binariesv615:30325510
bridge0708:30335490
bridge0723:30353136
vsaa593:30376534
vsc1dst:30438360
pythonvs932:30410667
wslgetstarted:30449410
vsclayoutctrt:30451275
dsvsc008:30440022
pythonvsnew555:30450902
vscscmwlcmt:30438805
vscgsvidc:30447482
cppdebugcf:30451567
pynewfile477cf:30450039

[MeganBeckett]

I'm also having these issues with VScode and running Jupyter notebooks - it happens with several cells, at different points in the notebook, so for me, it's not linked to running a specific function.

The error message is exactly the same as above.

Package              Version
-------------------- ------------
aiobotocore          2.1.2
aiohttp              3.8.1
aioitertools         0.10.0
aiosignal            1.2.0
argon2-cffi          21.3.0
argon2-cffi-bindings 21.2.0
asttokens            2.0.5
async-timeout        4.0.2
attrs                21.4.0
backcall             0.2.0
bleach               4.1.0
botocore             1.23.24
branca               0.4.2
certifi              2021.10.8
cffi                 1.15.0
charset-normalizer   2.0.12
cycler               0.11.0
debugpy              1.5.1
decorator            5.1.1
defusedxml           0.7.1
descartes            1.1.0
entrypoints          0.4
executing            0.8.3
folium               0.12.1.post1
fonttools            4.30.0
frozenlist           1.3.0
fsspec               2022.2.0
idna                 3.3
ipykernel            6.9.1
ipython              8.1.1
ipython-genutils     0.2.0
ipywidgets           7.6.5
jedi                 0.18.1
Jinja2               3.0.3
jmespath             0.10.0
jsonschema           4.4.0
jupyter              1.0.0
jupyter-client       7.1.2
jupyter-console      6.4.3
jupyter-core         4.9.2
jupyterlab-pygments  0.1.2
jupyterlab-widgets   1.0.2
kiwisolver           1.3.2
MarkupSafe           2.1.0
matplotlib           3.5.1
matplotlib-inline    0.1.3
mistune              0.8.4
mizani               0.7.3
multidict            6.0.2
nbclient             0.5.13
nbconvert            6.4.2
nbformat             5.2.0
nest-asyncio         1.5.4
notebook             6.4.8
numpy                1.22.3
packaging            21.3
palettable           3.3.0
pandas               1.4.1
pandocfilters        1.5.0
parso                0.8.3
pathlib              1.0.1
patsy                0.5.2
pexpect              4.8.0
pickleshare          0.7.5
Pillow               9.0.1
pip                  22.0.3
plotnine             0.8.0
prometheus-client    0.13.1
prompt-toolkit       3.0.28
ptyprocess           0.7.0
pure-eval            0.2.2
pycparser            2.21
Pygments             2.11.2
pyparsing            3.0.7
pyrsistent           0.18.1
python-dateutil      2.8.2
pytz                 2021.3
pyzmq                22.3.0
qtconsole            5.2.2
QtPy                 2.0.1
requests             2.27.1
s3fs                 2022.2.0
scipy                1.8.0
Send2Trash           1.8.0
setuptools           60.9.3
six                  1.16.0
stack-data           0.2.0
statsmodels          0.13.2
terminado            0.13.3
testpath             0.6.0
tornado              6.1
traitlets            5.1.1
typing_extensions    4.1.1
urllib3              1.26.8
wcwidth              0.2.5
webencodings         0.5.1
wheel                0.37.1
widgetsnbextension   3.5.2
wrapt                1.14.0
yarl                 1.7.2

[parodayco]

Thanks, @MeganBeckett. Can you confirm that your code cells will run as separate python scripts in VS Code without triggering a kernel panic? Also in ipython and/or jupyter environment (Jupyterlab etc) outside VS Code? There is some extra process in VS Code Jupyter that does not occur elsewhere.

[DonJayamanne]

@parodayco @MeganBeckett
Please could you provide the output from the Jupyter output panel

[parodayco]

@DonJayamanne I pasted that in my initial post, the error message is from the Jupyter output panel

[DonJayamanne]

@parodayco Please could you paste all of the output, i'd like to see the initial logs with information about the interpreter and paths, and the like.

Please could you also provide the following info:

• Run the following in the terminal and provide the output for that
  which python3
• Sample code that fails in VS Code and works successfully in Jupyter
• Please confirm the kernel dies at the exact moment when you run the following code. Possible some environment variables or the like are different and causing this block of code to fail.
  ibm_db.connect() or ibm_db_dbi.connect()
• Please run the following in vs code and jupyter and compare the values for the env and path variable.
  I suspect some env variable or path variable isn't correct and causing the package to take the process down.
  Would help if you could identify the different (or perhaps share the values from both & I could look for the differences)

import os
print(os.environ)

import sys
print(sys.path)

[kfchou]

I'm experiencing the same issue when I run dataframe.to_parquet().

error message:

Error 10:32:49: Disposing session as kernel process died ExitCode: undefined, Reason: /home/kfchou/anaconda3/envs/obs-resp/lib/python3.8/site-packages/traitlets/traitlets.py:2202: FutureWarning: Supporting extra quotes around strings is deprecated in traitlets 5.0. You can use 'hmac-sha256' instead of '"hmac-sha256"' if you require traitlets >=5.
  warn(
/home/kfchou/anaconda3/envs/obs-resp/lib/python3.8/site-packages/traitlets/traitlets.py:2157: FutureWarning: Supporting extra quotes around Bytes is deprecated in traitlets 5.0. Use '684fb716-4f0e-4ca1-b66c-fea21b2dfa18' instead of 'b"684fb716-4f0e-4ca1-b66c-fea21b2dfa18"'.
  warn(

Info 10:32:49: Dispose Kernel process

I'm running Ubuntu (WSL) in windows.

Python 3.8.10

VS code info:
Version: 1.65.0 (user setup)
Commit: b5205cc8eb4fbaa726835538cd82372cc0222d43
Date: 2022-03-02T11:12:08.962Z
Electron: 13.5.2
Chromium: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Windows_NT x64 10.0.19042

edit: My issue was resolved by using pyarrow rather than fastparquet