com.example.spanner.changestreams.ChangeStreamSampleIT: testChangeStreamSample failed

[flaky-bot[bot]]

This test failed!

To configure my behavior, see the Flaky Bot documentation.

If I'm commenting on this issue too often, add the flakybot: quiet label and I will stop commenting.

---

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

Test output

java.lang.AssertionError
	at com.example.spanner.changestreams.ChangeStreamSampleIT.testChangeStreamSample(ChangeStreamSampleIT.java:108)

[flaky-bot[bot]]

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 (b8df1c65b82106e9cffb52f04a557dbc7921a774), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).

[flaky-bot[bot]]

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

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

---

commit: 72f33abdc0fc1a38b84afc756775e2b883d91f74 buildURL: Build Status, Sponge status: failed

Test output

java.lang.AssertionError
	at com.example.spanner.changestreams.ChangeStreamSampleIT.testChangeStreamSample(ChangeStreamSampleIT.java:108)

[ansh0l]

cc @haikuo-google

[flaky-bot[bot]]

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

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

---

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

Test output

java.lang.AssertionError
	at [email protected]/com.example.spanner.changestreams.ChangeStreamSampleIT.testChangeStreamSample(ChangeStreamSampleIT.java:114)

[ansh0l]

@haikuo-google Can you take a look?

[kurtisvg]

https://github.com/GoogleCloudPlatform/java-docs-samples/pull/7339 added an ignore to this test. It needs to be removed before this issue can be closed.

[flaky-bot[bot]]

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

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

---

commit: 66eb5c5bdb2ae113a071551cb4a9ec4c64b7caca buildURL: Build Status, Sponge status: failed

Test output

com.google.common.truth.AssertionErrorWithFacts: 
expected to contain:
    Received a DataChangeRecord
but was:
    Updating database DDL to create table prefix_Singers and change stream prefix_ChangeStreamSingers.
    Inserting rows (1, singer_1_first_name, singer_1_last_name) and (2, singer_2_first_name, singer_2_last_name) into prefix_Singers table.
    Executing change stream initial query.
    Executing a change stream query with: start_timestamp => 2023-01-14T09:53:23.544000000Z, end_timestamp => 2023-01-14T09:53:53.544000000Z, partition_token => null, heartbeat_milliseconds => 5000
    Received a ChildPartitionsRecord: ChildPartitionsRecord{startTimestamp=2023-01-14T09:53:23.544000000Z, recordSequence='00000001', childPartitions=[ChildPartition{childToken='__8BAYEGyDSvMAABgsBEg3ByZWZpeF9DaGFuZ2VTdHJlYW1TaW5nZXJzAAGEgQCCgIMIw2QAAAAAAACEBB2xwRSFZzBfMAAB__-F_wXyNk5K3L-G_wXyNtMIKnWHgMBkAQH__w', parentTokens=[]}]}
    Received a ChildPartitionsRecord: ChildPartitionsRecord{startTimestamp=2023-01-14T09:53:23.544000000Z, recordSequence='00000002', childPartitions=[ChildPartition{childToken='__8BAYEGyDSvMAABgsBEg3ByZWZpeF9DaGFuZ2VTdHJlYW1TaW5nZXJzAAGEgQZsALJQAByCgIMIw2QAAAAAAACEBGC0YBOFZzI4XzExMzI0OTA2MQAB__-F_wXyNiI9hH-G_wXyNnpxU4iHgMBkAQH__w', parentTokens=[]}]}
    Executing change stream partition queries.
    Executing a change stream query with: start_timestamp => 2023-01-14T09:53:23.544000000Z, end_timestamp => 2023-01-14T09:53:53.544000000Z, partition_token => __8BAYEGyDSvMAABgsBEg3ByZWZpeF9DaGFuZ2VTdHJlYW1TaW5nZXJzAAGEgQCCgIMIw2QAAAAAAACEBB2xwRSFZzBfMAAB__-F_wXyNk5K3L-G_wXyNtMIKnWHgMBkAQH__w, heartbeat_milliseconds => 5000
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:28.544222000Z}
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:32.274356000Z}
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:37.274532000Z}
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:42.274696000Z}
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:47.274858000Z}
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:52.275029000Z}
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:53.544000000Z}
    Executing a change stream query with: start_timestamp => 2023-01-14T09:53:23.544000000Z, end_timestamp => 2023-01-14T09:53:53.544000000Z, partition_token => __8BAYEGyDSvMAABgsBEg3ByZWZpeF9DaGFuZ2VTdHJlYW1TaW5nZXJzAAGEgQZsALJQAByCgIMIw2QAAAAAAACEBGC0YBOFZzI4XzExMzI0OTA2MQAB__-F_wXyNiI9hH-G_wXyNnpxU4iHgMBkAQH__w, heartbeat_milliseconds => 5000
    Received a HeartbeatRecord: HeartbeatRecord{timestamp=2023-01-14T09:53:53.544000000Z}
    Updating database DDL to drop table prefix_Singers and change stream prefix_ChangeStreamSingers.
at com.example.spanner.changestreams.ChangeStreamSampleIT.testChangeStreamSample(ChangeStreamSampleIT.java:116)

[averikitsch]

I am reverting to ignore this test. This sample has 50% chance of the tests passing due to print statements not showing up. The product team needs to decide if the tests below are need to confirm the sample is working or the sample needs to be rewritten:

    Assert.assertTrue(got, got.contains("Received a DataChangeRecord"));
    Assert.assertTrue(got, got.contains("mods=[Mod{keysJson={\"SingerId\":\"1\"}, "
        + "oldValuesJson='', "
        + "newValuesJson="
        + "'{\"FirstName\":\"singer_1_first_name\",\"LastName\":\"singer_1_last_name\"}'}, "
        + "Mod{keysJson={\"SingerId\":\"2\"}, "
        + "oldValuesJson='', "
        + "newValuesJson="
        + "'{\"FirstName\":\"singer_2_first_name\",\"LastName\":\"singer_2_last_name\"}'}]"));