Skip to content

insights: add status field to transaction insights#98217

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
gtr:txn-insights-status
Mar 13, 2023
Merged

insights: add status field to transaction insights#98217
craig[bot] merged 1 commit intocockroachdb:masterfrom
gtr:txn-insights-status

Conversation

@gtr
Copy link
Copy Markdown

@gtr gtr commented Mar 8, 2023

Part of: #87785.

Previously, execution insights did not keep track of a transaction's
status. This commit adds the status field to transaction insights. A
transaction's status is determined from its statements: if all
statement statuses are Completed, then the transaction status is
Completed and if there is one Failed statement status, then the
transaction status is also Failed.

Release note (sql change): Added status column to
crdb_internal.[cluster|node]_txn_execution_insights virtual tables.

Part of: cockroachdb#87785.

Previously, execution insights did not keep track of a transaction's
status. This commit adds the `status` field to transaction insights. A
transaction's status is determined from its statements: if all
statement statuses are `Completed`, then the transaction status is
`Completed` and if there is one `Failed` statement status, then the
transaction status is also `Failed`.

Release note (sql change): Added `status` column to
`crdb_internal.[cluster|node]_txn_execution_insights` virtual tables.
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@gtr gtr force-pushed the txn-insights-status branch from 51556dc to e4cba47 Compare March 8, 2023 15:53
@gtr gtr marked this pull request as ready for review March 8, 2023 16:06
@gtr gtr requested review from a team and removed request for a team March 8, 2023 16:06
Copy link
Copy Markdown
Contributor

@maryliag maryliag left a comment

Choose a reason for hiding this comment

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

:lgtm:

Reviewed 8 of 8 files at r1, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @gtr)

@gtr
Copy link
Copy Markdown
Author

gtr commented Mar 13, 2023

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 13, 2023

Build succeeded:

@craig craig bot merged commit f44ffdb into cockroachdb:master Mar 13, 2023
@gtr gtr deleted the txn-insights-status branch July 13, 2023 15:20
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.

3 participants