questdb
questdb copied to clipboard
questdb
An open source time-series database for fast ingest and SQL queries
### To reproduce Slack thread: https://questdb.slack.com/archives/C1NFJEER0/p1743534505401339 Related Issue: https://github.com/questdb/questdb/issues/4679 There appears to be a binding issue when using `IN %(var)s` using psycopg. In the console a query like the following...
### To reproduce ``` java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at [email protected]/io.questdb.std.Unsafe$MethodHandlesClassDefiner.define(Unsafe.java:408) at [email protected]/io.questdb.std.Unsafe.defineAnonymousClass(Unsafe.java:155) at [email protected]/io.questdb.std.BytecodeAssembler.loadClass(BytecodeAssembler.java:436) at [email protected]/io.questdb.std.BytecodeAssembler.newInstance(BytecodeAssembler.java:452) at [email protected]/io.questdb.cairo.RecordSinkFactory.getInstance(RecordSinkFactory.java:650) at [email protected]/io.questdb.cairo.RecordSinkFactory.getInstance(RecordSinkFactory.java:41) at [email protected]/io.questdb.griffin.engine.groupby.DistinctTimeSeriesRecordCursorFactory.(DistinctTimeSeriesRecordCursorFactory.java:58) at [email protected]/io.questdb.griffin.SqlCodeGenerator.generateSelectDistinct(SqlCodeGenerator.java:3647) at [email protected]/io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:3398)...
### Is your feature request related to a problem? Some early testing suggests that there may be an optimisation for `LATEST ON` queries when no index is available. There are...
### Describe the bug ``` 2022-11-14T14:21:21.0403640Z ************************************************************************************* 2022-11-14T14:21:21.0404280Z ************************** Run 2 ******************************** 2022-11-14T14:21:21.0404920Z ************************************************************************************* 2022-11-14T14:21:21.0405730Z 2022-11-14T14:21:20.886058Z I IODispatcher connected [ip=127.0.0.1, fd=26] 2022-11-14T14:21:21.0406640Z 2022-11-14T14:21:20.886156Z I i.q.c.h.p.JsonQueryProcessorState [26] exec [q='select count() from...
### To reproduce when restart questdb, a table created via PG wire lost , the table has about 40000 rows , the following is crash log [crash+0.log](https://github.com/user-attachments/files/19468510/crash%2B0.log) I have tried...
### Is your feature request related to a problem? Users sometimes need to query data without knowing the timestamp ahead of time, for example, search for a unique row by...
### Is your feature request related to a problem? When generating query models (either internal to the database, or externally through query builders), it is possible to end up with...
### Is your feature request related to a problem? Running out of file handle limits is a common cause of issues with QuestDB deployments. While there is already a static...
### To reproduce Unable to easily reproduce. However, this failed on Linux-zfs ci, with seeds: ``` random seeds: 2619385209160L, 1742829770703L ``` Error: ``` java.lang.AssertionError: Memory usage by tag: NATIVE_PATH, difference:...
### To reproduce ```sql -- The following `create` creates a column with a reserved name -- It should not be allowed. CREATE table foo3 (_event VARCHAR, ts timestamp) timestamp(ts) PARTITION...
