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

GAUSS-01231 -- GAUSS-01240

GAUSS-01231: "COPY file signature not recognized"

SQLSTATE: 22P04

Description: The signature fails to be recognized during the copy of the data file.

Solution: The data file specified by COPY is damaged. Check the file.

GAUSS-01232: "invalid COPY file header (missing flags)"

SQLSTATE: 22P04

Description: The file header is missing during the copy of the data file.

Solution: The data file specified by COPY is damaged. Check the file.

GAUSS-01233: "unrecognized critical flags in COPY file header"

SQLSTATE: 22P04

Description: The file header fails to be recognized during the copy of the data file.

Solution: The data file specified by COPY is damaged. Check the file.

GAUSS-01234: "invalid COPY file header (missing length)"

SQLSTATE: 22P04

Description: The header length of the file is not long enough during the copy of the data file.

Solution: The data file specified by COPY is damaged. Check the file.

GAUSS-01235: "invalid COPY file header (wrong length)"

SQLSTATE: 22P04

Description: The header format of the file is incorrect during the copy of the data file.

Solution: Ensure that the format of the file header is correct and the file is complete.

GAUSS-01236: "missing data for OID column"

SQLSTATE: 22P04

Description: The value of OID is empty during data copying.

Solution: Ensure that no empty value exists in the first column of the data file.

GAUSS-01237: "null OID in COPY data"

SQLSTATE: 22P04

Description: The value of OID is null during data copying.

Solution: Check the statements for copy and ensure that the OID value of the table to which data needs to be imported is not null.

GAUSS-01238: "invalid OID in COPY data"

SQLSTATE: 22P04

Description: The value of OID of the corresponding data is invalid.

Solution: Ensure that in the statements for copy, the values in attribute columns match the actual data.

GAUSS-01239: "missing data for column '%s'"

SQLSTATE: 22P04

Description: In the COPY statement, the number of columns expected to be imported is greater than the actual number of columns. In this case, no data is available in some columns.

Solution: Ensure that in the statements for copy, the number of columns expected to be imported is consistent with the actual number of columns.

GAUSS-01240: "received copy data after EOF marker"

SQLSTATE: 22P04

Description: Data is obtained after the EOF marker occurs because the marker is not defined in the previous protocol.

Solution: Ensure that the size of data defined in the current protocol does not exceed the expected one.