# Latest **URL:** https://community.cratedb.com/latest.md [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) --- ## [CrateDB into Apache Arrow through ADBC: the native PostgreSQL ADBC driver vs the ODBC route, measured](https://community.cratedb.com/t/cratedb-into-apache-arrow-through-adbc-the-native-postgresql-adbc-driver-vs-the-odbc-route-measured/2155)
**Author:** [@singhpratech](https://community.cratedb.com/u/singhpratech)\ **Replies:** 0\ **Last updated:** [September 8, 2026, 7:09am UTC](https://community.cratedb.com/t/cratedb-into-apache-arrow-through-adbc-the-native-postgresql-adbc-driver-vs-the-odbc-route-measured/2155 "2026-09-08T07:09:50Z")
CrateDB speaks the PostgreSQL wire protocol, so there are two ways to get its results into Arrow record batches through ADBC (Arrow Database Connectivity): the Apache Arrow project’s native PostgreSQL ADBC driver, or adb… --- ## [CCLA/ICLA Github Bot validation](https://community.cratedb.com/t/ccla-icla-github-bot-validation/2150)
**Author:** [@Amine\_Djebbi](https://community.cratedb.com/u/Amine_Djebbi)\ **Replies:** 2\ **Last updated:** [August 3, 2026, 10:07am UTC](https://community.cratedb.com/t/ccla-icla-github-bot-validation/2150 "2026-08-03T10:07:41Z")
Hi all, I have an issue with ICLA validation to be able to contribute to a fix I made to SSO authentication in the code. Could someone help me. I’ve signed the online document but it is still blocked by the GitHub bot. … --- ## [Maximum High Availability with acceptable data loss](https://community.cratedb.com/t/maximum-high-availability-with-acceptable-data-loss/2149)
**Author:** [@Egor\_Sharin](https://community.cratedb.com/u/Egor_Sharin)\ **Replies:** 2\ **Last updated:** [July 27, 2026, 11:44pm UTC](https://community.cratedb.com/t/maximum-high-availability-with-acceptable-data-loss/2149 "2026-07-27T23:44:01Z")
Hi, Are there settings which would create a CrateDB cluster with 3 nodes, so that even if 2 nodes go down, the 1 remaining node retains the write (and read) capability? Similarly, for a 5-node cluster, can only 2 nodes… --- ## [Load testing CrateDB using Locust](https://community.cratedb.com/t/load-testing-cratedb-using-locust/1686)
**Author:** [@Wierd](https://community.cratedb.com/u/Wierd)\ **Replies:** 5\ **Last updated:** [August 13, 2025, 9:04am UTC](https://community.cratedb.com/t/load-testing-cratedb-using-locust/1686 "2025-08-13T09:04:15Z")
Introduction As with every other database, users want to run performance tests to get a feel for the performance of their workload. CrateDB offers a couple of tools that can be used for specific use cases. For example… --- ## [New CrateDB stable release: CrateDB 6.4](https://community.cratedb.com/t/new-cratedb-stable-release-cratedb-6-4/2148)
**Author:** [@ThomasBestfleischCra](https://community.cratedb.com/u/ThomasBestfleischCra)\ **Replies:** 0\ **Last updated:** [July 20, 2026, 2:27pm UTC](https://community.cratedb.com/t/new-cratedb-stable-release-cratedb-6-4/2148 "2026-07-20T14:27:30Z")
We are happy to announce a new CrateDB 6.4 stable release available for all users and customers. CrateDB 6.4 brings performance and resilience improvements, as well as SQL standard and PostgreSQL compatibility improveme… --- ## [Free cluster connection error](https://community.cratedb.com/t/free-cluster-connection-error/2146)
**Author:** [@0000abcd](https://community.cratedb.com/u/0000abcd)\ **Replies:** 1\ **Last updated:** [July 13, 2026, 7:50am UTC](https://community.cratedb.com/t/free-cluster-connection-error/2146 "2026-07-13T07:50:10Z")
Trying to access the web console at address cluster1-0000abcd.eks1.us-east-1.aws.cratedb.net, but the developer tools returned “ERR\_NAME\_NOT\_RESOLVED”, errored for 2+ days --- ## [Inserting bulk data in crate](https://community.cratedb.com/t/inserting-bulk-data-in-crate/2145)
**Author:** [@arnab32](https://community.cratedb.com/u/arnab32)\ **Replies:** 2\ **Last updated:** [July 1, 2026, 11:46am UTC](https://community.cratedb.com/t/inserting-bulk-data-in-crate/2145 "2026-07-01T11:46:04Z")
Hi Guys So, from a migration activity, we have recently upgraded the data from 4.8.1 to 5.10.16 We have restored most of the tables from the old to the new cluster. Recently, we started facing challenges while doing o… --- ## [Graph Traversal for basic relationship](https://community.cratedb.com/t/graph-traversal-for-basic-relationship/2143)
**Author:** [@Sreekanth\_PM](https://community.cratedb.com/u/Sreekanth_PM)\ **Replies:** 1\ **Last updated:** [June 23, 2026, 4:19pm UTC](https://community.cratedb.com/t/graph-traversal-for-basic-relationship/2143 "2026-06-23T16:19:14Z")
Hi, We are building a retrieval platform that mainly serves hybrid search workloads using vector search and BM25/full text search. CrateDB looks like a strong fit for this because hybrid retrieval can stay inside SQL, i… --- ## [Setting Azure blob storage as snapshot repository for CrateDB](https://community.cratedb.com/t/setting-azure-blob-storage-as-snapshot-repository-for-cratedb/695)
**Author:** [@proddata](https://community.cratedb.com/u/proddata)\ **Replies:** 2\ **Last updated:** [June 9, 2026, 9:26am UTC](https://community.cratedb.com/t/setting-azure-blob-storage-as-snapshot-repository-for-cratedb/695 "2026-06-09T09:26:55Z")
Create a new Storage Account in Microsoft Azure Create a new Container in the Storage Account Get you Access keys for the Container (Security + networking \> Access Keys) In your CrateDB Cluster create a new repository Y… --- ## [CrateDB 6.1.3 Upgrade Causing CPU Spikes on GCP](https://community.cratedb.com/t/cratedb-6-1-3-upgrade-causing-cpu-spikes-on-gcp/2109)
**Author:** [@Amogh\_Dixit](https://community.cratedb.com/u/Amogh_Dixit)\ **Replies:** 0\ **Last updated:** [May 15, 2026, 4:06am UTC](https://community.cratedb.com/t/cratedb-6-1-3-upgrade-causing-cpu-spikes-on-gcp/2109 "2026-05-15T04:06:42Z")
Upgrade Procedure: 5.10.14 → 6.0.5 → 6.1.3 Context: I am also aware of the bug in 6.1.x releases that could lead to table corruption, but this issue does not appear to be related to table corruption in my case. Issue… --- ## [Update table version to 6.x](https://community.cratedb.com/t/update-table-version-to-6-x/2107)
**Author:** [@aupilot](https://community.cratedb.com/u/aupilot)\ **Replies:** 0\ **Last updated:** [May 12, 2026, 4:27am UTC](https://community.cratedb.com/t/update-table-version-to-6-x/2107 "2026-05-12T04:27:41Z")
Perhaps someone find this useful. A simple helper script to update tables from 5.x to 6.x according to https://cratedb.com/docs/crate/reference/en/latest/admin/system-information.html#tables-need-to-be-upgraded. Only req… --- ## [Data corruption with misconfigured relayD](https://community.cratedb.com/t/data-corruption-with-misconfigured-relayd/2082)
**Author:** [@volker](https://community.cratedb.com/u/volker)\ **Replies:** 23\ **Last updated:** [May 5, 2026, 8:47am UTC](https://community.cratedb.com/t/data-corruption-with-misconfigured-relayd/2082 "2026-05-05T08:47:26Z")
I’m running a CrateDB cluster (version 6.0.3) with 4 nodes, hosting several tables, some of which are 25–200 GB in size. The core CREATE TABLE statement for one of these tables is as follows: CREATE TABLE IF NOT EXISTS … --- ## [CrateDB nodes going down in Ubuntu 24](https://community.cratedb.com/t/cratedb-nodes-going-down-in-ubuntu-24/2100)
**Author:** [@arnab32](https://community.cratedb.com/u/arnab32)\ **Replies:** 3\ **Last updated:** [April 24, 2026, 12:06pm UTC](https://community.cratedb.com/t/cratedb-nodes-going-down-in-ubuntu-24/2100 "2026-04-24T12:06:01Z")
Hello everyone Our organization is currently tasked with migration of cluster nodes from older ubuntu to latest ones using crate version-4.8.1. Here are the actions performed successfully. Deployed the cluster on th… --- ## [6.2.5 dockerhub image](https://community.cratedb.com/t/6-2-5-dockerhub-image/2102)
**Author:** [@anna.howell](https://community.cratedb.com/u/anna.howell)\ **Replies:** 2\ **Last updated:** [April 17, 2026, 2:47pm UTC](https://community.cratedb.com/t/6-2-5-dockerhub-image/2102 "2026-04-17T14:47:10Z")
Hi there, Do you guys have plans to publish 6.2.5 to dockerhub? It looks like 6.2.5 has been released, but I can’t see it on dockerhub. Thanks --- ## [Node in read-only mode after low diskspace](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166)
**Author:** [@web64](https://community.cratedb.com/u/web64)\ **Replies:** 3\ **Last updated:** [March 31, 2026, 1:48am UTC](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166 "2026-03-31T01:48:04Z")
Hi, The machine was using over 90% diskspace and the cratedb note went into read-only mode. I deleted lots of files and the server has now over 30% of available space. The cratedb node was restarted, everything is gre… --- ## [Using CrateDB Toolkit to sync MongoDB with CrateDB](https://community.cratedb.com/t/using-cratedb-toolkit-to-sync-mongodb-with-cratedb/2062)
**Author:** [@Vo\_Thien](https://community.cratedb.com/u/Vo_Thien)\ **Replies:** 25\ **Last updated:** [March 25, 2026, 6:10pm UTC](https://community.cratedb.com/t/using-cratedb-toolkit-to-sync-mongodb-with-cratedb/2062 "2026-03-25T18:10:56Z")
Hello, I want to sync DB from MongoDB with CrateDB , but it’s error: \ “\\\_id” conflicts with system column pattern InvalidColumnNameException\["\_id" conflic… --- ## [Npgsql Exception encountered when saving batches of data with Entity Framework Core 8](https://community.cratedb.com/t/npgsql-exception-encountered-when-saving-batches-of-data-with-entity-framework-core-8/2090)
**Author:** [@Jbc](https://community.cratedb.com/u/Jbc)\ **Replies:** 3\ **Last updated:** [March 25, 2026, 3:01pm UTC](https://community.cratedb.com/t/npgsql-exception-encountered-when-saving-batches-of-data-with-entity-framework-core-8/2090 "2026-03-25T15:01:12Z")
I am not entirely sure whether this issue is a CrateDB issue or an issue with the EFCore provider I am using, but I figure I will start here, and if you cannot help me I will try wth the provider. So, I recently started… --- ## [Sql exporter ssl problem with cratedb operator](https://community.cratedb.com/t/sql-exporter-ssl-problem-with-cratedb-operator/2099)
**Author:** [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\ **Replies:** 1\ **Last updated:** [March 25, 2026, 12:59pm UTC](https://community.cratedb.com/t/sql-exporter-ssl-problem-with-cratedb-operator/2099 "2026-03-25T12:59:56Z")
Problem The sql-exporter ConfigMap is generated from a bundled data/sql-exporter.yaml with a hardcoded DSN: data\_source\_name: "postgres://crate@localhost:5432/?connect\_timeout=5" There is no field in the CrateDB CR s… --- ## [»Loading data into CrateDB« weekly edition](https://community.cratedb.com/t/loading-data-into-cratedb-weekly-edition/2052)
**Author:** [@amotl](https://community.cratedb.com/u/amotl)\ **Replies:** 6\ **Last updated:** [March 5, 2026, 2:10am UTC](https://community.cratedb.com/t/loading-data-into-cratedb-weekly-edition/2052 "2026-03-05T02:10:56Z")
Introduction We are currently unlocking data loading into CrateDB using the excellent ingestr toolkit, based on dlt \[1\]. This topic informs about the progress and gives everyone the chance to participate early in the dev… --- ## [Resuming a CRFREE cloud cluster](https://community.cratedb.com/t/resuming-a-crfree-cloud-cluster/2098)
**Author:** [@0000abcd](https://community.cratedb.com/u/0000abcd)\ **Replies:** 2\ **Last updated:** [March 12, 2026, 9:08am UTC](https://community.cratedb.com/t/resuming-a-crfree-cloud-cluster/2098 "2026-03-12T09:08:16Z")
How long does it take for a free cluster to be ready to accept connections upon being resumed? --- ## [Separating node to node communication](https://community.cratedb.com/t/separating-node-to-node-communication/2093)
**Author:** [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\ **Replies:** 8\ **Last updated:** [January 30, 2026, 8:56am UTC](https://community.cratedb.com/t/separating-node-to-node-communication/2093 "2026-01-30T08:56:12Z")
Is there a way to communicate between nodes from different interface. I am planning to separate application to DB communication from DB to DB communication to speed up replication since we are storing wast amounts of dat… --- ## [Problem using the COPY FROM from AWS S3](https://community.cratedb.com/t/problem-using-the-copy-from-from-aws-s3/2092)
**Author:** [@djbestenergy](https://community.cratedb.com/u/djbestenergy)\ **Replies:** 1\ **Last updated:** [January 27, 2026, 10:22am UTC](https://community.cratedb.com/t/problem-using-the-copy-from-from-aws-s3/2092 "2026-01-27T10:22:33Z")
Hello all, (using version: 5.10.16 on 3 nodes) I’ve been using AWS S3 buckets recently to transfer data between tables for reindexing/resharding purposes. We used COPY TO/FROM in bash script with crash for this , which… --- ## [The LIKE/ILIKE keyword in CrateDB does not work when the target string contains newline (\\n) or tab (\\t) characters. This causes pattern matching to fail for multi-line or formatted text values](https://community.cratedb.com/t/the-like-ilike-keyword-in-cratedb-does-not-work-when-the-target-string-contains-newline-n-or-tab-t-characters-this-causes-pattern-matching-to-fail-for-multi-line-or-formatted-text-values/2089)
**Author:** [@anujjaiswar](https://community.cratedb.com/u/anujjaiswar)\ **Replies:** 3\ **Last updated:** [January 8, 2026, 6:39am UTC](https://community.cratedb.com/t/the-like-ilike-keyword-in-cratedb-does-not-work-when-the-target-string-contains-newline-n-or-tab-t-characters-this-causes-pattern-matching-to-fail-for-multi-line-or-formatted-text-values/2089 "2026-01-08T06:39:04Z")
For example, the query below returns an empty result: SELECT \* FROM table WHERE message ILIKE ‘%A user account was%’; But the actual message column value is: A user account was deleted accountid : amit --- ## [OPTIMIZE TABLE query progress tracking](https://community.cratedb.com/t/optimize-table-query-progress-tracking/2085)
**Author:** [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\ **Replies:** 3\ **Last updated:** [December 19, 2025, 11:12am UTC](https://community.cratedb.com/t/optimize-table-query-progress-tracking/2085 "2025-12-19T11:12:36Z")
Hello I started optimize query in my cratedb cluster and it seems like this process never ends I do not want to kill job but is there any way to understand what is happening at the background and nothing is blocking this… --- ## [What are the best practices for managing blob's metadata?](https://community.cratedb.com/t/what-are-the-best-practices-for-managing-blobs-metadata/1947)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 3\ **Last updated:** [December 15, 2025, 7:55am UTC](https://community.cratedb.com/t/what-are-the-best-practices-for-managing-blobs-metadata/1947 "2025-12-15T07:55:56Z")
Hi all, before going too far on the wrong way I need some advices on how to manage metadata related to blobs. If I understand correctly the documentation, the blob only queryable fields are digest and last\_modified col… --- ## [Circuit Breaker Error on COLLECT\_SET Aggregation - "breaker would use 18gb in total. Limit is 18gb"](https://community.cratedb.com/t/circuit-breaker-error-on-collect-set-aggregation-breaker-would-use-18gb-in-total-limit-is-18gb/2080)
**Author:** [@varad\_Deshmukh](https://community.cratedb.com/u/varad_Deshmukh)\ **Replies:** 1\ **Last updated:** [December 5, 2025, 11:07am UTC](https://community.cratedb.com/t/circuit-breaker-error-on-collect-set-aggregation-breaker-would-use-18gb-in-total-limit-is-18gb/2080 "2025-12-05T11:07:33Z")
Hello CrateDB Community, I’m experiencing circuit breaker errors during aggregation queries (specifically collect operations) and would appreciate guidance on optimization strategies. Environment: Crate DB cluster:… --- ## [Restore Snapshot from AWS S3 bucket repository into new Crate Cluster](https://community.cratedb.com/t/restore-snapshot-from-aws-s3-bucket-repository-into-new-crate-cluster/330)
**Author:** [@alexandre.marques](https://community.cratedb.com/u/alexandre.marques)\ **Replies:** 5\ **Last updated:** [December 4, 2025, 8:24am UTC](https://community.cratedb.com/t/restore-snapshot-from-aws-s3-bucket-repository-into-new-crate-cluster/330 "2025-12-04T08:24:43Z")
Hello to all, I have a repository with snapshots in a AWS S3 bucket created from a Crate Cluster. Now I need to migrate the data to a new Crate Cluster but I cannot restore the snapshots from the previous Crate Cluster… --- ## [Adaptive partitioning](https://community.cratedb.com/t/adaptive-partitioning/1974)
**Author:** [@ibrhmkoz](https://community.cratedb.com/u/ibrhmkoz)\ **Replies:** 1\ **Last updated:** [December 4, 2025, 7:38am UTC](https://community.cratedb.com/t/adaptive-partitioning/1974 "2025-12-04T07:38:24Z")
CREATE TABLE projects\_posts ( project\_id VARCHAR, labels ARRAY (VARCHAR), sentiment VARCHAR CHECK (sentiment IN ('negative', 'positive', 'neutral')), favorited\_at TIMESTAMP WITH TIME ZONE, hidden\_at T… --- ## [Add default value to column](https://community.cratedb.com/t/add-default-value-to-column/2078)
**Author:** [@Bhupendra\_Rane](https://community.cratedb.com/u/Bhupendra_Rane)\ **Replies:** 1\ **Last updated:** [December 1, 2025, 1:26pm UTC](https://community.cratedb.com/t/add-default-value-to-column/2078 "2025-12-01T13:26:24Z")
I have a table in CrateDB, and I need to add the default value for a column of type timestamp with time zone. How can I do that? My CrateDB version is 5.10.9. --- ## [Alter table quey](https://community.cratedb.com/t/alter-table-quey/2076)
**Author:** [@Gayatri\_Lakule](https://community.cratedb.com/u/Gayatri_Lakule)\ **Replies:** 1\ **Last updated:** [December 1, 2025, 12:44pm UTC](https://community.cratedb.com/t/alter-table-quey/2076 "2025-12-01T12:44:56Z")
Hello, I want to update an existing table sampletable by setting the default value of the auditdate column to CURRENT\_TIMESTAMP. However, the following query is not working: ALTER TABLE sampletable ALTER COLUMN audit… [Next page](https://community.cratedb.com/latest.md?page=1)