-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest/drt: add temp table usage to DRT #151545
Copy link
Copy link
Open
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.Might be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
We've seen cases where temporary table cleanup fails, but the errors often surface well after the original issue, making them hard to trace. To improve debugging, we should add temp table usage to DRT. This could help surface failures while we still have relevant context like logs.
This issue tracks adding a new DRT operation that creates and exercises temporary tables.
The operation could:
- Create a temporary table or view
- Add DML for the temporary table
- Sleep for a short period to keep the session active (to simulate cleanup paths triggered by session end vs. node crash)
- Disconnect to trigger cleanup logic
Jira issue: CRDB-53334
Epic CRDB-17128
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.Might be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)