spanner.cloud-client.snippets_test: test_query_data_with_timestamp_parameter failed

[flaky-bot]

Note: #3543 was also for this test, but it was closed more than 10 days ago. So, I didn't mark it flaky.

---

commit: 3680196
buildURL: Build Status, Sponge
status: failed

Test output

Traceback (most recent call last):
  File "/workspace/spanner/cloud-client/snippets_test.py", line 358, in test_query_data_with_timestamp_parameter
    assert 'VenueId: 4, VenueName: Venue 4, LastUpdateTime:' in out
AssertionError: assert 'VenueId: 4, VenueName: Venue 4, LastUpdateTime:' in ''

[flaky-bot]

Looks like this issue is flaky. 😟

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

A human should fix and close this.

---

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

[tmatsuo]

I'm not 100% confident, but the spanner tests has the following code:

def unique_database_id():
    """ Creates a unique id for the database. """
    return 'test-db-{}'.format(''.join(random.choice(
        string.ascii_lowercase + string.digits) for _ in range(5)))

Is it possible that on multiple machines, random gets the same seed then we get the same random id?

Anyways, maybe we can just use uuid4.

[flaky-bot]

Oops! Looks like this issue is still flaky. It failed again. 😬

I reopened the issue, but a human will need to close it again.

---

commit: 51a66f9
buildURL: Build Status, Sponge
status: failed

Test output

Traceback (most recent call last):
  File "/workspace/spanner/cloud-client/snippets_test.py", line 356, in test_query_data_with_timestamp_parameter
    assert 'VenueId: 4, VenueName: Venue 4, LastUpdateTime:' in out
AssertionError: assert 'VenueId: 4, VenueName: Venue 4, LastUpdateTime:' in ''