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

GAUSS-01241 -- GAUSS-01250

GAUSS-01241: "row field count is %d, expected %d"

SQLSTATE: 22P04

Description: The number of expected attributes is inconsistent with the actual number.

Solution: 1. The number of attributes returned from the DN to the CN is incorrect, which is an internal error. Contact technical support. 2. The number of attributes in the target table is inconsistent with the number of attributes in the source file to be copied. Check whether the number of columns in the file to be copied is the same as that specified in the table. "

GAUSS-01242: "literal carriage return found in data"

SQLSTATE: 22P04

Description: A carriage return character exists in the copied data.

Solution: Ensure that no carriage return character exists in the copied data.

GAUSS-01243: "literal newline found in data"

SQLSTATE: 22P04

Description: Unrecognized data format exists in the CSV file.

Solution: Ensure that the data format and content meet the constraints.

GAUSS-01244: "end-of-copy marker does not match previous newline style"

SQLSTATE: 22P04

Description: Abnormal characters exist in the file.

Solution: Ensure that the data format in the file is valid. For details, see "Copy" in the SQL Syntax.

GAUSS-01245: "end-of-copy marker corrupt"

SQLSTATE: 22P04

Description: Abnormal characters exist in the file.

Solution: Ensure that the data format in the file is valid. For details, see "Copy" in the SQL Syntax.

GAUSS-01246: "unterminated CSV quoted field"

SQLSTATE: 22P04

Description: Abnormal characters exist in the file.

Solution: Ensure that the data format in the file is valid. For details, see "Copy" in the SQL Syntax.

GAUSS-01247: "unexpected EOF in COPY data"

SQLSTATE: 22P04

Description: The copied file cannot be read.

Solution: Ensure that the data format in the file is valid. For details, see "Copy" in the SQL Syntax.

GAUSS-01248: "invalid field size"

SQLSTATE: 22P04

Description: Invalid data size is detected when the copied file is read.

Solution: Ensure that the data format in the file is valid. For details, see "Copy" in the SQL Syntax.

GAUSS-01249: "incorrect binary data format"

SQLSTATE: 22P03

Description: Incorrect binary data format exists.

Solution: Ensure that the data format in the file is valid. For details, see "Copy" in the SQL Syntax.

GAUSS-01250: "Failed to initialize Datanodes for COPY"

SQLSTATE: 08000

Description: Connections between DNs cannot be initialized for COPY.

Solution: 1. Check whether the cluster status is normal. 2. Check whether the connection between nodes is normal. 3. Check whether the network connection between the current nodes is normal. 4. Ensure that memory resources on all nodes are sufficient, and the OOM problem does not occur.