Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

⚠️ CI failed ⚠️ - Snowflake DB connection Error #1341

Open
github-actions bot opened this issue Feb 3, 2024 · 1 comment
Open

⚠️ CI failed ⚠️ - Snowflake DB connection Error #1341

github-actions bot opened this issue Feb 3, 2024 · 1 comment

Comments

@github-actions
Copy link

github-actions bot commented Feb 3, 2024

Workflow Run URL

@milesgranger
Copy link
Contributor

milesgranger commented Feb 5, 2024

FAILED tests/workflows/test_snowflake.py::test_read[client0] - snowflake.connector.errors.DatabaseError: 250001 (08001): Failed to connect to DB: ***.snowflakecomputing.com:443. Incorrect username or password was specified.
ERROR tests/workflows/test_snowflake.py::test_etl_into_snowflake[client0] - sqlalchemy.exc.DatabaseError: (snowflake.connector.errors.DatabaseError) 250001 (08001): Failed to connect to DB: ***.snowflakecomputing.com:443. Incorrect username or password was specified.

Then TPC-H: (edit: this part has been fixed now)

FAILED tests/tpch/test_correctness.py::test_dask_results[12] - AssertionError: DataFrame are different

DataFrame shape mismatch
[left]:  (7, 3)
[right]: (2, 3)
FAILED tests/tpch/test_optimization.py::test_optimization[18] - KeyError: False
FAILED tests/tpch/test_dask.py::test_query_18 - KeyError: False
FAILED tests/tpch/test_correctness.py::test_dask_results[13] - Failed: Timeout >3600.0s
FAILED tests/tpch/test_correctness.py::test_dask_results[16] - AssertionError: DataFrame are different

DataFrame shape mismatch
[left]:  (114161, 4)
[right]: (18314, 4)
FAILED tests/tpch/test_correctness.py::test_dask_results[17] - AssertionError: DataFrame.iloc[:, 0] (column name="avg_yearly") are different

DataFrame.iloc[:, 0] (column name="avg_yearly") values are different (100.0 %)
[index]: [0]
[left]:  [33330456.87]
[right]: [348406.0542857143]
At positional index 0, first diff: 33330456.87 != 348406.0542857143
FAILED tests/tpch/test_correctness.py::test_dask_results[18] - KeyError: False
FAILED tests/tpch/test_correctness.py::test_dask_results[21] - AssertionError: DataFrame are different

DataFrame shape mismatch
[left]:  (0, 2)
[right]: (100, 2)
FAILED tests/tpch/test_correctness.py::test_dask_results[22] - AssertionError: DataFrame.iloc[:, 1] (column name="numcust") are different

DataFrame.iloc[:, 1] (column name="numcust") values are different (100.0 %)
[index]: [0, 1, 2, 3, 4, 5, 6]
[left]:  [2680, 2642, 2779, 2697, 2835, 2653, 2739]
[right]: [888, 861, 964, 892, 948, 909, 922]
At positional index 0, first diff: 2680 != 888

@milesgranger milesgranger changed the title ⚠️ CI failed ⚠️ ⚠️ CI failed ⚠️ - Snowflake DB connection Error - TPCH incorrect results (regression) Feb 5, 2024
@milesgranger milesgranger changed the title ⚠️ CI failed ⚠️ - Snowflake DB connection Error - TPCH incorrect results (regression) ⚠️ CI failed ⚠️ - Snowflake DB connection Error Feb 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant