BestHub
Sign in
Tagged articles

Database Troubleshooting

36 articles · Page 1 of 1
StarRocks
StarRocks
May 21, 2026 · Databases

Say Goodbye to Repeated Pitfalls with Our Open‑Source AI Skill for Database Troubleshooting

The article introduces starrocks‑debug‑skills, an open‑source, three‑layer knowledge base (Skills, Cases, Tools) that captures real‑world StarRocks troubleshooting experience, shows how AI assistants can use it to diagnose issues such as import timeouts, version errors, and compaction slowdowns, and explains how to contribute new cases.

AIDatabase TroubleshootingOperations
0 likes · 13 min read
Say Goodbye to Repeated Pitfalls with Our Open‑Source AI Skill for Database Troubleshooting
Ops Community
Ops Community
Oct 4, 2025 · Databases

How to Quickly Diagnose and Fix a Frozen MySQL in Production: 5 Proven Steps

Facing a MySQL that suddenly becomes unresponsive in production? This article walks through the exact five‑step investigative process—checking process status, examining connections, locating lock waits, analyzing slow queries and system bottlenecks, and applying emergency recovery—illustrated with real‑world examples and command‑line snippets.

Database TroubleshootingOperationsProduction Incident
0 likes · 19 min read
How to Quickly Diagnose and Fix a Frozen MySQL in Production: 5 Proven Steps
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 TroubleshootingRollbackSQL Mode
0 likes · 7 min read
Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix
Sohu Tech Products
Sohu Tech Products
May 21, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating MySQL deadlock logs, analyzing their contents to pinpoint transaction timing, order, and lock details, and identifying the root cause of the deadlock, including special locking scenarios that can trigger deadlocks.

Database TroubleshootingDeadlockInnoDB
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
Sohu Tech Products
Sohu Tech Products
May 14, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating the deadlock log, analyzing its contents to determine the time, order, and involved SQL statements, and pinpointing the root cause of MySQL InnoDB deadlocks, including special locking scenarios and how to interpret lock structures.

Database TroubleshootingDeadlockInnoDB
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
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 TroubleshootingInnoDBLock Wait
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.

BinlogData synchronizationDatabase Troubleshooting
0 likes · 12 min read
Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode
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 TroubleshootingOceanBasememory calculation
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 TroubleshootingRAIDblktrace
0 likes · 11 min read
Root Cause Analysis of MySQL Insert Latency Using blktrace and Disk I/O Monitoring
ITPUB
ITPUB
Nov 3, 2022 · Databases

How to Diagnose and Resolve MySQL InnoDB Deadlocks in Production

This guide explains how to detect MySQL deadlock exceptions, retrieve and interpret InnoDB deadlock logs and binlog files, and use the information to pinpoint conflicting SQL statements and fix the underlying lock issues in live systems.

BinlogDatabase TroubleshootingDeadlock
0 likes · 9 min read
How to Diagnose and Resolve MySQL InnoDB Deadlocks in Production
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 TroubleshootingTiDB
0 likes · 19 min read
Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag
Liangxu Linux
Liangxu Linux
Dec 30, 2021 · Databases

Why MySQL UPDATE Fails with AND and How to Use Comma‑Separated Assignments

A developer noticed an UPDATE statement that appeared to run without effect, discovered that using AND between column assignments is invalid in MySQL, learned the correct comma‑separated syntax, and saw how logical AND expressions can produce unexpected zero values.

Database TroubleshootingLogical expressionsSQL syntax
0 likes · 3 min read
Why MySQL UPDATE Fails with AND and How to Use Comma‑Separated Assignments
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.

AerospikeData RebalancingDatabase Troubleshooting
0 likes · 12 min read
Fixing Aerospike Cluster Outage: Network Glitches, Memory Limits, and Rebalancing
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 23, 2020 · Databases

Resolving MySQL 5.7 Login Issue Caused by the auth_socket Plugin and Exploring Its Use Cases

The article describes a puzzling MySQL 5.7 situation where any password works, investigates the cause as the auth_socket authentication plugin, provides exact SQL commands to fix the issue, and explains the plugin's security characteristics and appropriate deployment scenarios.

Database Troubleshootingauth_socketauthentication plugin
0 likes · 5 min read
Resolving MySQL 5.7 Login Issue Caused by the auth_socket Plugin and Exploring Its Use Cases
Youzan Coder
Youzan Coder
Apr 29, 2020 · Databases

MySQL Slow Query Analysis: Root Causes and Optimization Strategies

The article examines why MySQL queries become slow, detailing system‑level issues such as network latency, I/O bottlenecks, and CPU settings, alongside database‑level problems like missing indexes, type conversion, poor execution plans, lock contention, skewed data, and inefficient SQL patterns, and offers optimization strategies.

Database PerformanceDatabase TroubleshootingIndex Optimization
0 likes · 15 min read
MySQL Slow Query Analysis: Root Causes and Optimization Strategies
FunTester
FunTester
Jul 31, 2019 · Databases

Why MySQL Join Query Slowed to 30,000 Seconds and How Restoring an Index Fixed It

The author describes a sudden 30,000‑second slowdown in a simple MySQL join query, details systematic diagnostics—including network, server load, and query testing—and ultimately discovers a missing index on the user_info table, restoring it to bring response times back to sub‑second levels.

Database TroubleshootingIndex OptimizationPerformance Tuning
0 likes · 4 min read
Why MySQL Join Query Slowed to 30,000 Seconds and How Restoring an Index Fixed It
MaGe Linux Operations
MaGe Linux Operations
Oct 30, 2018 · Databases

Top 10 MySQL Error Cases and How to Fix Them

This article presents ten classic MySQL error scenarios—from connection limits and replication conflicts to permission issues and character‑set problems—explaining their root causes, diagnostic commands, and step‑by‑step solutions to help beginners and DBAs troubleshoot efficiently.

Database TroubleshootingError handlingSQL
0 likes · 16 min read
Top 10 MySQL Error Cases and How to Fix Them
dbaplus Community
dbaplus Community
Feb 15, 2017 · Databases

How to Diagnose and Fix a Galera Cluster Node Failure in Percona XtraDB

This article walks through a real‑world Galera cluster outage, explains the replication and flow‑control mechanisms, details the step‑by‑step analysis of thread‑running spikes and wsrep delays, identifies a network‑induced port latency as the root cause, and describes the recovery actions taken to restore the Percona XtraDB Cluster.

Database TroubleshootingFlow ControlGalera
0 likes · 9 min read
How to Diagnose and Fix a Galera Cluster Node Failure in Percona XtraDB
dbaplus Community
dbaplus Community
Dec 26, 2016 · Databases

Why Do Oracle RAC Nodes Crash? Uncovering Memory Leak Bugs in ocssd.bin

An Oracle RAC deployment across four identical clusters repeatedly experienced node crashes, each traced to ocssd.bin failures caused by a memory leak bug in CRSD/OCSSD processes (Bug 11704113), with analysis of logs, kernel parameters, and recommended patches and configuration tweaks to prevent recurrence.

CRS bugDatabase TroubleshootingOracle RAC
0 likes · 13 min read
Why Do Oracle RAC Nodes Crash? Uncovering Memory Leak Bugs in ocssd.bin
ITPUB
ITPUB
Oct 14, 2016 · Operations

Why Do Stale MySQL Sleep Connections Appear After HAProxy Timeout Mismatch?

A MySQL server experienced max_connection errors due to lingering sleep connections caused by mismatched timeout settings between LVS and HAProxy, and adjusting HAProxy's timeout resolved the issue and prevented further connection exhaustion.

Database TroubleshootingHAProxyLVS
0 likes · 5 min read
Why Do Stale MySQL Sleep Connections Appear After HAProxy Timeout Mismatch?
ITPUB
ITPUB
Aug 9, 2016 · Databases

Why Does Oracle RAC Throw ‘IPC Send timeout’ and How to Fix It?

The article explains the common Oracle RAC “IPC Send timeout” error, shows real alert‑log examples, analyzes root causes such as network loss, resource exhaustion, or bugs, and provides step‑by‑step troubleshooting methods including monitoring tools and configuration checks.

ClusterwareDatabase TroubleshootingIPC Send timeout
0 likes · 11 min read
Why Does Oracle RAC Throw ‘IPC Send timeout’ and How to Fix It?
ITPUB
ITPUB
Apr 25, 2016 · Databases

Common MySQL Errors and How to Fix Them: A Practical Guide

This guide lists frequent MySQL error messages, explains their underlying causes, and provides step‑by‑step solutions—including configuration tweaks, permission adjustments, and server‑side fixes—to help developers quickly resolve database connectivity and query issues.

Database TroubleshootingError handlingMySQL configuration
0 likes · 25 min read
Common MySQL Errors and How to Fix Them: A Practical Guide
dbaplus Community
dbaplus Community
Feb 15, 2016 · Databases

How to Diagnose and Report MySQL/Oracle Issues Within 10 Minutes

This guide walks through a rapid 10‑minute troubleshooting workflow for MySQL and Oracle databases, covering resource checks, log inspection, wait‑event analysis, SQL identification, and feedback best practices to quickly pinpoint performance problems without relying on external monitoring tools.

Database TroubleshootingOracleSQL Analysis
0 likes · 9 min read
How to Diagnose and Report MySQL/Oracle Issues Within 10 Minutes