Skip to content

server,sql: ensure that temp tables wait to know about other instances#92993

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
ajwerner:ajwerner/deflake-temp-table-test
Dec 5, 2022
Merged

server,sql: ensure that temp tables wait to know about other instances#92993
craig[bot] merged 1 commit intocockroachdb:masterfrom
ajwerner:ajwerner/deflake-temp-table-test

Conversation

@ajwerner
Copy link
Copy Markdown
Contributor

@ajwerner ajwerner commented Dec 3, 2022

In #92666 we stopped waiting for the sqlinstance.Reader to know about all the other instances synchronously at startup. Waiting for this information requires out-of-region RPCs. The hazard here is that in the temp table tests which lower the grace period for temp tables dramatically, we might delete temp tables which should not be deleted. By waiting for these instances, we deflake the test.

Epic: none
Fixes: #92895

Release note: None

In cockroachdb#92666 we stopped waiting for the sqlinstance.Reader to know about all the
other instances synchronously at startup. Waiting for this information requires
out-of-region RPCs. The hazard here is that in the temp table tests which lower
the grace period for temp tables dramatically, we might delete temp tables
which should not be deleted. By waiting for these instances, we deflake the
test.

Epic: none
Fixes: cockroachdb#92895

Release note: None
@ajwerner ajwerner requested a review from a team as a code owner December 3, 2022 15:21
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@ajwerner ajwerner requested a review from a team December 3, 2022 16:28
Copy link
Copy Markdown

@postamar postamar left a comment

Choose a reason for hiding this comment

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

This change seems reasonable; however, I'm not an expert in this area.

@ajwerner
Copy link
Copy Markdown
Contributor Author

ajwerner commented Dec 5, 2022

I'll take it.

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Dec 5, 2022

Build succeeded:

@craig craig bot merged commit d1c95d5 into cockroachdb:master Dec 5, 2022
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.

pkg/ccl/testccl/sqlccl/sqlccl_test: TestTenantTempTableCleanup failed

3 participants