Ysqlsh: FATAL: role "yugabyte" does not exist

hhferreira · September 24, 2019, 9:18am

While going through the tutorial, I got stuck while trying to initialize ysqlsh to create demo tables and data.

Using Windows 10 with docker containers. Error is:

PS YugaByteDB> docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -h yb-tserver-n1  --echo-queries
ysqlsh: FATAL:  role "yugabyte" does not exist

Can you please help? I’m using docker-compose to start the containers with the template provided in the documentation:

version: '2'

services:
  yb-master:
      image: yugabytedb/yugabyte:latest
      container_name: yb-master-n1
      command: [ "/home/yugabyte/bin/yb-master", 
                "--fs_data_dirs=/mnt/disk0,/mnt/disk1", 
                "--master_addresses=yb-master-n1:7100", 
                "--replication_factor=1"]
      ports:
      - "7000:7000"
      environment:
        SERVICE_7000_NAME: yb-master

  yb-tserver:
      image: yugabytedb/yugabyte:latest
      container_name: yb-tserver-n1
      command: [ "/home/yugabyte/bin/yb-tserver", 
                "--fs_data_dirs=/mnt/disk0,/mnt/disk1",
                "--start_pgsql_proxy", 
                "--tserver_master_addrs=yb-master-n1:7100"]
      ports:
      - "9042:9042"
      - "6379:6379"
      - "5433:5433"
      - "9000:9000"
      environment:
        SERVICE_5433_NAME: ysql
        SERVICE_9042_NAME: ycql
        SERVICE_6379_NAME: yedis
        SERVICE_9000_NAME: yb-tserver
      depends_on:
      - yb-master

Please advise.
Thanks.

Best Regards,
Hélder Hugo Ferreira

ddorian43 · September 24, 2019, 2:09pm

Hi hhferreira
Can you try this ?

PS YugaByteDB> docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -U postgres -h yb-tserver-n1  --echo-queries```

hhferreira · September 26, 2019, 11:28am

Unfortunately, did not help as can be seen below:

PS YugaByteDB> docker pull yugabytedb/yugabyte
Using default tag: latest
latest: Pulling from yugabytedb/yugabyte
Digest: sha256:0716c8c7d782b8380727d9e0768136fb7f7103f9aebf66fc170978d824ffe425
Status: Image is up to date for yugabytedb/yugabyte:latest
docker.io/yugabytedb/yugabyte:latest
PS YugaByteDB> docker-compose up -d
Creating network “yugabytedb_default” with the default driver
Creating yb-master-n1 … done
Creating yb-tserver-n1 … done
PS YugaByteDB> docker exec -it yb-master-n1 bash -c “YB_ENABLED_IN_POSTGRES=1 FLAGS_pggate_master_addresses=yb-master-n1:7100 /home/yugabyte/postgres/bin/initdb -D /tmp/yb_pg_initdb_tmp_data_dir -U postgres” The files belonging to this database system will be owned by user “root”.
This user must also own the server process.

In YugaByte DB, setting LC_COLLATE to C and all other locale settings to en_US.UTF-8 by default. Locale support will be enhanced as part of addressing Issues · yugabyte/yugabyte-db · GitHub database cluster will be initialized with locales
COLLATE: C
CTYPE: en_US.UTF-8
MESSAGES: en_US.UTF-8
MONETARY: en_US.UTF-8
NUMERIC: en_US.UTF-8
TIME: en_US.UTF-8
The default database encoding has accordingly been set to “UTF8”.
The default text search configuration will be set to “english”.

Data page checksums are disabled.

creating directory /tmp/yb_pg_initdb_tmp_data_dir … ok
creating subdirectories … ok
selecting default max_connections … 300
selecting default shared_buffers … 128MB
selecting dynamic shared memory implementation … posix
creating configuration files … ok
running bootstrap script … I0926 11:20:54.900111 42 mem_tracker.cc:250] MemTracker: hard memory limit is 1.659352 GB
I0926 11:20:54.900215 42 mem_tracker.cc:252] MemTracker: soft memory limit is 1.410449 GB
I0926 11:20:54.900596 43 async_initializer.cc:73] Starting to init ybclient
I0926 11:20:54.902719 43 async_initializer.cc:77] Successfully built ybclient
W0926 11:20:54.915623 48 reactor.cc:380] pggate_ybclient_R000: Client call yb.master.MasterService.IsInitDbDone has no timeout set for connection id: { remote: 172.27.0.2:7100 idx: 0 protocol: 0x00007fa6284a9d18 → tcp }
ok
performing post-bootstrap initialization … I0926 11:21:11.094147 81 mem_tracker.cc:250] MemTracker: hard memory limit is 1.659352 GB
I0926 11:21:11.094249 81 mem_tracker.cc:252] MemTracker: soft memory limit is 1.410449 GB
I0926 11:21:11.094722 82 async_initializer.cc:73] Starting to init ybclient
I0926 11:21:11.096873 82 async_initializer.cc:77] Successfully built ybclient

and then when trying to run ysqlsh to connect to the service :

PS YugaByteDB> docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -h yb-tserver-n1 --echo-queries
ysqlsh: FATAL: role “yugabyte” does not exist
PS YugaByteDB> docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -U postgres -h yb-tserver-n1 --echo-queries
ysqlsh: FATAL: database “postgres” does not exist

Please advise.
Thanks.

Regards,
Hélder Hugo Ferreira

dorian_yugabyte · September 26, 2019, 12:39pm

Can you tell me which tutorial you’re using ?

hhferreira · September 26, 2019, 4:31pm

Sure, following URL used to launch docker: Deploy | YugabyteDB Docs

… and this one to create tables and sample data: YugabyteDB Quick start for macOS | YugabyteDB Docs

Any further hints?

Thanks in advance.

Best Regards,
Hélder Hugo

neha · September 26, 2019, 6:34pm

Hi @hhferreira,

It looks like YSQL didn’t end up getting initialized on your cluster. Can you please use this updated docker-compose.yaml?

version: '2'                                                                                         
                                                                                                     
services:                                                                                            
  yb-master:                                                                                         
      image: yugabytedb/yugabyte:latest                                                              
      container_name: yb-master-n1                                                                   
      command: [ "/home/yugabyte/bin/yb-master",                                                     
                "--fs_data_dirs=/mnt/disk0,/mnt/disk1",                                              
                "--master_addresses=yb-master-n1:7100",                                              
                "--replication_factor=1",                                                            
                "--enable_ysql=true"]                                                                
      ports:                                                                                         
      - "7000:7000"                                                                                  
      environment:                                                                                   
        SERVICE_7000_NAME: yb-master                                                                 
                                                                                                     
  yb-tserver:                                                                                        
      image: yugabytedb/yugabyte:latest                                                              
      container_name: yb-tserver-n1                                                                  
      command: [ "/home/yugabyte/bin/yb-tserver",                                                    
                "--fs_data_dirs=/mnt/disk0,/mnt/disk1",                                              
                "--start_pgsql_proxy",                                                               
                "--tserver_master_addrs=yb-master-n1:7100"]                                          
      ports:                                                                                         
      - "9042:9042"                                                                                  
      - "6379:6379"                                                                                  
      - "5433:5433"                                                                                  
      - "9000:9000"                                                                                  
      environment:                                                                                   
        SERVICE_5433_NAME: ysql                                                                      
        SERVICE_9042_NAME: ycql                                                                      
        SERVICE_6379_NAME: yedis                                                                     
        SERVICE_9000_NAME: yb-tserver                                                                
      depends_on:                                                                                    
      - yb-master

The main change is passing enable_ysql=true flag to yb-master process.

Steps to get it working will then be:

docker-compose down : This will remove existing cluster
docker-compose up -d : Create cluster using the new yaml
docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -h yb-tserver-n1 --echo-queries : Connect to YSQL shell.

Let me know if this works.

hhferreira · September 27, 2019, 8:26am

Still not working

PS YugaByteDB> docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -h yb-tserver-n1 --echo-queries
ysqlsh: FATAL: Not found: Error loading table with oid 1260 in database with oid 1: The object does not exist: table_id: “000000010000300080000000000004ec”

Could it be an error in the latest docker image?

dorian_yugabyte · September 27, 2019, 1:17pm

Just tried with the latest docker image in a clean environment using the config from neha.
Can you repeat again doing steps:

docker-compose stop
docker-compose rm
docker-compose up -d
docker exec -it yb-tserver-n1 /home/yugabyte/bin/ysqlsh -h yb-tserver-n1 --echo-queries

Those commands run serially should work.
Taken from: Deploy | YugabyteDB Docs

Can you also run ps -ef and confirm that yb-master was started with —enable_ysql?

Can you also print the version that you’re using by doing select version(); in YSQL ?

hhferreira · September 27, 2019, 2:30pm

Thanks! Working now, I had a weird character in my docker-compose.yaml file and the latest change to include the —enable_ysql was not being run. Nevertheless, i suggest you to update the documentation about the docker-compose.yaml definition to include this flag.

Best Regards,
Hélder Hugo Ferreira

neha · September 27, 2019, 4:55pm

Good to see that it’s working now!
We’ve updated documentation as well, thanks for the feedback.

-Neha

Topic		Replies	Views
Yugabyte Docker container Init Script General	5	1171	July 15, 2022
Ysqlsh: could not connect to server: Connection refused General	7	4138	April 11, 2023
Unable to enter ysql shell and General	3	748	June 8, 2021
Connection Refused General	9	1299	March 25, 2021
Running yb-ctl status does not give the node information General	5	1441	October 4, 2019

Ysqlsh: FATAL: role "yugabyte" does not exist

Related Topics