Jeremy Taylor
Jeremy Taylor
Noting that this has been observed but we don't have a repro identified yet. ``` 10/15/2024, 2:59:43.831 PM 14:59:43 | ERROR xtdb.pgwire | #error { 10/15/2024, 2:59:43.831 PM :cause class...
Things to cover: 1. Configuring a DEBUG logback.xml, provide a sample - per https://github.com/xtdb/xtdb/pull/3791 2. Ingestion stopped - why & what it means - "please report", etc. 3. Link to...
Discussed originally in https://discuss.xtdb.com/t/xtdb-v1-x-connects-with-postgresql-replica/511
 Possibly blocked on a separate workaround for the slow loading issue resolved in https://github.com/xtdb/xtdb/commit/8387fe30d77ad79e71a27d9e5bbb5c03d5c413ba
Currently it can be surprising to new users to discover XT's implicit GROUP BY behaviour. For more experienced SQL users this can even look more like a bug/misstep than a...
Problems: - We need to be fast for queries that filter by a unique or near-unique but non-primary key. Currently, to do this, we approximate secondary indices by maintaining 'metadata'...
Currently the output of `SELECT error FROM xt.txs` for a failed logical `ASSERT` assertion (i.e. not a 'real' error) is relatively unintelligible: [Play](https://play.xtdb.com/?version=2.0.0-b1&type=sql&txs=W3sic3lzdGVtLXRpbWUiOm51bGwsInR4cyI6IklOU0VSVCBJTlRPIGRvY3MgKF9pZCwgZm9vKSBWQUxVRVMgKDEsICdiYXInKSJ9LHsidHhzIjoiQVNTRVJUIEVYSVNUUyAoU0VMRUNUIDEgRlJPTSBpbmZvcm1hdGlvbl9zY2hlbWEuY29sdW1ucyBXSEVSRSBjb2x1bW5fbmFtZSA9ICdmb28nIEFORCBkYXRhX3R5cGUgPSAnOnV0ZjgnKTtcbklOU0VSVCBJTlRPIGRvY3MgKF9pZCwgZm9vKSBWQUxVRVMgKDIsIDEyMykiLCJzeXN0ZW0tdGltZSI6bnVsbH0seyJ0eHMiOiJBU1NFUlQgRVhJU1RTIChTRUxFQ1QgMSBGUk9NIGluZm9ybWF0aW9uX3NjaGVtYS5jb2x1bW5zIFdIRVJFIGNvbHVtbl9uYW1lID0gJ2ZvbycgQU5EIGRhdGFfdHlwZSA9ICc6dXRmOCcpO1xuSU5TRVJUIElOVE8gZG9jcyAoX2lkLCBmb28pIFZBTFVFUyAoMywgJ2ZhaWxzJykiLCJzeXN0ZW0tdGltZSI6bnVsbH1d&query=LS1TRUxFQ1QgMSBGUk9NIGluZm9ybWF0aW9uX3NjaGVtYS5jb2x1bW5zIFdIRVJFIGNvbHVtbl9uYW1lID0gJ2ZvbycgQU5EIGRhdGFfdHlwZSA9ICc6dXRmOCcKLS0gU0VMRUNUIF9pZCwgZm9vIEZST00gZG9jcwpTRUxFQ1QgKiBGUk9NIHh0LnR4czs%3D) This information should be more easily interpreted...
Copying from a [Discuss](https://discuss.xtdb.com/t/questions-regarding-v2-0-storage-architecture/480/8?u=refset) post to aid search... > Is there a way to get more information when I have an invalid config. eg., my local_config.yaml is: metrics: !Prometheus port:...
Currently this is how it works: ``` INSERT INTO docs (_id, foo) VALUES (1, TIMESTAMP '2023-03-15 12:00:00+01:00'); INSERT INTO docs (_id, foo) VALUES (2, TIMESTAMP '2023-03-15 12:00:00+03:00'); SELECT * FROM...
XTDB can't currently be deployed for _explicit_ read replicas because: 1. JDBC uses idempotent `CREATE ... IF NOT EXISTS` statements at startup (similarly for Kafka too?) 2. tx processing logic...