# CockroachDB **URL:** https://forum.cockroachlabs.com/c/cockroachdb/7.md?page=2 [Latest](https://forum.cockroachlabs.com/latest.md) · [Categories](https://forum.cockroachlabs.com/categories.md) · [Tags](https://forum.cockroachlabs.com/tags.md) **Page:** 3 --- ## [Python connection error Python(21491,0x1171bf600) malloc](https://forum.cockroachlabs.com/t/python-connection-error-python-21491-0x1171bf600-malloc/6066)
**Author:** [@dwiga](https://forum.cockroachlabs.com/u/dwiga)\ **Replies:** 1\ **Last updated:** [January 3, 2024, 3:32pm UTC](https://forum.cockroachlabs.com/t/python-connection-error-python-21491-0x1171bf600-malloc/6066 "2024-01-03T15:32:14Z")
Hi, I need help on python connection, I already followed the instructions but this error is still happening (pyro-py3.10) ➜ pyro python main.py Python(21491,0x1171bf600) malloc: \*\*\* error for object 0xf2: pointer be… --- ## [Force replication](https://forum.cockroachlabs.com/t/force-replication/6067)
**Author:** [@comtexing](https://forum.cockroachlabs.com/u/comtexing)\ **Replies:** 4\ **Last updated:** [December 28, 2023, 4:24pm UTC](https://forum.cockroachlabs.com/t/force-replication/6067 "2023-12-28T16:24:31Z")
Hi I use a cluster with 6 nodes, with 3 as replication-factor. After some time, I drain and stop node6. After replicated the ranges to the other nodes, I drain and stop node5. After replicated the ranges to the other… --- ## [Make sure related data (used in JOINs) is in the same range](https://forum.cockroachlabs.com/t/make-sure-related-data-used-in-joins-is-in-the-same-range/6061)
**Author:** [@Thomas1](https://forum.cockroachlabs.com/u/Thomas1)\ **Replies:** 4\ **Last updated:** [December 15, 2023, 9:59am UTC](https://forum.cockroachlabs.com/t/make-sure-related-data-used-in-joins-is-in-the-same-range/6061 "2023-12-15T09:59:41Z")
Hi everyone, I’m currently using MySQL with one of the tables containing more than 1 billion rows expecting it to grow to 100 billion in the next few years. Therefore I’m looking for a horizontal scaling alternative. Mo… --- ## [Encountered query error(s) fetching data : - max result size exceeded](https://forum.cockroachlabs.com/t/encountered-query-error-s-fetching-data-max-result-size-exceeded/6054)
**Author:** [@leokwan](https://forum.cockroachlabs.com/u/leokwan)\ **Replies:** 3\ **Last updated:** [November 28, 2023, 4:09pm UTC](https://forum.cockroachlabs.com/t/encountered-query-error-s-fetching-data-max-result-size-exceeded/6054 "2023-11-28T16:09:57Z")
Hi, I am running a test 3 nodes cluster on 23.1.12. On the web console under database tab, one of my table have a warning about “max result size exceeded”. The table seems ok and all queries have result returned, even t… --- ## [Self signed certificate from s3 compatible storage not recognized](https://forum.cockroachlabs.com/t/self-signed-certificate-from-s3-compatible-storage-not-recognized/6044)
**Author:** [@Surykant](https://forum.cockroachlabs.com/u/Surykant)\ **Replies:** 5\ **Last updated:** [October 31, 2023, 6:46pm UTC](https://forum.cockroachlabs.com/t/self-signed-certificate-from-s3-compatible-storage-not-recognized/6044 "2023-10-31T18:46:32Z")
I have a on-prem cockroachdb server with self signed certificate and trying to dump backup to a s3 compatible storage which also use a self signed certificate, which bails out with “x509: certificate signed by unknown au… --- ## [Cluster upgrade won't finalize](https://forum.cockroachlabs.com/t/cluster-upgrade-wont-finalize/6042)
**Author:** [@hsreogh](https://forum.cockroachlabs.com/u/hsreogh)\ **Replies:** 1\ **Last updated:** [October 30, 2023, 12:35am UTC](https://forum.cockroachlabs.com/t/cluster-upgrade-wont-finalize/6042 "2023-10-30T00:35:22Z")
I have just upgraded all my nodes from 22.2-90 to 23.1.11. I have not changed any auto-finalization settings. The cluster will not upgrade itself despite me trying: “RESET CLUSTER SETTING cluster.preserve\_downgrade\_opti… --- ## [Error: Connection terminated unexpectedly on EKS](https://forum.cockroachlabs.com/t/error-connection-terminated-unexpectedly-on-eks/6033)
**Author:** [@vishalzuru](https://forum.cockroachlabs.com/u/vishalzuru)\ **Replies:** 1\ **Last updated:** [October 23, 2023, 8:32pm UTC](https://forum.cockroachlabs.com/t/error-connection-terminated-unexpectedly-on-eks/6033 "2023-10-23T20:32:26Z")
We set up the Cockroach db database on an EKS cluster with three nodes and replicas. Our app (NodeJS) is connected to the cockroach db database, but after a while it throws the error “Error: Connection terminated unexpec… --- ## ["use of closed network connection" after restart drained node](https://forum.cockroachlabs.com/t/use-of-closed-network-connection-after-restart-drained-node/6029)
**Author:** [@comtexing](https://forum.cockroachlabs.com/u/comtexing)\ **Replies:** 4\ **Last updated:** [October 19, 2023, 2:27pm UTC](https://forum.cockroachlabs.com/t/use-of-closed-network-connection-after-restart-drained-node/6029 "2023-10-19T14:27:56Z")
Hi We habe a running 3 node cluster with out errors since 2 weeks. Yesterday a drain node3 and stop this node after some time. After an hour we turned the node3 on again. And now we the errors like: SQLSTATE\[40003\]: … --- ## [Unable to get CPU capacity](https://forum.cockroachlabs.com/t/unable-to-get-cpu-capacity/6022)
**Author:** [@elleston](https://forum.cockroachlabs.com/u/elleston)\ **Replies:** 1\ **Last updated:** [October 9, 2023, 2:19pm UTC](https://forum.cockroachlabs.com/t/unable-to-get-cpu-capacity/6022 "2023-10-09T14:19:07Z")
I’ve recently created a cluster using on premises deployment with systemd ( https://www.cockroachlabs.com/docs/stable/deploy-cockroachdb-on-premises? filters=systemd ), everything is working fine, but I noticed that all … --- ## [Usage as Airflow metadata storage](https://forum.cockroachlabs.com/t/usage-as-airflow-metadata-storage/6027)
**Author:** [@tuupola](https://forum.cockroachlabs.com/u/tuupola)\ **Replies:** 1\ **Last updated:** [October 4, 2023, 2:28pm UTC](https://forum.cockroachlabs.com/t/usage-as-airflow-metadata-storage/6027 "2023-10-04T14:28:12Z")
Has anyone been successful in using CockroachDB as metadata storage for Apache Airflow? I have a custom image built with the following Dockerfile: FROM apache/airflow:2.7.1 RUN pip install --no-cache-dir "apache-airflo… --- ## [Can I use certs from my certificate authority for a secure cluster?](https://forum.cockroachlabs.com/t/can-i-use-certs-from-my-certificate-authority-for-a-secure-cluster/6015)
**Author:** [@ultrapain](https://forum.cockroachlabs.com/u/ultrapain)\ **Replies:** 4\ **Last updated:** [October 4, 2023, 3:05pm UTC](https://forum.cockroachlabs.com/t/can-i-use-certs-from-my-certificate-authority-for-a-secure-cluster/6015 "2023-10-04T15:05:14Z")
I’m setting up a 3 node cockroachdb cluster to test out/demo. Certs are issued for our VMs from our corporate CA. I followed the instructions to generate self-signed certs so that I could see what naming conventions co… --- ## [TVF (table-valued functions) support](https://forum.cockroachlabs.com/t/tvf-table-valued-functions-support/6020)
**Author:** [@Nkojuharov](https://forum.cockroachlabs.com/u/Nkojuharov)\ **Replies:** 1\ **Last updated:** [October 2, 2023, 7:42pm UTC](https://forum.cockroachlabs.com/t/tvf-table-valued-functions-support/6020 "2023-10-02T19:42:53Z")
Can someone point to the documentation on TVFs? I can’t find anything stating they are not supported but also can’t find anything showing they are supported. All function documentation talks about scalar UDFs and gener… --- ## [Upgraded from 22.2 to 23.1.9 what now?](https://forum.cockroachlabs.com/t/upgraded-from-22-2-to-23-1-9-what-now/6018)
**Author:** [@dennisd86](https://forum.cockroachlabs.com/u/dennisd86)\ **Replies:** 3\ **Last updated:** [September 22, 2023, 1:33pm UTC](https://forum.cockroachlabs.com/t/upgraded-from-22-2-to-23-1-9-what-now/6018 "2023-09-22T13:33:26Z")
Hello, I did upgrade from 22.2 to 23.1.9. Today i read that there was an error with TTL descriptor removed while the upgrade was done. What do I have to do now to fix that issue? Just upgrade to 23.1.10 ? --- ## [How to remove a empty node from the node list?](https://forum.cockroachlabs.com/t/how-to-remove-a-empty-node-from-the-node-list/6017)
**Author:** [@comtexing](https://forum.cockroachlabs.com/u/comtexing)\ **Replies:** 2\ **Last updated:** [September 20, 2023, 1:54pm UTC](https://forum.cockroachlabs.com/t/how-to-remove-a-empty-node-from-the-node-list/6017 "2023-09-20T13:54:00Z")
Hi I show the node status, and get a empty ‘Null’ Node with ID 5: cockroach node status --host=dms-wwa-hof --certs-dir=/opt/ctx-dms/cockroachdb/certs Connecting to server “dms-wwa-hof:26257” as user “root”. Enter pa… --- ## [CockroachDB cluster 20.2.7 failure](https://forum.cockroachlabs.com/t/cockroachdb-cluster-20-2-7-failure/6013)
**Author:** [@todd-monetago](https://forum.cockroachlabs.com/u/todd-monetago)\ **Replies:** 1\ **Last updated:** [September 15, 2023, 3:29pm UTC](https://forum.cockroachlabs.com/t/cockroachdb-cluster-20-2-7-failure/6013 "2023-09-15T15:29:15Z")
We have a 3 node cluster on version 20.2.7 that has been solid for a very long time. Recently the cluster failed and became inaccessible via the shell or web console. The CRDB service restarted on each node without issue… --- ## [Unknown behaviour of a query](https://forum.cockroachlabs.com/t/unknown-behaviour-of-a-query/6004)
**Author:** [@tsyren](https://forum.cockroachlabs.com/u/tsyren)\ **Replies:** 1\ **Last updated:** [September 15, 2023, 3:03pm UTC](https://forum.cockroachlabs.com/t/unknown-behaviour-of-a-query/6004 "2023-09-15T15:03:28Z")
hi, folks! i have been running load test benchmarks on 16 CPU x 3 node cluster and got weird behaviour during that test. With index optimized slq query, a random high latency spikes (over 5 seconds) has occurred in midd… --- ## [Can not create client certs in Kubernetes](https://forum.cockroachlabs.com/t/can-not-create-client-certs-in-kubernetes/6002)
**Author:** [@msupra](https://forum.cockroachlabs.com/u/msupra)\ **Replies:** 1\ **Last updated:** [September 11, 2023, 8:00pm UTC](https://forum.cockroachlabs.com/t/can-not-create-client-certs-in-kubernetes/6002 "2023-09-11T20:00:01Z")
Hi all. I am a newby to Cockroachdb that I deployed on a private Kubernetes cluster. I have really run out of resources on how to resolve an issue and I really hope that the community will be able to assist me. I need to… --- ## [Cockroach crashing after a minute](https://forum.cockroachlabs.com/t/cockroach-crashing-after-a-minute/6012)
**Author:** [@jawaidbazyar](https://forum.cockroachlabs.com/u/jawaidbazyar)\ **Replies:** 1\ **Last updated:** [September 11, 2023, 5:46pm UTC](https://forum.cockroachlabs.com/t/cockroach-crashing-after-a-minute/6012 "2023-09-11T17:46:43Z")
Hi CRDB community! I had a single node CRDB running well for a month with my applications; I stepped away from it for a few months. When I start it and my applications up, crdb crashes with a panic I don’t understand an… --- ## [How to check all txns which start earlier than certain time get finalized\[Committed/Rollbacked\]?](https://forum.cockroachlabs.com/t/how-to-check-all-txns-which-start-earlier-than-certain-time-get-finalized-committed-rollbacked/6007)
**Author:** [@adzfolc](https://forum.cockroachlabs.com/u/adzfolc)\ **Replies:** 1\ **Last updated:** [August 30, 2023, 5:44pm UTC](https://forum.cockroachlabs.com/t/how-to-check-all-txns-which-start-earlier-than-certain-time-get-finalized-committed-rollbacked/6007 "2023-08-30T17:44:51Z")
root@localhost:26257/defaultdb\> select \* from crdb\_internal.cluster\_transactions; id | node\_id |… --- ## [Support GRANT SELECT on column level](https://forum.cockroachlabs.com/t/support-grant-select-on-column-level/6010)
**Author:** [@jenny610138](https://forum.cockroachlabs.com/u/jenny610138)\ **Replies:** 1\ **Last updated:** [August 30, 2023, 5:36pm UTC](https://forum.cockroachlabs.com/t/support-grant-select-on-column-level/6010 "2023-08-30T17:36:39Z")
Hi, I wonder if there’s any support or alternative on the grant select on column level GRANT SELECT (id) ON TABLE users TO role; --- ## [JSON Functions "jsonb\_path\_query"](https://forum.cockroachlabs.com/t/json-functions-jsonb-path-query/5795)
**Author:** [@michaelsaurin](https://forum.cockroachlabs.com/u/michaelsaurin)\ **Replies:** 3\ **Last updated:** [August 22, 2023, 4:27pm UTC](https://forum.cockroachlabs.com/t/json-functions-jsonb-path-query/5795 "2023-08-22T16:27:15Z")
Hello, Currently we are working with Postgres and we are using JSON Functions like jsonb\_path\_query. We are not able to use jsonb\_path\_query function in CockroachDB. Are these JSON functions still not supported? When w… --- ## [Unable to complete upgrade from 22.1 to 22.2 due to "descriptor not found" error](https://forum.cockroachlabs.com/t/unable-to-complete-upgrade-from-22-1-to-22-2-due-to-descriptor-not-found-error/5996)
**Author:** [@dgivens](https://forum.cockroachlabs.com/u/dgivens)\ **Replies:** 4\ **Last updated:** [August 17, 2023, 8:22pm UTC](https://forum.cockroachlabs.com/t/unable-to-complete-upgrade-from-22-1-to-22-2-due-to-descriptor-not-found-error/5996 "2023-08-17T20:22:36Z")
I seem to have really gotten myself into a pickle and it goes back to almost exactly a year ago when I was upgrading from v21.1 to v22.1. The TL;DR is I did something that caused a migration between v21.1 and v21.2 to be… --- ## [Configuration of primary/secondary DC](https://forum.cockroachlabs.com/t/configuration-of-primary-secondary-dc/5994)
**Author:** [@olgerd](https://forum.cockroachlabs.com/u/olgerd)\ **Replies:** 3\ **Last updated:** [August 9, 2023, 3:32pm UTC](https://forum.cockroachlabs.com/t/configuration-of-primary-secondary-dc/5994 "2023-08-09T15:32:04Z")
hello all. we have 3 DCs . Two of them we consider as primary and secondary DCs and the third DC is being used to avoid split brain (we do not place any data there usually, just watchdogs). due to the fact that latency… --- ## [Why CockroachDB use a key/value store to underly the whole system](https://forum.cockroachlabs.com/t/why-cockroachdb-use-a-key-value-store-to-underly-the-whole-system/5993)
**Author:** [@york](https://forum.cockroachlabs.com/u/york)\ **Replies:** 1\ **Last updated:** [August 4, 2023, 2:08pm UTC](https://forum.cockroachlabs.com/t/why-cockroachdb-use-a-key-value-store-to-underly-the-whole-system/5993 "2023-08-04T14:08:17Z")
hi all: i’m still confused when i have read Why we built CockroachDB on top of RocksDB Which storage systems can be selected and why key/value is selected ? --- ## [Availability of cluster](https://forum.cockroachlabs.com/t/availability-of-cluster/5991)
**Author:** [@priyamadhu](https://forum.cockroachlabs.com/u/priyamadhu)\ **Replies:** 5\ **Last updated:** [August 3, 2023, 4:41pm UTC](https://forum.cockroachlabs.com/t/availability-of-cluster/5991 "2023-08-03T16:41:49Z")
Can we configure the cockroachdb to be active-passive? I want a multi-node cluster with cockroachdb, with number of replicators = 2, where data is written on node1 and replicated on node2. If node1 is down, I want n… --- ## [Add Self-Hosted Node to Serverless Cluster](https://forum.cockroachlabs.com/t/add-self-hosted-node-to-serverless-cluster/5418)
**Author:** [@Ferdzz](https://forum.cockroachlabs.com/u/Ferdzz)\ **Replies:** 4\ **Last updated:** [July 31, 2023, 8:55pm UTC](https://forum.cockroachlabs.com/t/add-self-hosted-node-to-serverless-cluster/5418 "2023-07-31T20:55:29Z")
Hi, is it possible to connect a self-hosted Node (eg. in South Africa) to a serverless cluster, in order to bring data closer to the users while still winning the safety of a managed solution? And then if not, same quest… --- ## [Serverless cold start latencies](https://forum.cockroachlabs.com/t/serverless-cold-start-latencies/5985)
**Author:** [@skybrian](https://forum.cockroachlabs.com/u/skybrian)\ **Replies:** 3\ **Last updated:** [July 20, 2023, 9:36pm UTC](https://forum.cockroachlabs.com/t/serverless-cold-start-latencies/5985 "2023-07-20T21:36:00Z")
Hello, I’m wondering what I should expect for cold start latency on a serverless cluster. Using Node with the ‘pg’ driver, I’ve seen as high as 5 seconds, though it’s more like 2 seconds today. Is there a way to monitor … --- ## [About the execution time of the system statistics](https://forum.cockroachlabs.com/t/about-the-execution-time-of-the-system-statistics/5982)
**Author:** [@DreaM](https://forum.cockroachlabs.com/u/DreaM)\ **Replies:** 2\ **Last updated:** [July 14, 2023, 6:22pm UTC](https://forum.cockroachlabs.com/t/about-the-execution-time-of-the-system-statistics/5982 "2023-07-14T18:22:35Z")
I have a question about the time counted by “explain analyze”. Does it include the time to convert the queried result data into a string, such as converting the result’s INT to a String? (String used to display results i… --- ## [Time statistics for explian analyze](https://forum.cockroachlabs.com/t/time-statistics-for-explian-analyze/5980)
**Author:** [@DreamX](https://forum.cockroachlabs.com/u/DreamX)\ **Replies:** 1\ **Last updated:** [July 14, 2023, 6:15pm UTC](https://forum.cockroachlabs.com/t/time-statistics-for-explian-analyze/5980 "2023-07-14T18:15:41Z")
I have a question about the time counted by “explain analyze”. Does it include the time to convert the queried result data into a string, such as converting the result’s INT to a String? (String used to display results i… --- ## [How to display Chinese comments as Chinese instead of character encoding?](https://forum.cockroachlabs.com/t/how-to-display-chinese-comments-as-chinese-instead-of-character-encoding/5964)
**Author:** [@wencan](https://forum.cockroachlabs.com/u/wencan)\ **Replies:** 0\ **Last updated:** [June 28, 2023, 1:25am UTC](https://forum.cockroachlabs.com/t/how-to-display-chinese-comments-as-chinese-instead-of-character-encoding/5964 "2023-06-28T01:25:33Z")
I have created a table and added Chinese comments to each field in the table. But these comments are output as character encoding instead of Chinese symbols. show create test.person: table\_name | … [Previous page](https://forum.cockroachlabs.com/c/cockroachdb/7.md?page=1) [Next page](https://forum.cockroachlabs.com/c/cockroachdb/7.md?page=3)