Index name in Oracle

Summary This incident stemmed from an Oracle metadata lookup that failed to detect an existing index because the wrong column was queried. As a result, the application attempted to recreate an index that already existed, causing repeated failures. The underlying issue is a misunderstanding of how Oracle names and exposes indexes—especially system‑generated ones. Root Cause … Read more

Is a macro-based integer “type-builder” API (e.g. INT(32), UINT(16), OPTIMAL) a practical, portable replacement for stdint.h?

Summary This postmortem analyzes the practicality and systemic risks of replacing stdint.h with a macro‑based “type‑builder” API such as INT(32), UINT(16), FAST(64), and constraint wrappers like RANGE or EVEN. While the idea improves expressiveness, the investigation shows significant ABI, tooling, and portability hazards that make such an API difficult to adopt safely across compilers and … Read more

Automating spike detection (dummy variable) in multiple time series using departures from (rolling) mean

Summary Automated spike detection in multiple time series using departures from rolling mean failed due to incorrect standard deviation scaling and lack of trend normalization. Root Cause Incorrect standard deviation scaling: Multiplication by a fixed factor without considering the rolling window size led to false positives. Lack of trend normalization: Rolling mean alone did not … Read more

Next.js webpack error on first run (port 3000) but works on second run (port 3001)

Summary Issue: Next.js 14 project fails on the first run (port 3000) with a webpack error but works on the second run (port 3001). Root Cause: A race condition in webpack’s module resolution caused by concurrent server starts. Impact: Delayed development workflow and confusion for engineers. Fix: Prevent concurrent server starts or clear webpack cache … Read more

Why do I get a “fast forward rejected” when I push a second time?

Summary A “fast forward rejected” error on a second push happens when your local branch’s history no longer matches the remote’s history. Even if you are the only developer, Git can still detect divergence when the remote branch contains commits your local branch does not—often caused by non-fast‑forward updates, rebases, or detached‑HEAD pushes you forgot … Read more

How do I force stop a rogue Google Apps Script

Summary A Google Apps Script continued running even after the user deleted the project, removed triggers, and emptied the trash. The script kept monitoring Gmail and sending Google Voice texts because an OAuth-granted authorization token was still active on the user’s Google Account. Deleting the script does not revoke its previously granted permissions, so the … Read more

How to write a technical report for — Final Year Project

Summary A well-structured technical report is crucial for final year projects, ensuring clarity, completeness, and adherence to guidelines. This postmortem addresses common challenges in documenting BCA final year projects, focusing on root causes, real-world impacts, and senior-level fixes. Root Cause The primary issues in technical report preparation stem from: Lack of clarity on documentation requirements. … Read more