Tagged articles
database troubleshooting
37 articles · Page 1 of 1
This guide diagnoses database connection pool exhaustion by distinguishing connection leaks from genuine high concurrency, demonstrating log analysis for HikariCP and Druid, verifying leaks via SHOW PROCESSLIST and pool metrics, fixing code with try-with-resources, tuning key HikariCP parameters, and enabling leak detection to pinpoint exact leak locations.
Connection LeakDruidHikariCP
0 likes · 10 min read

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.
AIOperationsStarRocks
0 likes · 13 min read

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.
MySQLOperationsdatabase troubleshooting
0 likes · 19 min read

This article walks through a real‑world OceanBase ODP binlog connection failure, explains the error message, analyzes possible causes, shows how to trace logs and configuration, and provides a concrete fix by correcting the binlog_service_ip setting and restarting ODP.
ODPOceanBaseSQL
0 likes · 8 min read

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.
JSONMySQLdatabase troubleshooting
0 likes · 7 min read

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.
InnoDBMySQLSQL
0 likes · 16 min read

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.
InnoDBLock AnalysisMySQL
0 likes · 16 min read

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.
InnoDBLock WaitMySQL
0 likes · 9 min read

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 assistantChatDBADeepSeek
0 likes · 5 min read

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.
Flink CDCOBLogProxyOceanBase
0 likes · 12 min read

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.
AIChatDBADeepSeek
0 likes · 6 min read

This article presents a step‑by‑step AI‑assisted investigation of an OceanBase performance test that triggered error 4013 due to memory limits, detailing four interactive rounds with ChatDBA, the root‑cause analysis, and practical remediation measures.
AI DBAChatDBAOceanBase
0 likes · 8 min read

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.
ChatDBANTPOceanBase
0 likes · 7 min read

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.
AIChatDBAInnoDB
0 likes · 8 min read

This article walks through a common DBeaver CSV‑to‑SQL Server import error caused by mismatched numeric values, explains how to diagnose the issue by checking column types, and provides a clear, illustrated solution to ensure successful data loading.
CSV ImportDBeaverData type mismatch
0 likes · 4 min read

This guide explains why a remote PostgreSQL connection may fail with a password authentication error, analyzes common causes such as wrong credentials or misconfigured files, and provides step‑by‑step solutions including password reset, configuration checks, and trust authentication setup.
Connection ErrorPostgreSQLSQL
0 likes · 7 min read

A veteran Oracle DBA recounts the painful history of early Oracle versions, explains classic errors like ORA-1591 and ORA-1578, shares troubleshooting tactics, and reflects on how those hardships forged the expertise needed to master today’s complex database environments.
DBAORA-1578ORA-1591
0 likes · 8 min read

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.
MySQLOceanBasedatabase troubleshooting
0 likes · 11 min read

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.
MySQLRAIDblktrace
0 likes · 11 min read


ITPUBNov 3, 2022 · Databases
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.
InnoDBMySQLSQL
0 likes · 9 min read

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.
ClinicTiDBTiUP
0 likes · 19 min read

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.
ClickHouseDistributed DDLZooKeeper
0 likes · 5 min read

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.
Logical expressionsMySQLSQL syntax
0 likes · 3 min read

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

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.
InnoDBMySQLdatabase troubleshooting
0 likes · 12 min read

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.
InnoDBKILL QUERYMetadata Lock
0 likes · 8 min read

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.
MySQLauth_socketauthentication plugin
0 likes · 5 min read

This article walks through a practical MySQL troubleshooting experiment that shows how to identify a CPU‑intensive query using the processlist, locate the offending thread with top‑H, interpret performance_schema IDs, and safely terminate the problematic SQL statement.
CPUMySQLdatabase troubleshooting
0 likes · 3 min read

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 PerformanceIndex OptimizationInnoDB
0 likes · 15 min read

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.
Index OptimizationMySQLPerformance Tuning
0 likes · 4 min read

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.
MySQLSQLdatabase troubleshooting
0 likes · 16 min read

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.
Flow ControlGaleraMySQL
0 likes · 9 min read

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 bugMemory LeakOracle RAC
0 likes · 13 min read


ITPUBOct 14, 2016 · Operations
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.
HAProxyLVSMySQL
0 likes · 5 min read


ITPUBAug 9, 2016 · Databases
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.
ClusterwareIPC Send timeoutNetwork Monitoring
0 likes · 11 min read


ITPUBApr 25, 2016 · Databases
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.
MySQLMySQL configurationSQL
0 likes · 25 min read

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.
MySQLOraclePerformance Monitoring
0 likes · 9 min read
