Skip to content

ccl/sqlproxyccl: deflake TestConnectionMigration#108192

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
jaylim-crl:jay/230804-fix-migration-flake
Aug 5, 2023
Merged

ccl/sqlproxyccl: deflake TestConnectionMigration#108192
craig[bot] merged 1 commit intocockroachdb:masterfrom
jaylim-crl:jay/230804-fix-migration-flake

Conversation

@jaylim-crl
Copy link
Copy Markdown
Contributor

Fixes #106885.

This test flake seems extremely rare, and it's unclear why it occurred in the
first place. The past 1000 runs (all of what TC has) have been successful.
Regardless, this commit attempts at deflaking TestConnectionMigration. Given
that some subtests transfer connections through transferConnWithRetries, it
is possible that the transfer was retried, causing the metric to be
incremented.

Release note: None

Epic: none

@jaylim-crl jaylim-crl requested review from a team as code owners August 4, 2023 18:01
@jaylim-crl jaylim-crl requested a review from jeffswenson August 4, 2023 18:01
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Contributor

@darinpp darinpp left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

Fixes cockroachdb#106885.

This test flake seems extremely rare, and it's unclear why it occurred in the
first place. The past 1000 runs (all of what TC has) have been successful.
Regardless, this commit attempts at deflaking TestConnectionMigration. Given
that some subtests transfer connections through `transferConnWithRetries`, it
is possible that the transfer was retried, causing the metric to be
incremented.

Release note: None

Epic: none
@jaylim-crl jaylim-crl force-pushed the jay/230804-fix-migration-flake branch from 26f8587 to ee9ea9a Compare August 4, 2023 19:05
@jaylim-crl
Copy link
Copy Markdown
Contributor Author

TFTR! All the test failures are unrelated.

bors r=darinpp

craig bot pushed a commit that referenced this pull request Aug 4, 2023
108115: roachtest: don't reuse clusters that call dmsetup r=erikgrinaker,srosenberg a=andrewbaptist

Certain tests need to modify the blockdevice and they are prone to failures during setup that the device is still busy. Ideally we would figure out what is still holding onto the dish handle, but it is safer to simply not reuse clusters that perform this by adding `spec.ReuseNone()`

Fixes: #107865
Epic: none

Release note: None

108165: sql: fix insight integration test for contention r=koorosh a=koorosh

This change lowers the latency threshold for which statement is considered slow to make sure it detects contention.
Previous value was set to 100ms which is default. New value is set to 30ms to be the same as overridden
value in other tests.

Release note: None

Resolves: #108020

108192: ccl/sqlproxyccl: deflake TestConnectionMigration r=darinpp a=jaylim-crl

Fixes #106885.

This test flake seems extremely rare, and it's unclear why it occurred in the
first place. The past 1000 runs (all of what TC has) have been successful.
Regardless, this commit attempts at deflaking TestConnectionMigration. Given
that some subtests transfer connections through `transferConnWithRetries`, it
is possible that the transfer was retried, causing the metric to be
incremented.

Release note: None

Epic: none

Co-authored-by: Andrew Baptist <baptist@cockroachlabs.com>
Co-authored-by: Andrii Vorobiov <and.vorobiov@gmail.com>
Co-authored-by: Jay <jay@cockroachlabs.com>
@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 4, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 4, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 5, 2023

Build succeeded:

@craig craig bot merged commit a1c86ea into cockroachdb:master Aug 5, 2023
@jaylim-crl jaylim-crl deleted the jay/230804-fix-migration-flake branch August 5, 2023 00:56
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

ccl/sqlproxyccl: TestConnectionMigration failed

3 participants