Skip to content

sqlinstance: make Start async, use in-memory copy of self to bootstrap#92666

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
jaylim-crl:jay/221128-sqlinstance-async-start
Nov 29, 2022
Merged

sqlinstance: make Start async, use in-memory copy of self to bootstrap#92666
craig[bot] merged 1 commit intocockroachdb:masterfrom
jaylim-crl:jay/221128-sqlinstance-async-start

Conversation

@jaylim-crl
Copy link
Copy Markdown
Contributor

This solves bullet 4 of #85737. This commit makes sqlinstance.Start async, and
not block until the rangefeed gets started.

Epic: CRDB-18596

Release note: None

Copy link
Copy Markdown
Contributor

@ajwerner ajwerner left a comment

Choose a reason for hiding this comment

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

LGTM

This solves bullet 4 of cockroachdb#85737. This commit makes sqlinstance.Start async, and
not block until the rangefeed gets started.

Epic: CRDB-18596

Release note: None

Co-authored-by: Andrew Werner <awerner32@gmail.com>
@jaylim-crl jaylim-crl force-pushed the jay/221128-sqlinstance-async-start branch from b4fa8d9 to e90c549 Compare November 29, 2022 14:43
@jaylim-crl jaylim-crl marked this pull request as ready for review November 29, 2022 16:31
@jaylim-crl jaylim-crl requested a review from a team as a code owner November 29, 2022 16:31
@jaylim-crl
Copy link
Copy Markdown
Contributor Author

TFTR!

bors r=ajwerner

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Nov 29, 2022

Build succeeded:

@craig craig bot merged commit edc6fda into cockroachdb:master Nov 29, 2022
@jaylim-crl jaylim-crl deleted the jay/221128-sqlinstance-async-start branch November 30, 2022 16:54
ajwerner added a commit to ajwerner/cockroach that referenced this pull request Dec 3, 2022
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
craig bot pushed a commit that referenced this pull request Dec 5, 2022
92993: server,sql: ensure that temp tables wait to know about other instances r=ajwerner a=ajwerner

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

Co-authored-by: Andrew Werner <awerner32@gmail.com>
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.

2 participants