# CockroachDB **URL:** https://forum.cockroachlabs.com/c/cockroachdb/7.md [Latest](https://forum.cockroachlabs.com/latest.md) · [Categories](https://forum.cockroachlabs.com/categories.md) · [Tags](https://forum.cockroachlabs.com/tags.md) --- ## [CockroachDB Community Slack!](https://forum.cockroachlabs.com/t/cockroachdb-community-slack/3280)
**Author:** [@mattvardi](https://forum.cockroachlabs.com/u/mattvardi)\ **Replies:** 5\ **Last updated:** [March 21, 2023, 7:09pm UTC](https://forum.cockroachlabs.com/t/cockroachdb-community-slack/3280 "2023-03-21T19:09:31Z")
Cockroach forum folks! Thank you all so much for participating in this community with us. We really value the ability to chat back and forth about CockroachDB and related topics - which is why we’re inviting all of you t… --- ## [About the CockroachDB category](https://forum.cockroachlabs.com/t/about-the-cockroachdb-category/235)
**Author:** [@jessica](https://forum.cockroachlabs.com/u/jessica)\ **Replies:** 0\ **Last updated:** [August 16, 2016, 3:39pm UTC](https://forum.cockroachlabs.com/t/about-the-cockroachdb-category/235 "2016-08-16T15:39:06Z")
For topics that are relevant to a mass audience (the CockroachDB development team, other CockroachDB users, etc.). --- ## [How do changefeeds determine which partition of a topic to emit data to when a Kafka sink is configured?](https://forum.cockroachlabs.com/t/how-do-changefeeds-determine-which-partition-of-a-topic-to-emit-data-to-when-a-kafka-sink-is-configured/7065)
**Author:** [@kirupha2000](https://forum.cockroachlabs.com/u/kirupha2000)\ **Replies:** 2\ **Last updated:** [October 7, 2026, 10:50pm UTC](https://forum.cockroachlabs.com/t/how-do-changefeeds-determine-which-partition-of-a-topic-to-emit-data-to-when-a-kafka-sink-is-configured/7065 "2026-10-07T22:50:16Z")
When a changefeed is configured for a table with a Kafka sink, how does CockroachDB determine which partition to send the change record to? I couldn’t find any information regarding this in the documentation. --- ## [CockroachDB into Apache Arrow through ADBC, using psqlodbc 16 (PG wire) (adbcBridge 0.1.0)](https://forum.cockroachlabs.com/t/cockroachdb-into-apache-arrow-through-adbc-using-psqlodbc-16-pg-wire-adbcbridge-0-1-0/7063)
**Author:** [@singhpratech](https://forum.cockroachlabs.com/u/singhpratech)\ **Replies:** 1\ **Last updated:** [September 5, 2026, 9:31pm UTC](https://forum.cockroachlabs.com/t/cockroachdb-into-apache-arrow-through-adbc-using-psqlodbc-16-pg-wire-adbcbridge-0-1-0/7063 "2026-09-05T21:31:15Z")
adbcBridge is a small Apache-2.0 ADBC driver written in C11 that loads an ODBC driver and exposes it through the Arrow ADBC C ABI: block-cursor reads straight into Arrow record batches, bulk ingest, metadata, partitioned… --- ## [Internal RPC behavior](https://forum.cockroachlabs.com/t/internal-rpc-behavior/7043)
**Author:** [@shawnz99](https://forum.cockroachlabs.com/u/shawnz99)\ **Replies:** 1\ **Last updated:** [June 10, 2026, 3:08pm UTC](https://forum.cockroachlabs.com/t/internal-rpc-behavior/7043 "2026-06-10T15:08:31Z")
Hello all! I couldn’t find any guidelines for posting so I hope this format is okay. I am currently working on a research project where I’m intercepting RPC’s with gRPC. With cockroachDB I was trying to use the interna… --- ## [Upgrade to 26.1.1 stuck: SET CLUSTER SETTING version = '26.1' fails with node descriptor with node ID 1 was not found](https://forum.cockroachlabs.com/t/upgrade-to-26-1-1-stuck-set-cluster-setting-version-26-1-fails-with-node-descriptor-with-node-id-1-was-not-found/7041)
**Author:** [@trannghj](https://forum.cockroachlabs.com/u/trannghj)\ **Replies:** 1\ **Last updated:** [May 27, 2026, 5:38pm UTC](https://forum.cockroachlabs.com/t/upgrade-to-26-1-1-stuck-set-cluster-setting-version-26-1-fails-with-node-descriptor-with-node-id-1-was-not-found/7041 "2026-05-27T17:38:35Z")
Hi Cockroach Labs Support, Our self-hosted CockroachDB upgrade from 25.4 to 26.1.1 is stuck during finalization. All live nodes are already on v26.1.1, but cluster version remains 25.4. Running: SET CLUSTER SETTING v… --- ## [SQLAlchemy, asyncpg, and JWT](https://forum.cockroachlabs.com/t/sqlalchemy-asyncpg-and-jwt/7009)
**Author:** [@kacey](https://forum.cockroachlabs.com/u/kacey)\ **Replies:** 3\ **Last updated:** [May 27, 2026, 5:25pm UTC](https://forum.cockroachlabs.com/t/sqlalchemy-asyncpg-and-jwt/7009 "2026-05-27T17:25:04Z")
I am trying to connect to a CockroachDb instance using Sqlalchemy and asyncpg, authenticating with JWT. I currently have this working synchronously (using psycopg2 instead of asyncpg) using URL options, so I have a URL … --- ## [Need help to review a serializability implementation for MySQL Cluster](https://forum.cockroachlabs.com/t/need-help-to-review-a-serializability-implementation-for-mysql-cluster/6130)
**Author:** [@alex-ou](https://forum.cockroachlabs.com/u/alex-ou)\ **Replies:** 11\ **Last updated:** [January 2, 2026, 2:55am UTC](https://forum.cockroachlabs.com/t/need-help-to-review-a-serializability-implementation-for-mysql-cluster/6130 "2026-01-02T02:55:18Z")
Hey guys, I’ve developd a serializability implementation for MySQL Cluster(NDB Cluster) and you are invited to peer-review it for me. I believe it is the fifth one in commercial database systems after: MySQL InnoDB’s 2… --- ## [To the CockroachDB developers](https://forum.cockroachlabs.com/t/to-the-cockroachdb-developers/6999)
**Author:** [@alex-ou](https://forum.cockroachlabs.com/u/alex-ou)\ **Replies:** 7\ **Last updated:** [October 23, 2025, 1:36am UTC](https://forum.cockroachlabs.com/t/to-the-cockroachdb-developers/6999 "2025-10-23T01:36:05Z")
Dear CockroachDB developers, New technology to achieve serializability in a distributed database system has just surfaced. I’ve just posted the first technical path in my work here: GitHub - creamyfish/conflict\_serializ… --- ## [When using "cockroach start-single-node", is it expected that some transaction contention events will be lost?](https://forum.cockroachlabs.com/t/when-using-cockroach-start-single-node-is-it-expected-that-some-transaction-contention-events-will-be-lost/6986)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 11\ **Last updated:** [September 15, 2025, 8:42am UTC](https://forum.cockroachlabs.com/t/when-using-cockroach-start-single-node-is-it-expected-that-some-transaction-contention-events-will-be-lost/6986 "2025-09-15T08:42:57Z")
I wanted to test that I was successfully using “for update skip locked” to avoid transaction contention. To start with, I deliberated created contending transactions: In one connection, I started a transaction, ran upd… --- ## [FIFO queue with manually sharded position index](https://forum.cockroachlabs.com/t/fifo-queue-with-manually-sharded-position-index/7006)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 3\ **Last updated:** [August 15, 2025, 5:18am UTC](https://forum.cockroachlabs.com/t/fifo-queue-with-manually-sharded-position-index/7006 "2025-08-15T05:18:37Z")
Suppose we have FIFO queues, and for business reasons the queue should be strictly FIFO (customers might get upset if someone else gets ahead of them in line). Queues are independent (a user can appear in more than one … --- ## [Crdb\_internal.cluster\_locks doesn't show non-contended lock?](https://forum.cockroachlabs.com/t/crdb-internal-cluster-locks-doesnt-show-non-contended-lock/7005)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 5\ **Last updated:** [August 15, 2025, 2:37am UTC](https://forum.cockroachlabs.com/t/crdb-internal-cluster-locks-doesnt-show-non-contended-lock/7005 "2025-08-15T02:37:22Z")
I start with the beginning of the basic example (crdb\_internal) CREATE TABLE kv (k INT PRIMARY KEY, v INT); INSERT INTO kv (k, v) VALUES (1, 5), (2, 10), (3, 15); BEGIN; SELECT \* FROM kv WHERE k = 1 FOR UPDATE; If at t… --- ## [Can I recreate a cluster using the same name?](https://forum.cockroachlabs.com/t/can-i-recreate-a-cluster-using-the-same-name/7003)
**Author:** [@thewilkybarkid](https://forum.cockroachlabs.com/u/thewilkybarkid)\ **Replies:** 1\ **Last updated:** [July 28, 2025, 3:22pm UTC](https://forum.cockroachlabs.com/t/can-i-recreate-a-cluster-using-the-same-name/7003 "2025-07-28T15:22:00Z")
While testing out CockroachDB we created a cluster for our sandbox environment and tested the multi-region functionality. We didn’t realise that you can’t remove a region from a cluster, and want to remove one. As it’s … --- ## [Tracing changefeed change back to modifying transaction?](https://forum.cockroachlabs.com/t/tracing-changefeed-change-back-to-modifying-transaction/6991)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 1\ **Last updated:** [June 30, 2025, 5:08pm UTC](https://forum.cockroachlabs.com/t/tracing-changefeed-change-back-to-modifying-transaction/6991 "2025-06-30T17:08:48Z")
Using the updated option adds an updated timestamp to each delivered changefeed row. This provides the commit time of the change, and shows the “happens-before” ordering of row changes. The What is change data capture? … --- ## [Sudden Latency Spikes on Single Node After Leaseholder Rebalancing?](https://forum.cockroachlabs.com/t/sudden-latency-spikes-on-single-node-after-leaseholder-rebalancing/6988)
**Author:** [@taroki](https://forum.cockroachlabs.com/u/taroki)\ **Replies:** 0\ **Last updated:** [June 28, 2025, 2:01pm UTC](https://forum.cockroachlabs.com/t/sudden-latency-spikes-on-single-node-after-leaseholder-rebalancing/6988 "2025-06-28T14:01:04Z")
Hello We recently observed unexpected latency spikes on a specific node in our CockroachDB cluster after performing a routine scale-out. :innocent:Upon investigation; it appeared that several leaseholders were automatic… --- ## [Can a client get the txn id of its own currently open transaction?](https://forum.cockroachlabs.com/t/can-a-client-get-the-txn-id-of-its-own-currently-open-transaction/6984)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 3\ **Last updated:** [June 26, 2025, 1:02pm UTC](https://forum.cockroachlabs.com/t/can-a-client-get-the-txn-id-of-its-own-currently-open-transaction/6984 "2025-06-26T13:02:42Z")
I see the transaction id being shown by SHOW TRANSACTIONS as well as in the crdb\_internal.transaction\_contention\_events table. Is there a way for a client to get the transaction id of its own currently open transaction?… --- ## [Decommission a node fails](https://forum.cockroachlabs.com/t/decommission-a-node-fails/6976)
**Author:** [@hongyuan](https://forum.cockroachlabs.com/u/hongyuan)\ **Replies:** 2\ **Last updated:** [June 4, 2025, 2:39pm UTC](https://forum.cockroachlabs.com/t/decommission-a-node-fails/6976 "2025-06-04T14:39:32Z")
I have a 3 node v25.2.0 cluster deployed in secure mode with Kubernetes via the latest cockroach operator. The cluster seems to work well in that I can run cockroach sql and many administrative commands. bash-5.1$ cock… --- ## [With initial\_scan='yes', are we guaranteed to only get "resolved" after initial scan complete?](https://forum.cockroachlabs.com/t/with-initial-scan-yes-are-we-guaranteed-to-only-get-resolved-after-initial-scan-complete/6974)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 1\ **Last updated:** [May 20, 2025, 1:29pm UTC](https://forum.cockroachlabs.com/t/with-initial-scan-yes-are-we-guaranteed-to-only-get-resolved-after-initial-scan-complete/6974 "2025-05-20T13:29:15Z")
This seems to be almost implied by “The resolved timestamp is the high-water mark that guarantees that no previously unseen rows with an earlier update timestamp will be emitted to the sink”, and, for the update option, … --- ## [Is it possible to give a SQL user access to a database through the Cloud API?](https://forum.cockroachlabs.com/t/is-it-possible-to-give-a-sql-user-access-to-a-database-through-the-cloud-api/6973)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 2\ **Last updated:** [May 9, 2025, 2:23am UTC](https://forum.cockroachlabs.com/t/is-it-possible-to-give-a-sql-user-access-to-a-database-through-the-cloud-api/6973 "2025-05-09T02:23:10Z")
I see I can create a SQL user: CockroachDB Cloud API And of course I can connect to the database with an existing SQL user that has GRANT privilege, and grant the new sql user access to the database that way. However t… --- ## [What is the default transaction isolation in case of Java JPA for cockroachDB?](https://forum.cockroachlabs.com/t/what-is-the-default-transaction-isolation-in-case-of-java-jpa-for-cockroachdb/6972)
**Author:** [@brundhasv](https://forum.cockroachlabs.com/u/brundhasv)\ **Replies:** 3\ **Last updated:** [May 8, 2025, 2:26pm UTC](https://forum.cockroachlabs.com/t/what-is-the-default-transaction-isolation-in-case-of-java-jpa-for-cockroachdb/6972 "2025-05-08T14:26:37Z")
Hi, Interested to know what the default isolation is when we set ‘@Transactional’ in case of Java JPA Repo? The question arises because we connect to cockroachDB in java using ‘psql’(set in application.properties/yaml).… --- ## [In CockroachDB Cloud, how do I find out why my RU usage is very high?](https://forum.cockroachlabs.com/t/in-cockroachdb-cloud-how-do-i-find-out-why-my-ru-usage-is-very-high/6970)
**Author:** [@andrew\_wilcox](https://forum.cockroachlabs.com/u/andrew_wilcox)\ **Replies:** 2\ **Last updated:** [May 7, 2025, 10:06pm UTC](https://forum.cockroachlabs.com/t/in-cockroachdb-cloud-how-do-i-find-out-why-my-ru-usage-is-very-high/6970 "2025-05-07T22:06:06Z")
I signed up for CockroachDB Cloud and set up three tables with 2-4 rows each, and tested seeing a changedeed deliver ~6 messages to a webhook. I created and dropped the tables maybe 10 or 20 times as I figured out what … --- ## [Using Cloudflare Tunnels for Communication between Nodes](https://forum.cockroachlabs.com/t/using-cloudflare-tunnels-for-communication-between-nodes/6968)
**Author:** [@HexHands](https://forum.cockroachlabs.com/u/HexHands)\ **Replies:** 3\ **Last updated:** [April 16, 2025, 2:20pm UTC](https://forum.cockroachlabs.com/t/using-cloudflare-tunnels-for-communication-between-nodes/6968 "2025-04-16T14:20:01Z")
Hello, I am trying to get my CockroachDB nodes to communicate using Cloudflare Tunnels. So far, from what I have realized is that I have to direct each tunnel to a specific port on the machine which means that when I giv… --- ## [Computed column to expose an array in JSONB](https://forum.cockroachlabs.com/t/computed-column-to-expose-an-array-in-jsonb/6954)
**Author:** [@Colm](https://forum.cockroachlabs.com/u/Colm)\ **Replies:** 1\ **Last updated:** [March 21, 2025, 3:21pm UTC](https://forum.cockroachlabs.com/t/computed-column-to-expose-an-array-in-jsonb/6954 "2025-03-21T15:21:15Z")
Hi I haven’t found a way to do this. There is a slight difference between the two syntaxes, a JSON array looks like \["Aaa", "Bbb"\], while an ARRAY of strings is like this: {"Aaa", "Bbb"} You can do string manipulation… --- ## [Primary Key index is ignored...?](https://forum.cockroachlabs.com/t/primary-key-index-is-ignored/6952)
**Author:** [@tk35c](https://forum.cockroachlabs.com/u/tk35c)\ **Replies:** 1\ **Last updated:** [January 27, 2025, 6:11pm UTC](https://forum.cockroachlabs.com/t/primary-key-index-is-ignored/6952 "2025-01-27T18:11:17Z")
Hello. I’ve a CockroachDB v24.3.0 cluster with 6 nodes and I’m now evaluating how CockroachDB performs when we’ve to insert into tables with foreign key constraints. I’m using the following schema: CREATE TABLE IF NOT… --- ## [New License and OSS Build](https://forum.cockroachlabs.com/t/new-license-and-oss-build/6940)
**Author:** [@bbassotti](https://forum.cockroachlabs.com/u/bbassotti)\ **Replies:** 5\ **Last updated:** [January 20, 2025, 8:14pm UTC](https://forum.cockroachlabs.com/t/new-license-and-oss-build/6940 "2025-01-20T20:14:58Z")
With the new license, is it still possible to compile the OSS version? --- ## [Listen tcp :26257: bind: address already in use](https://forum.cockroachlabs.com/t/listen-tcp-bind-address-already-in-use/6951)
**Author:** [@HexHands](https://forum.cockroachlabs.com/u/HexHands)\ **Replies:** 3\ **Last updated:** [January 12, 2025, 3:16pm UTC](https://forum.cockroachlabs.com/t/listen-tcp-bind-address-already-in-use/6951 "2025-01-12T15:16:22Z")
I am trying to start a CockroachDB single node, but I keep getting the following error: server startup failed: cockroach server exited with error: listen tcp :26257: bind: address already in use I’m using this comman… --- ## [Question about INT data type](https://forum.cockroachlabs.com/t/question-about-int-data-type/6949)
**Author:** [@tk35c](https://forum.cockroachlabs.com/u/tk35c)\ **Replies:** 11\ **Last updated:** [January 10, 2025, 1:00pm UTC](https://forum.cockroachlabs.com/t/question-about-int-data-type/6949 "2025-01-10T13:00:26Z")
Hello. I’m creating a table in CockroachDB as follows CREATE TABLE IF NOT EXISTS prices( date\_logical\_session DATE DEFAULT now(), market\_code INT NOT NULL, currency\_code INT NOT NULL, valor\_number INT N… --- ## [Question about sql TYPEs](https://forum.cockroachlabs.com/t/question-about-sql-types/6947)
**Author:** [@gonedaddy1](https://forum.cockroachlabs.com/u/gonedaddy1)\ **Replies:** 3\ **Last updated:** [December 16, 2024, 2:45pm UTC](https://forum.cockroachlabs.com/t/question-about-sql-types/6947 "2024-12-16T14:45:11Z")
We have a couple of different people designing tables and their own data dictionary. So one guy defines CITY as STRING(50) and another guy defines it as STRING(64) and someone else made CITY to be a STRING(100). I don’t… --- ## [Performance degradation over time](https://forum.cockroachlabs.com/t/performance-degradation-over-time/6946)
**Author:** [@tk35c](https://forum.cockroachlabs.com/u/tk35c)\ **Replies:** 1\ **Last updated:** [December 9, 2024, 10:26am UTC](https://forum.cockroachlabs.com/t/performance-degradation-over-time/6946 "2024-12-09T10:26:48Z")
Hello. I’m testing Cockroach v24.3 in a 6 nodes cluster and I’m experiencing quite some performance degradation over time. The full description for the problem is in Performance degradation with batch upserts on v24.2.… --- ## [Cluster 3 nodes use 12GB+ memory without any data](https://forum.cockroachlabs.com/t/cluster-3-nodes-use-12gb-memory-without-any-data/6945)
**Author:** [@kocoten1992](https://forum.cockroachlabs.com/u/kocoten1992)\ **Replies:** 1\ **Last updated:** [December 9, 2024, 10:25am UTC](https://forum.cockroachlabs.com/t/cluster-3-nodes-use-12gb-memory-without-any-data/6945 "2024-12-09T10:25:38Z")
Hello, I’m trying cockroachdb, I set up a secure cluster 3 nodes using v24.3.0 (each node have 16GB), the cluster doesn’t have any data in it (to be absolutely correct - less than 10kb), it just there so I could try deve… [Next page](https://forum.cockroachlabs.com/c/cockroachdb/7.md?page=1)