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

How to ensure uniqueness with NULL values in cockroach DB

I have a table of accounts which generates unique keys with a sequence. It is used to generate unique identities for accounts and account/user pairs. I tried the following from pgsql: CREATE INDEX ON accounts (account_id, user_id) WHERE user_id IS…
Coyote
  • 2,454
  • 26
  • 47
0
votes
1 answer

Buiding CockroachDB for RPi yields 'segmentation violation error'

I am trying to build CockroachDB from sources on a RPi 3, following a couple of posts (this and this). My RaspberryPi setup: OS: 2018-06-27-raspbian-stretch CPU: ARMv7 rev 4(v71) Mem: 1G + SWAP: 1.5G Go version: go1.11 linux/arm I fixed a couple…
Lucian
  • 874
  • 11
  • 33
0
votes
1 answer

Final step in creating cockroachdb user certificates on Kubernetes (GKE)

I'm having trouble with the final step in creating user certificates for use with NodeJS pg client to access a secure CockroachDB running on GKE. (it all works fine using the root user client key and cert but I don't want to use root for pg…
bruce
  • 1,408
  • 11
  • 33
0
votes
1 answer

Trying to get Traefik to recognise the CockroachDB dashboard

UsingMiniKube on Windows 10 I have Traefik installed using a Daemonset as per the instructions here I installed CockroachDB (CD) using: helm install --name my-release-cockroachdb stable/cockroachdb As this created services I was expecting Traefik…
TheEdge
  • 9,291
  • 15
  • 67
  • 135
0
votes
1 answer

Migrating Cockroach DB from local machine to GCP Kubernetes Engine

Followed instructions here to create a local 3 node secure cluster Got the go example app running with the following DB connection string to connect to the secure cluster sql.Open("postgres",…
samstride
  • 168
  • 1
  • 7
0
votes
1 answer

Changing run parameter for cockroachDB in kubernetes GKE

I have a running GKE cluster with cockroachDB active. It's been running for quite a while and I don't want to reinitialize it from scratch - it uses the (almost) standard cockroachDB supplied yaml file to start. I need to change a switch in the exec…
bruce
  • 1,408
  • 11
  • 33
0
votes
1 answer

CockroachDb memory budget constraint

I have a local installation of CockroachDb on my windows PC and when I run a particular select query, I get the following error message: 7143455 bytes requested, 127403581 currently allocated, 134217728 bytes in budget. I have read a blog post…
Yusuff Sodiq
  • 815
  • 2
  • 12
  • 19
0
votes
1 answer

Duplicate key value when retrying SQL insert after quorum lost

I'm currently testing failure scenarios using 3 cockroachDB nodes. Using this scenario: Inserting records in a loop Shutdown 2 nodes out of 3 (to simulate Quorum lost) Wait long enough so the Postgres JDBC driver throws a IO Exception Restart…
sbrisson
  • 346
  • 1
  • 9
0
votes
1 answer

Local host redirection with Cloud Shell and Kubernetes

I'm a complete newbie with Kubernetes, and have been trying to get secure CockroachDB running. I'm using the instructions and preconfigured .yaml files provided by Cockroach.…
bruce
  • 1,408
  • 11
  • 33
0
votes
2 answers

exposing CockroachDB on Kubernetes to public IP

I have a CockroachDB instance running in a Kubernetes cluster on Google Kubernetes Engine. I am trying to expose port 26257 so I can connect to it from my local machine. As stated in this answer, port forwarding to the pod will not work. I have an…
skunkwerk
  • 2,920
  • 2
  • 37
  • 55
0
votes
1 answer

Interleave in parent performance for multiple key-value ranges

We are thinking about interleaving user-interactions with the user table, the only problem is that there are going to be tens of thousands of interactions per user, so 64MB of one key-value range will most likely seldom fit. The CockroachDB docs…
ACimander
  • 1,852
  • 13
  • 17
0
votes
0 answers

Blob store in addition to Cockroachdb

To store blob, what kind of distributed file system should I use in addition to cockroachdb? As I know, with CockroachDB, the max file size is 1MB. Should I use Hadoop, HDFS or something like that, to store files and keep my meta data in…
Edai
  • 9
  • 3
0
votes
1 answer

Using Spring MVC with CockroachDB

I am trying to develop a Spring MVC application liked to a CockroachDB Cluster database using Hibernate with PostgreSQL driver. The connection with the database is fine, and all tables are created. But when I launch the server I get this…
nicomahery
  • 1
  • 1
0
votes
1 answer

way to store images in cockroachdb as blob

Can we store files / images on cockroachdb and use it where S3 would otherwise by used ? So , both private and public images with different permissions can be stored.
fortm
  • 4,066
  • 5
  • 49
  • 79
0
votes
1 answer

Known limitations: maximum cluster size

So, after stumbling over some serious limitations with Cloud Spanner (no ORM for python, no update-by-query, index can not join to it's data table to fetch additional values) we are looking into another solution. CockroachDB looks like a good fit,…
ACimander
  • 1,852
  • 13
  • 17
1 2 3
…
28
29