1 views collected around this technical thread.
This article analyzes a MySQL 5.7.20 crash that occurs during INSERT operations on BLOB columns with INSERT … ON DUPLICATE syntax, explains the underlying bug in the copy_blob_value function, shows how to reproduce and locate it with gdb, and provides the fix introduced in MySQL 5.7.22.
A scheduled task system that frequently accesses MySQL and cache crashes at night due to a SIGSEGV in the HotSpot JVM caused by JIT compilation of hotspot code, and the article explains the JVM internals, JIT behavior, and provides configuration and driver downgrade solutions to prevent the failure.
This article analyzes why the MariaDB audit plugin crashes on MySQL 5.7, presents compatibility tables before and after source modification, details the verification steps, and provides a step‑by‑step solution including source code changes and recompilation to make the plugin work reliably.
This article examines how ARC‑managed object assignments can produce wild pointers and EXC_BAD_ACCESS crashes in multithreaded iOS apps, explains the underlying reference‑counting steps, demonstrates reproducible demo scenarios, and offers practical mitigation strategies for developers.
The article analyzes a crash introduced in iOS 16.1 where hiding and showing the system navigation bar triggers an NSLayoutConstraint activation failure in _UINavigationBarTitleControl, describes reproduction steps, investigates root causes, and presents a reliable fix by forcing layout updates before changing the bar’s hidden state.
This article investigates a MySQL crash triggered by a specific SELECT statement, analyzes the stack trace and optimizer behavior that leads to an invalid memory access, and presents three practical solutions including disabling DuplicateWeedout, upgrading MySQL, and normalizing table character sets.
This article examines typical Java application failure scenarios—including heap OOM, memory leaks, CPU spikes, thread leaks, deadlocks, stack overflows, and blocked threads—providing concise code examples and practical diagnostic tips for root cause analysis.
This article documents a runtime crash triggered by mutating an NSMutableSet while enumerating it, explains how the Objective‑C copy attribute works, demonstrates shallow and deep copy behavior for strings and collections, and provides low‑level source analysis of the copy implementation in the Apple runtime.
The article investigates a MySQL 8.0.26 crash triggered by setting the terminology_use_previous parameter to BEFORE_8_0_26, analyzes stack traces and core dumps, compares processlist access methods, references related bugs, and offers mitigation recommendations for monitoring tools.
The article investigates a MySQL 8.0.18 crash that occurs when importing a large create.sql containing longblob data under semi‑synchronous replication, reveals that enabling slave_compressed_protocol together with high‑availability latency checks triggers the failure, and provides a concrete fix by disabling the compressed protocol.
The article analyzes why Flutter crashes on iOS when accessing the GPU in the background, explains the official SyncSwitch fix for ImageDecoder, and details Xianyu’s additional patches for MultipleFrameCodec, EncodeImage, and Rasterizer::DrawToSurface that together, via PR #28383, fully resolve the GPU‑background crash.
This article explains the fundamentals of iOS crashes, describes exception types such as Mach and Signal, details stack memory layout and recovery techniques, and walks through several real‑world crash investigations—including WKWebView, ImageIO, and fishhook issues—culminating in practical mitigation steps that reduced crash rates by over 60%.
This article analyzes a crash caused by NSInvocation argument out‑of‑bounds on iOS 13.3+, explains the underlying runtime changes, demonstrates how to reproduce the issue with a timer‑triggered message forwarding scenario, and provides a fix by correcting the method signature.
The article investigates a MySQL crash caused by binlog errors due to a full '/' partition, explains why the error leads to server abort, demonstrates reproducing the issue with large transactions, traces the problem to the my_write function in the source code, and offers mitigation strategies such as reducing transaction size or expanding the temporary directory space.
The article examines Android crashes caused by the finalize() method exceeding its watchdog timeout, explains the underlying daemon implementation and typical causes such as long‑running finalizers, lock contention and low‑priority threads, and recommends avoiding finalize, reducing finalizable objects, or suppressing the watchdog exception as practical mitigations.
This article explains the fundamentals of peer‑to‑peer (P2P) download technology, its advantages over traditional client‑server models, the detailed download workflow, and the testing and monitoring approaches used to evaluate performance, stability, and crash rates.
This article explains why iOS crash logs are unreadable without symbolication, introduces three symbolication approaches—Xcode's symbolicatecrash, the atos/atosl tools, and dSYM‑based parsing—details the dSYM file structure, Mach‑O headers, load commands, data segments, and how to extract and demangle symbols for effective crash debugging.
The 2016 China Mobile App Performance Report, released by leading APM provider Tingyun, analyzes iOS and Android crash rates, network performance, error distributions, and third‑party API responsiveness, revealing that iOS apps crash five times more often than Android, network errors dominate failures, and certain industries suffer higher latency, offering developers data‑driven guidance to improve user experience.