-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: log event for TRUNCATE #25867
Copy link
Copy link
Closed
Labels
A-sql-mutationsMutation statements: UPDATE/INSERT/UPSERT/DELETE.Mutation statements: UPDATE/INSERT/UPSERT/DELETE.
Description
@a-robinson, @jseldess and I just spend a merry 30 minutes trying to figure out what was going on on cobalt, one of our production clusters.
The outcome was that someone must have TRUNCATEd a large table which left lots of empty ranges, which led to an imbalance of live bytes. We needed to look at raw range boundaries to figure this out.
There should be an event log for TRUNCATE similar to the one you get when a table gets created:
cc @jordanlewis for triage (and apologies for what is probably the wrong A-sql-* category)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-mutationsMutation statements: UPDATE/INSERT/UPSERT/DELETE.Mutation statements: UPDATE/INSERT/UPSERT/DELETE.
