MogDB
Ecological Tools
Doc Menu

GAUSS-04401 – GAUSS-04500


GAUSS-04401 – GAUSS-04410


GAUSS-04401: "The local index %u on the partition %u not exist."

SQLSTATE: 42704

Description: When partitions and indexes are concurrently dropped, an index dropped with a partition may not exist when drop index is executed.

Solution: Adjust concurrency control.

GAUSS-04403: "Can only access temp objects of the current session."

SQLSTATE: 0A000

Description: Accessing temporary objects in other sessions is not allowed.

Solution: Access only the temporary objects in the local session.

GAUSS-04404: "cache lookup failed for role %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04405: "temp relation is invalid because of cluster resizing"

SQLSTATE: 0A000

Description: The original temporary table becomes invalid after scale-out or scale-in.

Solution:

  1. Exit the current session, reconnect to the session, and create a temporary table.
  2. Use DROP SCHEMA *%s* and *%s* CASCADE to delete the temporary schema and recreate a temporary table.

GAUSS-04407: "Not allowed to insert into relation pg_auth_history."

SQLSTATE: XX000

Description:pg_auth_history is used to audit username and password changes. Related changes are recorded only when the username and password in pg_authid are changed. Any changes on the record will affect the auditing.

Solution: Do not use the INSERT INTO statement to insert records into pg_auth_history.

GAUSS-04408: "do not support create non-temp table like temp table"

SQLSTATE: 0A000

Description: When a common table is created, the LIKE temporary table syntax is used. This method is not supported.

Solution: Do not use the LIKE temporary table syntax to create a non-temporary table. If you want to use it, specify the to-be-created table as a temporary table.


GAUSS-04411 – GAUSS-04420


GAUSS-04411: "Multi-column combined informational constraint is forbidden."

SQLSTATE: 0A000

Description: Information constraints on a combination of multiple columns are not supported.

Solution: Establish information constraints in a column.

GAUSS-04414: "The number of %s distribute key can not exceed 1"

SQLSTATE: 42601

Description: A non-hash table cannot have multiple distribution columns.

Solution: Modify the table creation statement and specify one column as the distribution column.

GAUSS-04415: "Compatibility args %s is invalid\n"

SQLSTATE: 22023

Description: The specified compatibility line parameter is incorrect.

Solution: Specify the parameter to be ORA or TD.

GAUSS-04417: "Alias '%s' reference with window function included is not supported."

SQLSTATE: 42703

Description: During alias reference, the referenced expression cannot contain window functions.

Solution: Modify the SQL statement.

GAUSS-04418: "Alias '%s' reference with volatile function included is not supported."

SQLSTATE: 42703

Description: During alias reference, the referenced expression cannot contain volatile functions.

Solution: Modify the SQL statement.

GAUSS-04419: "Alias '%s' is ambiguous."

SQLSTATE: 42703

Description: The alias has been used.

Solution: Change the alias.


GAUSS-04421 – GAUSS-04430


GAUSS-04422: "%u/%u/%u invalid bcm meta buffer %u"

SQLSTATE: XX000

Description: The meta page of the BCM file is invalid.

Solution:Contact technical support.

GAUSS-04424: "Vector aggregation does not support this distinct clause in aggregate function"

SQLSTATE: XX000

Description: When the aggregation vectorized executor is initialized, the aggregate function does not support the distinct clause.

Solution:Contact technical support.

GAUSS-04425: "Grant not supported for TEMP and non-TEMP objects together"

SQLSTATE: 0A000

Description: The grant operation does not support temporary and non-temporary objects at the same time.

Solution: Split the statement to be executed into two statements to separately execute temporary and non-temporary objects.

GAUSS-04426: "Explicit prepare transaction is not supported."

SQLSTATE: 0A000

Description: Explicit PREPARE is not supported. This error occurs because you entered explicit PREPARE statement.

Solution: Do not enter an explicit PREPARE statement.

GAUSS-04427: "Explicit commit prepared transaction is not supported."

SQLSTATE: 0A000

Description: Explicit COMMIT PREPARED is not supported. This error occurs because you entered explicit COMMIT PREPARED statement.

Solution: Do not enter an explicit COMMIT PREPARED statement.

GAUSS-04428: "Explicit rollback prepared transaction is not supported."

SQLSTATE: 0A000

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04429: "LOCK not supported for TEMP and non-TEMP objects together"

SQLSTATE: 0A000

Description: The lock operation does not support temporary and non-temporary objects at the same time.

Solution: Split the statement to be executed into two statements to separately execute temporary and non-temporary objects.


GAUSS-04431 – GAUSS-04440


GAUSS-04432: "invalid set size for BipartiteMatch"

SQLSTATE: XX000

Description: Internal system error. The input parameter is invalid.

Solution:Contact technical support.

GAUSS-04433: "AIO Completer io_getevents() failed: error %d ."

SQLSTATE: XX000

Description: Failed to execute the OS function io_getevents().

Solution: Check whether the OS kernel function is greater than Linux 2.6.23 and whether the OS installed the libaio library.

GAUSS-04434: "parent of GROUPING is not VecAgg node"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04435: "parent of GROUPINGID is not VecAgg node"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04436: "Unsupported alternative subPlan expression in vector engine"

SQLSTATE: 0A000

Description: The alternative expression is not vectorized.

Solution: Modify the SQL statement.

GAUSS-04437: "Unsupported rowexpr expression in vector engine"

SQLSTATE: 0A000

Description: The rowexpr expression is not vectorized.

Solution: Modify the SQL statement.

GAUSS-04438: "unsupported vector sub plan type %d"

SQLSTATE: XX000

Description: An error is reported because the subplan type is not supported by the vectorized engine.

Solution: Modify the SQL statement.

GAUSS-04439: "Unsupported state in vec sort agg"

SQLSTATE: 20000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04440: "Failed to connect hdfs."

SQLSTATE: XX000

Description: Failed to connect to HDFS.

Solution: Check CN logs and find out the cause of the error.


GAUSS-04441 – GAUSS-04450


GAUSS-04441: "Unsupport store format, only support ORC format for DFS table."

SQLSTATE: XX000

Description: Internal system error. The data format of the HDFS table is not ORC.

Solution: Modify the data format.

GAUSS-04442: "'INSERT' is not supported by the type of relation."

SQLSTATE: D0011

Description: This table does not support the insert operation.

Solution:Contact technical support.

GAUSS-04443: "'DELETE' is not supported by the type of relation."

SQLSTATE: D0011

Description: This table does not support the delete operation.

Solution:Contact technical support.

GAUSS-04444: "'UPDATE' is not supported by the type of relation."

SQLSTATE: D0011

Description: This table does not support the update operation.

Solution:Contact technical support.

GAUSS-04449: "parent of GROUPING is not Agg node"

SQLSTATE: 42P27

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04450: "parent of GROUPINGID is not Agg node"

SQLSTATE: 42P27

Description:Internal system error.

Solution:Contact technical support.


GAUSS-04461 – GAUSS-04470


GAUSS-04468: "corrupt during reset shared hash table '%s'"

SQLSTATE: XX000

Description: The memory crashes when the hash table is reset.

Solution: Restart the server.

GAUSS-04469: "terminating SyncLocalXactsWithGTM process due to administrator command"

SQLSTATE: 57P01

Description: The primary server is demoted to standby or SyncLocalXactsWithGTM is stopped as the system exits.

Solution: No action is required.


GAUSS-04471 – GAUSS-04480


GAUSS-04471: "fallocate(fd=%d, amount=%d, offset=%ld),write count(%d), errno(%d), maybe you use adio without XFS filesystem, if you really want do this,please turn off GUC parameter enable_fast_allocate"

SQLSTATE: XX000

Description: Failed to quickly distribute the data file block.

Solution: Check whether the file system is XFS. If not, disable the enable_fast_allocate configuration item.

GAUSS-04472: "FileAsyncRead, file access failed %d"

SQLSTATE: XX000

Description: The abnormal file is detected in asynchronization I/O mode before the server reads the data file.

Solution: Ensure that the data file is normal. If it is abnormal, restore the data from the standby server or the backup data.

GAUSS-04474: "FileAsyncWrite, file access failed %d"

SQLSTATE: XX000

Description: The file is abnormal before the data file is written in asynchronization I/O mode.

Solution: Ensure that the data file is normal. If it is abnormal, restore the data from the standby server or the backup data.

GAUSS-04476: "FileAccess() FAILED %d"

SQLSTATE: XX000

Description: The file is abnormal before the data file is read and written in asynchronization I/O mode.

Solution: Ensure that the data file is normal. If it is abnormal, restore the data from the standby server or the backup data.

GAUSS-04479: "fallocate(fd=%d, amount=%u, offset=%u),write count(%d), errno(%d), maybe you use adio without XFS filesystem, if you really want do this,please turn off GUC parameter enable_fast_allocate"

SQLSTATE: XX000

Description: Internal system error.

Solution:Contact technical support.


GAUSS-04481 – GAUSS-04490


GAUSS-04481: "Require scratch buflist to reorder writes."

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04483: "CheckIOState, find an error in async write"

SQLSTATE: XX000

Description: An I/O write error occurs in the VACUUM FULL row-store table.

Solution: Check whether the disk is faulty or needs to be updated. Then, write again.

GAUSS-04484: "InProgressBuf not null: id %d flags %u, buf: id %d flags %u"

SQLSTATE: None

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04485: "posix_memalign fails, The alignment argument was not a power of two, or was not a multiple of sizeof(void *)"

SQLSTATE: XX000

Description: Internal system error. The memory of the OS is insufficient, the value of the memory alignment parameter is not the nth power of 2, or the pointer parameter is abnormal.

Solution: After the OS releases part of memory, allocate the memory again.


GAUSS-04491 – GAUSS-04500


GAUSS-04492: "redundant options."

SQLSTATE: XX000

Description: The option is redundant.

Solution: Do not set values for redundant options.

GAUSS-04494: "max_dop value can't be %ld."

SQLSTATE: 22003

Description: The value of max_dop is invalid.

Solution: Set max_dop to a value greater than or equal to 1.

GAUSS-04495: "invalid value '%s' for parameter '%s'"

SQLSTATE: 22023

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04496: "memory_limit size value can't be %d."

SQLSTATE: 22003

Description: The value of memory_limit is invalid.

Solution: Set the value of memory_limit to a positive number.