Сбой базы данных Postgres-xc при создании таблицы
Я настроил postgres-xc с gtm, одним главным узлом и двумя узлами данных.
При создании новой базы данных она создается, но при создании таблицы происходит сбой сервера.
postgres=# create database test7;
CREATE DATABASE
postgres=# CREATE TABLE DIST_REP(T INT) DISTRIBUTE BY REPLICATION TO NODE(datanode1,datanode2);
The connection to the server was lost. Attempting reset: Failed.
!>
журналы:
LOG: failed to find proc 0x7f91c21c4b80 in ProcArray
LOG: failed to find proc 0x7f91c21c7980 in ProcArray
STATEMENT: create database test7;
STATEMENT: CREATE TABLE DIST_REP(T INT) DISTRIBUTE BY REPLICATION TO NODE datanode1,datanode2;
LOG: server process (PID 2327) was terminated by signal 11: Segmentation fault
DETAIL: Failed process was running: CREATE TABLE DIST_REP(T INT) DISTRIBUTE BY REPLICATION TO NODE(datanode1,datanode2);
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
LOG: all server processes terminated; reinitializing
FATAL: the database system is in recovery mode
LOG: database system was interrupted; last known up at 2018-10-04 15:28:08 IST
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 0/1820AA8
LOG: record with zero length at 0/1820B98
LOG: redo done at 0/1820B68
LOG: last completed transaction was at log time 2018-10-04 15:32:08.627262+05:30
LOG: database system is ready to accept connections
LOG: autovacuum launcher started