fix(core): fix assertion exception in writer, which is triggered by OS error (#6204)

bluestreak01 · web-flow · commit fa577782d05a · 2025-09-30T14:17:03.000+01:00
diff --git a/core/src/main/java/io/questdb/cairo/TableWriter.java b/core/src/main/java/io/questdb/cairo/TableWriter.java
@@ -5456,6 +5456,11 @@ private void handleColumnTaskException(
 
     private void handleHousekeepingException(Throwable e) {
         // Log the exception stack.
+        // In some cases it is possible to leave corrupted state of table writer behind, for example in
+        // the case where we discovered we need to distress the writer - exception occurring trying to re-open
+        // last partition can leave some columns in "closed" state, with "fd=-1" but that does not stop O3 logic
+        // processing -1 as a correct fd leading to havoc.
+        distressed = true;
         LOG.error().$("data has been persisted, but we could not perform housekeeping [table=").$(tableToken)
                 .$(", error=").$(e)
                 .I$();
