tests.system.test_session_api: many tests failed

flaky-bot[bot] commented 11 months ago

Many tests failed at the same time in this package.

I will close this issue when there are no more failures in this package and there is at least one pass.
No new issues will be filed for this package until this issue is closed.
If there are already issues for individual test cases, I will close them when the corresponding test passes. You can close them earlier, if you prefer, and I won't reopen them while this issue is still open.

Here are the tests that failed:

test_session_crud
test_batch_insert_then_read
test_batch_insert_then_read_string_array_of_string
test_batch_insert_then_read_all_datatypes
test_batch_insert_or_update_then_query
test_batch_insert_w_commit_timestamp
test_transaction_read_and_insert_then_rollback
test_transaction_read_and_insert_then_exception
test_transaction_read_and_insert_or_update_then_commit
test_transaction_execute_sql_w_dml_read_rollback (#1012)
test_transaction_execute_update_read_commit (#999)
test_transaction_execute_update_then_insert_commit (#1034)
test_transaction_execute_sql_dml_returning (#938)
test_transaction_execute_update_dml_returning (#1013)
test_transaction_batch_update_dml_returning (#898)
test_transaction_batch_update_success
test_transaction_batch_update_and_execute_dml
test_transaction_batch_update_w_syntax_error
test_transaction_batch_update_wo_statements
test_transaction_batch_update_w_parent_span (#975)
test_execute_partitioned_dml (#1029)
test_transaction_read_w_concurrent_updates
test_transaction_query_w_concurrent_updates
test_transaction_read_w_abort
test_read_with_single_keys_index
test_empty_read_with_single_keys_index
test_read_with_multiple_keys_index
test_snapshot_read_w_various_staleness
test_multiuse_snapshot_read_isolation_strong
test_multiuse_snapshot_read_isolation_read_timestamp
test_multiuse_snapshot_read_isolation_exact_staleness
test_read_w_single_key
test_empty_read
test_read_w_multiple_keys
test_read_w_limit
test_read_w_ranges
test_read_partial_range_until_end
test_read_partial_range_from_beginning
test_read_with_range_keys_index_single_key
test_read_with_range_keys_index_closed_closed
test_read_with_range_keys_index_closed_open
test_read_with_range_keys_index_open_closed
test_read_with_range_keys_index_open_open
test_read_with_range_keys_index_limit_closed_closed
test_read_with_range_keys_index_limit_closed_open
test_read_with_range_keys_index_limit_open_closed
test_read_with_range_keys_index_limit_open_open
test_read_with_range_keys_and_index_closed_closed
test_read_with_range_keys_and_index_closed_open
test_read_with_range_keys_and_index_open_closed
test_read_with_range_keys_and_index_open_open
test_partition_read_w_index (#924)
test_execute_sql_w_manual_consume
test_execute_sql_w_to_dict_list
test_multiuse_snapshot_execute_sql_isolation_strong
test_execute_sql_returning_array_of_struct
test_execute_sql_returning_empty_array_of_struct
test_invalid_type
test_execute_sql_select_1
test_execute_sql_w_string_bindings
test_execute_sql_w_bool_bindings
test_execute_sql_w_int64_bindings
test_execute_sql_w_float64_bindings
test_execute_sql_w_float_bindings_transfinite
test_execute_sql_w_bytes_bindings
test_execute_sql_w_timestamp_bindings
test_execute_sql_w_date_bindings
test_execute_sql_w_numeric_bindings
test_execute_sql_w_jsonb_bindings
test_execute_sql_w_query_param_struct
test_execute_sql_returning_transfinite_floats
test_partition_query (#925)
test_mutation_groups_insert_or_update_then_query

commit: 7a92315c8040dbf6f652974e19cd63abfd6cda2f buildURL: Build Status, Sponge status: failed

flaky-bot[bot] commented 11 months ago

Looks like this issue is flaky. :worried:

I'm going to leave this open and stop commenting.

A human should fix and close this.

When run at the same commit (7a92315c8040dbf6f652974e19cd63abfd6cda2f), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).

harshachinta commented 11 months ago

Looks like this is flaky. A rerun of the kokoro build succeeded. https://fusion2.corp.google.com/ci/kokoro/prod:cloud-devrel%2Fclient-libraries%2Fpython%2Fgoogleapis%2Fpython-spanner%2Fcontinuous%2Fcontinuous/activity/f11b5f04-8984-4a9d-99c1-61a5281388bc/log

googleapis / python-spanner

tests.system.test_session_api: many tests failed #1059