BestHub
Sign in
Tag

Database Troubleshooting

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

Database TroubleshootingJSONMySQL
0 likes · 7 min read
Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2025 · Databases

Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution

This article explains how to reproduce a MySQL InnoDB lock‑wait scenario, use system tables such as information_schema.processlist, innodb_trx, sys.innodb_lock_waits and performance_schema to locate the blocking transaction, and finally resolve the issue by killing the offending session, while also providing quick‑check queries and parameter tuning advice.

Database TroubleshootingInnoDBMySQL
0 likes · 9 min read
Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 25, 2025 · Databases

ChatDBA vs DeepSeek: AI‑Driven Diagnosis of OceanBase Backup Cluster Tenant Sync Issue (Case Study)

This case study demonstrates how the AI assistant ChatDBA identifies and resolves a tenant data‑synchronization failure in an OceanBase primary‑backup cluster, detailing four interactive troubleshooting rounds, the final SQL fix, and a comparative analysis with the DeepSeek‑R1 model.

AI AssistantChatDBADatabase Troubleshooting
0 likes · 5 min read
ChatDBA vs DeepSeek: AI‑Driven Diagnosis of OceanBase Backup Cluster Tenant Sync Issue (Case Study)
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2025 · Databases

Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode

This article details the background, configuration, and step‑by‑step troubleshooting process for a data pipeline that replaces a MySQL source with OceanBase using OBLogProxy in binlog mode, explains why downstream reads missed incremental data, and provides conclusions and optimization measures.

Data SynchronizationDatabase TroubleshootingFlink CDC
0 likes · 12 min read
Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 11, 2025 · Databases

OceanBase Timeout During Merge: Diagnosis, Emergency Handling, and Optimization

This article details a timeout incident in an OceanBase cluster during a merge operation, explains the emergency suspension and resumption steps, analyzes log and metric data to identify queue backlog and disk I/O saturation as root causes, and offers practical optimization recommendations.

Database TroubleshootingOceanBaseQueue backlog
0 likes · 6 min read
OceanBase Timeout During Merge: Diagnosis, Emergency Handling, and Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 10, 2025 · Databases

ChatDBA AI Assistant Solves gh-ost Usage Issue: Case Study and DeepSeek Comparison

This article presents a detailed case study where the ChatDBA AI assistant diagnoses and resolves a gh-ost migration stall caused by large table size and VARCHAR length expansion, compares its response with DeepSeek, and showcases the tool's expert-mode root‑cause analysis and actionable recommendations.

AIChatDBADatabase Troubleshooting
0 likes · 6 min read
ChatDBA AI Assistant Solves gh-ost Usage Issue: Case Study and DeepSeek Comparison
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 18, 2024 · Databases

Troubleshooting OceanBase NTP Clock Synchronization Issues with ChatDBA

This article walks through a real‑world OceanBase NTP clock desynchronization problem, demonstrating how the ChatDBA AI assistant guides four rounds of interactive troubleshooting, identifies misconfigured ntpdate‑wrapper scripts, and provides a concrete solution to restore proper time sync.

ChatDBADatabase TroubleshootingNTP
0 likes · 7 min read
Troubleshooting OceanBase NTP Clock Synchronization Issues with ChatDBA
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 17, 2024 · Databases

Resolving MySQL “Too many open files” Error with ChatDBA: A Step‑by‑Step Experiment

This article walks through a practical experiment where the AI‑driven assistant ChatDBA diagnoses and resolves a MySQL “Too many open files” error by collecting system metrics, analyzing slow queries, identifying index misuse, and proposing concrete configuration and query adjustments.

ChatDBADatabase TroubleshootingIndex Optimization
0 likes · 5 min read
Resolving MySQL “Too many open files” Error with ChatDBA: A Step‑by‑Step Experiment
Aikesheng Open Source Community
Aikesheng Open Source Community
May 20, 2024 · Databases

Diagnosing MySQL Temporary Table Full Errors with ChatDBA (AI Edition) – Issue 51

This article presents a MySQL "table is full" error case, explains how the AI‑powered assistant ChatDBA analyzes possible causes such as insufficient temporary tablespace, heavy temporary table creation, and disk limits, and provides step‑by‑step configuration adjustments to resolve the issue.

AIChatDBADatabase Troubleshooting
0 likes · 8 min read
Diagnosing MySQL Temporary Table Full Errors with ChatDBA (AI Edition) – Issue 51
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 18, 2024 · Databases

MySQL ‘Disappearing Table’ Issue Caused by Zero‑Width Characters

This article explains how an invisible zero‑width Unicode character embedded in a MySQL table name can make the table appear to disappear, demonstrates the problem with reproducible examples, analyzes the root cause, and provides practical steps to detect and fix such issues.

Database TroubleshootingMySQLSQL
0 likes · 5 min read
MySQL ‘Disappearing Table’ Issue Caused by Zero‑Width Characters
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2024 · Databases

MySQL Cascade Replication Failure Caused by Duplicate server_id and Its Resolution

The article analyzes a MySQL cascade replication issue where the new slave failed to sync due to duplicate server_id values, explains the root cause stemming from automated server_id assignment, and provides step‑by‑step remediation to ensure unique server_id settings and reliable replication.

Database TroubleshootingMySQLcascade replication
0 likes · 6 min read
MySQL Cascade Replication Failure Caused by Duplicate server_id and Its Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 5, 2024 · Databases

Locating Large Transactions in MySQL Binlog Using GTID and Shell Scripts

This article explains how to identify and extract large MySQL transactions from binary log files by monitoring binlog size, parsing GTID information, and using shell scripts to retrieve transaction details, timestamps, positions, and DML statistics, with optional use of the my2sql tool.

Database TroubleshootingGTIDMySQL
0 likes · 12 min read
Locating Large Transactions in MySQL Binlog Using GTID and Shell Scripts
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 6, 2023 · Databases

Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL

This article analyzes the MySQL ERROR 1499 caused by exceeding partition limits in OceanBase, examines server parameters, recycle‑bin settings, and tenant memory usage, and provides calculations and recommendations to expand memory or limit partition counts to prevent the error.

Database TroubleshootingMySQLOceanBase
0 likes · 11 min read
Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 8, 2023 · Databases

Root Cause Analysis of MySQL Insert Latency Using blktrace and Disk I/O Monitoring

This article details a systematic investigation of MySQL insert slowdown caused by disk I/O anomalies, describing log analysis, blktrace data collection, RAID controller firmware bugs, and the final resolution through firmware upgrade, providing practical guidance for database performance troubleshooting.

Database TroubleshootingDisk I/OMySQL
0 likes · 11 min read
Root Cause Analysis of MySQL Insert Latency Using blktrace and Disk I/O Monitoring
Xiaolei Talks DB
Xiaolei Talks DB
Jun 6, 2022 · Databases

Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag

This article explains how to streamline TiDB 6.0 fault diagnosis by replacing manual screenshot and log collection with PingCAP's Clinic service and the TiUP Diag tool, covering data collection, upload procedures, security considerations, and additional diagnostic capabilities.

ClinicDatabase TroubleshootingDiagnostics
0 likes · 19 min read
Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag
Aikesheng Open Source Community
Aikesheng Open Source Community
May 5, 2022 · Databases

Resolving Stuck Distributed DDL in ClickHouse: Diagnosis and Workaround

An online ClickHouse 10-node cluster experienced a distributed DDL task that hung for over 100 hours, blocking subsequent operations; the article explains the FIFO execution model, diagnosis steps, and a workaround using table renaming to unblock the queue, recommending version upgrade.

ClickHouseDatabase TroubleshootingDistributed DDL
0 likes · 5 min read
Resolving Stuck Distributed DDL in ClickHouse: Diagnosis and Workaround
Xiaolei Talks DB
Xiaolei Talks DB
Aug 25, 2021 · Databases

Fixing Aerospike Cluster Outage: Network Glitches, Memory Limits, and Rebalancing

After a network disruption caused Paxos messages to be ignored and memory shortages prevented data migration, this article details how the Aerospike cluster became unavailable, the diagnostic logs, and the step‑by‑step remediation involving node restarts, memory tuning, and adding new nodes for load balancing.

AerospikeClusterData Rebalancing
0 likes · 12 min read
Fixing Aerospike Cluster Outage: Network Glitches, Memory Limits, and Rebalancing
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 14, 2021 · Databases

Recovering a Deleted InnoDB .ibd File and Detecting Missing Tablespace in MySQL

This article demonstrates how to simulate accidental deletion of a MySQL InnoDB .ibd file, observe the impact on queries, recover the file using the file descriptor in /proc, restart MySQL, and verify that various DDL operations can detect the missing tablespace.

Database TroubleshootingInnoDBMySQL
0 likes · 12 min read
Recovering a Deleted InnoDB .ibd File and Detecting Missing Tablespace in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Jan 6, 2021 · Databases

Using SHOW FULL PROCESSLIST to Diagnose and Resolve MySQL Table Locks

This article explains how to use MySQL's SHOW FULL PROCESSLIST command, interpret its output, kill problematic threads, and address metadata lock issues by inspecting InnoDB transactions and adjusting lock_wait_timeout, providing practical code examples for database administrators.

Database TroubleshootingInnoDBMySQL
0 likes · 8 min read
Using SHOW FULL PROCESSLIST to Diagnose and Resolve MySQL Table Locks