检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Data migration dataMigrationDeleteCluster Normal Start to delete the data migration instance. Data migration dataMigrationDeleteClusterApplication Normal Start to delete the job task. Data migration dataMigrationDeleteClusterApplicationFailed Warning Failed to delete the job.
PGXC_WORKLOAD_SQL_COUNT PGXC_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on all CNs in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
Delete Click Delete in the Operation column of a SQL probe. In the displayed dialog box, enter DELETE or click Auto Enter. Click OK. Parent Topic: Viewing GaussDB(DWS) Cluster Monitoring Information on the Monitoring Panel (DMS)
Precautions The user must have the DROP permission in order to delete a resource pool.
If there are a large number of UPDATE and DELETE operations, select the User tables. If there are a large number of CREATE and DELETE operations, select System catalogs. Click Next: Configure Schedule to configure the schedule and Vacuum type.
GAUSS-00678: "permission denied: '%s' is a system catalog" SQLSTATE: 42501 Description: You have no permission to delete this system catalog. Solution: Do not delete system catalogs.
If command is set to DELETE, only tuple data that meets the condition (the return value of using_expression is TRUE) can be deleted. The operations that are affected include DELETE and DELETE ... RETURNING.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes objects that depend on the affected objects. RESTRICT (default): refuses to delete objects with dependent objects.
Precautions Only the table owner and users granted the gs_redaction_policy preset role have the permission to delete data masking policies.
from view %s. errhint: You need an unconditional ON DELETE DO INSTEAD rule or an INSTEAD OF DELETE trigger. level:ERROR GS_231240003 errmsg:transaction left non-empty SPI stack. errhint: Check for missing \SPI_finish\ calls. level:WARNING GS_231240004 errmsg:subtransaction left non-empty
"vpc:*:get*", "vpc:*:list*", "vpc:*:create*", "vpc:*:delete*", "evs:*:get*", "evs:*:list*", "evs:*:create*", "evs
The owner can use, delete, and manage all resources in the VPC. If principals have resources in the subnet, the owner cannot delete the shared subnet or the VPC where the shared subnet belongs after the share is stopped.
Solution:contact technical support GAUSS-01636: "Unsupport to Update/Delete replication table without PRIMARY KEY" SQLSTATE: XX000 Description: During DELETE or UPDATE execution, the replication table lacks the primary key.
Handling Procedure To clear system tables for cluster versions earlier than 8.0, run DELETE FROM and then VACUUM FULL.
Solution: Delete the current table, rebuild it using CREATE TABLE, and rebuild its physical file.
Solution: Delete the returning lists. GAUSS-03828: "RETURNING lists are not supported in non-INSTEAD rules" SQLSTATE: 0A000 Description: The returning lists are used in the non-INSTEAD rules. Solution: Delete the returning lists.
Click Delete in the Operation column of the target DR task. In the dialog box that is displayed, click OK. The DR status will change to Deleting. You can delete a DR task when DR Status is Creation failed, Not started, Startup failed, Stopped, Stop failed, or Abnormal.
Table 1 List of short keys Teradata Short Key GaussDB(DWS) Syntax SEL SELECT INS INSERT UPD UPDATE DEL DELETE CT CREATE TABLE CV CREATE VIEW BT START TRANSACTION ET COMMIT Input - BT BT; -- delete from ${BRTL_DCOR}.BRTL_CS_CUST_CID_UID_REL where DW_Job_Seq = ${v_Group_No
GAUSS-50313: "Failed to delete %s group." SQLSTATE: None Description: Failed to delete the group. Solution: Check whether the group to be deleted exists. Check whether the cluster status is normal. GAUSS-50314: "Failed to delete %s user."
If they do, delete them and then modify the table. GAUSS-00725: "cannot alter table '%s' because column '%s.%s' uses its row type" SQLSTATE: 0A000 Description: A table cannot be modified if its row type is being used by a column.
