After connecting to the postgtes database by running gsql, users fail to create a table or a database.
1. Connect to the database and view the following GUC parameter:
2. Run the following command to check the parameter value of all data nodes as user root:
This is a problem of the Red Hat 6.4 and Red Hat 6.5 kernel protocol stacks. Red Hat has fixed this problem in 2.6.32-504 version.
Upgrade the Red Hat to resolve the problem. Alternatively, perform the following operations to handle the problem temporarily:
The rule of the current disk is sequenced in the integer order. Run the echo 1 command according to the integer order, and the path after the execution is /sys/module/sctp/parameters/no_checksums.
su - omm
cm_ctl query -Cvd
The environment CN can be queried.
Parameter description: Switch for switching between the TCP communication library and the SCTP communication library. The setting takes effect after the cluster is restarted.
This parameter is of the POSTMASTER type. Set the parameter by referring to Table 1.
Value range: Boolean type.
If the comm_tcp_mode parameter of the CN is set to on, the DN is connected in TCP mode. If the comm_tcp_mode parameter of the DN is set to on, only the TCP port is listened to and TCP communication is used between the DNs.
If the comm_tcp_mode parameter of the CN is set to off, the DN is connected in the SCTP mode. If the comm_tcp_mode parameter of the DN is set to off, the TCP and SCTP ports are monitored at the same time. The SCTP communication is used between the DNs.
Pay attention to the following:
If the comm_tcp_mode of the CN is set to off and the comm_tcp_mode of the DN is set to on, the cluster communication will be abnormal. You are advised to configure the CN and DN globally and restart the cluster for the settings to take effect.
Default value: off