Stack Overflow
Stack Overflow

Questions tagged [yugabytedb]

Use for programming questions related to the YugabyteDB distributed SQL database.

YugabyteDB is an open source, high-performance, distributed SQL database for powering global, massively-scalable applications. At its core is a distributed document store whose sharding, replication and ACID transactions architecture is inspired by Google Spanner. It provides two APIs on top of this core - YSQL for fully relational workloads and YCQL for semi-relational workloads.

335 questions
1
vote
0 answers

YugaByte DB services gets down when any of the yb-tserver stops working

I am new to Yugabyte DB i have 6 pods given below names and states . One pod yb-tserver-3 is in CrashLoopBackOff state .Now i am not able to connect to my DB through DBeaver as i am getting error1 :- FATAL: Remote error: Service unavailable…
shiwam
  • 11
  • 1
1
vote
2 answers

Does Yugabyte's YSQL support type BLOB?

I see that from Is there support for BLOBs in YugabyteDB like in Oracle or Postgres?, it says BLOB type is not supported. It is from two years ago so I am wondering if it's still true. From https://github.com/yugabyte/yugabyte-db/issues/3576, I see…
Mark
  • 113
  • 7
1
vote
0 answers

How to connect to redis/yedis with C++

My C++ skills is limited and I'm trying to save data to redis/yedis in C++ by following the guide from https://docs.yugabyte.com/latest/yedis/develop/client-drivers/yedis/cpp/#write-the-helloworld-c-application. The example code I am using…
Mark
  • 113
  • 7
1
vote
1 answer

How does gocql client pick the right Tablet server, for any query?

yugabyte cluster has 2 regions, 3 AZs, 6 node architecture. 4 nodes in central region, 2 nodes in east region Node1 (Master, TServer) US-east Node2 (Master, TServer) US-central-1 Node3 (TServer) US-central-1 Node4 (TServer) US-east Node5 (Master,…
overexchange
  • 15,768
  • 30
  • 152
  • 347
1
vote
1 answer

Checking disk size consumed by each database in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Is there any way we can check the disk size consumed by each database, tables? I tried the query below but no luck: - \l+ - select pg_database_size('databaseName'); - select t1.datname AS…
dh YB
  • 965
  • 3
  • 10
1
vote
0 answers

Unable to spin up 3 nodes via yb-master in yugabytedb

I am unable to start a 3 node universe with yb-master. I am following the docs here: https://docs.yugabyte.com/latest/deploy/manual-deployment/start-masters/#verify-health I created 3 master.conf files for 3 separate ips. For…
Mark
  • 113
  • 7
1
vote
1 answer

YCQL Secondary indexes on tables with TTL in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I have a table with TTL and a secondary index, using YugabyteDB 2.9.0 and I’m getting the following error when I try to insert a row: SyntaxException: Feature Not Supported Below is my…
dh YB
  • 965
  • 3
  • 10
1
vote
1 answer

Yugabyte - INSERT/UPDATE operations are ACID?

Below is the schema in yugabyte DB: ycqlsh:example> CREATE TABLE users(user_id INT PRIMARY KEY, full_name TEXT) WITH default_time_to_live = 0 AND transactions = {'enabled': 'false'};
 ycqlsh:example> CREATE TABLE entities(entity_id INT PRIMARY…
overexchange
  • 15,768
  • 30
  • 152
  • 347
1
vote
1 answer

Retrying SQLSTATE XX000 in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Just got this error message while running my query: Network error: recvmsg got EOF from remote (SQLSTATE XX000) Is this error retryable?
dh YB
  • 965
  • 3
  • 10
1
vote
2 answers

How to capture YugabyteDB changes to kafka?

[Question posted by a user on YugabyteDB Community Slack] If I want to capture all the DB updates and send them to a Kafka topic, is there a solution you may suggest?
dh YB
  • 965
  • 3
  • 10
1
vote
1 answer

Increasing Replication Factor in YugabyteDB live cluster?

[Question posted by a user on YugabyteDB Community Slack] Is there a way to go from RF1 -> RF3 -> RF5 cluster using the default yb-master + yb-tserver components (not using yugabyted cli) ? And if that is not possible, how ready is the yugabyted…
dh YB
  • 965
  • 3
  • 10
1
vote
0 answers

Yugabtye Row-Level Geo-Partitioning

I wrote a Row-Level Geo-Partitioning POC, and I set up the following link. I found that all the data of the node table are exactly the same.enter code here I want to make the horizontal split how to achieve it，how do you du it, thank…
Eric Pan
  • 11
  • 1
1
vote
1 answer

SQL Error [XX000]: ERROR: Already present: The column already exists - Yugabyte DB

SQL Alter script: alter table table_name ADD COLUMN IF NOT EXISTS chk_col jsonb not null DEFAULT '{}'::jsonb; In this script, I am getting "ERROR: Already present: The column already exists" but the column chk_col is not present in the table. If I…
lazyakshay
  • 11
  • 2
1
vote
1 answer

Clarification in regards to using safe_time in YugabyteDB

The document https://docs.yugabyte.com/latest/architecture/transactions/transactional-io-path/ says that a distributed txn can choose the safe_time from one of the involved tablets, and that safe_time considers the first uncommitted raft log’s…
MarkoR
  • 115
  • 8
1
vote
1 answer

Akka persistence support for Yugobyte

I'm planning to test the feasibility of using Yugobyte DB (https://www.yugabyte.com/) for an Akka persistence layer. From https://doc.akka.io/docs/akka/2.4/java/persistence.html : Plugin TCK In order to help developers build correct and high…
blue-sky
  • 51,962
  • 152
  • 427
  • 752
1 2 3
…
22 23