search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.9k stars 3.78k forks source link

server: hold up incoming SQL connections until tenant service is ready #111637

Open knz opened 11 months ago

knz commented 11 months ago

Is your feature request related to a problem? Please describe.

Requested by @smcvey : when automating cluster creation, currently crdb nodes report readiness before the SQL service for the application virtual cluster is ready to serve traffic.

This results in spurious SQL connection errors until some undeterminate time after server startup.

Describe the solution you'd like

Incoming SQL connections should be accepted and wait until the service is ready.

Epic: CRDB-26691

Jira issue: CRDB-32001

ajstorm commented 10 months ago

@stevendanna with the 2 PRs you merged, what work remains on this issue?

stevendanna commented 10 months ago

@ajstorm The general issue still remains. Namely we could hold connections for tenants that aren't the default target cluster. However, I think with the work done we could move this out of "Required for 23.2"