Stack Overflow
Stack Overflow

Questions tagged [cockroachdb]

A scalable, geo-replicated, transactional SQL datastore developed in Go.

CockroachDB is a scalable, geo-replicated, transactional SQL datastore being developed in .

References:

435 questions
2
votes
1 answer

In CockroachDB will ever WRITE perform a READ to table metadata under the hood?

Given that CockroachDB is implemented with a KV store under the hood, including the table metadata. Would every INSERT or UPDATE also make a call to the table metadata under the hood? Apologies for the dumb question, new to databases here!
Brian Shih
  • 301
  • 1
  • 8
2
votes
1 answer

When restoring a database on Cockroach why is there a difference in number of index entries/rows restored?

When backing up a database in CockroachDB the number of rows/index_entries/bytes written are included in the output: job_id | status | fraction_completed | rows | index_entries | …
Faizan Qazi
  • 101
  • 2
2
votes
1 answer

IMPORT job disappears when using sqlalchemy-cockroachdb

I’m trying to import a climate dataset (contains geometry) to my local cockroachdb (postgis extension is installed) through the sqlalchemy-cockroachdb adapter (v1.4.3). I have a file server running using: python -m http.server 3003 -d…
David den Uyl
  • 43
  • 4
2
votes
1 answer

Inserting batches of data into CockroachDB results in a maximum allowed size error

I was inserting batches of data into CockroachDB, multi-batches (up to 10) in a single transaction. After a couple of batches the insert failed with “message size 50 MiB bigger than maximum allowed message size 16 MiB”, which is correct, this batch…
Aydrian Howard
  • 379
  • 1
  • 8
2
votes
0 answers

CockroachDB Array type to Java Type

I am new to both CockroachDb and Hibernate/JPA. I am trying to understand how to map Array types in CockroachDb to a java type in an entity class. I see in the hibernate docs some information about types and casts…
margam
  • 21
  • 1
2
votes
1 answer

Add on-premise CockroachDB node to a cluster hosted in Kubernetes

I'm planning to deploy a small Kubernetes cluster (3x 32GB Nodes). I'm not experienced with K8S and I need to come up with some kind of resilient SQL database setup and CockroachDB seems like a great choice. I wonder if it's possible to relatively…
Xkonti
  • 109
  • 1
  • 11
2
votes
1 answer

How do you configure the number of replicas per table or database?

On Cockroachdb, is it possible to configure the number of replicas per table or database?
Rima
  • 61
  • 4
2
votes
2 answers

Which distributed SQL databases put data from different tables with the same tenant in the same node?

I’m designing a SQL data schema with many tables that have a compound primary key of (customer_id, id). The application will frequently need to run JOIN queries to assemble data. However, it should never run cross customer joins. (Strictly…
Calebmer
  • 2,972
  • 6
  • 29
  • 36
2
votes
1 answer

How to resolve ReadWithUncertainityInterval in cockroach database with springboot

While performing write/read operations in cockroach database with springboot, we are getting below error intermittently. Any solutions here is appreciated. Thanks Caused by: org.postgresql.util.PSQLException: ERROR: restart transaction:…
DK93
  • 89
  • 1
  • 14
2
votes
2 answers

Is it normal that CockroachDB Serverless uses 500K RUs in 19 hours with no connections?

I set up a CockroachDB cluster for a school project. The only thing I have done is created 1 database with 1 table with 1 instance of 6 rows, but when I look at the dashboard I have already used 500K RUs. This seems like a huge amount to me, but I'm…
Jakke
  • 33
  • 5
2
votes
3 answers

How do I connect DBeaver to CockroachDB Serverless?

How do I connect DBeaver with my CockroachDB Serverless database? I get errors that look like this: FATAL: codeParamsRoutingFailed: missing cluster name in connection string
Jordan Lewis
  • 16,900
  • 4
  • 29
  • 46
2
votes
0 answers

PHP PDO will not generate an error for non-existing database

My question: Why does new PDO() not display an error message if I give it the name of a database that does not exist on the server? My database server is CockroachDB v21.1.8 which supports most of PostgreSQL's syntax. I was working on improving the…
Nathan Weiler
  • 29
  • 4
2
votes
1 answer

Has CockroachDB implemented Row Level Security?

Regarding https://forum.cockroachlabs.com/t/row-level-security-with-multi-tenancy/1294/2 - I can't find anything in the docs whether it's been implemented in later versions. Ideally, if anyone can confirm this has been implemented, and where the…
steadweb
  • 15,364
  • 3
  • 33
  • 47
2
votes
1 answer

What happens if I add a new node to a CockroachDB cluster with more storage than existing nodes?

Having a 3x 1TB CockroachDB cluster, what happens if I add a single 4 TB node? Presumably only some of the 4TB can be used as not all can be replicated? If I add 3 new nodes with 4TB each, can all disk space be replicated/used?
Tobias Mühl
  • 1,788
  • 1
  • 18
  • 30
2
votes
1 answer

Testcontainers execInContainer not working with CockroachDB

I'm using Testcontainers to start a CockroachDB instance with docker. I need to enable support for temporary tables by setting the property sql.defaults.experimental_temporary_tables.enabled to true. When the machine is running, I can do it…
Davide D'Alto
  • 7,421
  • 2
  • 16
  • 30
1 2 3
…
28 29