SNOW-175554: Importing snowflake.connector from pytest code raises 'Windows fatal exception: code 0xc0000139'

[theguyoverthere]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using (python --version)? 3.7.7 (default, May 6 2020, 11:45:54) [MSC v.1916 64 bit (AMD64)]

2. What operating system and processor architecture are you using (python -c 'import platform; print(platform.platform())')? Windows-10-10.0.19041-SP0

3. What are the component versions in the environment (pip list)?

    asn1crypto                 1.3.0
    atomicwrites               1.4.0
    attrs                      19.3.0
    azure-common               1.1.25
    azure-storage-blob         2.1.0
    azure-storage-common       2.1.0
    boto3                      1.11.17
    botocore                   1.14.17
    certifi                    2020.6.20
    cffi                       1.13.2
    chardet                    3.0.4
    click                      7.1.2
    colorama                   0.4.3
    cryptography               2.8
    docutils                   0.15.2
    idna                       2.9
    ijson                      2.6.1
    importlib-metadata         1.7.0
    jmespath                   0.9.5
    more-itertools             8.4.0
    numpy                      1.19.0
    oscrypto                   1.2.0
    packaging                  20.4
    pandas                     1.0.5
    pip                        20.1.1
    pluggy                     0.13.1
    psycopg2                   2.8.4
    py                         1.9.0
    pyarrow                    0.17.1
    pycparser                  2.20
    pycryptodome               3.9.7
    pycryptodomex              3.9.7
    PyJWT                      1.7.1
    pyOpenSSL                  19.1.0
    pyparsing                  2.4.7
    pytest                     5.4.3
    pytest-runner              5.2
    python-dateutil            2.8.1
    pytz                       2019.3
    PyYAML                     5.3.1
    requests                   2.23.0
    s3transfer                 0.3.3
    setuptools                 47.3.1.post20200622
    six                        1.15.0
    snowflake-connector-python 2.2.3
    teradata                   15.10.0.21
    teradatasql                16.20.0.60
    urllib3                    1.25.8
    wcwidth                    0.2.5
    wheel                      0.34.2
    wincertstore               0.2
    XlsxWriter                 1.2.9
    xxhash                     1.4.4
    zipp                       3.1.0

4. What did you do? If possible, provide a recipe for reproducing the error.

import click
import snowflake.connector
from click.testing import CliRunner

@click.command()
def fun():
    pass

def test_command_configure():
    runner = CliRunner()
    result = runner.invoke(fun, [])
    assert result.exit_code == 0

A complete runnable program is good.

5. What did you expect to see?

============================= test session starts =============================
platform win32 -- Python 3.7.7, pytest-5.4.3, py-1.9.0, pluggy-0.13.1 -- E:\anaconda3\envs\cdb\python.exe
cachedir: .pytest_cache
rootdir: J:\cdb
collecting ... collected 1 item

test_ingest.py::test_command_configure PASSED                            [100%]

============================== 1 passed in 0.03s ==============================

6. What did you see instead?

============================= test session starts =============================
platform win32 -- Python 3.7.7, pytest-5.4.3, py-1.9.0, pluggy-0.13.1 -- E:\anaconda3\envs\cdb\python.exe
cachedir: .pytest_cache
rootdir: J:\cdb
collecting ... Windows fatal exception: code 0xc0000139

Current thread 0x00003e78 (most recent call first):
  File "<frozen importlib._bootstrap>", line 219 in _call_with_frames_removed
  File "<frozen importlib._bootstrap_external>", line 1043 in create_module
  File "<frozen importlib._bootstrap>", line 583 in module_from_spec
  File "<frozen importlib._bootstrap>", line 670 in _load_unlocked
  File "<frozen importlib._bootstrap>", line 967 in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983 in _find_and_load
  File "<frozen importlib._bootstrap>", line 219 in _call_with_frames_removed
  File "<frozen importlib._bootstrap_external>", line 1050 in exec_module
  File "<frozen importlib._bootstrap>", line 677 in _load_unlocked
  File "<frozen importlib._bootstrap>", line 967 in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983 in _find_and_load
  File "E:\anaconda3\envs\cdb\lib\site-packages\snowflake\connector\cursor.py", line 47 in <module>
  File "<frozen importlib._bootstrap>", line 219 in _call_with_frames_removed
  File "<frozen importlib._bootstrap_external>", line 728 in exec_module
  File "<frozen importlib._bootstrap>", line 677 in _load_unlocked
  File "<frozen importlib._bootstrap>", line 967 in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983 in _find_and_load
  File "E:\anaconda3\envs\cdb\lib\site-packages\snowflake\connector\connection.py", line 43 in <module>
  File "<frozen importlib._bootstrap>", line 219 in _call_with_frames_removed
  File "<frozen importlib._bootstrap_external>", line 728 in exec_module
  File "<frozen importlib._bootstrap>", line 677 in _load_unlocked
  File "<frozen importlib._bootstrap>", line 967 in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983 in _find_and_load
  File "E:\anaconda3\envs\cdb\lib\site-packages\snowflake\connector\__init__.py", line 18 in <module>
  File "<frozen importlib._bootstrap>", line 219 in _call_with_frames_removed
  File "<frozen importlib._bootstrap_external>", line 728 in exec_module
  File "<frozen importlib._bootstrap>", line 677 in _load_unlocked
  File "<frozen importlib._bootstrap>", line 967 in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983 in _find_and_load
  File "J:\cdb\tests\tools\cli\commands\test_ingest.py", line 15 in <module>
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\assertion\rewrite.py", line 152 in exec_module
  File "<frozen importlib._bootstrap>", line 677 in _load_unlocked
  File "<frozen importlib._bootstrap>", line 967 in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983 in _find_and_load
  File "E:\anaconda3\envs\cdb\lib\site-packages\py\_path\local.py", line 704 in pyimport
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\python.py", line 511 in _importtestmodule
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\python.py", line 443 in _getobj
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\python.py", line 261 in obj
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\python.py", line 459 in _inject_setup_module_fixture
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\python.py", line 446 in collect
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\runner.py", line 264 in <lambda>
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\runner.py", line 244 in from_call
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\runner.py", line 264 in pytest_make_collect_report
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\callers.py", line 187 in _multicall
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\manager.py", line 87 in <lambda>
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\manager.py", line 93 in _hookexec
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\hooks.py", line 286 in __call__
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\runner.py", line 382 in collect_one_node
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 681 in genitems
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 490 in _perform_collect
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 452 in perform_collect
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 257 in pytest_collection
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\callers.py", line 187 in _multicall
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\manager.py", line 87 in <lambda>
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\manager.py", line 93 in _hookexec
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\hooks.py", line 286 in __call__
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 246 in _main
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 191 in wrap_session
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\main.py", line 240 in pytest_cmdline_main
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\callers.py", line 187 in _multicall
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\manager.py", line 87 in <lambda>
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\manager.py", line 93 in _hookexec
  File "E:\anaconda3\envs\cdb\lib\site-packages\pluggy\hooks.py", line 286 in __call__
  File "E:\anaconda3\envs\cdb\lib\site-packages\_pytest\config\__init__.py", line 125 in main
  File "E:\Program Files\JetBrains\PyCharm Community Edition 2020.1.3\plugins\python-ce\helpers\pycharm\_jb_pytest_runner.py", line 43 in <module>
collected 1 item

test_ingest.py::test_command_configure PASSED                            [100%]

============================== 1 passed in 0.75s ==============================

Process finished with exit code 0

[adde-rishimehta]

+1

Seeing the similar issue on Docker container. Is there any investigation done yet?

Python Version: Python 3.7.5 Snowflake Connector Python: 2.2.9 OS: Linux-4.19.76-linuxkit-x86_64-with-debian-9.11

[venthur]

Same issue running pytest in docker in gitlab-ci.

[sfc-gh-mkeller]

Is everyone that is seeing this issue using Anaconda?

[venthur]

Nope, in my case it is a plain virtual environment (as in python3 -m venv venv) in docker.

[sfc-gh-hkapre]

@theguyoverthere @venthur Is this still an issue for you?