Info 14:39:04: Restart requested file:///Users/philipparodayco/Projects/WF360/test.ipynb Info 14:39:04: Restart kernel execution Info 14:39:04: Cancel pending cells Info 14:39:04: Starting raw kernel test (Python 3.9.12) for interpreter ~/.venv/test/bin/python Info 14:39:04: Restarting undefined Info 14:39:04: Kernel launching with ports 9000,9001,9002,9003,9004. Start port is 9000 Info 14:39:05: Process Execution: > ~/.venv/test/bin/python -c "import ipykernel; print(ipykernel.__version__); print("5dc3a68c-e34e-4080-9c3e-2a532b2ccb4d"); print(ipykernel.__file__)" > ~/.venv/test/bin/python -c "import ipykernel; print(ipykernel.__version__); print("5dc3a68c-e34e-4080-9c3e-2a532b2ccb4d"); print(ipykernel.__file__)" Info 14:39:05: Adding env Variable PYTHONNOUSERSITE to ~/.venv/test/bin/python Info 14:39:05: Process Execution: > ~/.venv/test/bin/python -m ipykernel_launcher --ip=127.0.0.1 --stdin=9003 --control=9001 --hb=9000 --Session.signature_scheme="hmac-sha256" --Session.key=b"426786fc-b22b-451d-96c5-85199ff6b80c" --shell=9002 --transport="tcp" --iopub=9004 --f=/var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json --debug > ~/.venv/test/bin/python -m ipykernel_launcher --ip=127.0.0.1 --stdin=9003 --control=9001 --hb=9000 --Session.signature_scheme="hmac-sha256" --Session.key=b"426786fc-b22b-451d-96c5-85199ff6b80c" --shell=9002 --transport="tcp" --iopub=9004 --f=/var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json --debug Info 14:39:05: Process Execution: cwd: ~/Projects/WF360 cwd: ~/Projects/WF360 Info 14:39:05: ipykernel version 6.13.0 for ~/.venv/test/bin/python Info 14:39:05: ipykernel location ~/.venv/test/lib/python3.9/site-packages/ipykernel/__init__.py for ~/.venv/test/bin/python Warn 14:39:05: StdErr from Kernel Process /Users/philipparodayco/.venv/test/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( Warn 14:39:05: StdErr from Kernel Process /Users/philipparodayco/.venv/test/lib/python3.9/site-packages/traitlets/traitlets.py:2157: FutureWarning: Supporting extra quotes around Bytes is deprecated in traitlets 5.0. Use '426786fc-b22b-451d-96c5-85199ff6b80c' instead of 'b"426786fc-b22b-451d-96c5-85199ff6b80c"'. warn( Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Using existing profile dir: '/Users/philipparodayco/.ipython/profile_default' Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Searching path ['/Users/philipparodayco/.ipython/profile_default', '/Users/philipparodayco/.venv/test/etc/ipython', '/usr/local/etc/ipython', '/etc/ipython'] for config files Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Attempting to load config file: ipython_config.py [IPKernelApp] Looking for ipython_config in /etc/ipython Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Looking for ipython_config in /usr/local/etc/ipython Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Looking for ipython_config in /Users/philipparodayco/.venv/test/etc/ipython [IPKernelApp] Looking for ipython_config in /Users/philipparodayco/.ipython/profile_default Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Attempting to load config file: ipython_kernel_config.py Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Looking for ipython_kernel_config in /etc/ipython [IPKernelApp] Looking for ipython_kernel_config in /usr/local/etc/ipython [IPKernelApp] Looking for ipython_kernel_config in /Users/philipparodayco/.venv/test/etc/ipython Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Looking for ipython_kernel_config in /Users/philipparodayco/.ipython/profile_default Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Connection file not found: /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Starting the kernel at pid: 74993 Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] shell ROUTER Channel on port: 9002 Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] stdin ROUTER Channel on port: 9003 Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] control ROUTER Channel on port: 9001 Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] iopub PUB Channel on port: 9004 Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Heartbeat REP Channel on port: 9000 Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Writing connection file: /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] To connect another client to this kernel, use: Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] --existing /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json Info 14:39:05: Kernel Output: NOTE: When using the `ipython kernel` entry point, Ctrl-C will not work. To exit, you will have to explicitly quit this process, by either sending "quit" from a client, or using Ctrl-\ in UNIX-like environments. To read more about this, see https://github.com/ipython/ipython/issues/2049 To connect another client to this kernel, use: --existing /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Seeing logger to stderr, rerouting to raw filedescriptor. Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Loading IPython extensions... Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Loading IPython extension: storemagic Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:kernel_info_request*** Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Content: {} ---> [IPKernelApp] kernel_info_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 823000, tzinfo=tzutc()), 'msg_id': '711c31de-4ca1-4867-85bc-1efa160160c0', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '711c31de-4ca1-4867-85bc-1efa160160c0', 'msg_type': 'kernel_info_request', 'parent_header': {}, 'metadata': {}, 'content': {}, 'buffers': []} Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_3', 'msg_type': 'kernel_info_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 826729, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_3', 'msg_type': 'kernel_info_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 823000, tzinfo=tzutc()), 'msg_id': '711c31de-4ca1-4867-85bc-1efa160160c0', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'protocol_version': '5.3', 'implementation': 'ipython', 'implementation_version': '8.2.0', 'language_info': {'name': 'python', 'version': '3.9.12', 'mimetype': 'text/x-python', 'codemirror_mode': {'name': 'ipython', 'version': 3}, 'pygments_lexer': 'ipython3', 'nbconvert_exporter': 'python', 'file_extension': '.py'}, 'banner': "Python 3.9.12 (main, Mar 26 2022, 15:51:15) \nType 'copyright', 'credits' or 'license' for more information\nIPython 8.2.0 -- An enhanced Interactive Python. Type '?' for help.\n", 'help_links': [{'text': 'Python Reference', 'url': 'https://docs.python.org/3.9'}, {'text': 'IPython Reference', 'url': 'https://ipython.org/documentation.html'}, {'text': 'NumPy Reference', 'url': 'https://docs.scipy.org/doc/numpy/reference/'}, {'text': 'SciPy Reference', 'url': 'https://docs.scipy.org/doc/scipy/reference/'}, {'text': 'Matplotlib Reference', 'url': 'https://matplotlib.org/contents.html'}, {'text': 'SymPy Reference', 'url': 'http://docs.sympy.org/latest/index.html'}, {'text': 'pandas Reference', 'url': 'https://pandas.pydata.org/pandas-docs/stable/'}]}, 'metadata': {}, 'tracker': } Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:kernel_info_request*** Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Content: {} ---> Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] kernel_info_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 824000, tzinfo=tzutc()), 'msg_id': '8a5f0140-da62-4fed-8d64-faaa4647d7e4', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '8a5f0140-da62-4fed-8d64-faaa4647d7e4', 'msg_type': 'kernel_info_request', 'parent_header': {}, 'metadata': {}, 'content': {}, 'buffers': []} Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_6', 'msg_type': 'kernel_info_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 829528, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_6', 'msg_type': 'kernel_info_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 824000, tzinfo=tzutc()), 'msg_id': '8a5f0140-da62-4fed-8d64-faaa4647d7e4', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'protocol_version': '5.3', 'implementation': 'ipython', 'implementation_version': '8.2.0', 'language_info': {'name': 'python', 'version': '3.9.12', 'mimetype': 'text/x-python', 'codemirror_mode': {'name': 'ipython', 'version': 3}, 'pygments_lexer': 'ipython3', 'nbconvert_exporter': 'python', 'file_extension': '.py'}, 'banner': "Python 3.9.12 (main, Mar 26 2022, 15:51:15) \nType 'copyright', 'credits' or 'license' for more information\nIPython 8.2.0 -- An enhanced Interactive Python. Type '?' for help.\n", 'help_links': [{'text': 'Python Reference', 'url': 'https://docs.python.org/3.9'}, {'text': 'IPython Reference', 'url': 'https://ipython.org/documentation.html'}, {'text': 'NumPy Reference', 'url': 'https://docs.scipy.org/doc/numpy/reference/'}, {'text': 'SciPy Reference', 'url': 'https://docs.scipy.org/doc/scipy/reference/'}, {'text': 'Matplotlib Reference', 'url': 'https://matplotlib.org/contents.html'}, {'text': 'SymPy Reference', 'url': 'http://docs.sympy.org/latest/index.html'}, {'text': 'pandas Reference', 'url': 'https://pandas.pydata.org/pandas-docs/stable/'}]}, 'metadata': {}, 'tracker': } Info 14:39:05: Got new session 7827b775-e6b2-4d85-8d7a-51a87862dcf2 Info 14:39:05: Started new restart session Info 14:39:05: Executing silently Code (idle) = import sys\nprint(sys.executable) Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:complete_request*** Warn 14:39:05: StdErr from Kernel Process [IPKernelApp] Content: {'code': '__file__.', 'cursor_pos': 9} ---> [IPKernelApp] complete_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 832000, tzinfo=tzutc()), 'msg_id': 'a9d8e81a-cdb8-4599-913b-3b4ba75fa101', 'msg_type': 'complete_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'a9d8e81a-cdb8-4599-913b-3b4ba75fa101', 'msg_type': 'complete_request', 'parent_header': {}, 'metadata': {}, 'content': {'code': '__file__.', 'cursor_pos': 9}, 'buffers': []} Warn 14:39:06: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:execute_request*** Warn 14:39:06: StdErr from Kernel Process [IPKernelApp] Content: {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import sys\nprint(sys.executable)'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 832000, tzinfo=tzutc()), 'msg_id': 'a99bbd9f-431e-44bf-b5a1-62bb840c0546', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'a99bbd9f-431e-44bf-b5a1-62bb840c0546', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {}, 'content': {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import sys\nprint(sys.executable)'}, 'buffers': []} Warn 14:39:06: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_14', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 249117, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_14', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 832000, tzinfo=tzutc()), 'msg_id': 'a99bbd9f-431e-44bf-b5a1-62bb840c0546', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 0, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 6, 241977, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } Info 14:39:06: Executing silently Code (completed) = import sys\nprint(sys.executable) Info 14:39:06: UpdateWorkingDirectoryAndPath in Kernel Info 14:39:06: Executing silently Code (idle) = import site\nsite.addsitedir(site.getusersitepackages())\nimport os\nimport sys\n%cd "/Users/philipparod Warn 14:39:06: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:execute_request*** Warn 14:39:06: StdErr from Kernel Process [IPKernelApp] Content: {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import site\nsite.addsitedir(site.getusersitepackages())\nimport os\nimport sys\n%cd "/Users/philipparodayco/Projects/WF360"\nif os.getcwd() not in sys.path:\n sys.path.insert(0, os.getcwd())\n__vsc_ipynb_file__ = "/Users/philipparodayco/Projects/WF360/test.ipynb"\n%config Completer.use_jedi = False'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 259000, tzinfo=tzutc()), 'msg_id': '85f36d3e-78e2-4044-90cf-cbf27f491909', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '85f36d3e-78e2-4044-90cf-cbf27f491909', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {}, 'content': {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import site\nsite.addsitedir(site.getusersitepackages())\nimport os\nimport sys\n%cd "/Users/philipparodayco/Projects/WF360"\nif os.getcwd() not in sys.path:\n sys.path.insert(0, os.getcwd())\n__vsc_ipynb_file__ = "/Users/philipparodayco/Projects/WF360/test.ipynb"\n%config Completer.use_jedi = False'}, 'buffers': []} Warn 14:39:06: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_19', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 272374, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_19', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 259000, tzinfo=tzutc()), 'msg_id': '85f36d3e-78e2-4044-90cf-cbf27f491909', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 0, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 6, 260842, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } Info 14:39:06: Executing silently Code (completed) = import site\nsite.addsitedir(site.getusersitepackages())\nimport os\nimport sys\n%cd "/Users/philipparod Info 14:39:06: Waiting for idle on (kernel): 7827b775-e6b2-4d85-8d7a-51a87862dcf2 -> idle Info 14:39:06: Finished waiting for idle on (kernel): 7827b775-e6b2-4d85-8d7a-51a87862dcf2 -> idle Info 14:39:24: Execute Cells request 0 Info 14:39:24: Execute Cell 0 ~/Projects/WF360/test.ipynb Warn 14:39:24: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:execute_request*** Warn 14:39:24: StdErr from Kernel Process [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import ibm_db, ibm_db_dbi as dbi\nimport json, sys'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 24, 755000, tzinfo=tzutc()), 'msg_id': '586f5357-f3ca-4127-a38f-9ae200b1fb45', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '586f5357-f3ca-4127-a38f-9ae200b1fb45', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000000'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import ibm_db, ibm_db_dbi as dbi\nimport json, sys'}, 'buffers': []} Warn 14:39:24: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_23', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 24, 779389, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_23', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 24, 755000, tzinfo=tzutc()), 'msg_id': '586f5357-f3ca-4127-a38f-9ae200b1fb45', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 1, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 24, 757732, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } Info 14:39:24: Cell 0 executed with state Success Info 14:39:35: Execute Cells request 1 Info 14:39:35: Execute Cell 1 ~/Projects/WF360/test.ipynb Warn 14:39:35: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:execute_request*** Warn 14:39:35: StdErr from Kernel Process [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'sys.path'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 35, 472000, tzinfo=tzutc()), 'msg_id': '0efec9a0-78e8-41d9-b72a-e622e1309d8b', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '0efec9a0-78e8-41d9-b72a-e622e1309d8b', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000001'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'sys.path'}, 'buffers': []} Warn 14:39:35: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_28', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 35, 484119, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_28', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 35, 472000, tzinfo=tzutc()), 'msg_id': '0efec9a0-78e8-41d9-b72a-e622e1309d8b', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 2, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 35, 473950, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } Info 14:39:35: Cell 1 executed with state Success Info 14:39:42: Execute Cells request 3 Info 14:39:42: Execute Cell 3 ~/Projects/WF360/test.ipynb Warn 14:39:42: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:execute_request*** Warn 14:39:42: StdErr from Kernel Process [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "with open('connection.json', 'r') as myfile:\n WF360 = json.loads(myfile.read())"} ---> Warn 14:39:42: StdErr from Kernel Process [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 42, 704000, tzinfo=tzutc()), 'msg_id': 'b76175ca-af89-4d63-a286-9798888627bf', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'b76175ca-af89-4d63-a286-9798888627bf', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000003'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "with open('connection.json', 'r') as myfile:\n WF360 = json.loads(myfile.read())"}, 'buffers': []} Warn 14:39:42: StdErr from Kernel Process [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_32', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 42, 709024, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_32', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 42, 704000, tzinfo=tzutc()), 'msg_id': 'b76175ca-af89-4d63-a286-9798888627bf', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 3, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 42, 706238, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } Info 14:39:42: Cell 3 executed with state Success Info 14:40:02: Execute Cells request 5 Info 14:40:02: Execute Cell 5 ~/Projects/WF360/test.ipynb Warn 14:40:02: StdErr from Kernel Process [IPKernelApp] *** MESSAGE TYPE:execute_request*** Warn 14:40:02: StdErr from Kernel Process [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "conn = dbi.connect(\n (\n 'database={};'\n 'hostname={};'\n 'port={};'\n 'apikey={};'\n 'authentication=gssplugin;'\n 'protocol=tcpip;'\n 'security=ssl;'\n ).format(\n WF360.get('database'),\n WF360.get('host'),\n WF360.get('port'),\n WF360.get('api_key')\n ),'','')"} ---> Warn 14:40:02: StdErr from Kernel Process [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 40, 2, 181000, tzinfo=tzutc()), 'msg_id': 'eb6a0e52-7422-4cd7-b6db-977e20b51a39', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'eb6a0e52-7422-4cd7-b6db-977e20b51a39', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000005'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "conn = dbi.connect(\n (\n 'database={};'\n 'hostname={};'\n 'port={};'\n 'apikey={};'\n 'authentication=gssplugin;'\n 'protocol=tcpip;'\n 'security=ssl;'\n ).format(\n WF360.get('database'),\n WF360.get('host'),\n WF360.get('port'),\n WF360.get('api_key')\n ),'','')"}, 'buffers': []} Error 14:40:02: Disposing session as kernel process died ExitCode: undefined, Reason: /Users/philipparodayco/.venv/test/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( /Users/philipparodayco/.venv/test/lib/python3.9/site-packages/traitlets/traitlets.py:2157: FutureWarning: Supporting extra quotes around Bytes is deprecated in traitlets 5.0. Use '426786fc-b22b-451d-96c5-85199ff6b80c' instead of 'b"426786fc-b22b-451d-96c5-85199ff6b80c"'. warn( [IPKernelApp] Using existing profile dir: '/Users/philipparodayco/.ipython/profile_default' [IPKernelApp] Searching path ['/Users/philipparodayco/.ipython/profile_default', '/Users/philipparodayco/.venv/test/etc/ipython', '/usr/local/etc/ipython', '/etc/ipython'] for config files [IPKernelApp] Attempting to load config file: ipython_config.py [IPKernelApp] Looking for ipython_config in /etc/ipython [IPKernelApp] Looking for ipython_config in /usr/local/etc/ipython [IPKernelApp] Looking for ipython_config in /Users/philipparodayco/.venv/test/etc/ipython [IPKernelApp] Looking for ipython_config in /Users/philipparodayco/.ipython/profile_default [IPKernelApp] Attempting to load config file: ipython_kernel_config.py [IPKernelApp] Looking for ipython_kernel_config in /etc/ipython [IPKernelApp] Looking for ipython_kernel_config in /usr/local/etc/ipython [IPKernelApp] Looking for ipython_kernel_config in /Users/philipparodayco/.venv/test/etc/ipython [IPKernelApp] Looking for ipython_kernel_config in /Users/philipparodayco/.ipython/profile_default [IPKernelApp] Connection file not found: /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json [IPKernelApp] Starting the kernel at pid: 74993 [IPKernelApp] shell ROUTER Channel on port: 9002 [IPKernelApp] stdin ROUTER Channel on port: 9003 [IPKernelApp] control ROUTER Channel on port: 9001 [IPKernelApp] iopub PUB Channel on port: 9004 [IPKernelApp] Heartbeat REP Channel on port: 9000 [IPKernelApp] Writing connection file: /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json [IPKernelApp] To connect another client to this kernel, use: [IPKernelApp] --existing /var/folders/jk/y6s_ywyd4tlg48r_nv7775q80000gn/T/tmp-74777GPLHqsOZsEXR.json [IPKernelApp] Seeing logger to stderr, rerouting to raw filedescriptor. [IPKernelApp] Loading IPython extensions... [IPKernelApp] Loading IPython extension: storemagic [IPKernelApp] *** MESSAGE TYPE:kernel_info_request*** [IPKernelApp] Content: {} ---> [IPKernelApp] kernel_info_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 823000, tzinfo=tzutc()), 'msg_id': '711c31de-4ca1-4867-85bc-1efa160160c0', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '711c31de-4ca1-4867-85bc-1efa160160c0', 'msg_type': 'kernel_info_request', 'parent_header': {}, 'metadata': {}, 'content': {}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_3', 'msg_type': 'kernel_info_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 826729, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_3', 'msg_type': 'kernel_info_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 823000, tzinfo=tzutc()), 'msg_id': '711c31de-4ca1-4867-85bc-1efa160160c0', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'protocol_version': '5.3', 'implementation': 'ipython', 'implementation_version': '8.2.0', 'language_info': {'name': 'python', 'version': '3.9.12', 'mimetype': 'text/x-python', 'codemirror_mode': {'name': 'ipython', 'version': 3}, 'pygments_lexer': 'ipython3', 'nbconvert_exporter': 'python', 'file_extension': '.py'}, 'banner': "Python 3.9.12 (main, Mar 26 2022, 15:51:15) \nType 'copyright', 'credits' or 'license' for more information\nIPython 8.2.0 -- An enhanced Interactive Python. Type '?' for help.\n", 'help_links': [{'text': 'Python Reference', 'url': 'https://docs.python.org/3.9'}, {'text': 'IPython Reference', 'url': 'https://ipython.org/documentation.html'}, {'text': 'NumPy Reference', 'url': 'https://docs.scipy.org/doc/numpy/reference/'}, {'text': 'SciPy Reference', 'url': 'https://docs.scipy.org/doc/scipy/reference/'}, {'text': 'Matplotlib Reference', 'url': 'https://matplotlib.org/contents.html'}, {'text': 'SymPy Reference', 'url': 'http://docs.sympy.org/latest/index.html'}, {'text': 'pandas Reference', 'url': 'https://pandas.pydata.org/pandas-docs/stable/'}]}, 'metadata': {}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:kernel_info_request*** [IPKernelApp] Content: {} ---> [IPKernelApp] kernel_info_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 824000, tzinfo=tzutc()), 'msg_id': '8a5f0140-da62-4fed-8d64-faaa4647d7e4', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '8a5f0140-da62-4fed-8d64-faaa4647d7e4', 'msg_type': 'kernel_info_request', 'parent_header': {}, 'metadata': {}, 'content': {}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_6', 'msg_type': 'kernel_info_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 829528, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_6', 'msg_type': 'kernel_info_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 824000, tzinfo=tzutc()), 'msg_id': '8a5f0140-da62-4fed-8d64-faaa4647d7e4', 'msg_type': 'kernel_info_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'protocol_version': '5.3', 'implementation': 'ipython', 'implementation_version': '8.2.0', 'language_info': {'name': 'python', 'version': '3.9.12', 'mimetype': 'text/x-python', 'codemirror_mode': {'name': 'ipython', 'version': 3}, 'pygments_lexer': 'ipython3', 'nbconvert_exporter': 'python', 'file_extension': '.py'}, 'banner': "Python 3.9.12 (main, Mar 26 2022, 15:51:15) \nType 'copyright', 'credits' or 'license' for more information\nIPython 8.2.0 -- An enhanced Interactive Python. Type '?' for help.\n", 'help_links': [{'text': 'Python Reference', 'url': 'https://docs.python.org/3.9'}, {'text': 'IPython Reference', 'url': 'https://ipython.org/documentation.html'}, {'text': 'NumPy Reference', 'url': 'https://docs.scipy.org/doc/numpy/reference/'}, {'text': 'SciPy Reference', 'url': 'https://docs.scipy.org/doc/scipy/reference/'}, {'text': 'Matplotlib Reference', 'url': 'https://matplotlib.org/contents.html'}, {'text': 'SymPy Reference', 'url': 'http://docs.sympy.org/latest/index.html'}, {'text': 'pandas Reference', 'url': 'https://pandas.pydata.org/pandas-docs/stable/'}]}, 'metadata': {}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:complete_request*** [IPKernelApp] Content: {'code': '__file__.', 'cursor_pos': 9} ---> [IPKernelApp] complete_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 832000, tzinfo=tzutc()), 'msg_id': 'a9d8e81a-cdb8-4599-913b-3b4ba75fa101', 'msg_type': 'complete_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'a9d8e81a-cdb8-4599-913b-3b4ba75fa101', 'msg_type': 'complete_request', 'parent_header': {}, 'metadata': {}, 'content': {'code': '__file__.', 'cursor_pos': 9}, 'buffers': []} [IPKernelApp] *** MESSAGE TYPE:execute_request*** [IPKernelApp] Content: {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import sys\nprint(sys.executable)'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 832000, tzinfo=tzutc()), 'msg_id': 'a99bbd9f-431e-44bf-b5a1-62bb840c0546', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'a99bbd9f-431e-44bf-b5a1-62bb840c0546', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {}, 'content': {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import sys\nprint(sys.executable)'}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_14', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 249117, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_14', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 5, 832000, tzinfo=tzutc()), 'msg_id': 'a99bbd9f-431e-44bf-b5a1-62bb840c0546', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 0, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 6, 241977, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:execute_request*** [IPKernelApp] Content: {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import site\nsite.addsitedir(site.getusersitepackages())\nimport os\nimport sys\n%cd "/Users/philipparodayco/Projects/WF360"\nif os.getcwd() not in sys.path:\n sys.path.insert(0, os.getcwd())\n__vsc_ipynb_file__ = "/Users/philipparodayco/Projects/WF360/test.ipynb"\n%config Completer.use_jedi = False'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 259000, tzinfo=tzutc()), 'msg_id': '85f36d3e-78e2-4044-90cf-cbf27f491909', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '85f36d3e-78e2-4044-90cf-cbf27f491909', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {}, 'content': {'silent': False, 'store_history': False, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import site\nsite.addsitedir(site.getusersitepackages())\nimport os\nimport sys\n%cd "/Users/philipparodayco/Projects/WF360"\nif os.getcwd() not in sys.path:\n sys.path.insert(0, os.getcwd())\n__vsc_ipynb_file__ = "/Users/philipparodayco/Projects/WF360/test.ipynb"\n%config Completer.use_jedi = False'}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_19', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 272374, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_19', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 6, 259000, tzinfo=tzutc()), 'msg_id': '85f36d3e-78e2-4044-90cf-cbf27f491909', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 0, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 6, 260842, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:execute_request*** [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import ibm_db, ibm_db_dbi as dbi\nimport json, sys'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 24, 755000, tzinfo=tzutc()), 'msg_id': '586f5357-f3ca-4127-a38f-9ae200b1fb45', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '586f5357-f3ca-4127-a38f-9ae200b1fb45', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000000'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'import ibm_db, ibm_db_dbi as dbi\nimport json, sys'}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_23', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 24, 779389, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_23', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 24, 755000, tzinfo=tzutc()), 'msg_id': '586f5357-f3ca-4127-a38f-9ae200b1fb45', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 1, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 24, 757732, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:execute_request*** [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'sys.path'} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 35, 472000, tzinfo=tzutc()), 'msg_id': '0efec9a0-78e8-41d9-b72a-e622e1309d8b', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': '0efec9a0-78e8-41d9-b72a-e622e1309d8b', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000001'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': 'sys.path'}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_28', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 35, 484119, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_28', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 35, 472000, tzinfo=tzutc()), 'msg_id': '0efec9a0-78e8-41d9-b72a-e622e1309d8b', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 2, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 35, 473950, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:execute_request*** [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "with open('connection.json', 'r') as myfile:\n WF360 = json.loads(myfile.read())"} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 42, 704000, tzinfo=tzutc()), 'msg_id': 'b76175ca-af89-4d63-a286-9798888627bf', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'b76175ca-af89-4d63-a286-9798888627bf', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000003'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "with open('connection.json', 'r') as myfile:\n WF360 = json.loads(myfile.read())"}, 'buffers': []} [IPKernelApp] {'header': {'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_32', 'msg_type': 'execute_reply', 'username': 'philipparodayco', 'session': 'c4119688-81ba33aae276f900b6a5c2ce', 'date': datetime.datetime(2022, 4, 12, 18, 39, 42, 709024, tzinfo=datetime.timezone.utc), 'version': '5.3'}, 'msg_id': 'c4119688-81ba33aae276f900b6a5c2ce_74993_32', 'msg_type': 'execute_reply', 'parent_header': {'date': datetime.datetime(2022, 4, 12, 18, 39, 42, 704000, tzinfo=tzutc()), 'msg_id': 'b76175ca-af89-4d63-a286-9798888627bf', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'content': {'status': 'ok', 'execution_count': 3, 'user_expressions': {}, 'payload': []}, 'metadata': {'started': datetime.datetime(2022, 4, 12, 18, 39, 42, 706238, tzinfo=datetime.timezone.utc), 'dependencies_met': True, 'engine': '83fc3168-fd94-4e38-97a0-4b63f102112b', 'status': 'ok'}, 'tracker': } [IPKernelApp] *** MESSAGE TYPE:execute_request*** [IPKernelApp] Content: {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "conn = dbi.connect(\n (\n 'database={};'\n 'hostname={};'\n 'port={};'\n 'apikey={};'\n 'authentication=gssplugin;'\n 'protocol=tcpip;'\n 'security=ssl;'\n ).format(\n WF360.get('database'),\n WF360.get('host'),\n WF360.get('port'),\n WF360.get('api_key')\n ),'','')"} ---> [IPKernelApp] execute_request: {'header': {'date': datetime.datetime(2022, 4, 12, 18, 40, 2, 181000, tzinfo=tzutc()), 'msg_id': 'eb6a0e52-7422-4cd7-b6db-977e20b51a39', 'msg_type': 'execute_request', 'session': 'b9e83e96-5e09-4ad4-b7e0-7d6fa3848951', 'username': 'bc05bec8-01ab-4a94-a192-14cc64d9dfae', 'version': '5.2'}, 'msg_id': 'eb6a0e52-7422-4cd7-b6db-977e20b51a39', 'msg_type': 'execute_request', 'parent_header': {}, 'metadata': {'cellId': 'vscode-notebook-cell:/Users/philipparodayco/Projects/WF360/test.ipynb#ch0000005'}, 'content': {'silent': False, 'store_history': True, 'user_expressions': {}, 'allow_stdin': True, 'stop_on_error': False, 'code': "conn = dbi.connect(\n (\n 'database={};'\n 'hostname={};'\n 'port={};'\n 'apikey={};'\n 'authentication=gssplugin;'\n 'protocol=tcpip;'\n 'security=ssl;'\n ).format(\n WF360.get('database'),\n WF360.get('host'),\n WF360.get('port'),\n WF360.get('api_key')\n ),'','')"}, 'buffers': []} Info 14:40:02: Dispose Kernel process Error 14:40:02: Raw kernel process exited code: undefined Warn 14:40:02: Error in waiting for cell to complete [Error: Canceled future for execute_request message before replies were done at t.KernelShellFutureHandler.dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1204175) at /Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1223227 at Map.forEach () at v._clearKernelState (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1223212) at v.dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1216694) at /Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:533674 at t.swallowExceptions (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:913059) at dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:533652) at t.RawSession.dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:537330) at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5)] Warn 14:40:02: Cell completed with errors [Error: Canceled future for execute_request message before replies were done at t.KernelShellFutureHandler.dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1204175) at /Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1223227 at Map.forEach () at v._clearKernelState (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1223212) at v.dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:1216694) at /Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:533674 at t.swallowExceptions (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:913059) at dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:533652) at t.RawSession.dispose (/Users/philipparodayco/.vscode/extensions/ms-toolsai.jupyter-2022.3.1000901801/out/extension.js:2:537330) at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5)] Info 14:40:02: Cancel all remaining cells true || Error || undefined Info 14:40:02: Cancel pending cells Info 14:40:02: Cell 5 executed with state Error