If your MySQL 8.0 replica runs with super_read_only and the default innodb_undo_log_truncate=ON, a hidden undo‑log truncation bug can corrupt data, trigger a cascade of related bugs, and remain unresolved in 8.0 releases, demanding urgent checks and workarounds.
The article walks through a seemingly simple C file‑creation snippet that fails on Windows because Microsoft's tmpfile() uses C:\, then reveals a hidden bug where a stray backslash in a comment and a missing space in an expression silently turn code into comments, illustrating how tiny syntax errors can break cross‑platform programs.
This article explains why recent Windows updates can cause a reboot instead of a shutdown, details the new KB5067036 fix for Win11, describes the lingering Task Manager process bug that drains resources, and provides step‑by‑step PowerShell commands and command‑line tricks to permanently resolve the issues.
The article analyzes Windows 11’s declining stability, explains how a flawed patch broke the ZeroCID activation method, details Microsoft’s clumsy fix, and offers workarounds such as offline updates and the Media Creation Tool while highlighting broader security and reliability concerns.
An investigation reveals that MySQL treats trailing spaces in VARCHAR values as insignificant during string comparison, causing queries like SELECT * WHERE name='Tom' to match rows with extra spaces, and demonstrates that using the BINARY keyword restores exact matching, highlighting a potential bug in MySQL 5.7.
The Windows 11 24H2 KB5055523 update unexpectedly creates an empty C:\inetpub folder on systems without Internet Information Services installed, likely due to a bug that triggers IIS‑related components, and although harmless and removable, Microsoft has not yet commented on the cause.
This article explains why using Arrays.asList to convert an array into a List can produce an immutable, fixed‑size list that throws UnsupportedOperationException on add or remove operations, illustrates the issue with real‑world incident details, analyzes the internal implementation, and provides a safe replacement using java.util.ArrayList.
This article walks through the investigation of MySQL bug #115352, describing how an assertion failure in InnoDB’s dictionary cache caused a server crash during a killed ALTER TABLE on a partitioned table, the debugging steps taken, and the eventual fix applied in MySQL 8.0.40.
A simple typo that changed a daily interest rate from 0.00006944444 to 0.00069444444 inflated calculated interest tenfold, went unnoticed because the author self‑approved the SQL update and testing only checked syntax, and the incident underscores the need for rigorous code review, testing, and change‑management procedures for critical data.
The article explains that in Java's SimpleDateFormat the lowercase y pattern (year‑of‑era) should be used for calendar dates, because the uppercase Y pattern represents a week‑based year which can incorrectly roll over to the next year near year‑end, causing bugs.
This article explains a long‑standing JDK bug where Arrays.asList().toArray() returns an Object[] that causes ArrayStoreException when modified, analyzes the underlying implementation differences between java.util.ArrayList and Arrays$ArrayList, and describes how the issue was finally fixed in JDK 9.
This article explains why using Java's Arrays.asList to convert an array into a List can cause UnsupportedOperationException when modifying the list, illustrates the underlying implementation details, and provides a safe solution using java.util.ArrayList to prevent serious runtime failures.
This article recounts a production incident caused by misusing JavaScript's split() on an empty string, then explains the method's syntax, basic usage, and common pitfalls such as empty strings, extra separators, and Unicode handling, offering practical solutions for each case.
This article explains a common pitfall when deleting elements from a Python list during iteration, demonstrates why the list does not become empty, and offers several reliable alternatives to avoid the bug.
The 1996 Ariane 5 launch failed when a reused navigation code incorrectly converted 64‑bit floating‑point velocity data to a 16‑bit signed integer, causing an overflow that disabled the guidance system and led to the rocket's explosion, highlighting critical software engineering lessons.
During a recent iteration, adding a simple log statement triggered a system exception because Fastjson automatically invoked a custom getter that returned null, leading to an NPE; the article details the root cause, the serialization process, and practical solutions to prevent similar issues.
This article explains Linux kernel crash diagnostics, covering Oops messages, BUG and BUG_ON macros, the die() and panic() pathways, preparation steps for reproducing bugs, kernel configuration options for debugging, and useful memory‑debugging utilities such as MEMWATCH, YAMD, Electric Fence and strace.
A fatal bug (ID #36808732) in MySQL 8.0.38, 8.4.1 and 9.0.0 causes the server to crash on restart when thousands of tables exist, prompting Percona to warn users not to upgrade until patched versions 8.0.39, 8.4.2 and 9.0.1 are released.
The article explains a bug in Java's ConcurrentHashMap.computeIfAbsent that can cause recursive updates and infinite loops, leading to CPU spikes, and shows that newer Java versions throw an IllegalStateException while recommending avoiding nested computeIfAbsent/putIfAbsent calls, with a code example.
This article investigates a concurrency bug in MyBatis caused by OGNL expression evaluation using reflection, explains the root cause through stack trace and source code analysis, and proposes solutions such as upgrading MyBatis or avoiding private inner‑class methods like Arrays.asList.
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.
This article walks through a real‑world NPE caused by Lombok’s @Builder ignoring field initializers, explains the underlying double‑initialisation bug, shows how @Builder.Default restores the defaults, and outlines Lombok’s compile‑time annotation processing mechanism.
The article surveys frequent Java development mistakes—such as NullPointerExceptions, unsafe object equality, improper null handling, manual mapping errors, thread‑safety and thread‑pool misuse, swallowed exceptions, Spring bean initialization problems, memory leaks, performance traps, and transaction misconfigurations—while offering practical fixes like annotations, Optional, MapStruct, concurrent utilities, immutable wrappers, bounded executors, unified logging, and proper AOP usage.
A seemingly harmless C ternary expression fails on Windows because a backslash in a comment turns the rest of the line into a comment, leading to a cross‑platform tmpfile bug and a similar spacing mistake that broke the code.
An in‑depth analysis reveals how the JDK’s DiscardPolicy rejection strategy can cause invokeAll to block indefinitely, exposing a subtle thread‑pool bug, the official response, and practical code examples demonstrating the issue and ways to avoid it.
This article explains how using 'YYYY' instead of 'yyyy' in Java's SimpleDateFormat can cause year miscalculations, especially around year-end weeks, demonstrates the issue with sample code, shows correct usage, and warns developers to avoid this subtle bug.
This article analyzes why the reset button in an Element‑Plus form clears all fields instead of restoring the initial values, explains the underlying cause related to the onMounted lifecycle timing, and presents several practical solutions—including lifecycle adjustment, patch‑package, component extension, and repository forking—to reliably preserve initial form data in Vue projects.
The article recounts a team's two‑year deep dive into DingTalk mini‑program development, exposing numerous iOS keyboard bugs, missing APIs, version‑upgrade quirks, performance issues, and inadequate official support, while also sharing workarounds, CI/CD automation tips, and suggestions for platform improvement.
This article examines why long‑running SELECT COUNT(*) statements are not recorded in MySQL's slow query log, analyzes the relevant source‑code functions, demonstrates debugging with gdb, identifies the min_examined_row_limit setting as the root cause, and provides practical solutions and bug‑report details.
This article explains how LinkedBlockingQueue, normally thread‑safe, can enter an infinite loop when its stream traversal is used under JDK 8 with concurrent remove() calls, analyzes the root cause in the tryAdvance method, and shows how the bug was fixed in later JDK versions.
A seemingly harmless C bug caused a Windows build to ignore a ternary file‑creation expression because a stray backslash in a comment turned the following code into a comment, illustrating how tiny syntax errors can cripple cross‑platform programs.
An in‑depth look at the decades‑long curl vulnerability discovered by Daniel Stenberg, tracing its origins in early cookie handling, the dual‑syntax challenges of RFC 6265, the 2022 security report, and the eventual fix that finally closed a 23.9‑year‑old bug.
The article recounts the 23.9‑year‑long curl vulnerability discovered by Daniel Stenberg, detailing the early implementation of cookie handling, the challenges of dual cookie syntax, the security bug involving control‑code cookies, and the eventual fix released after nearly nine thousand days.
A detailed post‑mortem of Digg's disastrous v4 launch reveals how a Python function with a mutable default argument caused massive cache overloads, forced emergency fixes, and ultimately contributed to the company's downfall, offering crucial lessons for backend engineers on safe defaults and release planning.
The article recounts how a mutable default argument bug in a Python function caused Digg's v4 release to crash, leading to massive performance issues, costly downtime, and ultimately contributing to the company's decline, illustrating key lessons for backend developers.
In MySQL 5.7 replication, disabling unique_checks can cause duplicate‑key errors on a unique index that is not a primary key, leading to replication stalls, and this guide explains the root cause, temporary and permanent fixes, and step‑by‑step reproduction instructions.
This article investigates a MyBatis‑Plus bug where enum values with abstract methods become anonymous classes, causing the framework to fail to locate the correct TypeHandler, leading to SQL errors, and provides several practical solutions to avoid or fix the issue.
This article investigates a historical MySQL bug where dropping large tables with a sizable buffer pool and Adaptive Hash Index (AHI) can cause severe latency, presents test configurations for 5.7.29 and 8.0.28, compares AHI‑on/off results, shows stack traces, and explains the lazy‑delete fix introduced in 8.0.23.
An overview of the Axios 1.1.0 release bug that corrupted the package, caused axios.get to become undefined in browsers, and the quick patches (v1.1.1, v1.1.2) that resolved the issue for developers worldwide.
The Axios 1.1.0 release introduced a corrupted build that caused the axios.get function to be undefined, leading to widespread request failures in both browser and Node.js environments, prompting developers to roll back or upgrade to patched versions.
A real‑world incident at Digg shows how using a mutable default argument in a Python function caused a cascade of performance problems, leading to a rushed v4 release, service outages, and ultimately the company's decline and acquisition.
The article recounts Digg's disastrous v4 launch, highlighting how a seemingly harmless Python default‑argument bug combined with rushed deployment, missing rollback plans, and external pressures led to massive performance failures, costly fixes, and ultimately the company’s decline and acquisition.
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.
A real‑world story shows how an overlooked undefined value in a JSON payload caused a front‑end bug that nearly cost a developer his year‑end bonus, and explains the quirks of JSON.stringify together with practical fixes and a custom implementation.
A real‑world story shows how a developer’s incorrect use of JSON.stringify caused a missing form field, broke a page, and nearly cost a year‑end bonus, followed by a detailed explanation of JSON.stringify’s quirks and a robust fix to prevent the issue.
This article recounts a developer's step‑by‑step investigation of an intermittent Fastjson generic‑type parsing error in a Java backend, detailing the initial symptom, debugging process, code examples, discovery of Fastjson’s cached generic handling bug, and the resolution by upgrading to version 1.2.33.
An in‑depth analysis reveals how Groovy’s implicit getter feature and method‑resolution rules cause a static method call to be intercepted by a subclass’s getTest method, leading to unexpected output and thread locking during performance testing.
A recent bug in the VSCode C++ extension version 1.9.4 randomly creates empty files with invalid code, corrupts existing user and system files, and appears to stem from uninitialized memory usage, but can be avoided by downgrading or disabling the problematic extension.
A recent VS Code bug in the C++ extension 1.9.4 causes the editor to generate numerous empty files with invalid names, corrupt user data, and even erase system files, stemming from memory‑dump artifacts and pointer issues that disappear when the extension is downgraded or disabled.
This article explains the common pitfall of deleting elements from a Python list while iterating, demonstrates how the list’s internal pointer causes skipped items, and presents several reliable techniques—such as copying, filtering, and slicing—to safely remove items without errors.
This article analyzes a Spring transaction rollback issue caused by the use of pattern‑based exception matching, explains why certain custom exceptions trigger unexpected rollbacks, traces the problem through source code and GitHub issues, and describes how the Spring team fixed it with type‑safe rollback rules and documentation updates.
This article explains the subtle difference between 'yyyy' and 'YYYY' in Java's SimpleDateFormat, demonstrates how using the wrong pattern can cause year miscalculations—especially on December 31st—and provides code examples and a clear explanation to help developers avoid this common bug.
The article explains a subtle Java date‑formatting bug where using the week‑based year pattern (YYYY) can incorrectly display the next calendar year for dates at year‑end, demonstrates the issue with sample code, and clarifies why yyyy should be used for ordinary year representation.
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 explains why using the pattern 'YYYY‑MM‑dd' with Java's SimpleDateFormat can produce an incorrect year for dates near the end of the year, demonstrates the issue with a unit test comparing it to the correct 'yyyy‑MM‑dd' pattern, and reveals that the problem stems from the week‑based year semantics of 'Y'.
The article investigates a bug introduced in MySQL 5.7.36 where mysqldump writes the SET @@GLOBAL.GTID_PURGED statement at the end of the dump file, causing GTID and data inconsistencies that break replication, and recommends using an older mysqldump version until the issue is fixed.
An Excel import that partially succeeds reveals a hidden bug where Spring’s @Transactional annotation doesn’t roll back when using Java 8’s parallelStream, and the article explains the underlying thread‑local transaction mechanics, demonstrates the issue with code, and offers practical solutions and best‑practice guidelines.
This article explains why React keys are crucial when rendering lists, demonstrating through a dynamic form example how using array indices as keys can cause bugs when items are added or deleted.
This article examines MySQL 8.0.18’s ANALYZE command, explains its role in updating table statistics, demonstrates a series of tests on a CentOS server—including data insertion and case‑sensitive table naming—and reveals a bug where uppercase table names prevent statistics from being refreshed.
This article describes how a hidden 100 ms latency in a Spring Boot channel service was traced with Arthas, revealing a Tomcat‑embed bug caused by repeated loading of Swagger UI resources, and explains how upgrading Tomcat or Spring Boot eliminates the delay.
When using MyBatis dynamic SQL to filter records by a numeric state field, the framework incorrectly evaluates the condition "state != ''" as false for the integer value 0 because its OGNL expression evaluator treats 0 as equivalent to an empty string, leading to unexpected query results.
A developer encountered a duplicate‑key error caused by an unexpected primary‑key update that overflowed the signed INT limit, exposing a hidden MySQL auto‑increment bug that persisted across normal inserts until a later DDL operation triggered failures, a problem present in Percona 5.6/5.7 but fixed in MySQL 8.0.
The article analyses a duplicate deregistration bug in Apache Dubbo 2.7.0‑2.7.4 caused by shutdown‑hook interactions, demonstrates how it reproduces with custom and open‑source versions, explains the internal debugging steps, and shows that the issue was fixed in Dubbo 2.7.5 onward, offering insights for registry extensions.
A React component that works locally threw a minified "#31" error only on Vivo X7 Android 5.1 devices because a Symbol polyfill loaded after React caused a mismatch in REACT_ELEMENT_TYPE, and adjusting the build order or JSX runtime resolved the illegal return‑value bug.
A recently discovered bug in the latest WeChat Windows client (v3.1.0.67) reveals raw XML representations of quoted messages—including plain text, articles, and emoji GIFs—allowing researchers to extract detailed message metadata and media URLs.
A Spring Boot service experienced an unexplained 100 ms extra latency per request, which was traced using the Arthas Java diagnostic tool to reveal a Tomcat embed bug caused by repeated loading of Swagger UI resources, and the issue is resolved by upgrading the embedded Tomcat version.
The article explains that Math.abs() can return a negative result when applied to Integer.MIN_VALUE because the absolute value exceeds the int range, detailing the two's‑complement representation, overflow behavior, and how the JLS defines the operation.
The article investigates the MySQL 5.7 sys schema ERROR 1356 caused by mysqldump --all-databases dropping mysql.proc, explains why the bug occurs, cites official documentation and bug reports, and provides four practical solutions including mysql_upgrade, separate sys backups, using --databases, and rebuilding from mysql‑sys.
A production MySQL query that omitted its leftmost indexed column caused a full‑table scan, CPU overload, and a read‑only alert, prompting a rapid investigation, temporary index addition, and a deeper discussion of the left‑most matching principle, Java validation pitfalls, and best‑practice lessons.
This article explores a JDK 8 bug in ConcurrentHashMap’s computeIfAbsent method that can cause an infinite loop, explains how the issue was discovered, reproduces it with test code, analyzes the root cause, and shows the fix introduced in JDK 9.
A game server developer copied a flawed Java function to calculate offline days, which mis‑computed the difference across year boundaries, leading to thousands of erroneous reward emails on 2020‑01‑01, and the issue was resolved by switching to the Java 8 date‑time API.
The article describes a bug where a user's VIP expiration date cannot exceed a specific day in 2038 because the MySQL INT column storing the timestamp reaches its maximum signed value, explaining the cause, impact, and the pragmatic decision to ignore the issue.
The article examines a recurring RocketMQ error (TIMEOUT_CLEAN_QUEUE) caused by the broker’s fast‑failure mechanism, explains how the broker queues and thread pools operate, reveals that SYSTEM_BUSY is mistakenly excluded from retry logic—a bug—and proposes both a temporary configuration tweak and a permanent code fix via a PR.
A production MySQL 8.0.15 MGR cluster suffered from massive internal temporary‑table file leaks due to a known bug, which was diagnosed through log analysis and Oracle documentation and resolved by upgrading to MySQL 8.0.16, confirming the issue is version‑specific and not MGR‑related.
This article explains why using uppercase YYYY or DD in Java date‑format patterns can produce incorrect results around year boundaries, demonstrates the bugs with concrete code examples, and clarifies the correct usage of lowercase yyyy and dd for calendar dates.
A Java developer discovers that formatting dates with the pattern “YYYY‑MM‑dd” causes a year‑off bug on New Year's Day, learns that “YYYY” denotes a week‑based year, and is advised to always use “yyyy‑MM‑dd” for reliable calendar dates.
A historic bug in Microsoft Zune’s date‑update driver arose from a flawed leap‑year handling loop, and the article explains the faulty code, why it failed, its wide impact, and how thorough boundary‑value testing could have prevented it.
This article shares a real‑world case study of loading billions of rows from an unsplittable text file into an Oracle table using SQL*Loader, detailing a parallel skip‑and‑load technique, performance results, a critical 4‑byte row limit bug, and practical recommendations for CPU‑vs IO‑bound workloads.
This article explains the MySQL 5.6 slave_rows_search_algorithms parameter, reproduces the HASH_SCAN bug that causes "Can't find record" errors during row‑based replication, analyzes why it occurs, and provides practical solutions such as adjusting keys, changing the algorithm setting, or upgrading MySQL.
The article explores what a bug really is, why bugs inevitably appear in software development, and offers practical strategies—such as effective logging, leveraging debugging tools, and keeping iteration sizes small—to locate and resolve bugs more quickly.
The article examines two typical return‑code bugs encountered during software testing—one where a default success code is unintentionally returned in error scenarios and another where mismatched return‑code checks render error‑handling branches unreachable—offering concrete solutions and best‑practice recommendations.
This article examines MySQL bug #89370, detailing how configuring semi‑synchronous replication with multiple slaves can cause a slave to stop receiving data for minutes despite normal replication status, and explains the underlying mechanisms, reproduction steps, and root cause of the issue.
The article examines two typical return‑code bugs encountered during white‑box testing—one where error paths mistakenly return a success code and another where callers check the wrong value—explaining their causes and offering concrete remediation guidelines to improve error handling.
This article examines MySQL bug #89126, explains how creating many tables can overflow the InnoDB table definition cache and cause crashes, illustrates the underlying mechanism with diagrams, and provides configuration advice to prevent the issue.
This article explains the hidden multithreading bugs in JDK 7 HashMap and JDK 8 ConcurrentHashMap that can cause 100% CPU usage, demonstrates how to reproduce them, and offers practical ways to avoid or resolve the issue.
The article analyzes a reported Kubernetes bug where watch events return non‑monotonic resourceVersion values after deleting early objects, details experiments that failed to reproduce it in version 1.6, explains the underlying code change in 1.7+, and outlines the community fixes introduced in PR #58547.
A customer’s Oracle 11g RAC experienced chronic high CPU usage; deep AWR analysis revealed that massive parse time was attributed to mutex waits and a hidden hard‑parse failure caused by a missing column, which triggered Bug 16175381 and forced process spin, ultimately resolved by correcting the faulty SQL.
This article recounts a baffling C bug where Microsoft's tmpfile() on Windows creates files in C:\, causing a stray backslash to comment out code, and explains how replacing a ternary operator with an if‑else fixed the issue while illustrating common cross‑platform pitfalls.
A lottery system that relied on MySQL’s SELECT without ORDER BY unintentionally gave a single player multiple top‑prize wins because InnoDB reordered results by primary key, revealing a subtle database engine rule that can corrupt random selection logic.
This article details a Redis replication bug where slave offsets exceed the master after network interruptions, explains the root‑cause analysis of offset handling during full and incremental sync, describes the code fix applied by the Redis team, and offers testing and prevention guidance.
