Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] POLARDB_11_STABLE polardb_build.sh 可能存在小bug. #552

Open
digoal opened this issue Jan 16, 2025 · 1 comment
Open

[Bug] POLARDB_11_STABLE polardb_build.sh 可能存在小bug. #552

digoal opened this issue Jan 16, 2025 · 1 comment
Labels
bug Something isn't working

Comments

@digoal
Copy link

digoal commented Jan 16, 2025

POLARDB_11_STABLE polardb_build.sh 可能存在小bug.

1、编译返回的port 5435有问题

git clone -c core.symlinks=true --depth 1 -b POLARDB_11_STABLE https://github.com/ApsaraDB/PolarDB-for-PostgreSQL

cd PolarDB-for-PostgreSQL
./polardb_build.sh --without-fbl --debug=off --withrep --initpx --storage=localfs 

...

2025-01-16 15:00:23.742 CST [30553] [30553] LOG:  redirecting log output to logging collector process
2025-01-16 15:00:23.742 CST [30553] [30553] HINT:  Future log output will appear in directory "pg_log".
. done
server started
server signaled
 slot_name | lsn 
-----------+-----
 replica1  | 
(1 row)

 slot_name | lsn 
-----------+-----
 replica2  | 
(1 row)

Following command can be used to connect to PG:

su postgres -c "/home/postgres/tmp_basedir_polardb_pg_1100_bld/bin/psql -h 127.0.0.1 -p 5432 postgres"
su postgres -c "/home/postgres/tmp_basedir_polardb_pg_1100_bld/bin/psql -h 127.0.0.1 -p 5433 postgres"
su postgres -c "/home/postgres/tmp_basedir_polardb_pg_1100_bld/bin/psql -h 127.0.0.1 -p 5435 postgres"

################################ px_init ################################
server signaled
rds build done

replica2 端口不是5435, 而是5434

postgres@135451a5cc62:/tmp/PolarDB-for-PostgreSQL$ psql -p 5435
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.1" and accepting
	TCP/IP connections on port 5435?
postgres@135451a5cc62:/tmp/PolarDB-for-PostgreSQL$ psql -p 5434
psql (11.9)
Type "help" for help.

postgres=# 

2、多了一个tmp_replica_dir_polardb_pg_1100_bld目录, 这个目录的数据库没有启动, 配置端口还是5432

$ cd ~
postgres@135451a5cc62:~$ ll
total 64
drwxr-x---  1 postgres postgres 4096 Jan 16 15:05 ./
drwxr-xr-x  1 root     root     4096 Sep  4 17:24 ../
-rw-------  1 postgres postgres   71 Jan 16 15:05 .bash_history
-rw-r--r--  1 postgres postgres  220 Jan  7  2022 .bash_logout
-rw-r--r--  1 postgres postgres 3995 Sep  4 17:24 .bashrc
drwx------  3 postgres postgres 4096 Jan 16 14:58 .config/
-rw-------  1 postgres postgres   60 Jan 16 14:57 .lesshst
-rw-r--r--  1 postgres postgres  807 Jan  7  2022 .profile
-rw-------  1 postgres postgres  245 Jan 16 15:02 .psql_history
-rw-r--r--  1 postgres postgres    0 Jan 16 14:43 .sudo_as_admin_successful
drwxr-xr-x  6 postgres postgres 4096 Jan 16 14:59 tmp_basedir_polardb_pg_1100_bld/
drwxr-xr-x 15 postgres postgres 4096 Jan 16 15:00 tmp_datadir_polardb_pg_1100_bld/
drwx------ 23 postgres postgres 4096 Jan 16 15:00 tmp_master_dir_polardb_pg_1100_bld/
drwx------ 17 postgres postgres 4096 Jan 16 15:00 tmp_replica_dir_polardb_pg_1100_bld/
drwx------ 24 postgres postgres 4096 Jan 16 15:00 tmp_replica_dir_polardb_pg_1100_bld1/
drwx------ 24 postgres postgres 4096 Jan 16 15:00 tmp_replica_dir_polardb_pg_1100_bld2/

$ ll tmp_replica_dir_polardb_pg_1100_bld
total 128
drwx------ 17 postgres postgres  4096 Jan 16 15:21 ./
drwxr-x---  1 postgres postgres  4096 Jan 16 15:05 ../
drwx------  6 postgres postgres  4096 Jan 16 15:00 base/
drwx------  2 postgres postgres  4096 Jan 16 15:00 global/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_dynshmem/
-rw-------  1 postgres postgres  4513 Jan 16 15:00 pg_hba.conf
-rw-------  1 postgres postgres  1636 Jan 16 15:00 pg_ident.conf
drwx------  4 postgres postgres  4096 Jan 16 15:00 pg_logical/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_notify/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_replslot/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_serial/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_snapshots/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_stat/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_stat_tmp/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_subtrans/
drwx------  2 postgres postgres  4096 Jan 16 15:00 pg_tblspc/
-rw-------  1 postgres postgres     3 Jan 16 15:00 PG_VERSION
drwx------  4 postgres postgres  4096 Jan 16 15:00 polar_cache_trash/
-rw-------  1 postgres postgres  2083 Jan 16 15:00 polar_dma.conf
drwx------  2 postgres postgres  4096 Jan 16 15:00 polar_fullpage/
-rw-------  1 postgres postgres   211 Jan 16 15:21 polar_node_static.conf
drwx------  2 postgres postgres  4096 Jan 16 15:00 polar_rel_size_cache/
-rw-------  1 postgres postgres    88 Jan 16 15:00 postgresql.auto.conf
-rw-------  1 postgres postgres 26164 Jan 16 15:00 postgresql.conf
-rw-r--r--  1 postgres postgres   188 Jan 16 15:00 recovery.conf

$ grep port tmp_replica_dir_polardb_pg_1100_bld/postgresql.conf
#port = 5432				# (change requires restart)
#ssl_passphrase_command_supports_reload = off
					# supported by the operating system:
					# supported by the operating system:
					#   %r = remote host and port
@digoal digoal added the bug Something isn't working label Jan 16, 2025
@polardb-bot
Copy link

polardb-bot bot commented Jan 16, 2025

Hi @digoal ~ Thanks for opening this issue! 🎉

Please make sure you have provided enough information for subsequent discussion.

We will get back to you as soon as possible. ❤️

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant