Stack Overflow
Stack Overflow

Questions tagged [cockroachcloud]

cockroachcloud tag is specifically for the questions related to the Cockroach Labs Cloud edition.

15 questions
6
votes
2 answers

Alternative For Stored Procedures In cockroachDB

I was trying to migrate from Another RDBMS to cockroachDB but I think there is no such functionality like stored procedures in Cockroach. So what is the best alternative to make a stored procedure in cockroachDB ?
divya kriplani
  • 63
  • 5
3
votes
2 answers

How do I connect Ecto to CockroachDB Serverless?

I'd like to use CockroachDB Serverless for my Ecto application. How do I specify the connection string? I get an error like this when trying to connect. [error] GenServer #PID<0.295.0> terminating ** (Postgrex.Error) FATAL 08004…
Jordan Lewis
  • 16,900
  • 4
  • 29
  • 46
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
1 answer

Can't connect to CockroachCloud Free (beta) Cluster from a Spring Data R2DBC driver

I created CrockroachCloud Free (beta) Cluster and I was able to connect to the DB with the command line. But when I tried to connect from a Spring Data R2DBC driver I get an exception. I'm using following connection string in my…
Miyuru Ratnayake
  • 456
  • 3
  • 11
1
vote
1 answer

Why is my CockroachDB disk usage not decreasing?

I deleted a bunch of data from my CockroachDB database, but the disk usage is not reducing.
Jackson
  • 607
  • 2
  • 6
  • 20
1
vote
1 answer

Cockroachdb: Retrieving cluster info: failed Error: 401 Unauthorized

I am trying to connect to my Cockroachdb cluster using: ccloud auth login && \ ccloud cluster sql ocean-panda To which I am getting the following error: logged in to "YASH KOTHARI's Organization" (org-3447v) as YASH KOTHARI Retrieving cluster info:…
Yash Kothari
  • 233
  • 3
  • 6
1
vote
1 answer

Random spikes in usage (CockroachCloud Serverless)

I recently set up a free CockroachDB Serverless cluster on CockroachCloud. It's been really great so far, but sometimes there are random spikes in Request Units even though the amount of SQL statements doesn't increase at all. Here's a screenshot of…
Gadget
  • 183
  • 1
  • 7
1
vote
1 answer

encapsulating a Drop and Add constraint in a transaction

I have a simple drop and add a constraint encapsulated in a transaction as follows: begin; alter table movies drop constraint actor_check; alter table movies add constraint actor_check check ( "actor" not like '%Harpo Marx%' and "actor" not like…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
1
vote
2 answers

can not connect to cockroachdb invalid cluster name

Why I cant connect to cockroachdb via powershell ? I use this command: cockroach sql --url postgres://username@cloud-host:26257/defaultdb?sslmode=require&options=--cluster=clustername; I get the following error: Invalid clustername 08004 but the…
localdata01
  • 587
  • 7
  • 17
1
vote
0 answers

Accessing cockroachcloud db from python app running in Heroku

I just updated my python app running in heroku to point cockroachdb cloud DB. I am using the psycopg2 python library. Here is the exception I am running into: 2021-06-16T13:07:40.857022+00:00 app[web.1]: Oops! An exception has occured: FATAL: …
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
1 answer

Cannot decommission cockroachdb node

Inside Kubernetes, after scale node, cannot decommission {"level":"warn","ts":1665138574.1910405,"logger":"controller.CrdbCluster","msg":"scaling down stateful…
GurbaniX
  • 187
  • 2
  • 12
0
votes
0 answers

How to copy a cloud cockroachdb cluster to a local cluster in a docker container

I have a cluster running on cockroachlabs that I want to copy to a single-node running in a local docker container. I have searched wide to find how to backup and restore my data. Since cockroach dump has been deprecated, the preferred method seems…
Solstice
  • 21
  • 1
  • 6
0
votes
1 answer

How do I connect JetBrains DataGrip to CockroachDB Serverless?

I'd like to use JetBrains DataGrip with CockroachDB Serverless. How do I create a connection? I get errors that look like this: [08004] FATAL: codeParamsRoutingFailed: missing cluster name in connection string.
Jordan Lewis
  • 16,900
  • 4
  • 29
  • 46
0
votes
1 answer

Alter the definition of the Stored Computed Column in CockroachCloud

I have stored computed column defined as: ALTER TABLE computed_column AS INT col1+col2 STORED; Is there way to change the calculation to col1+col3 without first dropping the computed_column?
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
-1
votes
1 answer

using sql regrex_replace to replace every word that starts with a # symbol with mask(word)

I have text data as following in single column This is a credit card number #341332123-432432-413213-13223. The CC # should be masked This is a email #test@test.com The email address should be masked This is a phone #555-555-5555, The phone number…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100