# CrateDB **URL:** https://community.cratedb.com/c/cratedb/18.md?page=3 [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) **Page:** 4 --- ## [What is the minimum value for DEBUG\_VOLUME\_SIZE?](https://community.cratedb.com/t/what-is-the-minimum-value-for-debug-volume-size/1907)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 3\ **Last updated:** [November 24, 2024, 10:17am UTC](https://community.cratedb.com/t/what-is-the-minimum-value-for-debug-volume-size/1907 "2024-11-24T10:17:12Z")
Hi all, I’m trying to setup CrateDB in a home-lab with storage constraints. I’m using the crate-operator helm chart and, in the examples, the DEBUG\_VOLUME\_SIZE is set to 128Gb. What is the minimum value that I can use… --- ## [Issue while inserting data with a string value greater than 32kb](https://community.cratedb.com/t/issue-while-inserting-data-with-a-string-value-greater-than-32kb/1900)
**Author:** [@Snehal\_Jadhav](https://community.cratedb.com/u/Snehal_Jadhav)\ **Replies:** 1\ **Last updated:** [November 13, 2024, 2:15pm UTC](https://community.cratedb.com/t/issue-while-inserting-data-with-a-string-value-greater-than-32kb/1900 "2024-11-13T14:15:04Z")
We have created a table with defination 'create table TestLargeData ( id long, name string, primary key (name,id ) ) WITH ( “translog.durability” = ‘ASYNC’ ); ’ When size of name string is greater than 32kb,the … --- ## [IN clause on primary key column does not return all the records if it has more than 5k inputs](https://community.cratedb.com/t/in-clause-on-primary-key-column-does-not-return-all-the-records-if-it-has-more-than-5k-inputs/1878)
**Author:** [@anujjaiswar](https://community.cratedb.com/u/anujjaiswar)\ **Replies:** 3\ **Last updated:** [November 13, 2024, 10:10am UTC](https://community.cratedb.com/t/in-clause-on-primary-key-column-does-not-return-all-the-records-if-it-has-more-than-5k-inputs/1878 "2024-11-13T10:10:23Z")
Query e.g: SELECT \* FROM table1 WHERE t1 = ‘abc’ AND id IN (551, 102, 1053, 4, 603, … n) AND t2 = 12; Note: Above query has more than 5000 elements in the IN clause. Above query does not return all the records. id is… --- ## [Cluster Discovery breaking once enabling host based auth in Kubernetes on GCP](https://community.cratedb.com/t/cluster-discovery-breaking-once-enabling-host-based-auth-in-kubernetes-on-gcp/1894)
**Author:** [@pmumby\_flowcoffee](https://community.cratedb.com/u/pmumby_flowcoffee)\ **Replies:** 1\ **Last updated:** [November 7, 2024, 5:37am UTC](https://community.cratedb.com/t/cluster-discovery-breaking-once-enabling-host-based-auth-in-kubernetes-on-gcp/1894 "2024-11-07T05:37:59Z")
Hello, we are deploying a self managed CrateDB Cluster on top of our Kubernetes Cluster on GKE/GCP. We have it working well in general, however now that we’re done our proof of concept, we’re moving onto making it produc… --- ## [Docker cluster on 3 nodes](https://community.cratedb.com/t/docker-cluster-on-3-nodes/1892)
**Author:** [@joheams](https://community.cratedb.com/u/joheams)\ **Replies:** 1\ **Last updated:** [November 4, 2024, 4:55pm UTC](https://community.cratedb.com/t/docker-cluster-on-3-nodes/1892 "2024-11-04T16:55:41Z")
Hi all, I have seen similiar question, but for the better of me I cant get it to work. I am trying to setup a cluster on three different docker machines (different servers) the setup looks similiar to this docker run -… --- ## [Wrong HTTP Error code when shard is unavailable?](https://community.cratedb.com/t/wrong-http-error-code-when-shard-is-unavailable/1888)
**Author:** [@echarlus](https://community.cratedb.com/u/echarlus)\ **Replies:** 0\ **Last updated:** [October 10, 2024, 12:55pm UTC](https://community.cratedb.com/t/wrong-http-error-code-when-shard-is-unavailable/1888 "2024-10-10T12:55:44Z")
Hi, I’m performing resiliency tests on my app with Crate 5.7.5 and I stumbled upon an error description which, in my opinion, does not match the Error Code returned by the HTTP Endpoint. I’m received an error with Code… --- ## [Scaling CrateDB cluster for increased read and write throughput - Emmanuel Katto](https://community.cratedb.com/t/scaling-cratedb-cluster-for-increased-read-and-write-throughput-emmanuel-katto/1884)
**Author:** [@emmanuelkatto](https://community.cratedb.com/u/emmanuelkatto)\ **Replies:** 1\ **Last updated:** [October 8, 2024, 8:12am UTC](https://community.cratedb.com/t/scaling-cratedb-cluster-for-increased-read-and-write-throughput-emmanuel-katto/1884 "2024-10-08T08:12:43Z")
Hi everyone, My name is Emmanuel Katto. I wanted to know how can I effectively scale my CrateDB cluster for increased read and write throughput? Any recommendations on configuration or hardware? Please share tips. Than… --- ## [Crate Admin UI couldn't view cluster status](https://community.cratedb.com/t/crate-admin-ui-couldnt-view-cluster-status/1722)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 9\ **Last updated:** [October 7, 2024, 1:40pm UTC](https://community.cratedb.com/t/crate-admin-ui-couldnt-view-cluster-status/1722 "2024-10-07T13:40:23Z")
Our crate 5.6.2 cluster has five nodes that three nodes are master and five nodes also as data nodes. Now I couldn’t view cluster status in Admin UI, while nodes status are normal by using systemctl status crate command,… --- ## [Cannot insert into table I created](https://community.cratedb.com/t/cannot-insert-into-table-i-created/1873)
**Author:** [@ness](https://community.cratedb.com/u/ness)\ **Replies:** 4\ **Last updated:** [October 2, 2024, 3:25pm UTC](https://community.cratedb.com/t/cannot-insert-into-table-i-created/1873 "2024-10-02T15:25:18Z")
Using http interface, eg via Crash CLI, I see strange behaviour. cr\> create table logs5(pid varchar(10), process varchar(10)); CREATE OK, 1 row affected (0.255 sec) cr\> insert into logs5(pid, process) VALUES (“a”,“b”… --- ## [How to import csv file which contains into table which have json columns](https://community.cratedb.com/t/how-to-import-csv-file-which-contains-into-table-which-have-json-columns/1870)
**Author:** [@sushilr007](https://community.cratedb.com/u/sushilr007)\ **Replies:** 0\ **Last updated:** [October 1, 2024, 11:28am UTC](https://community.cratedb.com/t/how-to-import-csv-file-which-contains-into-table-which-have-json-columns/1870 "2024-10-01T11:28:33Z")
I am trying to import csv data in table using below command COPY table1(col1,col2,col3) from 'file:///home/tab.csv' WITH (format= 'csv' , delimiter = ',') RETURN SUMMARY; I am not getting any kind of error but in col3 i… --- ## [How do we access words' frequencies?](https://community.cratedb.com/t/how-do-we-access-words-frequencies/1865)
**Author:** [@ibrhmkoz](https://community.cratedb.com/u/ibrhmkoz)\ **Replies:** 0\ **Last updated:** [September 30, 2024, 12:16pm UTC](https://community.cratedb.com/t/how-do-we-access-words-frequencies/1865 "2024-09-30T12:16:34Z")
I have an inverted index over certain columns of a table as follows: index keyword\_ft using fulltext(title, content, transcript\['text'\]) with (analyzer = 'english'), Can I access this inverted index to learn how many … --- ## [Connecting to CrateDB with crate-jdbc and pgjdbc](https://community.cratedb.com/t/connecting-to-cratedb-with-crate-jdbc-and-pgjdbc/1851)
**Author:** [@gorde.akshay](https://community.cratedb.com/u/gorde.akshay)\ **Replies:** 4\ **Last updated:** [September 23, 2024, 12:38pm UTC](https://community.cratedb.com/t/connecting-to-cratedb-with-crate-jdbc-and-pgjdbc/1851 "2024-09-23T12:38:09Z")
Hello, I see that there are two JDBC drivers available for crate to connect from Java code. First is GitHub - crate/crate-jdbc: A JDBC driver for CrateDB. and second is GitHub - pgjdbc/pgjdbc: Postgresql JDBC Driver. … --- ## [Issue with adding new fields in the object data type](https://community.cratedb.com/t/issue-with-adding-new-fields-in-the-object-data-type/1849)
**Author:** [@vinayak.shukre](https://community.cratedb.com/u/vinayak.shukre)\ **Replies:** 3\ **Last updated:** [September 20, 2024, 7:11am UTC](https://community.cratedb.com/t/issue-with-adding-new-fields-in-the-object-data-type/1849 "2024-09-20T07:11:57Z")
In my crate setup, I noticed below type of logs. Sep 10 16:40:00 cp-20-44-50-229 crate\[257638\]: \[2024-09-10T16:40:00,296\]\[WARN \]\[o.e.i.s.IndexShard \] \[cp-20-44-50-229.internal\] \[test..partitioned.t1.04732dpi6ksj4… --- ## [MasterNotDiscoveredException exception when running create queries in CrateDB](https://community.cratedb.com/t/masternotdiscoveredexception-exception-when-running-create-queries-in-cratedb/1846)
**Author:** [@Prudhvi\_Boyina](https://community.cratedb.com/u/Prudhvi_Boyina)\ **Replies:** 1\ **Last updated:** [September 15, 2024, 12:11pm UTC](https://community.cratedb.com/t/masternotdiscoveredexception-exception-when-running-create-queries-in-cratedb/1846 "2024-09-15T12:11:51Z")
Hi Team, I am getting exception when creating an user/table in CrateDB. I was able to run the select quries. Exception : MasterNotDiscoveredException\[org.elasticsearch.cluster.block.ClusterBlockException: blocked by: … --- ## [Failed to update from joined table](https://community.cratedb.com/t/failed-to-update-from-joined-table/1845)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 1\ **Last updated:** [September 11, 2024, 9:11am UTC](https://community.cratedb.com/t/failed-to-update-from-joined-table/1845 "2024-09-11T09:11:57Z")
Hi Team, I’m using CrateDB 5.5.2 and tried to update a field in a table with values obtained from joining another table. However, I encountered the following error, but I don’t know the exact cause. UPDATE Ebs.Rwmv\_Xxmt… --- ## [Crate 5.6.5 : failed engine \[lucene commit failed\] -\> DB corrupted and not starting anymore](https://community.cratedb.com/t/crate-5-6-5-failed-engine-lucene-commit-failed-db-corrupted-and-not-starting-anymore/1839)
**Author:** [@echarlus](https://community.cratedb.com/u/echarlus)\ **Replies:** 2\ **Last updated:** [September 3, 2024, 8:25am UTC](https://community.cratedb.com/t/crate-5-6-5-failed-engine-lucene-commit-failed-db-corrupted-and-not-starting-anymore/1839 "2024-09-03T08:25:08Z")
Hi, I’ve just stumbled on a DB corruption error preventing the whole DB from starting. This is crate 5.6.5 on a one node linux machine. I’ve been using crate for 7 years and it’s the first time something like that happ… --- ## [TranslogCorruptedException](https://community.cratedb.com/t/translogcorruptedexception/1264)
**Author:** [@versatildefuy](https://community.cratedb.com/u/versatildefuy)\ **Replies:** 9\ **Last updated:** [September 3, 2024, 8:23am UTC](https://community.cratedb.com/t/translogcorruptedexception/1264 "2024-09-03T08:23:06Z")
Hi guys, I am running a one-node deployment, version 4.1.8, for a small deployment. After a reboot, I encountered the following problem: servicesnode.1.o10owwaac4vg@b2-15-smart-city | org.elasticsearch.indices.recov… --- ## [SQLParseException while importing JSON](https://community.cratedb.com/t/sqlparseexception-while-importing-json/1838)
**Author:** [@Michele](https://community.cratedb.com/u/Michele)\ **Replies:** 2\ **Last updated:** [August 29, 2024, 3:31pm UTC](https://community.cratedb.com/t/sqlparseexception-while-importing-json/1838 "2024-08-29T15:31:13Z")
Hello :wave: This query leads to the error below; in other words, is it possible to import any json to a table created as “create table msg (o object);” ? INSERT INTO msg VALUES ('{"entry":\[{"changes":\[{"field":"messag… --- ## [Unable to create a repository (CrateDB cluster running with docker containers) \[SOLVED\]](https://community.cratedb.com/t/unable-to-create-a-repository-cratedb-cluster-running-with-docker-containers-solved/1589)
**Author:** [@cocoa](https://community.cratedb.com/u/cocoa)\ **Replies:** 18\ **Last updated:** [August 14, 2024, 5:50pm UTC](https://community.cratedb.com/t/unable-to-create-a-repository-cratedb-cluster-running-with-docker-containers-solved/1589 "2024-08-14T17:50:55Z")
Hello, I created a shared directory trough the host filesystem and the docker container. The local directory is mounted in container dir /backup (using docker compose) volumes: - /data/cratedb\_local/backup:/backup … --- ## [Insert data into crate using Kafka connect, Do we need schema for every record?](https://community.cratedb.com/t/insert-data-into-crate-using-kafka-connect-do-we-need-schema-for-every-record/1828)
**Author:** [@gorde.akshay](https://community.cratedb.com/u/gorde.akshay)\ **Replies:** 0\ **Last updated:** [August 8, 2024, 4:21am UTC](https://community.cratedb.com/t/insert-data-into-crate-using-kafka-connect-do-we-need-schema-for-every-record/1828 "2024-08-08T04:21:22Z")
For data ingestion in the crate using Kafka connect distributed mode. we have configured the following properties “key.converter”:“org.apache.kafka.connect.json.JsonConverter”, “value. converter”:“org.apache.kafka.con… --- ## [Is there any way to insert data from kafka topic to crate using kafka connect?](https://community.cratedb.com/t/is-there-any-way-to-insert-data-from-kafka-topic-to-crate-using-kafka-connect/1824)
**Author:** [@gorde.akshay](https://community.cratedb.com/u/gorde.akshay)\ **Replies:** 3\ **Last updated:** [August 6, 2024, 11:43am UTC](https://community.cratedb.com/t/is-there-any-way-to-insert-data-from-kafka-topic-to-crate-using-kafka-connect/1824 "2024-08-06T11:43:36Z")
Is there any way to insert data from Kafka topic to the crate using Kafka connect? Any help appreciated. --- ## [Exception in JDBC sink connector](https://community.cratedb.com/t/exception-in-jdbc-sink-connector/1826)
**Author:** [@gorde.akshay](https://community.cratedb.com/u/gorde.akshay)\ **Replies:** 7\ **Last updated:** [August 6, 2024, 5:13am UTC](https://community.cratedb.com/t/exception-in-jdbc-sink-connector/1826 "2024-08-06T05:13:15Z")
I have configured json file below { “name”: “cratedb-connector”, “config”: { “connector.class”: “io.confluent.connect.jdbc.JdbcSinkConnector”, “topics”: “mytopic”, “connection.url”: “jdbc:crate://localho… --- ## [Exception related to pk.mode and delete.enabled](https://community.cratedb.com/t/exception-related-to-pk-mode-and-delete-enabled/1827)
**Author:** [@gorde.akshay](https://community.cratedb.com/u/gorde.akshay)\ **Replies:** 1\ **Last updated:** [August 6, 2024, 4:43am UTC](https://community.cratedb.com/t/exception-related-to-pk-mode-and-delete-enabled/1827 "2024-08-06T04:43:44Z")
I have configured JSON as below { "name": "cratedb-connector", "config": { "connector.class": "io.confluent.connect.jdbc.JdbcSinkConnector", "topics": "mytopic", "connection.url":"jdbc:postgresql://local… --- ## [ERROR: A document with the same primary key exists already (SQLSTATE 23505)](https://community.cratedb.com/t/error-a-document-with-the-same-primary-key-exists-already-sqlstate-23505/1810)
**Author:** [@tsgaah](https://community.cratedb.com/u/tsgaah)\ **Replies:** 2\ **Last updated:** [August 1, 2024, 11:30am UTC](https://community.cratedb.com/t/error-a-document-with-the-same-primary-key-exists-already-sqlstate-23505/1810 "2024-08-01T11:30:08Z")
Using CrateDB with the adapter for Prometheus metric LTS. The table has been created as follows: CREATE TABLE "metrics" ( "timestamp" TIMESTAMP, "labels\_hash" STRING, "labels" OBJECT(DYNAMIC), "value" D… --- ## [How add partitions to existing table?](https://community.cratedb.com/t/how-add-partitions-to-existing-table/1820)
**Author:** [@cocoa](https://community.cratedb.com/u/cocoa)\ **Replies:** 7\ **Last updated:** [July 27, 2024, 8:03am UTC](https://community.cratedb.com/t/how-add-partitions-to-existing-table/1820 "2024-07-27T08:03:44Z")
Hello everyone, I have a table created with this configuration : schema table\_name num\_shards num\_reps c\_b p\_b blobs\_path mars data\_log 6 2 \_id NULL NULL I would like to bring the number of replicas to 4 and… --- ## [Setting statement\_timeout](https://community.cratedb.com/t/setting-statement-timeout/1814)
**Author:** [@djbestenergy](https://community.cratedb.com/u/djbestenergy)\ **Replies:** 4\ **Last updated:** [July 23, 2024, 4:28pm UTC](https://community.cratedb.com/t/setting-statement-timeout/1814 "2024-07-23T16:28:13Z")
Hi all, I read in a document that running SET GLOBAL PERSISTENT statement\_timeout = ‘2m’; Would set the timeout to 2 minutes for the whole cluster ? Is this the correct way , as I’m getting statements running longer … --- ## [Performance issue](https://community.cratedb.com/t/performance-issue/1802)
**Author:** [@volker](https://community.cratedb.com/u/volker)\ **Replies:** 6\ **Last updated:** [July 22, 2024, 5:56am UTC](https://community.cratedb.com/t/performance-issue/1802 "2024-07-22T05:56:08Z")
hey, i have some queries they become very slow (~70 seconds). here is one of this: WITH diff AS ( SELECT ts, ( fields\['Acct-Input-Octets'\] - COALESCE( LAG(fields\['Acct-Input-Octets'\]) OVER ( … --- ## [Unable to trigger duplicate key error with multi-record insert](https://community.cratedb.com/t/unable-to-trigger-duplicate-key-error-with-multi-record-insert/1812)
**Author:** [@homer](https://community.cratedb.com/u/homer)\ **Replies:** 2\ **Last updated:** [July 21, 2024, 10:26am UTC](https://community.cratedb.com/t/unable-to-trigger-duplicate-key-error-with-multi-record-insert/1812 "2024-07-21T10:26:36Z")
I’m using a cratedb cloud free tier cluster for testing. Not sure whether the bug is with cratedb or asyncpg (or whether it’s a bug at all), here’s the code: CREATE TABLE foo ( id integer, type integer, res… --- ## [Caller=server.go:349 level=error msg="Failed to write data to CrateDB" err="error closing write batch: timeout: context deadline exceeded"](https://community.cratedb.com/t/caller-server-go-349-level-error-msg-failed-to-write-data-to-cratedb-err-error-closing-write-batch-timeout-context-deadline-exceeded/1809)
**Author:** [@tsgaah](https://community.cratedb.com/u/tsgaah)\ **Replies:** 6\ **Last updated:** [July 18, 2024, 12:33pm UTC](https://community.cratedb.com/t/caller-server-go-349-level-error-msg-failed-to-write-data-to-cratedb-err-error-closing-write-batch-timeout-context-deadline-exceeded/1809 "2024-07-18T12:33:25Z")
Have configured a single node CrateDB cluster with cratedb-prometheus-adapter as a proof of concept for LTS of Prometheus metrics. The following error is produced after starting the adapter: caller=server.go:349 level=… --- ## [ Help Needed: Storing Binary Files and Metadata in CrateDB Using NiFi](https://community.cratedb.com/t/help-needed-storing-binary-files-and-metadata-in-cratedb-using-nifi/1798)
**Author:** [@d\_user](https://community.cratedb.com/u/d_user)\ **Replies:** 1\ **Last updated:** [July 9, 2024, 1:50pm UTC](https://community.cratedb.com/t/help-needed-storing-binary-files-and-metadata-in-cratedb-using-nifi/1798 "2024-07-09T13:50:56Z")
Hello, I have a few days of experience with CrateDB and NiFi. I would like to transfer a binary file (such as an image, video, or Excel file) using NiFi to CrateDB. I am unsure how to create the appropriate objects in C… [Previous page](https://community.cratedb.com/c/cratedb/18.md?page=2) [Next page](https://community.cratedb.com/c/cratedb/18.md?page=4)