Alex Pelagenko

chore(core): reduce sequencer txn log file storage record length from 60 to 40 bytes

1

The new sequencer V2 record can be compacted to 40 bytes instead of 60 without sacrificing too much of usable data range and code complexity. Proposed layout: * Structure Version:...

### To reproduce ``` 2024-03-20T15:41:12.6653541Z 2024-03-20T15:41:12.448659Z I i.q.c.p.WalWriterPool closed 2024-03-20T15:41:12.6654123Z Tests run: 10, Failures: 1, Errors: 0, Skipped: 4, Time elapsed: 64.895 sec

### Is your feature request related to a problem? Huge commits (the data size exceeds available RAM) can be written to WAL files but then crash instances with OOM errors...

SQL: sample by 1h fill(linear) align to calendar does not align to calendar

2

### Describe the bug _No response_ ### To reproduce on demo https://demo.questdb.io/ run ```SQL select pickup_datetime, last(passenger_count) v from trips where cab_type = 'yellow' and pickup_datetime > '2009-03-03' and pickup_datetime...

### To reproduce When copying table and running INSERT as SELECT with batching the query reported as timed out to the web console but the data is copied. INSERT as...

### To reproduce ``` 2024-06-14T09:45:15.737549Z I i.q.g.e.QueryProgress exe [id=432, sql=`SELECT min(quantity), max(quantity) FROM tab`, principal=admin, cache=false] 2024-06-14T09:45:15.737661Z I i.q.g.e.QueryProgress fin [id=433, sql=`SELECT min(quantity), max(quantity) FROM tab`, principal=admin, cache=false, time=73487150500] 2024-06-14T09:45:15.738009Z...

Simplify datatetime SQL arithmetics

1

### Is your feature request related to a problem? Functions to add/remove a period of time are cumbersome For example subtracting 2 hours syntax is `dateadd('h', -2, now())` ### Describe...

OOM logging is badly formatted

5

### To reproduce ``` 2024-07-22T17:51:34.453589Z I i.q.c.TableWriter o3 commit [table=testWalWriteFullRandom_nonwal, o3RowCount=1769558] sun.misc.Unsafe.allocateMemory() OutOfMemoryError [RSS_MEM_USED=4368849184, size=1055916032, memoryTag=45], original message: 2024-07-22T17:51:36.654908Z C i.q.c.TableWriter could not sort varsize o3 column [table=testWalWriteFullRandom_nonwal, column=var_top, type=VARCHAR,...

### Is your feature request related to a problem? Logs files can be massive on production load. ### Describe the solution you'd like. The feature to make the rolling is...

fix(core): fix stale table suspended flag not cleared after auto resume on restart

3

When QuestDB re-tries applying transactions to a suspended state after a restart it does not change the state of the table to non-suspended if successful. This PR fixes this problem....