greenplum安装时初始化失败-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文

greenplum安装时初始化失败

alsm_liang 2017-12-22 18:07:54 3012

selecting default max_connections ... initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/d1/gpseg0.initdb" 2>&1
initdb: removing data directory "/data/d1/gpseg0"
initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/d2/gpseg1.initdb" 2>&1
initdb: removing data directory "/data/d2/gpseg1"
initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/d3/gpseg2.initdb" 2>&1
initdb: removing data directory "/data/d3/gpseg2"
initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/d4/gpseg3.initdb" 2>&1
initdb: removing data directory "/data/d4/gpseg3"
2017-12-22 09:49:03.721754 GMT,,,p12111,th1001723712,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:49:04.106441 CST,,,p12111,th1001723712,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7fcb374b4b35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

2017-12-22 09:49:04.085161 GMT,,,p12152,th1037383488,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:49:04.522705 CST,,,p12152,th1037383488,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7fc7396b6b35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

2017-12-22 09:49:04.217425 GMT,,,p12154,th299583296,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:49:04.632536 CST,,,p12154,th299583296,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7f6d0d717b35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

2017-12-22 09:49:04.310192 GMT,,,p12156,th-1470683328,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:49:04.687493 CST,,,p12156,th-1470683328,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7fdba3ed5b35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

20171222:17:49:54:010837 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:54:010837 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:54:010837 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:54:010837 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:54:010837 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/d1/gpseg0
20171222:17:49:54:010910 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:54:010910 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:54:010910 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:54:010910 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:54:010910 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/d2/gpseg1
20171222:17:49:55:011016 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:55:011016 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:55:011016 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:55:011145 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:55:011145 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:55:011016 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:55:011145 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:49:55:011016 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/d3/gpseg2
20171222:17:49:55:011145 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:49:55:011145 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/d4/gpseg3
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_WAIT
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_COUNT
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_SUMMARY_STATUS_REPORT
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Parallel process exit status
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked as completed = 0
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked as killed = 0
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[WARN]:-Total processes marked as failed = 4 <<<<<
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_SUMMARY_STATUS_REPORT
FAILED:gpslaver~40000~/data/d1/gpseg0~2~0~41000
FAILED:gpslaver~40001~/data/d2/gpseg1~3~1~41001
FAILED:gpslaver~40002~/data/d3/gpseg2~4~2~41002
FAILED:gpslaver~40003~/data/d4/gpseg3~5~3~41003
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function CREATE_QES_PRIMARY
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function CREATE_QES_MIRROR
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_SETUP
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_SETUP
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_COUNT
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_COUNT
20171222:17:49:55:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_COUNT
20171222:17:49:56:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_COUNT
20171222:17:49:56:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_COUNT
20171222:17:49:56:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_COUNT
20171222:17:49:56:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_COUNT
20171222:17:49:56:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_WAIT
20171222:17:49:56:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
20171222:17:49:56:013426 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Main
20171222:17:49:56:013426 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Command line options passed to utility = 172.16.0.4
20171222:17:49:56:013501 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Main
20171222:17:49:56:013426 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Function PROCESS_QE
20171222:17:49:56:013501 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Command line options passed to utility = 172.16.0.4
20171222:17:49:56:013426 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Processing segment gpslaver
20171222:17:49:56:013602 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Main
20171222:17:49:56:013501 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Function PROCESS_QE
20171222:17:49:56:013602 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Command line options passed to utility = 172.16.0.4
20171222:17:49:56:013501 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Processing segment gpslaver
20171222:17:49:56:013729 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Main
20171222:17:49:56:013602 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Function PROCESS_QE
20171222:17:49:56:013729 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Command line options passed to utility = 172.16.0.4
20171222:17:49:56:013602 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Processing segment gpslaver
20171222:17:49:56:013729 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Start Function PROCESS_QE
20171222:17:49:56:013729 gpcreateseg.sh:gpmaster:gpadmin-INFO:-Processing segment gpslaver
The files belonging to this database system will be owned by user "gpadmin".
This user must also own the server process.

The database cluster will be initialized with locale en_US.utf8.

creating directory /data/m1/gpseg0 ... ok
creating subdirectories ... ok
selecting default max_connections ... The files belonging to this database system will be owned by user "gpadmin".
This user must also own the server process.

The database cluster will be initialized with locale en_US.utf8.

creating directory /data/m2/gpseg1 ... ok
creating subdirectories ... ok
selecting default max_connections ... initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/m1/gpseg0.initdb" 2>&1
initdb: removing data directory "/data/m1/gpseg0"
The files belonging to this database system will be owned by user "gpadmin".
This user must also own the server process.

The database cluster will be initialized with locale en_US.utf8.

creating directory /data/m3/gpseg2 ... ok
creating subdirectories ... ok
selecting default max_connections ... The files belonging to this database system will be owned by user "gpadmin".
This user must also own the server process.

The database cluster will be initialized with locale en_US.utf8.

creating directory /data/m4/gpseg3 ... ok
creating subdirectories ... ok
selecting default max_connections ... initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/m2/gpseg1.initdb" 2>&1
initdb: removing data directory "/data/m2/gpseg1"
initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/m3/gpseg2.initdb" 2>&1
initdb: removing data directory "/data/m3/gpseg2"
initdb: error 256 from: "/usr/local/greenplum-db/bin/postgres" --boot -x0 -F -c max_connections=750 -c shared_buffers=4000 -c max_fsm_pages=200000 < "/dev/null" > "/data/m4/gpseg3.initdb" 2>&1
initdb: removing data directory "/data/m4/gpseg3"
2017-12-22 09:50:21.833231 GMT,,,p14754,th1479673664,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:50:22.001021 CST,,,p14754,th1479673664,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7f3253c83b35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

2017-12-22 09:50:22.213279 GMT,,,p14783,th334993216,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:50:22.550387 CST,,,p14783,th334993216,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7f390f8dcb35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

2017-12-22 09:50:22.377386 GMT,,,p14801,th1158313792,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:50:22.696515 CST,,,p14801,th1158313792,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7f3440a0ab35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

2017-12-22 09:50:22.438707 GMT,,,p14803,th1319561024,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can not be set by the user and will be ignored.",,,,,,,,"set_config_option","guc.c",9638,
2017-12-22 17:50:22.749967 CST,,,p14803,th1319561024,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create shared memory segment: Cannot allocate memory (pg_shmem.c:183)","Failed system call was shmget(key=1, size=203066560, 03600).","This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 203066560 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4000) and/or its max_connections parameter (currently 750).
The PostgreSQL documentation contains more information about shared memory configuration.",,,,,,"InternalIpcMemoryCreate","pg_shmem.c",183,addr2line: /usr/local/greenplum-db/lib/libz.so.1: no version information available (required by /lib64/libbfd-2.23.52.0.1-55.el7.so)
1 0xb0a52e postgres errstart + 0x4de
2 0x8e0eff postgres PGSharedMemoryCreate + 0x23f
3 0x962294 postgres CreateSharedMemoryAndSemaphores + 0x374
4 0xb1e259 postgres BaseInit + 0x19
5 0x5f848f postgres AuxiliaryProcessMain + 0x30f
6 0x7ff366 postgres main + 0x4a6
7 0x7fa94a3d1b35 libc.so.6 __libc_start_main + 0xf5
8 0x4c4a19 postgres + 0x4c4a19

20171222:17:51:12:013426 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:12:013426 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:12:013426 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:12:013426 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:12:013426 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/m1/gpseg0
20171222:17:51:12:013501 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:12:013501 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:12:013501 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:12:013501 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:12:013501 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/m2/gpseg1
20171222:17:51:13:013602 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:13:013602 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:13:013729 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:13:013602 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:13:013729 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:13:013602 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:13:013729 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:13:013602 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/m3/gpseg2
20171222:17:51:13:013729 gpcreateseg.sh:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND
20171222:17:51:13:013729 gpcreateseg.sh:gpmaster:gpadmin-FATAL:-Failed to start segment instance database gpslaver /data/m4/gpseg3
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_WAIT
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_COUNT
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function PARALLEL_SUMMARY_STATUS_REPORT
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Parallel process exit status
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked as completed = 0
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked as killed = 0
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[WARN]:-Total processes marked as failed = 4 <<<<<
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function PARALLEL_SUMMARY_STATUS_REPORT
FAILED:gpslaver~50000~/data/m1/gpseg0~6~0~51000
FAILED:gpslaver~50001~/data/m2/gpseg1~7~1~51001
FAILED:gpslaver~50002~/data/m3/gpseg2~8~2~51002
FAILED:gpslaver~50003~/data/m4/gpseg3~9~3~51003
20171222:17:51:13:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function CREATE_QES_MIRROR
INSERT 0 1
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[FATAL]:-Errors generated from parallel processes
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Dumped contents of status file to the log file
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Building composite backout file
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function ERROR_EXIT
20171222:17:51:14:gpinitsystem:gpmaster:gpadmin-[FATAL]:-Failures detected, see log file /home/gpadmin/gpAdminLogs/gpinitsystem_20171222.log for more detail Script Exiting!
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[WARN]:-Script has left Greenplum Database in an incomplete state
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[WARN]:-Run command /bin/bash /home/gpadmin/gpAdminLogs/backout_gpinitsystem_gpadmin_20171222_172634 to remove these changes
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-Start Function BACKOUT_COMMAND
20171222:17:51:14:030441 gpinitsystem:gpmaster:gpadmin-[INFO]:-End Function BACKOUT_COMMAND

这是为什么啊?我这个是单机搭建的,没有分布式。

关系型数据库 Shell PostgreSQL
分享到
取消 提交回答
全部回答(2)
  • 窦贤明
    2019-07-17 21:50:01

    主机的semaphore设置不够,调大一点

    0 0
  • alsm_liang
    2019-07-17 21:50:01

    是在自己的虚拟机弄的,单机环境,虚拟机1G内存,更改系统参数是参考网上的资料设置的,是不是这里设置太高了,所以启动不起来?跪求大神教一教怎么改,学习之路很长,希望有人指导。

    0 0
添加回答
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

推荐文章
相似问题
推荐课程