Questions tagged [yugabytedb]
Use for programming questions related to the YugabyteDB distributed SQL database.
yugabytedb
365
questions
0
votes
1
answer
7
views
Error binding socket when starting YugabyteDB
I have a 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/...
- 1,015
0
votes
1
answer
7
views
Optimistic and pessimistic locks in YugabyteDB
Newbie user here, starting to use yugabyteDB with some transactional queries.
Regarding optimistic and pessimistic locks, could somebody please clarify what is supported by yugabyte?
Looking at https:/...
- 1,015
0
votes
1
answer
6
views
Auto-discover the current leader of yb-master in YugabyteDB?
Is there's a way to auto-discover the current leader of YB-master machine? Or can we proxy the ysql requests from follower to leader?
From my side, if I don't connect with the leader of yb-master, the ...
- 1,015
0
votes
1
answer
9
views
View does not exist in YugabyteDB concurrent DDL
I am running YugabyteDB 2.14.2.0 on a single node setup, using a database that had been created as COLOCATED. In that database there are tables defined WITH (COLOCATED = FALSE), and I have defined a ...
- 1,015
0
votes
1
answer
3
views
Architecture of key management in YugabyteDB
I'm looking for information on how key management is implemented in YB (meaning YugabyteDB itself). In general, and in particular when using block-level encryption at rest, how are the keys stored? ...
- 1,015
0
votes
1
answer
23
views
pg_dump Issue While Exporting Schema of Existing Postgres Database for YugaByte Migration
I have an existing postgres database which I want to migrate to YugaByte using yb-voyager. I used the below command to export the postgres database schema.
yb-voyager export schema --export-dir <...
- 11.8k
-1
votes
1
answer
32
views
How to connect to YugaByte local cluster from PgAdmin
I have installed YugaByte and created a local cluster in one AWS EC2 (RHEL 8) machine by following this tutorial. The yugabyte is running as below:
The IP Address of the AWS EC2 machine is: 10.10.23....
- 11.8k
0
votes
1
answer
13
views
How to remove dead node from the cluster dashboard in YugabyteDB?
How to remove a node from a cluster, so that cluster doesn't keep reporting it as “down” or red-icon in dashboard ? I suspect yb-admin is needed, but can only find blacklist and blacklist-leader.
- 1,015
0
votes
2
answers
19
views
Getting hostname of each yb-tserver in YugabyteDB cluster using YSQL
How can I easily set host on startup of a yb-container, such that select * from yb_servers() lists a hostname instead of an ip-address in the host column?
startup command for 6 docker nodes was:
...
- 1,015
0
votes
1
answer
6
views
Change YSQL in YugabyteDB to scroll horizontally?
Is it possible to change ysqlsh to scroll horizontally instead of wrap long tables and be able to use PgUp and PgDn similar to psql?
I can't find it in the docs.
- 1,015
0
votes
1
answer
10
views
How to use password with `@` in connection string in YugabyteDB?
How do you escape a password that contains “@“ in connection string?
When I ssh to the pod and echo the ENV it outputs the correct password, but the app can’t access the DB. It throws incorrect ...
- 1,015
0
votes
1
answer
8
views
`yb_is_database_colocated` is missing after upgrading YugabyteDB cluster to 2.18.1.0
We found today the issue, that the function yb_is_database_colocated() is missing after an upgrade to 2.18.1.0.
select yb_is_database_colocated();
[Code: 0, SQL State: 42883] ERROR: function ...
- 1,015
0
votes
2
answers
13
views
Performance of incrementing counters in YugabyteDB YSQL
I have 1,000 components each has a separate table row that it update every 10 seconds.
I currently use redis with HSET and HGET.
Is it reasonable to use ysql for this?
Will frequent updates create ...
- 1,015
1
vote
1
answer
11
views
Is it possible to check on which tablet a row belongs in YugabyteDB YSQL?
Is it possible to know for a specific row on which tablet it resides?
I have found the hash value of the primary key against a record using yb_hash_code(). Assuming the value is 44277.
I have also ...
- 1,015
0
votes
1
answer
26
views
How can I migrate a BLOB column into yugabyte?
We want to switch from MySQL to yugabytedb but have some columns with blob data stored in them (type LONGBLOB).
I see that yugabyte supports BLOB but during migration yugabyte voyager told me that it ...
- 564