OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Diagnostic Tool

V4.3.0
  • obdiag Overview
  • obdiag installation
  • obdiag configuration
  • One-click Cluster Inspection
    • One-click cluster inspection
    • Detailed explanation of cluster inspection indicators
  • One-click Information Gathering
    • One-click routine information collection
      • OceanBase cluster log collection
      • Host information collection
      • SQL details collection
      • Stack information collection
      • Flame Picture/Bian Que Picture Collection
      • ASH report collection
      • Collect table-related information
      • Cluster parameter collection
      • Variable collection
      • clog/slog collection
      • DBMS_XPLAN information collection
      • Core file collection
      • AWR report collection
      • obproxy log collection
      • OMS log collection
      • Collect all information
    • One-click scenario-based information collection
      • Overview
      • Collect basic cluster information
      • Collect backup problem information
      • Collect backup cleanup problem information
      • Collect clog disk full problem information
      • Collect cluster downtime problem information
      • Collect merge problem information
      • Collect CPU high problem information
      • Collect information on delay issues in primary and standby databases
      • Collect I/O problem information
      • Collect log archiving problem information
      • Collect long transaction problem information
      • Collect memory problem information
      • Collect SQL performance problem information
      • Collect PX error reporting information
      • Collect recovery problem information
      • Collect observer restart information without reason
      • Collect owner-cutting problem information
      • Collect information about hanging transaction issues
      • Collect copy imbalance problem information
      • Collect SQL error reporting information
      • Collect cluster TopSQL information
      • Collect application error information
      • Collect obproxy restart problem information for no reason
      • Collect ODP parameter information
      • Collect unspecified scenario problem information
  • One-click Diagnostic Analysis
    • One-click diagnostic analysis log
    • One-click full-link diagnostic log analysis
    • Parameter analysis (compared with default values)
    • Parameter analysis (parameter differences on different observers)
    • Analyze variables
    • Instructions for using index space analysis
    • One-click diagnostic analysis of memory
    • One-click diagnosis and analysis of queue backlog
  • One-click Root Cause Analysis
    • One-click root cause analysis
    • Root cause analysis scenario: disconnection
    • Root cause analysis scenario: card merging major_hold
    • Root cause analysis scenario: lock conflict lock_conflict
    • Root cause analysis scenario: executing DDL and reporting disk full error ddl_disk_full
    • Root cause analysis scenario: clog disk is full clog_disk_full
    • Root cause analysis scenario: log error log_error
    • Root cause analysis scenario: DDL failure ddl_failure
    • Root cause analysis scenario: Troubleshooting index build execution error index_ddl_error
    • Root cause analysis scenario: transaction disconnection scenario transaction_disconnection
    • Root cause analysis scenario: transaction execution times out and error transaction_execute_timeout
    • Root cause analysis scenario: transaction does not end and error transaction_not_ending is reported
    • Root cause analysis scenario: transaction other errors transaction_other_error
    • Root cause analysis scenario: transaction rollback error transaction_rollback
    • Root cause analysis scenario: transaction wait timeout error transaction_wait_timeout
    • Root cause analysis scenario: OMS full migration exception oms_full_trans
    • Root cause analysis scenario: OMS obcdc component analysis oms_obcdc
    • Root cause analysis scenario: suspended transaction suspend_transaction
    • Root cause analysis scenario: Unit GC exception unit_gc
    • Root cause analysis scenario: OceanBase cluster playback card
    • Root cause analysis scenario: OceanBase cluster memory explosion
    • Root cause analysis scenario: Abnormal deletion of OBServer node
    • Root cause analysis scenario: GC troubleshooting gc_troubleshooting
    • Root cause analysis scenario: Schema leak schema_leak
    • Root cause analysis scenario: partition split scheduling error split_schedule_error
    • Root cause analysis scenario: weak read problem troubleshooting weak_read_troubleshooting
    • Root cause analysis scenario: SQL execution memory is too high execute_memory_high
  • One-click Cluster Insights
    • Overview
    • Cluster overview information insights
    • Cluster node information insight
    • Cluster unit information insight
    • Cluster Zone Information Insights
    • Cluster RS Information Insights
    • Cluster tenant information insight
    • Cluster event information insight
    • Cluster lock information insight
    • Cluster topsql information insight
    • Cluster slowsql information insight
    • Cluster table information insight
    • Cluster processlist information insight
    • SQL execution plan information insights
    • Insights into database disk usage information
    • Insight on the disk usage of the specified table in the database
    • Insights into the full tenant information of the cluster
    • Cluster node CPU usage information insights
    • Internal table name fuzzy matching information insight
    • Cluster leader information insight
    • Information insights into locks held on a certain table
    • Cluster long transaction information information insight
    • Actual execution plan operator information insight
    • Memory information insights for all tenants
    • processlist Real-time session summary information insights
    • Table/index storage method information insight
    • Table NDV Information Insights
    • Table index information insight
    • Merge status display
    • clog log volume/capacity statistics
  • Plug-in file upgrade
  • Update and uninstall
  • Telemetry Mode
  • FAQ
  • Tools
    • Configuration file encryption
    • AI Intelligent Diagnosis Assistant
    • Disk IO performance detection
    • Configure verification tool
  • Release Notes
    • obdiag V4.2.0
    • obdiag V4.1.0
    • obdiag V4.0.0
    • obdiag V3.7.2
    • obdiag V3.7.1
    • obdiag V3.7.0
    • obdiag V3.6.0
    • obdiag V3.5.0
    • obdiag V3.4.0
    • obdiag V3.3.0
    • obdiag V3.2.0
    • obdiag V3.1.0
    • obdiag V3.0.0
    • obdiag V2.6.0
    • obdiag V2.5.0
    • obdiag V2.4.0
    • obdiag V2.3.0
    • obdiag V2.2.0
    • obdiag V2.1.0
    • obdiag V2.0.0
    • obdiag V1.6.2
    • obdiag V1.6.1
    • obdiag V1.6.0
    • obdiag V1.5.2
    • obdiag V1.5.1
    • obdiag V1.5.0
    • obdiag V1.4.0
    • obdiag V1.3.0

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Diagnostic Tool
  3. V4.3.0

OMS log collection

Last Updated:2026-09-04 08:22:12

Instructions for use
Prerequisites
Usage example
Method 1: Use with configuration file
Method 2: Pass configuration through --config (out-of-the-box)

This article applies to the scenario of independent deployment of obdiag. Use the obdiag gather oms_log command to collect logs of OceanBase Migration Service (OMS) related components with one click.

If it is a cluster deployed by obd, information can be collected directly through the obd side diagnostic command group.

Description

Before use, you need to fill in the SSH login information of the OMS-related nodes in the obdiag configuration (that is, the configuration must include the IP, ssh_username, ssh_password, home_path, etc. of the OMS node). The OMS node configuration method is similar to obcluster/obproxy. For details, please refer to the deployment documentation or contact the administrator.

Instructions for use

obdiag gather oms_log [options]

The options are explained below:

Option name
Is it required
Data type
Default value
Description
--from No string Default is empty The start time of log collection, format: yyyy-mm-dd hh:mm:ss.
--to No string Default is empty The end time of log collection, format: yyyy-mm-dd hh:mm:ss.
--since No string 30m The time range relative to the current time, format: <n><m|h|d>, where n represents the time number to be entered, m represents minutes, h represents hours, and d represents days, such as 1h represents the last hour.
--scope no string all Type of OMS logs to collect. Optional values ​​are console, nginx, supervisord, drc, ghana, scheduler, web, alarm, api, gc, cm, supervisor, cdc, libobcdc, store, all.
--grep No string Default is empty Keyword filtering, can be specified multiple times, only collect log lines containing the specified keyword.
--store_dir No string Current directory Local path to store results.
--temp_dir No string /tmp The temporary file storage directory on the remote OMS node.
--recent_count No int 0 Only collect the most recent N log files; --from, --to, --since are ignored when greater than 0.
--oms_component_id No string Default is empty The OMS component ID corresponding to the CDC log, in the format of 10.10.10.1-123.
-c No string ~/.obdiag/config.yml Configuration file path.
--inner_config No string Default is empty obdiag Self-configuration, format: --inner_config key=value.
--config No string Default is empty Cluster/OMS node configuration, format: --config key1=value1 --config key2=value2. See obdiag configuration for details.
--config_password No string Default is empty obdiag When using an encrypted configuration file, you need to pass in the corresponding password through this option. For details, see Configuration File Encryption.

Prerequisites

  1. Obdiag has been installed and user-side configuration has been completed.
  2. The configuration already contains the SSH login information and log_path (OMS log root directory) of the OMS node, ensuring that the machine where obdiag is located can SSH to the OMS node.

Usage example

Method 1: Use with configuration file

After ensuring that the OMS node information has been configured in ~/.obdiag/config.yml, execute:

# Collect last 30 minutes of OMS logs (default)
obdiag gather oms_log

# Collect last 1 hour of OMS logs
obdiag gather oms_log --since 1h

# Specify time range
obdiag gather oms_log --from "2024-01-15 10:00:00" --to "2024-01-15 11:00:00"

# Collect only console and CDC logs
obdiag gather oms_log --scope console --scope cdc

# Keyword filter
obdiag gather oms_log --since 1h --grep "ERROR" --grep "Exception"

# Collect at most the 5 latest log files
obdiag gather oms_log --recent_count 5

# Specify CDC component ID (when collecting CDC logs)
obdiag gather oms_log --since 1h --oms_component_id 10.10.10.1-12345 --scope cdc

Method 2: Pass configuration through --config (out-of-the-box)

When passing OMS node information through --config, you need to specify the IP, ssh login information and log_path (OMS log root directory) of each OMS node, for example:

obdiag gather oms_log --since 1h \
    --config oms.servers.nodes[0].ip=xx.xx.xx.1 \
    --config oms.servers.nodes[1].ip=xx.xx.xx.2 \
    --config oms.servers.global.ssh_username=admin \
    --config oms.servers.global.ssh_password=****** \
    --config oms.servers.global.log_path=/home/admin/logs
```<main id="notice" type='notice'>
  <h4>Description</h4>
  <p>OMS collection depends on <code>oms.servers</code> and <code>oms.servers.global.log_path</code> (OMS log root directory, required) in the configuration. CDC related logs also need to configure <code>store_path</code> and specify <code>--oms_component_id</code> in the command. For the configuration template, please refer to <code>~/.obdiag/example/all-components-with-oms.yml</code>. </p>
</main>

## Result description

After the command is successfully executed, a collection package (such as `obdiag_gather_pack_yyyyMMddHHmmss`) will be generated in the directory specified by `--store_dir`, which contains compressed log packages collected by each OMS node based on time and scope to facilitate troubleshooting of migration and synchronization issues.

Previous topic

obproxy log collection
Last

Next topic

Collect all information
Next
on this page
Instructions for use
Prerequisites
Usage example
Method 1: Use with configuration file
Method 2: Pass configuration through --config (out-of-the-box)