Incident Report: ArrayIndexOutOfBoundsException When Synchronizing JTable Sort Order to JList in Java File Browser Summary A developer attempted to synchronize sorting between a JTable and a JList by capturing the sorted view indices via TableRowSorter during a sort event. They encountered an ArrayIndexOutOfBoundsException when iterating over row indices, preventing the synchronization of the file browser … Read more
Production Incident: Flash Memory Performance Degradation Due to Disabled ART Prefetch on STM32F4 Summary During hardware initialization, prefetching was inadvertently disabled in the STM32F4 memory subsystem. This caused severe performance degradation during peak traffic when instruction fetches from Flash couldn’t be anticipated by the ART Accelerator, leading to CPU stalls and unresponsive systems. Root Cause … Read more
Postmortem: Misconfiguration of NTAG213 Password Protection in Android NFC Summary A developer attempted to enable password protection on NTAG213 NFC tags using Android’s NfcA technology. After configuring the PWD, PACK, and ACCESS bytes, tags either remained unlocked or became inaccessible. The issue stemmed from incomplete configuration sequences and misunderstanding of NTAG213 authentication requirements. Root Cause … Read more
Why i = i++ Doesn’t Increment the Variable Summary Root Cause Operator precedence: Post-increment (i++) returns the original value before incrementing the variable Execution order: Why This Happens in Real Systems Attempts to compact code into fewer lines Accidental refactoring where increment logic gets merged with assignment Misunderstanding of operator behavior during quick fixes Copy-pasting … Read more
Postmortem: Avoiding OUTER APPLY for Retrieving Latest Rows in SQL Server Summary A developer needed to fetch the latest attendance record per employee after a specific timestamp but inadvertently retrieved all matching records. The initial solution used OUTER APPLY, which caused performance issues in a complex production query. This postmortem explains the optimization strategy replacing … Read more
Solving Inconsistent Font Scaling in React Native Apps Summary Consistent font sizing across different Android/iOS devices proved challenging due to default pixel density scaling in React Native. Attempts to manually scale fonts using screen dimensions failed because reported pixel dimensions don’t linearly correlate with physical display size across manufacturers. Root Cause React Native applies automatic … Read more
Postmortem: Solving mysqlclient Installation Failures on macOS Due to Missing MySQL Configuration Flags Summary Installation of the mysqlclient Python package via pip fails on macOS with explicit errors The package requires MySQL client C library headers and binaries (libmysqlclient) Failure occurs because build tools can’t locate MySQL client dependencies Users are directed to manually specify … Read more
Why Promise.all in MongoDB Transactions Leads to Undefined Behavior Summary MongoDB transactions require sequential execution of operations within a session. Promise.all and similar constructs cause parallel execution, violating MongoDB’s transaction isolation constraints. This pattern can appear to work but risks data corruption and undefined behavior under load. Root Cause MongoDB’s transaction protocol requires operations to … Read more
Types No Longer Inferred from Array.reduce Initial Value After TypeScript Version Change Summary A TypeScript upgrade or downgrade in a Deno environment caused type inference failures for Array.reduce operations when using an initial value of Map<string, number>. Previously, the result type was correctly inferred as Map, but after the environment change, TypeScript required explicit generic … Read more
TypeScript TS2339: Property href does not exist on type URL | Request Summary In an Expo React Native app using tRPC, a developer attempted to convert values of type string | URL | Request into a URL string. TypeScript threw TS2339 when accessing .href because the union includes the Request type, which lacks this property. … Read more