search

coiled / benchmarks

BSD 3-Clause "New" or "Revised" License
28 stars 17 forks source link

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

Open github-actions[bot] opened 7 months ago

github-actions[bot] commented 7 months ago

Workflow Run URL

milesgranger commented 7 months ago

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