snowflakedb / snowflake-connector-python

Snowflake Connector for Python
https://pypi.python.org/pypi/snowflake-connector-python/
Apache License 2.0
587 stars 470 forks source link

SNOW-942951: `arrow_iterator.pyx` Error when Reading a String Column #1775

Closed srilman closed 7 months ago

srilman commented 1 year ago

Python version

3.11

Operating system and processor architecture

macOS-13.2.1-arm64-arm-64bit

Installed packages

I'm using Conda, so output of conda list:

# packages in environment at /Users/.../mambaforge/envs/DEVARROW:
#
# Name                    Version                   Build  Channel
aiohttp                   3.8.5           py311heffc1b2_0    conda-forge
aiosignal                 1.3.1              pyhd8ed1ab_0    conda-forge
appnope                   0.1.3              pyhd8ed1ab_0    conda-forge
asn1crypto                1.5.1              pyhd8ed1ab_0    conda-forge
asttokens                 2.4.0              pyhd8ed1ab_0    conda-forge
async-timeout             4.0.3              pyhd8ed1ab_0    conda-forge
attrs                     23.1.0             pyh71513ae_1    conda-forge
aws-c-auth                0.7.4                h2ed40ff_1    conda-forge
aws-c-cal                 0.6.2                h12c43c8_2    conda-forge
aws-c-common              0.9.3                hb547adb_0    conda-forge
aws-c-compression         0.2.17               h12c43c8_3    conda-forge
aws-c-event-stream        0.3.2                h88fe898_1    conda-forge
aws-c-http                0.7.13               he062130_1    conda-forge
aws-c-io                  0.13.32              h13ba428_5    conda-forge
aws-c-mqtt                0.9.6                h3ffe4bb_2    conda-forge
aws-c-s3                  0.3.17               hf064be9_3    conda-forge
aws-c-sdkutils            0.1.12               h12c43c8_2    conda-forge
aws-checksums             0.1.17               h12c43c8_2    conda-forge
aws-crt-cpp               0.23.1               h96fc18d_5    conda-forge
aws-sdk-cpp               1.11.156             he831950_3    conda-forge
backcall                  0.2.0              pyh9f0ad1d_0    conda-forge
backports                 1.0                pyhd8ed1ab_3    conda-forge
backports.functools_lru_cache 1.6.5              pyhd8ed1ab_0    conda-forge
blinker                   1.6.2              pyhd8ed1ab_0    conda-forge
boto3                     1.28.61            pyhd8ed1ab_0    conda-forge
botocore                  1.31.61            pyhd8ed1ab_0    conda-forge
brotli                    1.1.0                hb547adb_1    conda-forge
brotli-bin                1.1.0                hb547adb_1    conda-forge
brotli-python             1.1.0           py311ha891d26_1    conda-forge
bzip2                     1.0.8                h3422bc3_4    conda-forge
c-ares                    1.19.1               hb547adb_0    conda-forge
ca-certificates           2023.7.22            hf0a4a13_0    conda-forge
cached-property           1.5.2                hd8ed1ab_1    conda-forge
cached_property           1.5.2              pyha770c72_1    conda-forge
cachetools                5.3.1              pyhd8ed1ab_0    conda-forge
ccache                    4.8.1                hbf08be0_0    conda-forge
cctools_osx-arm64         973.0.1             h62378fb_14    conda-forge
certifi                   2023.7.22          pyhd8ed1ab_0    conda-forge
cffi                      1.15.1          py311hae827db_3    conda-forge
charset-normalizer        3.3.0              pyhd8ed1ab_0    conda-forge
click                     8.1.7           unix_pyh707e725_0    conda-forge
cmake                     3.27.6               h1c59155_0    conda-forge
colorama                  0.4.6              pyhd8ed1ab_0    conda-forge
compiler-rt               16.0.6               hf8d1dfb_0    conda-forge
compiler-rt_osx-arm64     16.0.6               hf8d1dfb_0    conda-forge
contourpy                 1.1.1           py311he4fd1f5_1    conda-forge
coverage                  7.3.2           py311heffc1b2_0    conda-forge
credstash                 1.17.1             pyh9f0ad1d_0    conda-forge
cryptography              41.0.4          py311h5fb2c35_0    conda-forge
cycler                    0.12.0             pyhd8ed1ab_0    conda-forge
cython                    0.29.36         py311ha891d26_1    conda-forge
decorator                 5.1.1              pyhd8ed1ab_0    conda-forge
et_xmlfile                1.1.0              pyhd8ed1ab_0    conda-forge
exceptiongroup            1.1.3              pyhd8ed1ab_0    conda-forge
execnet                   2.0.2              pyhd8ed1ab_0    conda-forge
executing                 1.2.0              pyhd8ed1ab_0    conda-forge
filelock                  3.12.4             pyhd8ed1ab_0    conda-forge
flaky                     3.7.0              pyh9f0ad1d_0    conda-forge
fonttools                 4.43.1          py311h05b510d_0    conda-forge
freetype                  2.12.1               hadb7bae_2    conda-forge
frozenlist                1.4.0           py311heffc1b2_1    conda-forge
fsspec                    2023.9.2           pyh1a96a4e_0    conda-forge
gflags                    2.2.2             hc88da5d_1004    conda-forge
glog                      0.6.0                h6da1cb0_0    conda-forge
gmp                       6.2.1                h9f76cd9_0    conda-forge
greenlet                  3.0.0           py311hbaf5611_1    conda-forge
grpcio                    1.57.0          py311hea943cd_1    conda-forge
h5py                      3.8.0           nompi_py311hf81d9a4_100    conda-forge
hdf5                      1.12.2          mpi_mpich_h4e1c725_1    conda-forge
icu                       73.2                 hc8870d7_0    conda-forge
idna                      3.4                pyhd8ed1ab_0    conda-forge
importlib-metadata        6.8.0              pyha770c72_0    conda-forge
iniconfig                 2.0.0              pyhd8ed1ab_0    conda-forge
ipython                   8.16.1             pyh31c8845_0    conda-forge
jedi                      0.19.1             pyhd8ed1ab_0    conda-forge
jmespath                  1.0.1              pyhd8ed1ab_0    conda-forge
joblib                    1.3.2              pyhd8ed1ab_0    conda-forge
kiwisolver                1.4.5           py311he4fd1f5_1    conda-forge
krb5                      1.21.2               h92f50d5_0    conda-forge
lcms2                     2.15                 hf2736f0_3    conda-forge
ld64_osx-arm64            609                 ha4bd21c_14    conda-forge
lerc                      4.0.0                h9a09cb3_0    conda-forge
libabseil                 20230802.1      cxx17_h13dd4ca_0    conda-forge
libaec                    1.1.2                h13dd4ca_1    conda-forge
libarrow                  13.0.0           h0c25ffe_6_cpu    conda-forge
libblas                   3.9.0           18_osxarm64_openblas    conda-forge
libbrotlicommon           1.1.0                hb547adb_1    conda-forge
libbrotlidec              1.1.0                hb547adb_1    conda-forge
libbrotlienc              1.1.0                hb547adb_1    conda-forge
libcblas                  3.9.0           18_osxarm64_openblas    conda-forge
libclang-cpp16            16.0.6          default_h07b2d96_1    conda-forge
libcrc32c                 1.1.2                hbdafb3b_0    conda-forge
libcxx                    16.0.6               h4653b0c_0    conda-forge
libdeflate                1.19                 hb547adb_0    conda-forge
libedit                   3.1.20191231         hc8eb9b7_2    conda-forge
libev                     4.33                 h642e427_1    conda-forge
libevent                  2.1.12               h2757513_1    conda-forge
libexpat                  2.5.0                hb7217d7_1    conda-forge
libffi                    3.4.2                h3422bc3_5    conda-forge
libgfortran               5.0.0           13_2_0_hd922786_1    conda-forge
libgfortran5              13.2.0               hf226fd6_1    conda-forge
libgoogle-cloud           2.12.0               hde42cda_2    conda-forge
libgrpc                   1.57.0               hdbe17d8_1    conda-forge
libhiredis                1.0.2                hbec66e7_0    conda-forge
libiconv                  1.17                 he4db4b2_0    conda-forge
libjpeg-turbo             3.0.0                hb547adb_1    conda-forge
liblapack                 3.9.0           18_osxarm64_openblas    conda-forge
libnghttp2                1.52.0               hae82a92_0    conda-forge
libopenblas               0.3.24          openmp_hd76b1f2_0    conda-forge
libpng                    1.6.39               h76d750c_0    conda-forge
libpq                     15.4                 hcea71ed_2    conda-forge
libprotobuf               4.23.4               hf590ac1_6    conda-forge
libsqlite                 3.43.0               hb31c410_0    conda-forge
libssh2                   1.11.0               h7a5bd25_0    conda-forge
libthrift                 0.19.0               h026a170_1    conda-forge
libtiff                   4.6.0                ha8a6c65_2    conda-forge
libutf8proc               2.8.0                h1a8c8d9_0    conda-forge
libuv                     1.46.0               hb547adb_0    conda-forge
libwebp-base              1.3.2                hb547adb_0    conda-forge
libxcb                    1.15                 hf346824_0    conda-forge
libxml2                   2.11.5               h25269f3_1    conda-forge
libzlib                   1.2.13               h53f4e23_5    conda-forge
llvm-openmp               17.0.2               h1c12783_0    conda-forge
llvm-tools                16.0.6               he79909e_2    conda-forge
llvmlite                  0.40.1          py311hea943cd_0    conda-forge
lz4-c                     1.9.4                hb7217d7_0    conda-forge
make                      4.3                  he57ea6c_1    conda-forge
matplotlib                3.6.1           py311ha1ab1f8_1    conda-forge
matplotlib-base           3.6.1           py311h99a5f44_1    conda-forge
matplotlib-inline         0.1.6              pyhd8ed1ab_0    conda-forge
maven                     3.9.5                hce30654_0    conda-forge
mccabe                    0.7.0              pyhd8ed1ab_0    conda-forge
mmh3                      3.0.0           py311ha397e9f_3    conda-forge
multidict                 6.0.4           py311he2be06e_0    conda-forge
munkres                   1.1.4              pyh9f0ad1d_0    conda-forge
ncurses                   6.4                  h7ea286d_0    conda-forge
numba                     0.57.1          py311hbf3c4e2_0    conda-forge
numpy                     1.24.4          py311hb8f3215_0    conda-forge
oauthlib                  3.2.2              pyhd8ed1ab_0    conda-forge
openjpeg                  2.5.0                h4c1507b_3    conda-forge
openpyxl                  3.1.2           py311heffc1b2_0    conda-forge
openssl                   3.1.3                h53f4e23_0    conda-forge
orc                       1.9.0                hbfdecac_2    conda-forge
oscrypto                  1.2.1              pyhd3deb0d_0    conda-forge
packaging                 23.2               pyhd8ed1ab_0    conda-forge
pandas                    1.5.3           py311h4eec4a9_1    conda-forge
parso                     0.8.3              pyhd8ed1ab_0    conda-forge
pexpect                   4.8.0              pyh1a96a4e_2    conda-forge
pickleshare               0.7.5                   py_1003    conda-forge
pillow                    10.0.1          py311h8dc27b9_2    conda-forge
pip                       23.2.1             pyhd8ed1ab_0    conda-forge
platformdirs              3.8.1              pyhd8ed1ab_0    conda-forge
pluggy                    1.3.0              pyhd8ed1ab_0    conda-forge
prompt-toolkit            3.0.39             pyha770c72_0    conda-forge
prompt_toolkit            3.0.39               hd8ed1ab_0    conda-forge
protobuf                  4.23.4          py311h590876e_3    conda-forge
psutil                    5.9.5           py311heffc1b2_1    conda-forge
pthread-stubs             0.4               h27ca646_1001    conda-forge
ptyprocess                0.7.0              pyhd3deb0d_0    conda-forge
pure_eval                 0.2.2              pyhd8ed1ab_0    conda-forge
pyarrow                   13.0.0          py311hd7bc329_6_cpu    conda-forge
pyasn1                    0.5.0              pyhd8ed1ab_0    conda-forge
pyasn1-modules            0.3.0              pyhd8ed1ab_0    conda-forge
pycodestyle               2.11.0             pyhd8ed1ab_0    conda-forge
pycparser                 2.21               pyhd8ed1ab_0    conda-forge
pycryptodomex             3.19.0          py311heffc1b2_1    conda-forge
pyflakes                  3.1.0              pyhd8ed1ab_0    conda-forge
pygments                  2.16.1             pyhd8ed1ab_0    conda-forge
pyjwt                     2.8.0              pyhd8ed1ab_0    conda-forge
pyparsing                 3.1.1              pyhd8ed1ab_0    conda-forge
pysocks                   1.7.1              pyha2e5f31_6    conda-forge
python                    3.11.6          h47c9636_0_cpython    conda-forge
python-dateutil           2.8.2              pyhd8ed1ab_0    conda-forge
python-dotenv             1.0.0                    pypi_0    pypi
python_abi                3.11                    4_cp311    conda-forge
pytz                      2023.3.post1       pyhd8ed1ab_0    conda-forge
pyu2f                     0.1.5              pyhd8ed1ab_0    conda-forge
re2                       2023.03.02           hc5e2d97_0    conda-forge
readline                  8.2                  h92ec313_1    conda-forge
requests                  2.31.0             pyhd8ed1ab_0    conda-forge
requests-oauthlib         1.3.1              pyhd8ed1ab_0    conda-forge
rhash                     1.4.4                hb547adb_0    conda-forge
rsa                       4.9                pyhd8ed1ab_0    conda-forge
s3fs                      0.4.2                      py_0    conda-forge
s3transfer                0.7.0              pyhd8ed1ab_0    conda-forge
setuptools                59.8.0          py311h267d04e_1    conda-forge
sigtool                   0.1.3                h44b9a77_0    conda-forge
six                       1.16.0             pyh6c4a22f_0    conda-forge
snappy                    1.1.10               h17c5cce_0    conda-forge
snowflake-connector-python 3.2.1           py311h5b90cc1_0    conda-forge
snowflake-sqlalchemy      1.5.0              pyhd8ed1ab_0    conda-forge
sortedcontainers          2.4.0              pyhd8ed1ab_0    conda-forge
sqlalchemy                1.4.49          py311heffc1b2_0    conda-forge
stack_data                0.6.2              pyhd8ed1ab_0    conda-forge
tapi                      1100.0.11            he4954df_0    conda-forge
threadpoolctl             3.2.0              pyha21a80b_0    conda-forge
tk                        8.6.13               hb31c410_0    conda-forge
toml                      0.10.2             pyhd8ed1ab_0    conda-forge
tomli                     2.0.1              pyhd8ed1ab_0    conda-forge
tomlkit                   0.12.1             pyha770c72_0    conda-forge
tornado                   6.3.3           py311heffc1b2_1    conda-forge
traitlets                 5.11.2             pyhd8ed1ab_0    conda-forge
types-psycopg2            2.9.21.14                pypi_0    pypi
types-pymysql             1.1.0.1                  pypi_0    pypi
typing-extensions         4.8.0                hd8ed1ab_0    conda-forge
typing_extensions         4.8.0              pyha770c72_0    conda-forge
tzdata                    2023c                h71feb2d_0    conda-forge
urllib3                   1.26.17            pyhd8ed1ab_0    conda-forge
wcwidth                   0.2.8              pyhd8ed1ab_0    conda-forge
wheel                     0.41.2             pyhd8ed1ab_0    conda-forge
xorg-libxau               1.0.11               hb547adb_0    conda-forge
xorg-libxdmcp             1.1.3                h27ca646_0    conda-forge
xz                        5.2.6                h57fd34a_0    conda-forge
yarl                      1.9.2           py311heffc1b2_0    conda-forge
zipp                      3.17.0             pyhd8ed1ab_0    conda-forge
zstd                      1.5.5                h4f39d0f_0    conda-forge

What did you do?

I attempted to run the following query and download the data to a local machine:

import snowflake.connector
conn = snowflake.connector.connect(...)
cur = conn.cursor()
cur.execute("select ds from FEATURE_STORE.FEATURES_QUERY where ds::date >= '2022-03-01' and ds::date < '2022-06-01'")

out = cur.fetch_arrow_all()

and saw the following error:

*** snowflake.connector.errors.OperationalError: 255005: Failed to read next arrow batch:
    b'Array length did not match record batch length'

This code snippet also leads to the error:

batches = cur.get_result_batches()
for i, b in enumerate(batches):
  print(i)
  b.to_arrow()

I tried decreasing the range of the filter, and the error disappeared. I couldn't reproduce the error on a smaller range.

What did you expect to see?

To end up with an Arrow table, no exceptions.

Can you set logging to DEBUG and collect the logs?

Output was too long, only last ~200 lines:


2023-10-16 16:06:38,599 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_5_2
2023-10-16 16:06:38,599 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 31
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_3 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_5_1
2023-10-16 16:06:38,599 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 31
2023-10-16 16:06:38,599 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 32
2023-10-16 16:06:38,599 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_5_3
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_1 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_5_2
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_3 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 2/4 active sessions
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_1 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 3/4 active sessions
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_3 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_5_1 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd17a10>
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_0 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_5_3
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_1 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_5_2 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd39490>
2023-10-16 16:06:38,599 - ThreadPoolExecutor-0_0 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 4/4 active sessions
2023-10-16 16:06:38,601 - ThreadPoolExecutor-0_0 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_5_3 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd391d0>
2023-10-16 16:06:38,658 - ThreadPoolExecutor-0_1 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_5_2?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=hYV0QZdIqufTYWnX5aeDalRoiKI%3D HTTP/1.1" 200 244920
2023-10-16 16:06:38,679 - ThreadPoolExecutor-0_0 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_5_3?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=GI5vGo1KXfl72nQ0MH20jDibQ6U%3D HTTP/1.1" 200 435494
2023-10-16 16:06:38,684 - ThreadPoolExecutor-0_3 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_5_1?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=JJ8rG90kC0XcT7GbsB25CEqnVzA%3D HTTP/1.1" 200 135937
2023-10-16 16:06:38,719 - ThreadPoolExecutor-0_1 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 3/4 active sessions
2023-10-16 16:06:38,719 - ThreadPoolExecutor-0_1 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_5_2
2023-10-16 16:06:38,719 - ThreadPoolExecutor-0_1 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_5_2
2023-10-16 16:06:38,719 - ThreadPoolExecutor-0_1 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 9
2023-10-16 16:06:38,719 - ThreadPoolExecutor-0_1 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 9
2023-10-16 16:06:38,719 - ThreadPoolExecutor-0_1 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_5_2
2023-10-16 16:06:38,739 - ThreadPoolExecutor-0_3 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 2/4 active sessions
2023-10-16 16:06:38,739 - ThreadPoolExecutor-0_3 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_5_1
2023-10-16 16:06:38,739 - ThreadPoolExecutor-0_3 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_5_1
2023-10-16 16:06:38,739 - ThreadPoolExecutor-0_3 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 5
2023-10-16 16:06:38,739 - ThreadPoolExecutor-0_3 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 5
2023-10-16 16:06:38,739 - ThreadPoolExecutor-0_3 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_5_1
2023-10-16 16:06:38,813 - ThreadPoolExecutor-0_0 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 1/4 active sessions
2023-10-16 16:06:38,813 - ThreadPoolExecutor-0_0 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_5_3
2023-10-16 16:06:38,813 - ThreadPoolExecutor-0_0 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_5_3
2023-10-16 16:06:38,814 - ThreadPoolExecutor-0_0 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 16
2023-10-16 16:06:38,814 - ThreadPoolExecutor-0_0 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 16
2023-10-16 16:06:38,814 - ThreadPoolExecutor-0_0 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_5_3
2023-10-16 16:06:38,871 - ThreadPoolExecutor-0_2 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 0/4 active sessions
2023-10-16 16:06:38,871 - ThreadPoolExecutor-0_2 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_4_6
2023-10-16 16:06:38,871 - ThreadPoolExecutor-0_2 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_4_6
2023-10-16 16:06:38,872 - ThreadPoolExecutor-0_2 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 5
2023-10-16 16:06:38,872 - ThreadPoolExecutor-0_2 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 5
2023-10-16 16:06:38,872 - ThreadPoolExecutor-0_2 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_4_6
2023-10-16 16:06:38,872 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 32
2023-10-16 16:06:38,872 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 32
2023-10-16 16:06:38,872 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 33
2023-10-16 16:06:38,873 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_5_4
2023-10-16 16:06:38,873 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 33
2023-10-16 16:06:38,873 - ThreadPoolExecutor-0_1 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_5_4
2023-10-16 16:06:38,873 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 33
2023-10-16 16:06:38,873 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 34
2023-10-16 16:06:38,873 - ThreadPoolExecutor-0_1 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 1/4 active sessions
2023-10-16 16:06:38,873 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_5_5
2023-10-16 16:06:38,873 - ThreadPoolExecutor-0_1 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_5_4 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd15910>
2023-10-16 16:06:38,873 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 34
2023-10-16 16:06:38,873 - ThreadPoolExecutor-0_0 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_5_5
2023-10-16 16:06:38,873 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 34
2023-10-16 16:06:38,873 - ThreadPoolExecutor-0_0 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 2/4 active sessions
2023-10-16 16:06:38,873 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 35
2023-10-16 16:06:38,874 - ThreadPoolExecutor-0_0 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_5_5 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd391d0>
2023-10-16 16:06:38,874 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_5_6
2023-10-16 16:06:38,874 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 35
2023-10-16 16:06:38,874 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 35
2023-10-16 16:06:38,874 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 36
2023-10-16 16:06:38,874 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_6_0
2023-10-16 16:06:38,874 - ThreadPoolExecutor-0_3 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_5_6
2023-10-16 16:06:38,874 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 36
2023-10-16 16:06:38,874 - ThreadPoolExecutor-0_2 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_6_0
2023-10-16 16:06:38,874 - ThreadPoolExecutor-0_2 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 4/4 active sessions
2023-10-16 16:06:38,874 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 36
2023-10-16 16:06:38,874 - ThreadPoolExecutor-0_2 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_6_0 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd39490>
2023-10-16 16:06:38,874 - ThreadPoolExecutor-0_3 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 3/4 active sessions
2023-10-16 16:06:38,874 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 37
2023-10-16 16:06:38,875 - ThreadPoolExecutor-0_3 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_5_6 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd17a10>
2023-10-16 16:06:38,875 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_6_1
2023-10-16 16:06:38,929 - ThreadPoolExecutor-0_2 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_6_0?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=NUVR3fCuqhelcvL00TqLUUZytSk%3D HTTP/1.1" 200 26953
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 3/4 active sessions
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_6_0
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_6_0
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 1
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 1
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_6_0
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_2 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_6_1
2023-10-16 16:06:38,943 - ThreadPoolExecutor-0_1 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_5_4?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=ulFS2WyxnuOoOhBIO0wAwthcsvc%3D HTTP/1.1" 200 843706
2023-10-16 16:06:38,944 - ThreadPoolExecutor-0_0 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_5_5?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=p99syAgYSvj2%2FLx4%2FTUJRCLQCxw%3D HTTP/1.1" 200 1678678
2023-10-16 16:06:38,944 - ThreadPoolExecutor-0_2 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 4/4 active sessions
2023-10-16 16:06:38,944 - ThreadPoolExecutor-0_2 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_6_1 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd39490>
2023-10-16 16:06:38,945 - ThreadPoolExecutor-0_3 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_5_6?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=3UOU%2FEQQCXqgwzv23FIL0GKliAE%3D HTTP/1.1" 200 1426651
2023-10-16 16:06:39,034 - ThreadPoolExecutor-0_2 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_6_1?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=OpujMMCEBBXLREav0Ihns0pWxkU%3D HTTP/1.1" 200 135944
2023-10-16 16:06:39,045 - ThreadPoolExecutor-0_2 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 3/4 active sessions
2023-10-16 16:06:39,045 - ThreadPoolExecutor-0_2 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_6_1
2023-10-16 16:06:39,045 - ThreadPoolExecutor-0_2 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_6_1
2023-10-16 16:06:39,045 - ThreadPoolExecutor-0_2 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 5
2023-10-16 16:06:39,045 - ThreadPoolExecutor-0_2 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 5
2023-10-16 16:06:39,045 - ThreadPoolExecutor-0_2 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_6_1
2023-10-16 16:06:39,214 - ThreadPoolExecutor-0_1 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 2/4 active sessions
2023-10-16 16:06:39,214 - ThreadPoolExecutor-0_1 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_5_4
2023-10-16 16:06:39,214 - ThreadPoolExecutor-0_1 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_5_4
2023-10-16 16:06:39,214 - ThreadPoolExecutor-0_1 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 31
2023-10-16 16:06:39,214 - ThreadPoolExecutor-0_1 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 31
2023-10-16 16:06:39,214 - ThreadPoolExecutor-0_1 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_5_4
2023-10-16 16:06:39,214 - MainThread result_set.py:88 - result_set_iterator() - DEBUG - user began consuming result batch 37
2023-10-16 16:06:39,215 - MainThread result_set.py:90 - result_set_iterator() - DEBUG - user finished consuming result batch 37
2023-10-16 16:06:39,215 - MainThread result_set.py:73 - result_set_iterator() - DEBUG - user requesting to consume result batch 38
2023-10-16 16:06:39,215 - MainThread result_set.py:77 - result_set_iterator() - DEBUG - queuing download of result batch id: data_0_6_2
2023-10-16 16:06:39,215 - ThreadPoolExecutor-0_2 result_batch.py:280 - _download() - DEBUG - started downloading result batch id: data_0_6_2
2023-10-16 16:06:39,215 - ThreadPoolExecutor-0_2 network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 3/4 active sessions
2023-10-16 16:06:39,215 - ThreadPoolExecutor-0_2 result_batch.py:290 - _download() - DEBUG - downloading result batch id: data_0_6_2 with existing session <snowflake.connector.vendored.requests.sessions.Session object at 0x12fd15910>
2023-10-16 16:06:39,298 - ThreadPoolExecutor-0_3 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 2/4 active sessions
2023-10-16 16:06:39,298 - ThreadPoolExecutor-0_3 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_5_6
2023-10-16 16:06:39,298 - ThreadPoolExecutor-0_3 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_5_6
2023-10-16 16:06:39,298 - ThreadPoolExecutor-0_3 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 5
2023-10-16 16:06:39,298 - ThreadPoolExecutor-0_3 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 5
2023-10-16 16:06:39,298 - ThreadPoolExecutor-0_3 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_5_6
2023-10-16 16:06:39,299 - ThreadPoolExecutor-0_2 connectionpool.py:456 - _make_request() - DEBUG - https://sfc-va2-ds1-14-customer-stage.s3.amazonaws.com:443 "GET /zmo8-s-v2su2525/results/01afb176-0403-de52-2919-030139da3bff_0/main/data_0_6_2?x-amz-server-side-encryption-customer-algorithm=AES256&response-content-encoding=gzip&AWSAccessKeyId=AKIAWABB6N5GVNDINO5B&Expires=1697508395&Signature=W1XmdyXINkFP1Q3vqy0Bv%2BqhXyg%3D HTTP/1.1" 200 244929
2023-10-16 16:06:39,342 - ThreadPoolExecutor-0_0 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 1/4 active sessions
2023-10-16 16:06:39,342 - ThreadPoolExecutor-0_0 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_5_5
2023-10-16 16:06:39,342 - ThreadPoolExecutor-0_0 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_5_5
2023-10-16 16:06:39,354 - ThreadPoolExecutor-0_2 network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool 'None', SessionPool 0/4 active sessions
2023-10-16 16:06:39,354 - ThreadPoolExecutor-0_2 result_batch.py:301 - _download() - DEBUG - successfully downloaded result batch id: data_0_6_2
2023-10-16 16:06:39,354 - ThreadPoolExecutor-0_2 result_batch.py:643 - _create_iter() - DEBUG - started loading result batch id: data_0_6_2
2023-10-16 16:06:39,355 - ThreadPoolExecutor-0_2 arrow_iterator.cpython-311-darwin.so:0 - __cinit__() - DEBUG - Batches read: 9
2023-10-16 16:06:39,355 - ThreadPoolExecutor-0_2 CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 9
2023-10-16 16:06:39,355 - ThreadPoolExecutor-0_2 result_batch.py:646 - _create_iter() - DEBUG - finished loading result batch id: data_0_6_2
Traceback (most recent call last):
  File "/Users/.../mono/develop/quick.py", line 50, in <module>
    out = cur.fetch_arrow_all()
          ^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/cursor.py", line 1097, in fetch_arrow_all
    return self._result_set._fetch_arrow_all()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/result_set.py", line 169, in _fetch_arrow_all
    tables = list(self._fetch_arrow_batches())
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/result_set.py", line 86, in result_set_iterator
    batch_iterator = future.result()
                     ^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/concurrent/futures/_base.py", line 456, in result
    return self.__get_result()
           ^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/concurrent/futures/_base.py", line 401, in __get_result
    raise self._exception
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/result_batch.py", line 706, in create_iter
    return self._get_arrow_iter(connection=connection)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/result_batch.py", line 654, in _get_arrow_iter
    return self._create_iter(iter_unit=IterUnit.TABLE_UNIT, connection=connection)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/result_batch.py", line 645, in _create_iter
    loaded_data = self._load(response, iter_unit)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/result_batch.py", line 570, in _load
    iter = PyArrowIterator(
           ^^^^^^^^^^^^^^^^
  File "src/snowflake/connector/arrow_iterator.pyx", line 138, in snowflake.connector.arrow_iterator.PyArrowIterator.__cinit__
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/errors.py", line 297, in errorhandler_wrapper
    raise Error.errorhandler_make_exception(
snowflake.connector.errors.OperationalError: 255005: 255005: Failed to read next arrow batch: b'Array length did not match record batch length'
2023-10-16 16:06:39,401 - MainThread connection.py:659 - close() - INFO - closed
2023-10-16 16:06:39,401 - MainThread telemetry.py:211 - close() - DEBUG - Closing telemetry client.
2023-10-16 16:06:39,401 - MainThread connection.py:665 - close() - INFO - No async queries seem to be running, deleting session
2023-10-16 16:06:39,401 - MainThread network.py:1220 - _use_requests_session() - DEBUG - Session status for SessionPool '....us-east-1.snowflakecomputing.com', SessionPool 1/1 active sessions
2023-10-16 16:06:39,401 - MainThread network.py:881 - _request_exec_wrapper() - DEBUG - remaining request timeout: 5, retry cnt: 1
2023-10-16 16:06:39,401 - MainThread network.py:863 - add_request_guid() - DEBUG - Request guid: 9298e062-96f6-42ea-82da-a064ee98b7f3
2023-10-16 16:06:39,401 - MainThread network.py:1072 - _request_exec() - DEBUG - socket timeout: 60
2023-10-16 16:06:39,405 - MainThread network.py:988 - _request_exec_wrapper() - DEBUG - Ignored error
Traceback (most recent call last):
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/network.py", line 891, in _request_exec_wrapper
    return_object = self._request_exec(
                    ^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/network.py", line 1189, in _request_exec
    raise err
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/network.py", line 1084, in _request_exec
    raw_ret = session.request(
              ^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/vendored/requests/sessions.py", line 577, in request
    settings = self.merge_environment_settings(
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/vendored/requests/sessions.py", line 759, in merge_environment_settings
    env_proxies = get_environ_proxies(url, no_proxy=no_proxy)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/vendored/requests/utils.py", line 830, in get_environ_proxies
    if should_bypass_proxies(url, no_proxy=no_proxy):
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/site-packages/snowflake/connector/vendored/requests/utils.py", line 814, in should_bypass_proxies
    bypass = proxy_bypass(parsed.hostname)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/urllib/request.py", line 2660, in proxy_bypass
    return proxy_bypass_macosx_sysconf(host)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/urllib/request.py", line 2637, in proxy_bypass_macosx_sysconf
    return _proxy_bypass_macosx_sysconf(host, proxy_settings)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/.../mambaforge/envs/DEVARROW/lib/python3.11/urllib/request.py", line 2579, in _proxy_bypass_macosx_sysconf
    from fnmatch import fnmatch
ImportError: sys.meta_path is None, Python is likely shutting down
2023-10-16 16:06:39,405 - MainThread network.py:1225 - _use_requests_session() - DEBUG - Session status for SessionPool '....us-east-1.snowflakecomputing.com', SessionPool 0/1 active sessions
2023-10-16 16:06:39,405 - MainThread network.py:741 - _post_request() - DEBUG - ret[code] = N/A, after post request
2023-10-16 16:06:39,409 - MainThread _query_context_cache.py:141 - clear_cache() - DEBUG - clear_cache() called
2023-10-16 16:06:39,409 - MainThread connection.py:678 - close() - DEBUG - Session is closed
sfc-gh-achandrasekaran commented 10 months ago

@srilman could you verify if this issue happens with newer versions of the connector? 3.5 or 3.6?

sfc-gh-aling commented 7 months ago

@srilman are you still seeing the issue?

is there possible for you to share us with a minimal reproducible sample including the schema of your table as well as some sample data?

srilman commented 7 months ago

No, I can't replicate it anymore. Going to close this issue and can reopen if I see it again.