cockroachdb / cockroachdb/cockroach
Transaction Execution page shows Failed Execution Insight with blank Error Code and Error Message
- 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
Click on Latest Transaction Execution ID. In this case, cd506fad-a12d-4156-b97e-837c6d7d3892.
**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
Assessment
This issue has not been assessed yet.