cockroachdb / cockroachdb/cockroach

Transaction Execution page shows Failed Execution Insight with blank Error Code and Error Message

Open
#132,196 1 comment 0 reactions 0 assignees View on GitHub
branch-release-23.2 branch-release-24.1 branch-release-24.2 C-bug T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**

Transaction Execution page shows Failed Execution Insight with blank Error Code and Error Message

**To Reproduce**

1. ran `cockroach demo --no-example-database` with `cockroach-v24.2.2.darwin-11.0-arm64`
2. In sql shell, ran

```
demo@127.0.0.1:26257/defaultdb> BEGIN;
BEGIN

Time: 1ms total (execution 1ms / network 1ms)

demo@127.0.0.1:26257/defaultdb OPEN> select * from crdb_internal.cluster_settings where variabl like 'FLORENCE%';
ERROR: column "variabl" does not exist
SQLSTATE: 42703
demo@127.0.0.1:26257/? ERROR> Rollback
-> ;
ROLLBACK

Time: 1ms total (execution 1ms / network 0ms)

demo@127.0.0.1:26257/defaultdb> begin;
BEGIN

Time: 0ms total (execution 1ms / network 0ms)

demo@127.0.0.1:26257/defaultdb OPEN> select * from table_does_not_exist;
ERROR: relation "table_does_not_exist" does not exist
SQLSTATE: 42P01
demo@127.0.0.1:26257/? ERROR> rollback;
ROLLBACK
```

3. Navigate to **Insights** page, Workload Insights > Transaction Executions

Screenshot 2024-10-08 at 4 04 05 PM

Click on Latest Transaction Execution ID. In this case, cd506fad-a12d-4156-b97e-837c6d7d3892.

Screenshot 2024-10-08 at 3 38 03 PM

**Expected behavior**
Error Code and Error Message display the same error info as in the sql shell.

**Environment:**
- CockroachDB version v24.2.2
- Server OS: mac
- Client app `cockroach sql`

Jira issue: CRDB-42870

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.