To reproduce

SELECT * FROM table ORDER BY ts DESC LIMIT 10;

Hit download parquet:

Error:

2025-10-28T15:37:22.690293Z E i.q.c.h.p.ExportQueryProcessor partial parquet response sent, closing connection on error [fd=5315022703649, parquetFileOffset=3, errorMessage=cannot insert rows out of order to non-partitioned table. Table=/var/lib/questdb/db/zzz.copy.697d19f3a89d8d72]

Workaround:

SELECT * FROM (table ORDER BY ts desc limit 10) ORDER BY ts ASC;

This issue should be fixed by removing the temporary table: #6300

QuestDB version:

Master

OS, in case of Docker specify Docker and the Host OS:

N/A

File System, in case of Docker specify Host File System:

N/A

Full Name:

Nick Woolmer

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