sql: statement bundles are missing schema, environment, or table statistics #80396
Assignees
Labels
branch-release-22.1
Used to mark GA and release blockers, technical advisories, and bugs for 22.1
C-bug
Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
deprecated-branch-release-22.1.0
GA-blocker
T-sql-queries
SQL Queries Team
Comments
mgartner
added
C-bug
|
Hi @mgartner, please add branch-* labels to identify which branch(es) this release-blocker affects. 🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan. |
mgartner
added
branch-release-22.1
|
I've bisected to 203c7f4. |
mgartner
added a commit
to mgartner/cockroach
that referenced
this issue
Apr 22, 2022
A regression was introduced in cockroachdb#71246 that caused errors when running internal queries to populate files in statement bundles. As a result, critical information was missing from the `env.sql`, `schema.sql`, and `stats*.sql` files. This commit fixes the issue by using an `InternalExecutorOverride` with a root user override. A root user is required because a node user is insufficient - it does not have privileges on user-defined relations which is needed for the `SHOW CREATE` queries that populate `schema.sql`. Fixes cockroachdb#80396 Release note: None
mgartner
added a commit
to mgartner/cockroach
that referenced
this issue
Apr 22, 2022
A regression was introduced in cockroachdb#71246 that caused errors when running internal queries to populate files in statement bundles. As a result, critical information was missing from the `env.sql`, `schema.sql`, and `stats*.sql` files. This commit fixes the issue by using the internal executor factory to create an internal executor with the current session's session data. Fixes cockroachdb#80396 Release note: None
blathers-crl bot
pushed a commit
that referenced
this issue
Apr 24, 2022
A regression was introduced in #71246 that caused errors when running internal queries to populate files in statement bundles. As a result, critical information was missing from the `env.sql`, `schema.sql`, and `stats*.sql` files. This commit fixes the issue by using the internal executor factory to create an internal executor with the current session's session data. Fixes #80396 Release note: None
blathers-crl bot
pushed a commit
that referenced
this issue
Apr 24, 2022
A regression was introduced in #71246 that caused errors when running internal queries to populate files in statement bundles. As a result, critical information was missing from the `env.sql`, `schema.sql`, and `stats*.sql` files. This commit fixes the issue by using the internal executor factory to create an internal executor with the current session's session data. Fixes #80396 Release note: None
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
On
release-22.1.0(current at dc22506), theenv.sql,schema.sql, andstats*.sqlfiles have errors like:These files contain none of the usual information. I first noticed this problem when collecting a statement bundle for the telemetry cluster which was running v22.1.0-beta.2.
Marking this as a GA blocker because the information in these files is absolutely critical for diagnosing performance problems.
Jira issue: CRDB-15958
The text was updated successfully, but these errors were encountered: