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
3
votes
1 answer

CockroachDB snapshot backups in Kubernetes

I am trying to take snapshot backups with Velero in Kubernetes of a 12 node test CockroachDB cluster with Velero such that, if the cluster failed, we could rebuild the cluster and restore the cockroachdb from these snapshots. We're using Velero to…
outside2344
  • 2,075
  • 2
  • 29
  • 52
3
votes
0 answers

OCI runtime failed container_linux:345 starting container process caused process_linux init caused rootfs_linux:58 mounting caused perm deni unknown

I'm setting up Nakama for a personal Unity3D project. Normally it has to return to a normal command-line. Like user@vps-24-nextwab:~$ I use Docker version 18.09.7, build 2d0083d I tried on two different VPS, with a root and non-root user. What I…
Fruity Label
  • 31
  • 4
3
votes
1 answer

How can I add a custom, arbitrary option to a table in sqlalchemy?

I'm trying to create a table with sqlalchemy's declarative_base and I would like to add cockroachdb's INTERLEAVE IN PARENT option: CREATE TABLE orders ( customer INT, id INT, total DECIMAL(20, 5), PRIMARY KEY (customer, id), …
user582175
  • 954
  • 12
  • 17
3
votes
1 answer

Why CockroachDB may close connection during large data input?

I have a Cockroach DB on Kubernetes (AWS) and a python code to load some data based on psycopg2. But when I try to run a complex query on a 100K rows of data getting connection breakage after some waiting with the following…
Oleksandr Vasylenko
  • 31
  • 4
3
votes
1 answer

SELECT with OR using two columns with index is very slow

There is a table with the following definition in my Cockroach database: CREATE TABLE foo_value ( foo_id_a INT NOT NULL, foo_id_b INT NOT NULL, value FLOAT NULL, create_date_time TIMESTAMP NULL, update_date_time TIMESTAMP NULL, …
Tobias Hermann
  • 9,936
  • 6
  • 61
  • 134
3
votes
1 answer

cockroachdb jsonb select query

I have a simple table in CockroachDB v2.0-beta: CREATE TABLE account ( id UUID NOT NULL DEFAULT uuid_v4()::UUID, acct JSON NULL, CONSTRAINT "primary" PRIMARY KEY (id ASC), INVERTED INDEX account_acct_idx (acct), FAMILY "primary"…
George
  • 81
  • 1
  • 7
3
votes
1 answer

CockroachDB Clustered Across Google Container Engine Clusters, Stateful Sets

CockroachDB has a relatively simple clustering mechanism, you initialize the DB with a command line option pointing at the host name of the other cockroach machines (but, this question is relevant really for any peer to peer clustered db). One of…
Patrick White
  • 844
  • 7
  • 17
3
votes
1 answer

How to Delete all the databases in CockroachDB?

I am trying to figure out how to delete all the databases in the CockroachDB using commands, without needing to delete them one by one. If that is not an option, can you point out the directory where all the information of the databases are stored…
Apocaleone
  • 67
  • 12
3
votes
1 answer

Unable to connect a node to cluster

I have three cockroachdb nodes, two of which are with DigitalOcean (one in SF and NY) and the third TX server. I followed the Manual Deployment documentation and our local node initated and then our remote nodes came back with: * * WARNING: The…
Jared Dunham
  • 1,467
  • 2
  • 17
  • 29
3
votes
1 answer

Why is CockroachDB's disk usage increasing even though I'm not writing to it?

I started a CockroachDB process recently and noticed that its disk usage has continued increasing even though I stopped writing to it hours ago. What's going on? Is there any way to stop it from growing?
Alex Robinson
  • 12,633
  • 2
  • 38
  • 55
3
votes
3 answers

How do I import a CSV file into CockroachDB?

I have a CSV file I exported from a MySQL database and I want to move it over to CockroachDB. How do I read in the data from the command line?
benesch
  • 5,239
  • 1
  • 22
  • 36
3
votes
3 answers

How do joins work in the Cloud Spanner database?

How do joins work in Google's Cloud Spanner database? Will the join query execute fast? Is there any comparison between SQL(MySql, Oracle, MSSQL) vs NewSQL(Cloud Spanner/TiDB/CockroachDB)?
Kumar Siva
  • 349
  • 2
  • 5
  • 16
2
votes
0 answers

CockroachDB performance is much worse than mongoDB and Aurora?

I am doing some basic load testing against cockroachDB, mongoDB and Aurora. I just have a project which can keep read/write into one of those three DBs. In that project, we can configure groutine numbers about read/write so that we can mimic…
xiaoyaoworm
  • 1,052
  • 4
  • 13
  • 32
2
votes
1 answer

JOOQ: Database version is older than what dialect COCKROACHDB supports: 13.0.0

We use CockroachDB 22.2 and JOOQ 3.18.2. In our logs, this message appears: Database version is older than what dialect COCKROACHDB supports: 13.0.0. Consider https://www.jooq.org/download/support-matrix to see what jOOQ version and edition…
Ondra Žižka
  • 43,948
  • 41
  • 217
  • 277
2
votes
0 answers

Can't connect to cockroachdb on gcp

I deployed a CockroachDB cluster on a 4 gcp instances in a secure mode and configured a TCP proxy load balancer to distribute the traffic, but when I try to connect to it through the load balancer sometimes I get connected but most of the times I…
Naran
  • 83
  • 6
1 2 3
…
28 29