Updated on 2023-12-22 GMT+08:00

GAUSS-02061 -- GAUSS-02070

GAUSS-02061: "could not send data to WAL stream: %s"

SQLSTATE: XX000

Description: During data replication between the primary and standby server, the standby server detects errors when sending data. Resolve the problem based on the "%s" error message.

Solution:"1. If the network connection times out, adjust the current network environment. If the primary server is overloaded, adjust services. 2. If the primary server is shut down unexpectedly, identify the cause. "

GAUSS-02062: "sockaddr is NULL, because there is no connection to primary"

SQLSTATE: XX000

Description: The socketaddr is empty. As a result, connection between the primary and standby servers fails.

Solution: Check the logs of the primary and standby server to determine the cause for abnormal disconnection of the socket.

GAUSS-02063: "cannot continue Data streaming, recovery has already ended"

SQLSTATE: XX000

Description: Restoration of the current instance has been terminated. Data replication does not need to be continued.

Solution:"1. It is normal to report the error message. 2. Ensure that the standby instance is upgraded to a primary instance at a right time. "

GAUSS-02064: "writing incorrect data page checksum at: rnode[%u,%u,%u], blocknum[%u], pageoffset[%u], size[%u], queueoffset[%u/%u]"

SQLSTATE: XX000

Description: A data page CRC received by the standby server from the primary server fails to be verified.

Solution: Check whether the network environment is normal or whether a packet is lost.

GAUSS-02065: "invalid tablespace link %s: %m"

SQLSTATE: XX000

Description: Invalid symbol links exist under the pg_tblspc directory of the standby server.

Solution: Check whether the error is caused by malicious operation. If it is, recover the environment. Alternatively, fix the standby instance. technical support

GAUSS-02066: "invalid tablespace directory %s: %m"

SQLSTATE: 42809

Description: Links under the pg_tblspc directory are navigated to invalid directories.

Solution: Check whether the error is caused by malicious operation. If it is, recover the environment. Alternatively, fix the standby instance. technical support

GAUSS-02067: "'database %u/%u' invalid directory : %m"

SQLSTATE: XX000

Description: The data directory is invalid.

Solution: Check whether the error is caused by malicious operation. If it is, recover the environment. Alternatively, fix the standby instance. technical support

GAUSS-02068: "'database %u/%u' exists but is not a directory"

SQLSTATE: 42809

Description: The tablespace directories under the pg_tblspc file of the standby server are non-directory files.

Solution: Check whether the error is caused by malicious operation. If it is, recover the environment. Alternatively, fix the standby instance. technical support

GAUSS-02069: "could not find type OID for relation %u"

SQLSTATE: XX000

Description: Failed to find the required relation.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-02070: "unrecognized list node type: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.