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

Cannot assign requested address with YugabyteDB and Docker Volume

Problem when using yugabyte with persistence volume in docker. On first run everything work fine, but when re-create container with existing volume, it fail to start: master.err : ./../src/yb/master/master_main.cc:131] Network error…
FranckPachot
  • 414
  • 4
  • 10
1
vote
1 answer

YugabyteDB Voyager import data Error Resolving name

Following the YugabyteDB Voyager database migration steps (https://docs.yugabyte.com/preview/migrate/migrate-steps/) going from PostgreSQL to YugabyteDB on a local Kubernetes, on Docker Desktop, on WSL2, on Windows. Using Ubuntu 22.04 on WSL2 to run…
hawky
  • 116
  • 6
1
vote
1 answer

Getting read-ops/sec in YugabyteDB node through the CLI

[Question posted by a user on YugabyteDB Community Slack] I log in my VM using ssh. I can't connect to VM's IP:7000 directly using the browser. How can I get read ops/sec and write ops/sec etc by bash?
dh YB
  • 965
  • 3
  • 10
1
vote
1 answer

Changing replication factor of an already running cluster in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I've been googling a bit and it seems that, although it is not recommended to change the RF of an already running cluster, is it possible?
dh YB
  • 965
  • 3
  • 10
1
vote
1 answer

CMake Error "include could not find requested file" when nest a third-party cmake project into my own

Following is my CMakeLists.txt structure |-- MyProject |-- CMakeLists.txt |-- README.md |-- bin |-- include |-- lib |-- src | |-- CMakeLists.txt | |-- main.cc | |-- parser | |-- CMakeLists.txt …
luvcode02
  • 21
  • 1
  • 4
1
vote
0 answers

Yugabyte Backup Completed with Error but Backup is completed

Hi I am getting error below when I triggered Yugabyte Backup in parallel. I also see the backup marked as completed with location where it is stored. Does this mean backup task failed in UI but the backup succeeded? Failed to execute task…
user_1357
  • 7,766
  • 13
  • 63
  • 106
1
vote
0 answers

some values changed to 0 when inserting data in yugabyte

yugabyte version 2.7.1.1 This is createing table sql: CREATE SEQUENCE IF NOT EXISTS xxl_job_info_id_seq; -- Table Definition CREATE TABLE "public"."xxl_job_info" ( "id" int4 NOT NULL DEFAULT nextval('xxl_job_info_id_seq'::regclass), …
kevin_chen
  • 160
  • 1
  • 1
  • 11
1
vote
1 answer

Partitioned table inside a colocated database in YugabyteDB YSQL

[Question posted by a user on YugabyteDB Community Slack] Is it possible to create a partitioned table in a colocated database? When the database is created with colocated=true and trying to add a partitioned table like this: create table test(id…
dh YB
  • 965
  • 3
  • 10
1
vote
1 answer

What is the proper syntax for using the DISABLE_FK_CHECK option of the COPY command?

How do we use the DISABLE_FK_CHECK option in the COPY command? This does not work: yugabyte=> \COPY xpctd_prtn_value FROM '/root/data.txt' WITH (FORMAT CSV, DELIMITER '|', DISABLE_FK_CHECK); ERROR: option "disable_fk_check" not recognized LINE 1:…
Jim Knicely
  • 11
  • 1
1
vote
0 answers

Getting exited with error code 132 when setting up yugabyte on docker

I am new to yugabyte and trying to set it up exactly using the docker installation guide but the container keeps exiting with code 132 using both docker run and docker compose
dark
  • 335
  • 4
  • 13
1
vote
1 answer

What is the data version that is read when using the follower read option?

[Question posted by a user on YugabyteDB Community Slack] If you set yb_read_from_followers=on and are connected to a tablet leader, do you still read stale data from a snapshot yb_follower_read_staleness_ms ago? I read this:…
dh YB
  • 965
  • 3
  • 10
1
vote
2 answers

Can Distributed SQL tools be applied as alternatives to 2 phase commit or sagas patterns for distributed transaction coordination?

I am currently reading the Microservices Patterns and it says there are mostly two approaches for distributed transactions: two phase commit (2PC) and sagas pattern. Also, I've heard about currently evolving Distributed SQL (DSQL) tools like…
Alexander Bashkirov
  • 63
  • 7
1
vote
1 answer

Setting server timezone in YugabyteDB YSQL

[Question posted by a user on YugabyteDB Community Slack] How do you permanently (not session level) set the timezone in YugabyteDB YSQL? Is this a G-flag or via ysql_pg_conf? Can you give an example? Thanks.
dh YB
  • 965
  • 3
  • 10
1
vote
2 answers

Difference between ysql_num_tablets & ysql_num_shards_per_tserver flags in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Does the ysql_num_tablets G-flag replace the ysql_num_shards_per_tserver G-flag? ysql_num_tablets seems to be currently absent from the online documentation.
dh YB
  • 965
  • 3
  • 10
1
vote
1 answer

Purging old log files in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] How can I configure the YugaByte server logs to purge every few days? They seem to fill up fast and my server runs out of disk. Especially the yb-tserver logs. Apart from the logs folder,…
dh YB
  • 965
  • 3
  • 10
1 2
3
…
22 23