Exception in drop index, table suspended #6146
Description
To reproduce
2025-09-15T17:59:39.315234Z C i.q.c.TableWriter exception on index drop [txn=98593050, table=tr, column=eid, error=
java.lang.StackOverflowError
at io.questdb.std.IntGroupSort.partition(IntGroupSort.java:55)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:61)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
...
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.questdb.std.IntGroupSort.quickSortImpl(IntGroupSort.java:63)
at io.q
2025-09-15T17:59:39.318803Z C i.q.g.e.o.AlterOperation could not alter table [table=tr~149, command=5, msg=cannot remove index for [txn=98593050, table=tr, column=eid]: , errno=0]
2025-09-15T17:59:39.318867Z E i.q.c.w.ApplyWal2TableJob error applying SQL to wal table [table=tr~149, sql=ALTER TABLE tr ALTER COLUMN eid DROP INDEX, msg=cannot remove index for [txn=98593050, table=tr, column=eid]: , errno=0]
2025-09-15T17:59:39.327685Z C i.q.c.w.ApplyWal2TableJob job failed, table suspended [table=tr~149, seqTxn=102965850, error=
io.questdb.cairo.CairoException: [0] cannot remove index for [txn=98593050, table=tr, column=eid]:
]
QuestDB version:
9.0.3
OS, in case of Docker specify Docker and the Host OS:
NA
File System, in case of Docker specify Host File System:
NA
Full Name:
Alex Pelagenko
Affiliation:
QuestDB
Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?
- Yes, I have
Additional context
No response