greenplum小版本升级

最新推荐文章于 2024-05-16 17:03:12 发布
最新推荐文章于 2024-05-16 17:03:12 发布
阅读量766 收藏
点赞数 1
分类专栏： greenplum数据库 文章标签： 数据库 postgresql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/csyup1/article/details/126946985
版权

1.环境配置信息：greenplum 6.3 （社区版）

2.故障现象：

主节点日志：
[gpadmin@gpmaster pg_log]$ tail -100f gpdb-2021-11-01_000000.csv
2021-11-01 05:51:04.026103 EDT,“gpadmin”,“sdvhdb”,p14688,th-916293504,“10.126.14.12”,“1080”,2021-11-01 05:51:02 EDT,0,con136198,cmd3,seg-1,dx1170166,sx1,“ERROR”,“XX000”,“tupdesc reference 0x1a6c388 is not owned by resource owner Portal (resowner.c:1099) (seg3 slice1 10.50.176.151:6001 pid=9459) (resowner.c:1099)”,“SELECT SUM( CASE kc24.aka130 WHEN ‘14’ THEN kc24.ake038 END ) AS y,
kc24.akb020,COUNT ()
FROM
hspvhmiddata.pa_kc24 kc24
WHERE
kc24.akc194 >= ‘2021-01-01’
AND kc24.akc194 <= ‘2021-01-31’
GROUP BY
kc24.akb020
HAVING count() > 0”,0,“resowner.c”,1099,"Stack trace:
1 0x9f390c postgres errstart (elog.c:558)
2 0xa8a0fe postgres cdbdisp_get_PQerror (cdbdispatchresult.c:554)
3 0xa8a26d postgres cdbdisp_dumpDispatchResult (cdbdispatchresult.c:466)
4 0xa8a368 postgres cdbdisp_dumpDispatchResults (cdbdispatchresult.c:621)
5 0xa87cb3 postgres CdbDispatchHandleError (cdbdisp.c:163)
6 0x6dbeb4 postgres mppExecutorCleanup (execUtils.c:2218)
7 0x6c10d5 postgres standard_ExecutorRun (execMain.c:1005)
8 0x88f7b7 postgres (pquery.c:1152)
9 0x8917a1 postgres PortalRun (pquery.c:999)
10 0x88bdc0 postgres (postgres.c:1805)
11 0x88e5a4 postgres PostgresMain (postgres.c:5215)
12 0x4cc2b0 postgres (postmaster.c:4464)
13 0x815f16 postgres PostmasterMain (postmaster.c:1520)
14 0x4ceb31 postgres main (main.c:205)
15 0x7f63c4f963d5 libc.so.6 __libc_start_main + 0xf5
16 0x4cf10c postgres + 0x4cf10c

segment日志：
2021-10-29 03:48:27.260225 EDT,“gpadmin”,“sdvhdb”,p24502,th876808320,“10.50.176.149”,“20726”,2021-10-29 03:48:26 EDT,0,con119328,cmd12,seg0,slice1,dx1086249,sx1,“ERROR”,“XX000”,“tupdesc ref
erence 0x299b388 is not owned by resource owner Portal (resowner.c:1099)”,“SELECT SUM( CASE kc24.aka130 WHEN ‘14’ THEN kc24.ake038 END ) AS y,
kc24.akb020,COUNT ()
FROM
hspvhmiddata.pa_kc24 kc24
WHERE
kc24.akc194 >= ‘2021-01-01’
AND kc24.akc194 <= ‘2021-01-31’
GROUP BY
kc24.akb020
HAVING count() > 0”,0,“resowner.c”,1099,"Stack trace:
1 0x9f390c postgres errstart (elog.c:558)
2 0x9f6ab8 postgres elog_finish (elog.c:1730)
3 0xa34596 postgres (resowner.c:1098)
4 0x4d806b postgres DecrTupleDescRefCount (tupdesc.c:338)
5 0x6e23e5 postgres ExecAgg (nodeAgg.c:2849)
6 0x6c8ee8 postgres ExecProcNode (execProcnode.c:1093)
7 0x6f5335 postgres ExecResult (tuptable.h:159)
8 0x6c8d98 postgres ExecProcNode (execProcnode.c:970)
9 0x707100 postgres ExecMotion (tuptable.h:159)
10 0x6c8e78 postgres ExecProcNode (execProcnode.c:1121)
11 0x6c0309 postgres (tuptable.h:159)
12 0x6c1033 postgres standard_ExecutorRun (execMain.c:951)
13 0x88f7b7 postgres (pquery.c:1152)
14 0x8917a1 postgres PortalRun (pquery.c:999)
15 0x889b9e postgres (postgres.c:1377)
16 0x88e7d9 postgres PostgresMain (postgres.c:5361)
17 0x4cc2b0 postgres (postmaster.c:4464)
18 0x815f16 postgres PostmasterMain (postmaster.c:1520)
19 0x4ceb31 postgres main (main.c:205)
20 0x7f482fd9f3d5 libc.so.6 __libc_start_main + 0xf5
21 0x4cf10c postgres + 0x4cf10c
"
2021-10-29 03:48:27.260589 EDT,“gpadmin”,“sdvhdb”,p24502,th876808320,“10.50.176.149”,“20726”,2021-10-29 03:48:26 EDT,0,con119328,cmd12,seg0,slice1,dx1086249,sx1,“LOG”,“00000”,“An exception
was encountered during the execution of statement: SELECT SUM( CASE kc24.aka130 WHEN ‘14’ THEN kc24.ake038 END ) AS y,
kc24.akb020,COUNT ()
FROM
hspvhmiddata.pa_kc24 kc24
WHERE
kc24.akc194 >= ‘2021-01-01’
AND kc24.akc194 <= ‘2021-01-31’
GROUP BY
kc24.akb020
HAVING count() > 0”,0,

3.根本原因： 经查询，疑似greenplum bug，官网论坛建议升级解决。

4.解决方案： 将gp数据库小版本升级到官方最新版本，过程如下
1)检查集群状态、停数据库、对主节点数据节点数据冷备份
[gpadmin@gpmaster ~]$ gpstate -a
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-Starting gpstate with args: -a
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-local Greenplum Version: ‘postgres (Greenplum Database) 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93’
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-master Greenplum Version: ‘PostgreSQL 9.4.24 (Greenplum Database 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jan 13 2020 22:04:43’
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-Obtaining Segment details from master…
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-Gathering data from segments…
…
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-Greenplum instance status summary
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Master instance = Active
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Master standby = No master standby configured
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total segment instance count from metadata = 8
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Primary Segment Status
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total primary segments = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total primary segment valid (at master) = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Mirror Segment Status
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total mirror segments = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total mirror segment valid (at master) = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total mirror segment failures (at master) = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number mirror segments acting as primary segments = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number mirror segments acting as mirror segments = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@gpmaster ~]$ gpstate -m
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-Starting gpstate with args: -m
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-local Greenplum Version: ‘postgres (Greenplum Database) 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93’
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-master Greenplum Version: ‘PostgreSQL 9.4.24 (Greenplum Database 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jan 13 2020 22:04:43’
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-Obtaining Segment details from master…
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:--------------------------------------------------------------
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:–Current GPDB mirror list and status
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:–Type = Group
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:--------------------------------------------------------------
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg02 /paic/greenplum/mirror/gpseg0 7000 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg02 /paic/greenplum/mirror/gpseg1 7001 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg01 /paic/greenplum/mirror/gpseg2 7000 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg01 /paic/greenplum/mirror/gpseg3 7001 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@gpmaster ~]$ gpstop -M fast -a
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Starting gpstop with args: -M fast -a
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Gathering information and validating the environment…
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Obtaining Segment details from master…
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Greenplum Version: ‘postgres (Greenplum Database) 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93’
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=‘fast’
20211101:20:03:46:007794 gpstop:gpmaster:gpadmin-[INFO]:-Master segment instance directory=/paic/greenplum/master/gpseg-1
20211101:20:03:50:007794 gpstop:gpmaster:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20211101:20:03:50:007794 gpstop:gpmaster:gpadmin-[INFO]:-Terminating processes for segment /paic/greenplum/master/gpseg-1
20211101:20:03:50:007794 gpstop:gpmaster:gpadmin-[INFO]:-No standby master host configured
20211101:20:03:50:007794 gpstop:gpmaster:gpadmin-[INFO]:-Targeting dbid [2, 6, 3, 7, 4, 8, 5, 9] for shutdown
20211101:20:03:50:007794 gpstop:gpmaster:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait…
20211101:20:03:50:007794 gpstop:gpmaster:gpadmin-[INFO]:-0.00% of jobs completed
20211101:20:03:54:007794 gpstop:gpmaster:gpadmin-[INFO]:-100.00% of jobs completed
20211101:20:03:54:007794 gpstop:gpmaster:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait…
20211101:20:03:54:007794 gpstop:gpmaster:gpadmin-[INFO]:-0.00% of jobs completed
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-100.00% of jobs completed
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:- Segments stopped successfully = 8
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:- Segments with errors during stop = 0
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-Successfully shutdown 8 of 8 segment instances
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-No leftover gpmmon process found
20211101:20:03:57:007794 gpstop:gpmaster:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20211101:20:03:58:007794 gpstop:gpmaster:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20211101:20:03:58:007794 gpstop:gpmaster:gpadmin-[INFO]:-Cleaning up leftover shared memory
[gpadmin@gpmaster ~]$

主节点对master目录进行冷备份：
[root@gpmaster paic]$ su - gpadmin
[root@gpmaster greenplum]# cd /paic/greenplum
[root@gpmaster greenplum]# cp -r master master_bak111
[root@gpmaster greenplum]# du -sh *
238G master
238G master_bak111
[root@gpmaster greenplum]# chown -R gpadmin:gpadmin master_bak111

数据节点1：确认数据库已经完成停止，对数据目录进行冷备份：
[root@gpseg01 ~]# ps -ef|grep gpadmin
[root@gpseg01 ~]# cd /paic/greenplum
[root@gpseg01 greenplum]# ls
master mirror primary
[root@gpseg01 greenplum]# du -sh *
0 master
986G mirror
986G primary
[root@gpseg01 greenplum]# cp -r primary primary_bak111
[root@gpseg01 greenplum]# du -sh *
0 master
986G mirror
986G primary
986G primary_bak111
[root@gpseg01 greenplum]#chown -R gpadmin:gpadmin primary_bak111

数据节点2：确认数据库已经完成停止，对数据目录进行冷备份：
[root@gpseg02 ~]# ps -ef|grep gpadmin
[root@gpseg02 ~]# cd /paic/greenplum
[root@gpseg02 greenplum]# ls
master mirror primary
[root@gpseg02 greenplum]# du -sh *
0 master
986G mirror
986G primary
[root@gpseg02 greenplum]# cp -r primary primary_bak111
[root@gpseg02 greenplum]# du -sh *
0 master
986G mirror
986G primary
986G primary_bak111
[root@gpseg02 greenplum]#chown -R gpadmin:gpadmin primary_bak111

2)升级gp程序
主节点；直接安装gp小版本程序，会替换低版本
[root@gpmaster allInstall]# yum install open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm: open-source-greenplum-db-6-6.17.1-1.el7.x86_64
Marking open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package greenplum-db.x86_64 0:6.3.0-1.el7 will be obsoleted
—> Package open-source-greenplum-db-6.x86_64 0:6.17.1-1.el7 will be obsoleting
–> Finished Dependency Resolution
c7-media | 3.6 kB 00:00:00

Dependencies Resolved

=================================================================================================================================================================================================================
Package Arch Version Repository Size

Installing:
open-source-greenplum-db-6 x86_64 6.17.1-1.el7 /open-source-greenplum-db-6.17.1-rhel7-x86_64 313 M
replacing greenplum-db.x86_64 6.3.0-1.el7

Transaction Summary

Install 1 Package

Total size: 313 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : open-source-greenplum-db-6-6.17.1-1.el7.x86_64 1/2
Erasing : greenplum-db-6.3.0-1.el7.x86_64 2/2
Verifying : open-source-greenplum-db-6-6.17.1-1.el7.x86_64 1/2
Verifying : greenplum-db-6.3.0-1.el7.x86_64 2/2

Installed:
open-source-greenplum-db-6.x86_64 0:6.17.1-1.el7

Replaced:
greenplum-db.x86_64 0:6.3.0-1.el7

Complete!
[root@gpmaster allInstall]# cd /usr/local
[root@gpmaster local]# ls -la|grep greenplum
lrwxrwxrwx. 1 root root 30 Aug 11 19:16 greenplum-db -> /usr/local/greenplum-db-6.17.1
drwxr-xr-x. 11 root root 238 Aug 11 19:16 greenplum-db-6.17.1
[root@gpmaster local]# chown -R gpadmin:gpadmin greenplum-db*
[root@gpmaster local]# ls -la|grep greenplum
lrwxrwxrwx. 1 gpadmin gpadmin 30 Aug 11 19:16 greenplum-db -> /usr/local/greenplum-db-6.17.1
drwxr-xr-x. 11 gpadmin gpadmin 238 Aug 11 19:16 greenplum-db-6.17.1
[root@gpmaster gpseg-1]# su - gpadmin
Last login: Wed Aug 11 18:46:39 CST 2021 from gpseg01 on pts/36
[gpadmin@gpmaster ~]$ psql -V
psql (PostgreSQL) 9.4.24
[gpadmin@gpmaster ~]$ env|grep PATH
LD_LIBRARY_PATH=/usr/local/greenplum-db-6.17.1/lib:/usr/local/greenplum-db-6.17.1/ext/python/lib:/usr/local/greenplum-db-6.17.1/lib:/usr/local/greenplum-db-6.17.1/ext/python/lib
in:/usr/sbin:/home/gpadmin/.local/bin:/home/gpadmin/bin
PYTHONPATH=/usr/local/greenplum-db-6.17.1/lib/python

数据节点1：直接安装gp小版本程序，会替换低版本
[root@gpseg01 allInstall]# yum install open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm: open-source-greenplum-db-6-6.17.1-1.el7.x86_64
Marking open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package greenplum-db.x86_64 0:6.3.0-1.el7 will be obsoleted
—> Package open-source-greenplum-db-6.x86_64 0:6.17.1-1.el7 will be obsoleting
–> Finished Dependency Resolution
c7-media | 3.6 kB 00:00:00

Dependencies Resolved

=================================================================================================================================================================================================================
Package Arch Version Repository Size

Installing:
open-source-greenplum-db-6 x86_64 6.17.1-1.el7 /open-source-greenplum-db-6.17.1-rhel7-x86_64 313 M
replacing greenplum-db.x86_64 6.3.0-1.el7

Transaction Summary

Install 1 Package

Total size: 313 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : open-source-greenplum-db-6-6.17.1-1.el7.x86_64 1/2
Erasing : greenplum-db-6.3.0-1.el7.x86_64 2/2
Verifying : open-source-greenplum-db-6-6.17.1-1.el7.x86_64 1/2
Verifying : greenplum-db-6.3.0-1.el7.x86_64 2/2

Installed:
open-source-greenplum-db-6.x86_64 0:6.17.1-1.el7

Replaced:
greenplum-db.x86_64 0:6.3.0-1.el7

Complete!
[root@gpseg01 allInstall]# cd /usr/local
[root@gpseg01 local]# ls -la|grep greenplum
lrwxrwxrwx. 1 root root 30 Aug 11 19:13 greenplum-db -> /usr/local/greenplum-db-6.17.1
drwxr-xr-x. 11 root root 238 Aug 11 19:13 greenplum-db-6.17.1
[root@gpseg01 local]# chown -R gpadmin:gpadmin greenplum-db*
[root@gpseg01 local]# ls -la|grep greenplum
lrwxrwxrwx. 1 gpadmin gpadmin 30 Aug 11 19:13 greenplum-db -> /usr/local/greenplum-db-6.17.1
drwxr-xr-x. 11 gpadmin gpadmin 238 Aug 11 19:13 greenplum-db-6.17.1
[root@gpseg01 local]# su - gpadmin
Last login: Wed Aug 11 18:43:18 CST 2021 on pts/0
[gpadmin@gpseg01 ~]$ psql -V
psql (PostgreSQL) 9.4.24

数据节点2升级GP程序：
[root@gpseg02 allInstall]# yum install open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm: open-source-greenplum-db-6-6.17.1-1.el7.x86_64
Marking open-source-greenplum-db-6.17.1-rhel7-x86_64.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package greenplum-db.x86_64 0:6.3.0-1.el7 will be obsoleted
—> Package open-source-greenplum-db-6.x86_64 0:6.17.1-1.el7 will be obsoleting
–> Finished Dependency Resolution
c7-media | 3.6 kB 00:00:00

Dependencies Resolved

=================================================================================================================================================================================================================
Package Arch Version Repository Size

Installing:
open-source-greenplum-db-6 x86_64 6.17.1-1.el7 /open-source-greenplum-db-6.17.1-rhel7-x86_64 313 M
replacing greenplum-db.x86_64 6.3.0-1.el7

Transaction Summary

Install 1 Package

Total size: 313 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : open-source-greenplum-db-6-6.17.1-1.el7.x86_64 1/2
Erasing : greenplum-db-6.3.0-1.el7.x86_64 2/2
Verifying : open-source-greenplum-db-6-6.17.1-1.el7.x86_64 1/2
Verifying : greenplum-db-6.3.0-1.el7.x86_64 2/2

Installed:
open-source-greenplum-db-6.x86_64 0:6.17.1-1.el7

Replaced:
greenplum-db.x86_64 0:6.3.0-1.el7

Complete!
[root@gpseg02 allInstall]# cd /usr/local
[root@gpseg02 local]# ls -lat|grep greenplum
drwxr-xr-x. 11 root root 238 Aug 11 19:07 greenplum-db-6.17.1
lrwxrwxrwx. 1 root root 30 Aug 11 19:07 greenplum-db -> /usr/local/greenplum-db-6.17.1
[root@gpseg02 local]# chown -R gpadmin:gpadmin greenplum-db*
[root@gpseg02 local]# ls -lat|grep greenplum
drwxr-xr-x. 11 gpadmin gpadmin 238 Aug 11 19:07 greenplum-db-6.17.1
lrwxrwxrwx. 1 gpadmin gpadmin 30 Aug 11 19:07 greenplum-db -> /usr/local/greenplum-db-6.17.1
[root@gpseg02 local]# su - gpadmin
Last login: Wed Aug 11 19:04:44 CST 2021 on pts/0
[gpadmin@gpseg02 ~]$ psql-V
bash: psql-V: command not found…
[gpadmin@gpseg02 ~]$ psql -V
psql (PostgreSQL) 9.4.24

3)用升级后的程序启动数据库并检查集群状态和访问数据
[gpadmin@gpmaster ~]$ gpstate -a
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-Starting gpstate with args: -a
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-local Greenplum Version: ‘postgres (Greenplum Database) 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93’
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-master Greenplum Version: ‘PostgreSQL 9.4.24 (Greenplum Database 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jan 13 2020 22:04:43’
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-Obtaining Segment details from master…
20211101:22:37:42:000303 gpstate:gpmaster:gpadmin-[INFO]:-Gathering data from segments…
…
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-Greenplum instance status summary
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Master instance = Active
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Master standby = No master standby configured
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total segment instance count from metadata = 8
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Primary Segment Status
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total primary segments = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total primary segment valid (at master) = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Mirror Segment Status
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total mirror segments = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total mirror segment valid (at master) = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total mirror segment failures (at master) = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number postmaster processes found = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number mirror segments acting as primary segments = 0
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:- Total number mirror segments acting as mirror segments = 4
20211101:22:37:44:000303 gpstate:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@gpmaster ~]$ gpstate -m
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-Starting gpstate with args: -m
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-local Greenplum Version: ‘postgres (Greenplum Database) 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93’
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-master Greenplum Version: ‘PostgreSQL 9.4.24 (Greenplum Database 6.3.0 build commit:77aa1b6e4486adbaede9f5f2864a04fc3a512e93) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jan 13 2020 22:04:43’
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:-Obtaining Segment details from master…
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:--------------------------------------------------------------
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:–Current GPDB mirror list and status
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:–Type = Group
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:--------------------------------------------------------------
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg02 /paic/greenplum/mirror/gpseg0 7000 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg02 /paic/greenplum/mirror/gpseg1 7001 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg01 /paic/greenplum/mirror/gpseg2 7000 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:- gpseg01 /paic/greenplum/mirror/gpseg3 7001 Passive Synchronized
20211101:22:38:28:000522 gpstate:gpmaster:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@gpmaster paic]$
[gpadmin@gpmaster paic]$
[gpadmin@gpmaster paic]$ psql
psql (9.4.24)
Type “help” for help.

postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------------------±--------±---------±-----------±-----------±--------------------
BIZMNIT_ADB_SCREEN_DB | hgjc | UTF8 | en_US.utf8 | en_US.utf8 |
MACRODCS_ADB_DB | hgjc | UTF8 | en_US.utf8 | en_US.utf8 |
postgres | gpadmin | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | gpadmin | UTF8 | en_US.utf8 | en_US.utf8 | =c/gpadmin +
| | | | | gpadmin=CTc/gpadmin
template1 | gpadmin | UTF8 | en_US.utf8 | en_US.utf8 | =c/gpadmin +
| | | | | gpadmin=CTc/gpadmin
(5 rows)

postgres=# select version();
version

–
PostgreSQL 9.4.24 (Greenplum Database 6.17.1 build commit:3633e368b674f35eb9609717eed42569ab138858 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jul 23 2021 01:38:1
8
(1 row)

5.参考引用：
https://github.com/greenplum-db/gpdb/issues/12764

Alex@12
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Greenplum【部署 05】GP最新版本v6.20.3安装配置验证（内核参数+初始化参数说明）
Java与大数据相关实践内容分享！
04-22 1531
Greenplum【环境搭建 05】GP最新版本v6.20.3配置安装验证（内核参数+初始化参数说明）
greenplum-7.0.0 版本包
04-27
版本包
Greenplum数据库（一）Greenplum简介及安装
热门推荐
08-29 1万+
Greenplum6.20超详细安装教程
Greenplum【部署 08】数据库小版本升级流程及问题处理 Error open-source-greenplum-db-6 conflicts with_greenplum小版本升级(1)
最新发布
m0_54903333的博客
05-16 303
对于从来没有接触过网络安全的同学，我们帮你准备了详细的学习成长路线图。可以说是最科学最系统的学习路线，大家跟着这个大的方向学习准没问题。项目数据库要从 MySQL 切换到 Greenplum 问题最多的就是 SQL 语法不同，MySQL有。非常强大，支持合并写入（当违反某唯一约束时，冲突则更新，不冲突则写入），同时支持流式计算。PostgreSQL 9.5 引入了 UPSET 功能，其语法。实现冲突更新，Greenplum却没有。因篇幅有限，仅展示部分资料。
GreenPlum版本升级
IT邦德
06-10 3669
Greenplum版本升级的详细过程，此博客做了详细的介绍。
Greenplum【部署 08】数据库小版本升级流程及问题处理 Error: open-source-greenplum-db-6 conflicts with
Java与大数据相关实践内容分享！
07-26 661
Greenplum【部署 08】数据库小版本升级流程及问题处理 Error: open-source-greenplum-db-6 conflicts with
greenplum 升级greenplum-db-6.1.0 ＞ greenplum-db-6.15.0超详细
network_mitong的博客
08-08 525
目录 前言 一、pandas是什么？ 二、使用步骤 1.引入库 2.读入数据 总结 前言 升级时间：2021/08/08 此次升级内容：greenplum-db-6.1.0 > greenplum-db-6.15.0 默认安装目录：/usr/local 安装包存放路径：/root/ 服务器数量：10台，1台master、1台standby、8台节点 升级包：greenplum-db-6.15.0-rhel7-x86_64.rpm 关注微信公众号“仗剑闯天下...
Greenplum 最新版本6.20.3已正式发布
PostgreSQL China
04-18 1465
引言 自Greenplum 6.0正式版发布以来，一直保持每月一个小版本的迭代速率，持续为用户提供新功能和修复补丁，目前的最新版 6.20.3 已于2022年4月8日发布。此外，Greenplum众多商业组件也在不断迭代，致力于为用户提供更加完善的产品功能和更加舒适的用户体验。现在让我们通过本文概览一下Greenplum内核及其重要组件的最新资讯。 青梅资讯 内核更新 Greenplum 内核基于 PostgreSQL ，并针对大数据场景和用户需求开发了众多优秀特性并作了极致优化。随着G..
教您正确使用最新版本的Greenplum 官方监控工具（GPCC）
weixin_33957382的博客
01-31 995
Greenplum Command Center，或者简称GPCC，是Greenplum原生的图形化运维管理工具。在最近3年来的开发中，基于全新的界面和用户体验，陆续推出了监控、历史数据、管理的功能，在众多商业用户上得到了广泛的应用和认可。 随着Greenplum 6.0的发布，Greenplum Command Center(也称为GPCC)也在新的版本中抵达了一个新的里程碑。我们跳过...
Greenplum6.2.1版本安装包(RPM)版
04-07
标签中的"GreenPlum6.2.1 GP6+版本 GP6.2.1安装包"强调了这是Greenplum 6系列的版本，6.2.1是其中的一个稳定版本，具备了GP6+版本的所有特性和优化。GP6+版本相比早期版本，提升了性能，增强了安全性，并引入了更多...
Greenplum清除mirror
12-03
在Greenplum数据库管理系统中，"Greenplum清除mirror"是指移除镜像段（mirror ...同时，根据实际的Greenplum版本和集群配置，可能需要调整或添加额外的步骤。在进行任何重大操作前，总是建议先在测试环境中演练。
greenplum客户端工具
06-04
- **兼容性**：确保升级工具与当前运行的Greenplum版本兼容，不兼容可能会引发问题。 - **监控日志**：升级过程中密切关注日志输出，以便及时发现和解决问题。 - **安全更新**：定期升级不仅为了获取新功能，也是...
2024 年 5 个关键网络安全趋势(3)，网络安全系统工程师面试
2401_83945851的博客
04-14 714
在实际的渗透测试过程中，面对复杂多变的网络环境，当常用工具不能满足实际需求的时候，往往需要对现有工具进行扩展，或者编写符合我们要求的工具、自动化脚本，这个时候就需要具备一定的编程能力。就在去年夏天，威胁行为者使用名为TeamsPhisher的恶意开源程序，通过 Microsoft Teams 向毫无戒心的用户发送网络钓鱼诱饵，以实施后续网络攻击，包括勒索软件攻击。到 2023 年，深度造假活动将惊人地增长3000%，这种复杂的技术被用来创建与合法邮件几乎无法区分的通信，同时还具有更便宜、更易于使用的优点。
Greenplum 6 一键升级脚本
wzy0623的专栏
10-17 245
cat .bashrc # .bashrc # Source global definitions if [ -f /etc/bashrc ]; then . /etc/bashrc fi # Uncomment the following line if you don't like systemctl's auto-paging feature: # export SYSTEMD_PAGER= # User specific aliases and functions source /u.
Greenplum csvlog(日志数据)检索、释义(gp_toolkit.gp_log*) ...
weixin_34132768的博客
04-14 693
标签 PostgreSQL , Greenplum , csvlog , gp_toolkit 背景 由于GP为分布式数据库，当查看它的一些日志时，如果到服务器上查看，会非常的繁琐，而且不好排查问题。 例如这是某个节点的日志 2018-08-23 15:34:30.004070 CST,"digoal","postgres",p12775,th-17...
Greenplum数据库故障分析——版本升级后gpstart -a为何返回失败
肥叔菌的博客
08-04 621
从上面日志可以看出在升级前HA组件在修复standbymaster，gpinitstandby运行到从master数据目录拷贝数据到standbymaster时，升级脚本关闭了greenplum集群，导致的失败。现场项目进行Greenplum数据库小版本升级时，升级脚本报错，提示数据库启动失败。在升级前HA组件在修复standbymaster，gpinitstandby运行到从master数据目录拷贝数据到standbymaster时，升级脚本关闭了greenplum集群，导致的失败。...
【青梅快讯】惊喜不断，Greenplum 最新版本 6.13.0已发布
Greenplum中文社区
01-05 1006
...
Chapter 15 PL/Python 语言扩展
kygoal的博客
12-24 1930
Chapter 15 PL/Python 语言扩展 This sectioncontains an overview of the Greenplum Database PL/Python Language. •    About Greenplum PL/Python •    Enabling and Removing PL/Python support •    Developin
Greenplum生态系统与工具概览
其生态发展与PostgreSQL的内核升级紧密相关，从最初的8.2版本逐渐升级到9.4，预示着Greenplum在性能和功能上的不断提升。Greenplum中文社区自2018年成立以来，致力于在中国推广和维护Greenplum的生态环境，为用户和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值