cockroach debug merge-logs command merges log files from multiple nodes into a single time-ordered stream of messages with an added per-message prefix to indicate the corresponding node. You can use it in conjunction with logs collected using the
debug zip command to aid in debugging.
The file produced by
cockroach debug merge-log can contain highly sensitive, unanonymized information, such as usernames, passwords, and possibly your table's data. You should share this data only with Cockroach Labs developers and only after determining the most secure method of delivery.
debug subcommands are useful only to CockroachDB's developers and contributors.
$ cockroach debug merge-logs [log file directory] [flags]
Use the following flags to filter the
debug merge-logs results for a specified regular expression or time range.
|Limit the results to the specified regular expression
|Start time for the time range filter.
|End time for the time range filter.
Generate a debug zip file:
$ cockroach debug zip ./cockroach-data/logs/debug.zip --insecure
Unzip the file:
$ unzip ./cockroach-data/logs/debug.zip
Merge the logs in the debug folder:
$ cockroach debug merge-logs debug/nodes/*/logs/*
Alternatively, filter the merged logs for a specified time range:
$ cockroach debug merge-logs debug/nodes/*/logs/* --from= "18:36:28.208553" --to= "18:36:29.232864"
You can also filter the merged logs for a regular expression:
cockroach debug merge-logs debug/nodes/*/logs/* --filter="RUNNING IN INSECURE MODE"