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

Collation support in YugabyteDB?

I need to use collation from YugabyteDB and has a few questions on how collation works in YugabyteDB - Does YugabyteDB support all the functionality from Postgres? Is the support up to date with collation from Postgres? For example, case and accent…
user1093296
  • 23
  • 3
1
vote
1 answer

Using multiple DDLs within a transaction in YugabyteDB

Does anyone know the reason, yugabyte-specific or otherwise, that I cannot alternate between truncating and inserting within the same transaction? These steps: Truncate a table. Insert a row into that table. Truncate again. Insert another row into…
MarkoR
  • 115
  • 8
1
vote
2 answers

Is there a way to pass a variable as an argument to a trigger function in YugabyteDB?

[Disclaimer: This question was posed by one of our YugabyteDB users on our yugabyte.com/slack channel] The documentation for triggers below gives an example of attaching a trigger to the update of an employee…
MarkoR
  • 115
  • 8
1
vote
1 answer

How to scale a range sharded index on a timestamp column in YugabyteDB?

Is there any performance tuning to do for a write-bound workload in YugabyteDB? We thought that by simply adding additional nodes to our YugabyteDB cluster, without further tuning, we would have seen some noticeable increase in writes, however this…
MarkoR
  • 115
  • 8
1
vote
1 answer

Yugabyte :: ysqlsh: could not connect to server: Connection refused

When I run the container, it gets started, it does ✅ System checks and also prints the message "Yugabyted started successfully" And then when it tries to create the sample DB, it prints this error message. Anybody has any idea on this? ysqlsh: could…
theNewGuy
  • 23
  • 3
1
vote
1 answer

Create YB DB and Schemas via a Script file

Yugabyte, is there a way I can create the YB DB and it's schema by running one script file with all the commands mentioned here (https://docs.yugabyte.com/latest/quick-start/explore/ysql/#docker)
theNewGuy
  • 23
  • 3
1
vote
1 answer

Why does YugaByteDB YSQL select query return unexpected bytes when using bytea data type?

I am trying to store some binary data into yugabytedb on my laptop in minikube, so I used the bytea datatype as the documentation says. But when it comes to retrieving the binary data back using a select query, the bytes returned are very different…
Rodgers Ategyeka
  • 59
  • 8
1
vote
1 answer

Why does create table operation attach owner as 'yugabyte' to a new table yet the database to which am connected has a different owner?

I have installed yugabytedb in minikube on my laptop and created a database with owner 'Rodgers'. Then I run the ysqlsh to execute ysql commands from the terminal, one of which is 'CREATE DATABASE ...'. Problem When I try connecting to the database…
Rodgers Ategyeka
  • 59
  • 8
1
vote
0 answers

How to connect to yugabyte instance from app using certificates? Able to connect via ycqlsh but not from golang application

I was able to connect to the yugabyte cassandra instance through ycqlsh with the given certificates. ycqlsh --ssl Have exported the env var SSL_CERTFILE. This works but from the golang application passing the same certificates gives me an…
Adith Dev Reddy
  • 55
  • 1
  • 6
1
vote
1 answer

Getting invalid syntax error when i try to start yugabytes DB

I have installed yugabytes DB in linux machine and when i try to start the cluster using yugabyted and getting error as invalid syntax. Please help how to resolve this issue. ./bin/yugabyted status File "./bin/yugabyted", line 1430 with…
thilsen
  • 11
  • 2
1
vote
0 answers

Timed out waiting for a YugaByte DB cluster

ubuntu@vps-9b30a7d3:~/Database/yugabyte-2.1.8.1$ ./bin/yb-ctl create Creating cluster. Waiting for cluster to be ready. Viewing file /home/ubuntu/yugabyte-data/node-1/disk-1/tserver.err: sh: 1: /home/ubuntu/Database/yugabyte-2.1.8.1/bin/yb-tserver:…
Agami
  • 11
  • 1
1
vote
1 answer

Are passwords for system users/roles stored in encrypted form in YugabyteDB YSQL and YCQL?

When we create users/roles (see examples below) how are the passwords stored persistently? Are these stored in some encrypted form, and not as plain text? # YSQL CREATE USER tester WITH PASSWORD 'test_password'; or, # YCQL CREATE ROLE IF NOT EXISTS…
Charlie O'Riely
  • 87
  • 6
1
vote
1 answer

Does serial or sequence ensure the uniqueness of data in Yugabyte?

We want to migrate from mysql database to Yugabyte(PostgreSQL) database. We found 2 alternatives in YugabyteDB for mysql AUTO_INCREMENT () serial sequence For some reason we are not like to use UUID. In that case does serial or sequence ensure the…
Draga
  • 43
  • 6
1
vote
1 answer

Unable to access the yugabyte tserver and master admin ui

I'm new in YugaByte. It's really great for scaling purpose. I've created a 3 node cluster in AWS EC2. It's running fine and status is also proper. But when I'm trying to access the Admin UI for the YB-TServer and Master from my local machine using…
dkr
  • 11
  • 1
1
vote
1 answer

In YugabyteDB YSQL, how can we track the number of active connections on each server?

How can we track the active connections to a yb-tserver at a given time, and what client IP address the connection is originating from? Mostly need this for debugging purposes.
Charlie O'Riely
  • 87
  • 6
1 2 3
…
22 23