The 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 zip can contain highly sensitive, identifiable information, such as usernames, hashed passwords, and possibly your table's data. You can use the --redact flag to redact the sensitive data out of log files and crash reports before sharing them with Cockroach Labs.
Subcommands
While the cockroach debug command has a few subcommands, users are expected to use only the zip, encryption-active-key, merge-logs, list-files, tsdump, and ballast subcommands.
We recommend using the encryption-decrypt and job-trace subcommands only when directed by the Cockroach Labs support team.
The other debug subcommands are useful only to Cockroach Labs. Output of debug commands may contain sensitive or secret information.
Synopsis
$ cockroach debug merge-logs [log file directory] [flags]
Flags
The debug merge-logs subcommand supports the following flags:
| Flag | Description |
|---|---|
--format |
Required The format of the logs in the log file directory. The logs in a .zip generated using cockroach debug zip are of type crdb-v1. |
--filter |
Limit the results to the specified regular expression |
--from |
Start time for the time range filter. |
--to |
End time for the time range filter. |
--redact |
Redact sensitive data from the log files. |
Example
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/* --format=crdb-v1
Alternatively, filter the merged logs for a specified time range:
cockroach debug merge-logs debug/nodes/*/logs/* --format=crdb-v1 --from="231031 19:19:50.917185" --to="231031 19:19:57.189263"
You can also filter the merged logs for a regular expression:
cockroach debug merge-logs debug/nodes/*/logs/* --format=crdb-v1 --filter="ALL SECURITY CONTROLS HAVE BEEN DISABLED"
You can redact sensitive information from the merged logs:
cockroach debug merge-logs debug/nodes/*/logs/* --format=crdb-v1 --redact
Considerations
As of v23.2, logs can be configured to use a timezone with formats crdb-v1 or crdb-v2. This is a backward-incompatible change. cockroach debug merge-logs requires v23.2 or later if run against logs with the timezone configured. With versions prior to v23.2, cockroach debug merge-logs will return an error if run against logs with the timezone configured.
