【问题背景】被锁的truncate和持锁的select语句Topsql都未记录【问题分析】1、参数设置的全部记录执行语句enable_resource_track=onresource_track_cost=20resource_track_duration=1sresource_track_level=query2、日志里面搜索Too many session info in the memory，没有，排除转储慢导致的漏记3、查询select count(*) from pg_stat_get_wlm_realtime_session_info(null);结果显示为0，排除内存中当前为转存topsql的记录4、从日志中看是查询的sql漏记，现场还反馈有个Truncate操作的sql导致了锁等待超时，在topsql查对应sql的时候也是查不到。5、经过测试，锁等待超时（被锁的SQL是truncate，持锁的SQL是select）的也会记录到topsql中【问题根因】1、811版本上，topsql里不记录被锁超时truncate语句，812版本后topsql里会记录，可以在审计日志中查看truncate语句2、持锁select语句不记录，是因为dwmart_bch_b02.t88_sa_mb_user_info是自定义函数的子语句，日志里querry_id显示为0，记录子语句需要开启参数enable_track_record_subsql【说明】enable_track_record_subsql：此版本每个语句都会争抢topsql的锁，再加上子语句，争抢会更多。而且需要写入表里的数据也更多，会对性能有影响。

请在变更前完成checklist检查，详情见附件

一、问题现象使用gs_replace修复CN时，报错锁集群失败[GUASS-51608] : Failed to lock cluster.二、操作影响此操作影响业务，修复过程需要锁集群，建议计划窗内执行，注释白名单三、排查过程1.执行修复gs_replace -t config -h hostname1修复过程报错：[GUASS-51608] : Failed to lock cluster.报错后退出修复2.排查gs_replace日志日志路径,本节点和修复节点都看cd $GAUSSLOG/om/tail -500f gs_replace-2022-02-13_321948.log日志报错信息如下：gsql: FATAL: database “productdb” does not existDETAIL: The database subdirectory “base/19092” is missing.报错意思19092这个库缺失3.连接每个CN查看所有库select oid,* from pg_database where oid='19092';发现其他正常的一个CN节点这个库没有，是元数据不一致了，需要把这个CN也修复4.将元数据不一致的CN，手动让其故障挪走CN目录下的conf文件cd /srv/BigData/mppdb/data1/coordinatormv *.conf* /home/omm/backup/ps -ef|grep -v grep |grep -i coorkill -9 $CN_PID确认CN是认为故障了cm_ctl query -Cvdp5.执行gs_replace修复gs_replace -t config -h hostname1,hostname2gs_replace -t start -h hostname1,hostname26.修复正常此情况比较少见，可以参考，一定在窗口时间内执行，如果有LVS，记得刷新配置吆，刷新LVS步骤：切换用户su - rootsource环境变量source /opt/huawei/Bigdata/mppdb/.mppdbgs_profile刷新配置，LVS地址10.10.10.10和FusionInsight_MPPDB_8.1.1/__MPPDBServer版本需替换自己的真实环境gs_loadbalance -t reload -U omm -X ${BIGDATA_HOME}/FusionInsight_MPPDB_8.1.1/*_*_MPPDBServer/etc/mppdb-install-config.xml  --lvs-addr=10.10.10.10

【参考资料】cid:link_9cid:link_1本资料针对集群创建失败案例进行补充   梳理出集群创建实现流程和每个环节步骤的作用，以及其对应关键操作。再结合在交付，客户使用dws创建集群过程中大概的进度和已发现的问题案例，整理出对应关系表，帮助用户，服务人员，交付人员在处理问题时，能快速的定界，定位，解决集群创建失败问题。首先登陆后台的mysql数据库 rms库，查看执行到哪一步：1）登陆dwscontroller 后台rms数据库：https://bbs.huaweicloud.com/forum/forum.php?mod=viewthread&tid=1738222）执行sql：select task.job_id, task.task_name, task.begin_time, task.listener_num, task.retry_num, task.execution_status from rds_instance ins left join taskmgr_task task on ins.jobId=task.job_id left JOIN taskmgr_job job on task.job_id=job.job_id where ins.`name` like '%集群名称%' order by task.job_id,task.begin_time;    注：部分环节还没有案例，待继续完善步骤任务作用关键操作大概进度对应案例1ResTenantTask判断表rds_restenant中是否有租户，没有则创建入库　5%cid:link_62ResUserTask创建运维账号，创建obs账号　　　3RdsBindEpsTask集群注册到eps　　　4RdsCreateResourceTenantVpcTask创建VPC　13%cid:link_25RdsSecurityGroupTask创建安全组　　　6RdsServerGroupTask创建用户组　　　7RdsCreateInstanceTask创建实例，ECS创建磁盘，安装操作系统；BMS则下发逻辑安装　33%cid:link_3https://bbs.huaweicloud.com/forum/thread-107166-1-1.htmlhttps://bbs.huaweicloud.com/forum/thread-91555-1-1.html8RdsPingInstanceManagerIpTaskcurl manage:12017 查看管理面和节点是否想通curl manage:1201740%cid:link_79RdsShutdownServerTask关闭服务器　　　10RdsCreatePortTask创建端口　　https://bbs.huaweicloud.com/forum/thread-0241106798574909024-1-1.html11StartupServerTask启动服务器　　　12RdsDownloadPackageTask下载安装包　46%　https://bbs.huaweicloud.com/forum/forum.php?mod=viewthread&tid=16579513RdsInitInstanceChannelTask修改root，mark，mike密码并加密入库　　　14RdsWaitSendInitConfigTask往当前的节点上传initDB.json文件　　15RdsInitInstanceTask创建数据库用户名，完成数据库，操作系统，agent配置文件的初始化节点间互信64%cid:link_4cid:link_8https://bbs.huaweicloud.com/forum/forum.php?mod=viewthread&tid=158691cid:link_816CreateVpcEndpointServiceTask如需要则创建vpcEP并置位，将状态入库到cluster表　　　17CreatePublicIPTask为bms或者ecs绑定eip，eip绑定方法为null则不创建　　　18BindPublicIPTask如果eip没有创建失败且需要绑定eip则才traffic接口绑定eip　90%　19RdsInstanceCreateCompletedTask实例创建完毕开启对实例的监控　9x%cid:link_520RdsInstanceSreMonitorTask根据配置及库中存的sre_monitor信息开始，sre监控器　　　　　　　　21RdsCheckClusterStatusTask稽核集群的状态，是否所有节点都创建完成　　　22RdsClusterBackupTask对新建的集群进行备份　　　23CreatePrivateZoneTask创建内网域名　　　24RdsActiveClusterTask刷新集群状态　　https://bbs.huaweicloud.com/forum/forum.php?mod=viewthread&tid=16839425RdsNotifyToBssForExcuteTaskNotifyToBss　　　

【涉及局点】鄂尔多斯智能体HCS DWS 8.1.1.300【问题现象】集群下发成功后，规格录入失败，ossres-dws.log日志报错：The current flavor is exist【问题原因】预制的规格停用，前台发放dws集群时不显示规格【定位过程】登录cdk-master进dwscontroller容器，查看/opt/cloud/3rdComponent/tomcat/logs中的ossres-dws.log日志，报错The current flavor is exist查看数据库，发现系统预制规格与新录的规格内存和CPU的值一样，磁盘大小不一样     4. 后发现预制的规格停用，前台发放dws集群时不显示那个规格。启用之后正常显示

序号标题链接1【总结】GaussDB(DWS)现网运维常用命令，掌握这些就够了https://bbs.huaweicloud.com/forum/thread-140018-1-1.html2GaussDB(DWS)维护日常运维常用名词&缩略语解析https://bbs.huaweicloud.com/forum/thread-0260973995732300020-1-1.html3FI界面无资源权限cid:link_04FI界面重装主机清除节点报错，安装节点提示环境未清理干净https://bbs.huaweicloud.com/forum/thread-0238972233307360195-1-1.html5第三方用户系统同步过来的用户FI页面无法正常展示cid:link_16LVS故障（主备切换）cid:link_2

序号标题链接1GaussDB 200 网络问题定位指南cid:link_02centos 7.6 ipmi社区已知问题https://bbs.huaweicloud.com/forum/thread-108778-1-1.html3服务器重启后raid缓存策略被重置的问题https://bbs.huaweicloud.com/forum/thread-101504-1-1.html4【硬件&OS;、工具】维护宝典汇总贴来啦~https://bbs.huaweicloud.com/forum/thread-100107-1-1.html5根据一个sys异常高判断的硬件问题https://bbs.huaweicloud.com/forum/thread-96650-1-1.html6文件句柄数占用率过高的处理方案。https://bbs.huaweicloud.com/forum/thread-91070-1-1.html7Ping 10.185.xxx.61   报ping: sendmsg: Operation not permittedhttps://bbs.huaweicloud.com/forum/thread-87285-1-1.html8关于Resource   temporarily unavailable报错的分析。https://bbs.huaweicloud.com/forum/thread-85242-1-1.html9环境配置引发的查询报错could not   send startup packet:connection timed outhttps://bbs.huaweicloud.com/forum/thread-83933-1-1.html10DWS混合云后台登录方法https://bbs.huaweicloud.com/forum/thread-81939-1-1.html11DAYU开发作业选不到数据库，所有节点提示/etc/fstab   有问题。 是警告。集群自身状态正常https://bbs.huaweicloud.com/forum/thread-81938-1-1.html12Resource temporarily   unavailable 报错分析https://bbs.huaweicloud.com/forum/thread-81064-1-1.html13更换磁盘后，diskmgt没有自动挂载新raid组https://bbs.huaweicloud.com/forum/thread-77407-1-1.html14关于一个ssh登陆引发节点cpu使用率高的问题https://bbs.huaweicloud.com/forum/thread-75413-1-1.html15GaussDB   A是否支持升级openssh版本？https://bbs.huaweicloud.com/forum/thread-69957-1-1.html

序号标题链接1向elb监听器中增加后台云服务器组时报错ipaddressxxxisnotvalidIPforthespecihttps://bbs.huaweicloud.com/forum/thread-175760-1-1.html2通过容器登录DN失败报错：Load-Key“xxxxxxx”：Invalidformat；Mike@“ip”：Permishttps://bbs.huaweicloud.com/forum/thread-174755-1-1.html3HCS/HCSO形态DWS管控面故障案例总结https://bbs.huaweicloud.com/forum/thread-173841-1-1.html4DWSHCS场景netcardmonitor.sh脚本产生大量软终端，导致OS定期重启https://bbs.huaweicloud.com/forum/thread-173389-1-1.html5审计日志转储失败https://bbs.huaweicloud.com/forum/thread-171110-1-1.html6Dmsagent进程在长时间运行(4-5个月后)占用内存过多，导致内核无法分配内存，进程异常https://bbs.huaweicloud.com/forum/thread-168527-1-1.html7connectTool.sh连接cn节点超时port22：Connectiontimedouthttps://bbs.huaweicloud.com/forum/thread-155037-1-1.html8根目录满排查方法https://bbs.huaweicloud.com/forum/thread-154290-1-1.html9单实例重启或隔离https://bbs.huaweicloud.com/forum/thread-147713-1-1.html10单节点重启或隔离https://bbs.huaweicloud.com/forum/thread-147714-1-1.html11多个CN节点隔离https://bbs.huaweicloud.com/forum/thread-147718-1-1.html12升级数据库报错，You（omm）arenotallowedtousethisprogram(crontab)https://bbs.huaweicloud.com/forum/thread-144953-1-1.html13句柄不回收，空间不释放https://bbs.huaweicloud.com/forum/thread-145138-1-1.html14【HC/HCS/HCSO】查杀语句https://bbs.huaweicloud.com/forum/thread-150168-1-1.html15【HC/HCS/HCSO】单实例重启或隔离https://bbs.huaweicloud.com/forum/thread-150170-1-1.html16【HC/HCS/HCSO】单节点重启或隔离https://bbs.huaweicloud.com/forum/thread-150171-1-1.html17【HC/HCS/HCSO】重启集群https://bbs.huaweicloud.com/forum/thread-150174-1-1.html18【HC/HCS/HCSO】多个CN节点隔离https://bbs.huaweicloud.com/forum/thread-150172-1-1.html19如何查询残留线程https://bbs.huaweicloud.com/forum/thread-150382-1-1.html20某局点一个dn的pg_xlog一直增长https://bbs.huaweicloud.com/forum/thread-140434-1-1.html21DN线程残留导致表drop不掉的问题https://bbs.huaweicloud.com/forum/thread-143379-1-1.html22GaussDB(DWS)OMS节点上单机库的statscollector进程IO高https://bbs.huaweicloud.com/forum/thread-143389-1-1.html23【应急标准操作】【线下】查杀语句https://bbs.huaweicloud.com/forum/thread-147712-1-1.html24CN异常重启cid:link_025nodeagent未启动https://bbs.huaweicloud.com/forum/thread-0277972384315680202-1-1.html26DN实例主备切换cid:link_127用户表的大小的总和 与 通过 pg_total_user_resource_info 查used_space 数据相差过大cid:link_228GDS 报错connection timed outcid:link_329执行作业报错Failed to connect dn_xxxx. detail: none，stream线程等待连接，状态为stream get conncid:link_4

序号标题链接1连接DWS集群报错theauthenticationtype5isnotsupportedhttps://bbs.huaweicloud.com/forum/thread-177553-1-1.html2随机DN频繁corehttps://bbs.huaweicloud.com/forum/thread-177550-1-1.html3gds报错unexpectedEOFonGDSconnection"gsfs://10.100.19.187:/500https://bbs.huaweicloud.com/forum/thread-177545-1-1.html4配置elb添加CN后，远程连接新CN执行DDL慢https://bbs.huaweicloud.com/forum/thread-177544-1-1.html5过多Savepoint导致查询慢https://bbs.huaweicloud.com/forum/thread-177388-1-1.html6表删除报错：relationdoesnotexistonDNhttps://bbs.huaweicloud.com/forum/thread-177376-1-1.html7作业报错：multipleupdatestoarowbyasinglequeryforcolumnstorhttps://bbs.huaweicloud.com/forum/thread-177250-1-1.html8DWS-10000告警https://bbs.huaweicloud.com/forum/thread-173717-1-1.html9部分监控面板没有信息https://bbs.huaweicloud.com/forum/thread-173708-1-1.html10SSH命令报错:"packet_write_wait:connectiontoport22:Brokenpipe"https://bbs.huaweicloud.com/forum/thread-169934-1-1.html11ECF-->Region:初始化Master虚拟机失败cid:link_612工作负载队列关联用户报错dnxxxx_xxxxpermspacepermspacelimithttps://bbs.huaweicloud.com/forum/thread-167044-1-1.html13工作负载队列接口异常https://bbs.huaweicloud.com/forum/thread-165343-1-1.html14集群ntp配置异常，节点时间有差异https://bbs.huaweicloud.com/forum/thread-164998-1-1.html15关于SmartRaid驱动问题导致DWS发放BMS集群失败的处理办法https://bbs.huaweicloud.com/forum/thread-162631-1-1.html16FI界面告警：gtm主备不同步或者断连https://bbs.huaweicloud.com/forum/thread-153822-1-1.html17使用mergeinto时，结果集不满足预期怎么办https://bbs.huaweicloud.com/forum/thread-153783-1-1.html18JDBC使用过程中的常见报错及处理方法https://bbs.huaweicloud.com/forum/thread-153750-1-1.html19数据库服务端编码是latin1，存入的字符格式是gbk，如何导出utf8格式的字符https://bbs.huaweicloud.com/forum/thread-153728-1-1.html20日志目录cm_agent/pg_log目录下javaudf函数打印大量日志https://bbs.huaweicloud.com/forum/thread-145332-1-1.html21GaussDB(DWS)pg_class中relpages页面估算严重不准https://bbs.huaweicloud.com/forum/thread-147133-1-1.html22【8.0.3】【DWS】【弹性EIP】解绑弹性IP报错，IP找不到，但EIP资源中该IP已处于解绑状态https://bbs.huaweicloud.com/forum/thread-147351-1-1.html23【8.0.3】【DWS】【连接实例】使用运维容器的connectTool连接实例，报错DecryptFailedhttps://bbs.huaweicloud.com/forum/thread-147084-1-1.html24copy入库失败，报错detail：1054SCTPconnectfailedhttps://bbs.huaweicloud.com/forum/thread-148605-1-1.html25update语句报错：multipleupdatestoarowbyasinglequeryforcolumhttps://bbs.huaweicloud.com/forum/thread-145415-1-1.html26spark连接dws报Theauthenticationtype5isnotsupporthttps://bbs.huaweicloud.com/forum/thread-140422-1-1.html27查询pg_rules系统表报错：unrecognizedquerycommandtype:7https://bbs.huaweicloud.com/forum/thread-141390-1-1.html28GaussDB(DWS)查询报错临时空间不足temporaryfilesizeexceedshttps://bbs.huaweicloud.com/forum/thread-140484-1-1.html29jdbc执行语句报错：preparedstatement"S_x"alreadyexistshttps://bbs.huaweicloud.com/forum/thread-132864-1-1.html30FusionInsightManager系统报错连接数据库失败，failedtoreadthedatabasehttps://bbs.huaweicloud.com/forum/thread-133442-1-1.html31内部连接场景一：pooler:Thenodedn_xx[xx]hasnoavailableslothttps://bbs.huaweicloud.com/forum/thread-125510-1-1.html32停止定时任务报错Cannotoperatethisjobduetorunningstatushttps://bbs.huaweicloud.com/forum/thread-119719-1-1.html33执行业务报错：Can'tfitxidintopagehttps://bbs.huaweicloud.com/forum/thread-116810-1-1.html34安装集群提初始化系统环境报错cid:link_035preinstall报错，操作系统版本不一致cid:link_136FI显示节点故障，后台集群状态正常cid:link_237审计日志query_id记录重复cid:link_738管控面实时查询监控项无数据cid:link_339HCS 802 是通过底层绑定的ELB，现升级到810。有界面可以绑定，但是以前绑定的ELB在页面看不到https://bbs.huaweicloud.com/forum/thread-0236972056177540198-1-1.html40点击集群管理，面板显示空白，并且报错: 获取容量接口异常； 获取集群和节点接口异常； CF2_E00002 underlined: F12查看接口状态码为500https://bbs.huaweicloud.com/forum/thread-0245971411096880182-1-1.html41业务SQL语句执行报错 max iteration times 200 hit when looping over right plan treecid:link_442CDM从MRS flink到DWS报错 Database connection failed when ending copycid:link_543LVS负载均衡极限性能场景，cn网络传输流量大的场景下，LVS负载高cid:link_844could not send data to serverhttps://bbs.huaweicloud.com/forum/thread-195897-1-1.html45Fail to head OBS in node:cn_**** with ** NameLookupErrorcid:link_946GAUSS-02820: dn_*_*: invalid input syntax for type *: *cid:link_1047GaussDB(DWS) 语句处于排队状态执行慢cid:link_1148业务入库报错perm space is out of groups perm space limitcid:link_1249GaussDB(DWS) Schema授权后报错current user does not have privilegehttps://bbs.huaweicloud.com/forum/thread-193223-1-1.html50copy报错connection failed when canceling copy operationhttps://bbs.huaweicloud.com/forum/thread-192525-1-1.html51业务报错：too many connections for role "%s"cid:link_1352建表报错：ERROR: There is no hash distributable columncid:link_1453Failed to send dynamic workload params to CCNcid:link_1554GaussDB(DWS)创建表报错：There is no hash distributable columncid:link_1655查询表无数据/所属者查询有数据授权用户查询无数据只显示字段https://bbs.huaweicloud.com/forum/thread-185915-1-1.html56GaussDB(DWS) 使用Apache Spark访问DWS数据库cid:link_1757自定义java函数在dws中执行报错：reflection/loadLibrary is not allowedcid:link_1858column "name" does not exist/relation "**" does not existcid:link_1959查杀语句报错：killing backend is prohibited during online expansioncid:link_2060analyze提示WARNING: The tupleDesc analyzed in CN is differentcid:link_2161删除函数报错：ERROR: function xxx asks parameterscid:link_2262none of server's SASL authentication mechainisms are supportedcid:link_2363分区表创建索引报错：ERROR: partitioned table does not support global indexcid:link_2464create or replace view报错：ERROR: cannot drop columns from viewcid:link_2565GaussDB(DWS) JDBC连接报错和性能问题定位cid:link_2666实例创建到9x%无法创建/RdsActiveClusterTask FAILhttps://bbs.huaweicloud.com/forum/thread-182180-1-1.html67GaussDB(DWS)列存分区表ALTER TABLE加分区memory is temporarily unavailablehttps://bbs.huaweicloud.com/forum/thread-181773-1-1.html68空闲连接CacheMemoryContext占用高导致触发memory is temporarily unavailable报错cid:link_2769业务报错：Session used memory kbytes is beyond the limitation kbyteshttps://bbs.huaweicloud.com/forum/thread-180056-1-1.html70DRS创建数据同步任务报错；DRS.M00004:服务器错误cid:link_28

序号标题链接1DWS单点性能案例集锦https://bbs.huaweicloud.com/forum/thread-90331-1-1.html2外表导入40G数据耗时1小时https://bbs.huaweicloud.com/forum/thread-177546-1-1.html3常见GATHER慢问题集锦https://bbs.huaweicloud.com/forum/thread-161503-1-1.html4DDL慢之系统表索引后置问题https://bbs.huaweicloud.com/forum/thread-161454-1-1.html5列存小CU多导致的性能慢问题https://bbs.huaweicloud.com/forum/thread-161327-1-1.html6GaussDB(DWS)为什么会出现普通用户比dbadmin用户执行的慢https://bbs.huaweicloud.com/forum/thread-116830-1-1.html7GaussDB(DWS)第一次查询慢https://bbs.huaweicloud.com/forum/thread-116834-1-1.html8批量绑定执行PBE形式语句性能分析https://bbs.huaweicloud.com/forum/thread-132681-1-1.html9客户简单groupby查询慢，等待视图中有streamgetconnhttps://bbs.huaweicloud.com/forum/thread-136091-1-1.html10性能问题之CN（Coordinator协调节点）hang问题汇总https://bbs.huaweicloud.com/forum/thread-136283-1-1.html11explainperformance显示的执行时间短gsql返回的时间长https://bbs.huaweicloud.com/forum/thread-144153-1-1.html12查询information_schema模式下的tables系统视图性能差https://bbs.huaweicloud.com/forum/thread-143470-1-1.html13单点性能问题基础篇&实战篇&案例篇汇总https://bbs.huaweicloud.com/forum/thread-150120-1-1.html14DWS系统级性能问题处理套路https://bbs.huaweicloud.com/forum/thread-150310-1-1.html15未对ELK组件做操作，执行性能突然下降https://bbs.huaweicloud.com/forum/thread-146945-1-1.html16短查询高并发导致性能下降https://bbs.huaweicloud.com/forum/thread-146934-1-1.html17DWS性能问题之单节点IO高https://bbs.huaweicloud.com/forum/thread-152917-1-1.html

序号标题链接1omm用户D状态进程超过阈值的排查方法https://bbs.huaweicloud.com/forum/thread-65389-1-1.html2GaussDB for   DWS维护宝典-安装类故障-安装双机OMS，主OMS成功，备启动时提示NTP超时https://bbs.huaweicloud.com/forum/thread-62806-1-1.html3GaussDB for   DWS维护宝典-安装类故障- 安装OMS失败，报错安装logman失败https://bbs.huaweicloud.com/forum/thread-62802-1-1.html4GaussDB for   DWS维护宝典-安装类故障- 操作系统shared_buffers参数的值大于kernel.shmmaxhttps://bbs.huaweicloud.com/forum/thread-62801-1-1.html5GaussDB for   DWS维护宝典-安装类故障- root用户属组不对导致安装gaussdb失败https://bbs.huaweicloud.com/forum/thread-62800-1-1.html6GaussDB for   DWS维护宝典-安装类故障-系统信号量不足导致安装gaussdb失败https://bbs.huaweicloud.com/forum/thread-62797-1-1.html7GaussDB for   DWS维护宝典-安装类故障-"/etc/hosts”配置不对导致安装OMS失败https://bbs.huaweicloud.com/forum/thread-62791-1-1.html8GaussDB for   DWS维护宝典-安装类故障-安装备OMS时启动ntp失败https://bbs.huaweicloud.com/forum/thread-62756-1-1.html9GaussDB for   DWS维护宝典-安装类故障-安装OMS提示解密失败https://bbs.huaweicloud.com/forum/thread-62755-1-1.html10GaussDB for   DWS维护宝典-安装类故障-安装Ldap错误导致OMS安装失败https://bbs.huaweicloud.com/forum/thread-62753-1-1.html11GaussDB for   DWS维护宝典-安装类故障- 文件权限不对导致Preinstall执行失败https://bbs.huaweicloud.com/forum/thread-62752-1-1.html12GaussDB for   DWS维护宝典-安装类故障- 磁盘空间不足导致RPM安装失败https://bbs.huaweicloud.com/forum/thread-62751-1-1.html13GaussDB for   DWS维护宝典-安装类故障-版本过高导致RPM安装失败https://bbs.huaweicloud.com/forum/thread-62750-1-1.html14GaussDB for   DWS维护宝典-安装类故障-文件权限导致OS优化失败https://bbs.huaweicloud.com/forum/thread-62748-1-1.html15GaussDB for   DWS维护宝典-安装类故障-swap分区不一致导致磁盘格式化失败https://bbs.huaweicloud.com/forum/thread-62747-1-1.html16GaussDB for   DWS维护宝典-安装类故障-2.1.2 磁盘数量不足导致磁盘格式化失败https://bbs.huaweicloud.com/forum/thread-62746-1-1.html17GaussDB for   DWS维护宝典-安装类故障- Preinstall报set os parameters faihttps://bbs.huaweicloud.com/forum/thread-62744-1-1.html18GaussDB(DWS)升级&扩容变更FAQhttps://bbs.huaweicloud.com/forum/thread-113431-1-1.html19pg_catalog.pg_attribute表达到88Ghttps://bbs.huaweicloud.com/forum/thread-110863-1-1.html20配置LVS（安装负载均衡）后，集群降级，cn状态为downhttps://bbs.huaweicloud.com/forum/thread-110467-1-1.html21DWS内存问题定位三板斧https://bbs.huaweicloud.com/forum/thread-110215-1-1.html22添加主机在初始化服务和实例失败，还原元数据报错缺少format   optionhttps://bbs.huaweicloud.com/forum/thread-108266-1-1.html23添加主机成功后页面出现37014   Gaussdb进程锁文件已经存在的告警https://bbs.huaweicloud.com/forum/thread-108025-1-1.html24添加主机时在初始化服务和实例失败，报错set   os parameters failedhttps://bbs.huaweicloud.com/forum/thread-108024-1-1.html25添加主机在初始化服务和实例失败，扩容节点gs_local日志报role   16664 does not existhttps://bbs.huaweicloud.com/forum/thread-108019-1-1.html26添加主机在初始化服务和实例失败，报错不能修改default_transaction_read_onlyhttps://bbs.huaweicloud.com/forum/thread-108018-1-1.html27添加主机在初始化服务和实例失败，报错[GAUSS-52631]   : Invalid value for GUC paramehttps://bbs.huaweicloud.com/forum/thread-107533-1-1.html28添加主机在初始化服务和实例失败，postinstall.log日志报Failed   to rebuild instance [60https://bbs.huaweicloud.com/forum/thread-107520-1-1.html29添加主机在初始化服务和实例失败，postinstall日志报lost   connectionhttps://bbs.huaweicloud.com/forum/thread-107518-1-1.html30添加主机在初始化服务和实例失败，报错cn个数不在0~10的范围https://bbs.huaweicloud.com/forum/thread-107373-1-1.html31扩容或重装主机时在第一步校验参数失败报Failed   to verify nodes connection错误https://bbs.huaweicloud.com/forum/thread-107372-1-1.html32主机管理界面添加主机的时候识别出主机IP都是两个的解决办法https://bbs.huaweicloud.com/forum/thread-107369-1-1.html33【维护案例】绝对表空间使用不规范致使内存异常https://bbs.huaweicloud.com/forum/thread-104330-1-1.html34DWS 故障服务器修复https://bbs.huaweicloud.com/forum/thread-102391-1-1.html35【集群】维护宝典汇总贴来啦~https://bbs.huaweicloud.com/forum/thread-100109-1-1.html36GaussDB网络重传/丢包问题定位总结https://bbs.huaweicloud.com/forum/thread-99679-1-1.html37国网常见问题：https://bbs.huaweicloud.com/forum/thread-98272-1-1.html38DWS集群只读磁盘base目录占有率高案例分析https://bbs.huaweicloud.com/forum/thread-98270-1-1.html39业务报错：could not begin   transaction on datanodeshttps://bbs.huaweicloud.com/forum/thread-97669-1-1.html40泰山服务器重启后，数据库性能严重劣化https://bbs.huaweicloud.com/forum/thread-96974-1-1.html41cn/dn内存达到上限无法执行任何语句时如何查看内存视图https://bbs.huaweicloud.com/forum/thread-94896-1-1.html42suse 12.3   操作系统问题导致cn卡死或频繁重启https://bbs.huaweicloud.com/forum/thread-94892-1-1.html43FI页面出现datanode磁盘异常告警的处理步骤https://bbs.huaweicloud.com/forum/thread-94566-1-1.html44执行gs_replace时报错需要输入密码：Invalid   username/password， login deniedhttps://bbs.huaweicloud.com/forum/thread-93595-1-1.html45【外部连接报错】场景三：客户端连接数据库很慢https://bbs.huaweicloud.com/forum/thread-93474-1-1.html46【外部连接报错】场景二：An I/O   error occurred while sending to the backend.https://bbs.huaweicloud.com/forum/thread-93472-1-1.html47【外部连接报错】场景一：too many   clients already， active/non_active: xxx/xxxhttps://bbs.huaweicloud.com/forum/thread-93442-1-1.html48DWS三权分立https://bbs.huaweicloud.com/forum/thread-92711-1-1.html49DWS锁管理参数https://bbs.huaweicloud.com/forum/thread-92710-1-1.html50GaussDB（DWS）xlog积压引起磁盘满（二）之CN复制槽https://bbs.huaweicloud.com/forum/thread-92420-1-1.html51【快速应急】too many   clients already， active/non_active: xxxx/xxxx.https://bbs.huaweicloud.com/forum/thread-91559-1-1.html52GaussDB 200   6.5.1  GDS启动失败https://bbs.huaweicloud.com/forum/thread-89981-1-1.html53pgxc_node的hostis_primary的值和实际对不上怎么解决https://bbs.huaweicloud.com/forum/thread-88350-1-1.html54TCP临时端口使用率超过阈值告警https://bbs.huaweicloud.com/forum/thread-85641-1-1.html55业务报错原因总结：terminating   connection due to administrator commandhttps://bbs.huaweicloud.com/forum/thread-85456-1-1.html56没有analyze时可能会导致内存不可用报错：memory   is temporarily unavailablehttps://bbs.huaweicloud.com/forum/thread-85225-1-1.html57很久不用集群，查询集群状态，都是Ticket   expired，Unspecified GSSfailure等等https://bbs.huaweicloud.com/forum/thread-83375-1-1.html58内存不可用报错：memory   temporarily unavailable 的排查方法https://bbs.huaweicloud.com/forum/thread-82838-1-1.html59【维护案例】新装、扩容集群通信报错：data/control   channel disconnecthttps://bbs.huaweicloud.com/forum/thread-80127-1-1.html60【CPU问题案例1】CPU使用率超过阈值https://bbs.huaweicloud.com/forum/thread-79937-1-1.html61LVS部署后验证轮询异常，/etc/rc.d/rc.local里面的网卡和iptables的配置项被丢失https://bbs.huaweicloud.com/forum/thread-79919-1-1.html62C80SPC800升级前整改，cn系统函数不一致https://bbs.huaweicloud.com/forum/thread-79916-1-1.html63集群出现大量（5W+）僵尸进程，OS   load高，引发os重启https://bbs.huaweicloud.com/forum/thread-79110-1-1.html64使用omm用户修改集群参数时报“Permission   denied”https://bbs.huaweicloud.com/forum/thread-77974-1-1.html65界面实例启动失败，后台集群状态正常https://bbs.huaweicloud.com/forum/thread-77212-1-1.html66CPU高的高效排查手段https://bbs.huaweicloud.com/forum/thread-76364-1-1.html67表定义不合理导致autovacuum占用大量内存https://bbs.huaweicloud.com/forum/thread-76191-1-1.html68idle线程过多导致memory is   temporarily unavailablehttps://bbs.huaweicloud.com/forum/thread-76190-1-1.html69用DS发起连接的时候，等待锁超时，wait   transaction 1234567 sync time exceed 600shttps://bbs.huaweicloud.com/forum/thread-76030-1-1.html70业务报错Cannot get stream   index，maybe comm_max_stream is not enoughhttps://bbs.huaweicloud.com/forum/thread-76003-1-1.html71集群重启后，备cm_server   进程down，cms无法启动，探秘！https://bbs.huaweicloud.com/forum/thread-75800-1-1.html72Gauss DB某一节点文件描述符耗尽应急https://bbs.huaweicloud.com/forum/thread-75465-1-1.html73单节点CPU高？是不是很多getClientInfo进程https://bbs.huaweicloud.com/forum/thread-74914-1-1.html74GaussDB(DWS)使用技巧-怎么针对一个用户，进行并发数的限制https://bbs.huaweicloud.com/forum/thread-74904-1-1.html75升级集群前准备失败（81%），报 the   environmental variable [GAUSS_ENV]'s value https://bbs.huaweicloud.com/forum/thread-74720-1-1.html76多租户资源管理，配置了CPU限额，还是出现了单个用户的作业将CPU资源占高的情况https://bbs.huaweicloud.com/forum/thread-73291-1-1.html77配置的ntp外部时钟源可以ping通，但是ntp服务不能同步时间https://bbs.huaweicloud.com/forum/thread-72616-1-1.html78【集群启停】dn手动停止之后再次启动时启动不了https://bbs.huaweicloud.com/forum/thread-71163-1-1.html79找到占用CPU过高的sql语句https://bbs.huaweicloud.com/forum/thread-70939-1-1.html80扩容或重装主机时报Failed to   verify nodes connection错误https://bbs.huaweicloud.com/forum/thread-70728-1-1.html81环境变量污染导致的集群安装初使化失败。https://bbs.huaweicloud.com/forum/thread-70336-1-1.html82pg_log日志过少。https://bbs.huaweicloud.com/forum/thread-70335-1-1.html83日志路径权限不足导致的增加CN失败。https://bbs.huaweicloud.com/forum/thread-70329-1-1.html84端口号冲突导致的集群状态异常。https://bbs.huaweicloud.com/forum/thread-70327-1-1.html85作业执行时，如果出现执行不动的情况，查看wait_status，发现大量在wait   ccnhttps://bbs.huaweicloud.com/forum/thread-70299-1-1.html86多租户创建时，CPU配额没有达到上限，就会报错CPU资源不足怎么处理https://bbs.huaweicloud.com/forum/thread-70297-1-1.html87信号量不足导致的增加CN失败。https://bbs.huaweicloud.com/forum/thread-70242-1-1.html88某局点因同一网段内多个集群安装lvs导致业务连接超时https://bbs.huaweicloud.com/forum/thread-69961-1-1.html89执行业务时报错duplicate GSS   authentication requesthttps://bbs.huaweicloud.com/forum/thread-69089-1-1.html90GaussDB for DWS   升级网卡驱动后数据库配置实施方案https://bbs.huaweicloud.com/forum/thread-68471-1-1.html91GaussDB for DWS   文件句柄使用率超过阈值或连接数达到最大导致业务报错https://bbs.huaweicloud.com/forum/thread-68465-1-1.html92 GaussDB for DWS terminating connection due   to administratorhttps://bbs.huaweicloud.com/forum/thread-68444-1-1.html93【集群发放失败】实例创建到9x%无法创建/RdsActiveClusterTaskFAILhttps://bbs.huaweicloud.com/forum/thread-168394-1-1.html94【集群创建失败】64%失败/DWS.6000/RdsIntInstanceTaskFAILhttps://bbs.huaweicloud.com/forum/thread-161238-1-1.html95【集群创建失败】创建报错DWS.6000/在64%失败/RdsIntInstanceTask为FAILhttps://bbs.huaweicloud.com/forum/thread-158691-1-1.html96【集群创建失败】集群创建失败DWS.6000/进度40%失败/RdsPingInstanceManagerIpTaskhttps://bbs.huaweicloud.com/forum/thread-159358-1-1.html97【创建集群失败】DWS.6000/BMS.0047/进度32%https://bbs.huaweicloud.com/forum/thread-159362-1-1.html98【创建集群失败】进度到在50%，在RdsCreatePortTask任务FAILhttps://bbs.huaweicloud.com/forum/thread-153161-1-1.html99升级集群42%报错，更新系统表cannotchangereturntypeofexistingfunctiohttps://bbs.huaweicloud.com/forum/thread-148604-1-1.html100xx局点DWS8.0.1线下集群安装preinstall卡住https://bbs.huaweicloud.com/forum/thread-127017-1-1.html101XX局点安装集群时，安装日志提示超时报错https://bbs.huaweicloud.com/forum/thread-127791-1-1.html102DWS集群创建，BMS规格不显示https://bbs.huaweicloud.com/forum/thread-124336-1-1.html103oms组件iam状态exception，manager无法登录https://bbs.huaweicloud.com/forum/thread-174990-1-1.html104GaussDB（DWS）重建实例https://bbs.huaweicloud.com/forum/thread-165194-1-1.html105GaussDB(DWS)主备切换分析https://bbs.huaweicloud.com/forum/thread-156025-1-1.html106主机故障导致MPPDB集群降级https://bbs.huaweicloud.com/forum/thread-148606-1-1.html107新搭建集群，导入lisence文件失败https://bbs.huaweicloud.com/forum/thread-148600-1-1.html108DN长时间处于starting状态--（文件系统问题）https://bbs.huaweicloud.com/forum/thread-137897-1-1.html109GaussDB(DWS)单节点长时间故障应急https://bbs.huaweicloud.com/forum/thread-136663-1-1.html110【集群创建失败】DWS.6000/46%左右失败/RdsDownloadPackageTask失败https://bbs.huaweicloud.com/forum/thread-165795-1-1.html111集群更多查看监控指标不显示内容https://bbs.huaweicloud.com/forum/thread-153410-1-1.html112Toomanyopenfilesinsystem导致单节点故障，导致集群不可用https://bbs.huaweicloud.com/forum/thread-149144-1-1.html113重启集群https://bbs.huaweicloud.com/forum/thread-147701-1-1.html114某局点FIM页面有37031告警，CM_AGENT连接数据库失败https://bbs.huaweicloud.com/forum/thread-144626-1-1.html115【创建集群失败】ResTenantTask报错https://bbs.huaweicloud.com/forum/thread-160669-1-1.html116【8.0.3】创建DWS集群报错，资源租户VPC，后台查错误步骤为CreateResourceTenantVpcFailed，https://bbs.huaweicloud.com/forum/thread-146791-1-1.html117集群信息报异常DWS.0005访问资源不存在或状态异常https://bbs.huaweicloud.com/forum/thread-115811-1-1.html118【HC/HCS/HCSO】主备均衡https://bbs.huaweicloud.com/forum/thread-150166-1-1.html119【HC/HCS/HCSO】清理系统表https://bbs.huaweicloud.com/forum/thread-150164-1-1.html120【HC/HCS/HCSO】gs_replace修复实例https://bbs.huaweicloud.com/forum/thread-150101-1-1.html121重启集群https://bbs.huaweicloud.com/forum/thread-145772-1-1.html122主备均衡https://bbs.huaweicloud.com/forum/thread-145786-1-1.html123【gs_diagnose】集群故障诊断&&集群故障时间线梳理工具介绍https://bbs.huaweicloud.com/forum/thread-173152-1-1.html124dn主备切换分析https://bbs.huaweicloud.com/forum/thread-0220972903967300003-1-1.html125DWS内核版本集群安装与问题cid:link_0126build拉起一段时间后退出cid:link_1127主动预防-kerbos认证问题排查与整改cid:link_2

序号标题链接1集群创建9x%失败问题排查https://bbs.huaweicloud.com/forum/thread-112367-1-1.html2【创建集群失败】报DWS.6000，到86%时创建失败，执行到RdsInitInstanceTaskhttps://bbs.huaweicloud.com/forum/thread-112311-1-1.html3[HCS]-DWS租户面监控面板信息全不显示，且报接口异常--8.0.2   930版本https://bbs.huaweicloud.com/forum/thread-110762-1-1.html4MANAGER页面显示主机故障，后台数据库状态正常https://bbs.huaweicloud.com/forum/thread-110512-1-1.html5[HCS]-DWS租户面监控面板信息全不显示，且报接口异常--InitDms.json配置文件缺失https://bbs.huaweicloud.com/forum/thread-110400-1-1.html6【集群信息】集群规格详情显示cpu为32U与节点后台查询结果48U不一致处理方法https://bbs.huaweicloud.com/forum/thread-108380-1-1.html7ECS资源不足导致DWS集群创建失败https://bbs.huaweicloud.com/forum/thread-107352-1-1.html8【创建集群失败】报DWS.6000，到33%时创建失败，执行到RdsCreateInstanceTaskhttps://bbs.huaweicloud.com/forum/thread-107166-1-1.html9【创建集群失败】报DWS.6000，13%时创建失败，   执行到RdsCreateResourceTenantVpchttps://bbs.huaweicloud.com/forum/thread-107164-1-1.html10叶子租户资源修改提示“无效的服务名”https://bbs.huaweicloud.com/forum/thread-106280-1-1.html11ldapserver服务异常或者okerberos，oldap进程异常https://bbs.huaweicloud.com/forum/thread-106279-1-1.html12DWS租户面监控面板信息全不显示，且报接口异常https://bbs.huaweicloud.com/forum/thread-104048-1-1.html13GaussDB   A管控面升级8005后，数据库用户不显示，点击创建用户只闪一下，无法创建成功https://bbs.huaweicloud.com/forum/thread-103943-1-1.html14【管控面】维护宝典汇总贴来啦~https://bbs.huaweicloud.com/forum/thread-100108-1-1.html15集群因句柄泄露导致业务不可用https://bbs.huaweicloud.com/forum/thread-98137-1-1.html16记录一次调试FI Manager的外接接口https://bbs.huaweicloud.com/forum/thread-97226-1-1.html17DWS集群创建时因管理租户密码被改创建失败https://bbs.huaweicloud.com/forum/thread-94914-1-1.html18CES页面不显示DWS集群监控信息问题https://bbs.huaweicloud.com/forum/thread-93572-1-1.html19DWS安装完成后页面无法显示规格https://bbs.huaweicloud.com/forum/thread-93562-1-1.html20DWS裸机集群创建时因互信创建失败https://bbs.huaweicloud.com/forum/thread-93210-1-1.html21集群页面显示磁盘容量异常https://bbs.huaweicloud.com/forum/thread-93174-1-1.html22集群升级时因发包错误导致升级中止https://bbs.huaweicloud.com/forum/thread-92970-1-1.html23客户集群因网络压力备份失败https://bbs.huaweicloud.com/forum/thread-92958-1-1.html24客户集群升级时失败https://bbs.huaweicloud.com/forum/thread-92254-1-1.html25集群创建完成后EIP不通https://bbs.huaweicloud.com/forum/thread-92253-1-1.html26Agent升级失败https://bbs.huaweicloud.com/forum/thread-92251-1-1.html27页面创建BMS集群时报错https://bbs.huaweicloud.com/forum/thread-91555-1-1.html28管理面和业务内大网ip不通https://bbs.huaweicloud.com/forum/thread-91484-1-1.html29EIP由于策略路由丢失无法连接问题https://bbs.huaweicloud.com/forum/thread-91077-1-1.html30Message日志无法写入问题https://bbs.huaweicloud.com/forum/thread-91076-1-1.html31FIM页面删除CN时页面成功后台查看未剔除https://bbs.huaweicloud.com/forum/thread-90378-1-1.html32oms通过后台命令卸载后，manager页面有残留主机信息https://bbs.huaweicloud.com/forum/thread-84995-1-1.html33重启oms，ldap服务启动异常https://bbs.huaweicloud.com/forum/thread-83591-1-1.html34C80SPC800升级前整改，FIM界面显示后台一个节点实例异常https://bbs.huaweicloud.com/forum/thread-79915-1-1.html35IM界面显示后台一个节点实例启动失败https://bbs.huaweicloud.com/forum/thread-78219-1-1.html36ldapserver与krbserver进程故障。https://bbs.huaweicloud.com/forum/thread-76647-1-1.html37【管控面升级】1859560，参数信息校验失败，措施信息：Failedtologingaussdbhttps://bbs.huaweicloud.com/forum/thread-154096-1-1.html38【HCS管控面升级】ECF-Common/ECF-Cluster用户ecf登录验证失败https://bbs.huaweicloud.com/forum/thread-149808-1-1.html39【DWS管控面升级】802升级803，参数信息校验失败:failedtologinmysqldbhttps://bbs.huaweicloud.com/forum/thread-141530-1-1.html40【8.0.3】【Insight】【日志收集】serviceOM数仓界面收集DWS日志，报错500InternalERRORhttps://bbs.huaweicloud.com/forum/thread-146787-1-1.html41【8.0.3】RdsPingInstanceManageIpTask失败，BMS实例未能正常开机https://bbs.huaweicloud.com/forum/thread-150640-1-1.html42【8.0.3】DWS集群没有内网域名，查明为RdsCreatePrivateZoneTask失败。https://bbs.huaweicloud.com/forum/thread-150643-1-1.html43【8.0.3】DWS安装完成后不显示创建集群按钮https://bbs.huaweicloud.com/forum/thread-150656-1-1.html44DWS安装完成后页面无法显示规格https://bbs.huaweicloud.com/forum/thread-150650-1-1.html45从mananger页面启动MPPDB失败，prestart报错执行kerberosUtility.py脚本报错https://bbs.huaweicloud.com/forum/thread-130127-1-1.html46从mananger页面启动MPPDB失败，prestart报错cannotbindtoldapserverhttps://bbs.huaweicloud.com/forum/thread-130129-1-1.html47登录管控面后台数据库dwscontrollerecfdmshttps://bbs.huaweicloud.com/forum/thread-173822-1-1.html48DWS管控面服务修改参数并让参数立即生效https://bbs.huaweicloud.com/forum/thread-173819-1-1.html

序号标题链接1服务端工具gs_sshhttps://bbs.huaweicloud.com/forum/thread-101317-1-1.html2安装lvs时报Get network   segment failedhttps://bbs.huaweicloud.com/forum/thread-92915-1-1.html3使用weblogic链接高斯时，出现链接断开，报错This   connection has been dhttps://bbs.huaweicloud.com/forum/thread-85214-1-1.html4在集群内多个节点上执行命令或者存取文件（批量操作）https://bbs.huaweicloud.com/forum/thread-81559-1-1.html5检查和设置网卡多队列报错“module   object has no attribute ‘GSSException“https://bbs.huaweicloud.com/forum/thread-73573-1-1.html6gsar网络监测工具使用及含义说明https://bbs.huaweicloud.com/forum/thread-121639-1-1.html7DWS监控脚本https://bbs.huaweicloud.com/forum/thread-135778-1-1.html8GaussDB(DWS)pg_xlogdump pagehack工具https://bbs.huaweicloud.com/forum/thread-142380-1-1.html9GaussDB(DWS)如何安装gdb/gstack/iotop工具https://bbs.huaweicloud.com/forum/thread-143096-1-1.html10GaussDB(DWS)calxid工具https://bbs.huaweicloud.com/forum/thread-147126-1-1.html11根据relfilenode查找Schema、表名，判断是表文件还是索引文件https://bbs.huaweicloud.com/forum/thread-173239-1-1.html12排查系统表索引、元组后置问题https://bbs.huaweicloud.com/forum/thread-171819-1-1.html13HC、HCS、HCSO巡检问题汇总cid:link_014快速解core工具cid:link_115一键配置OS core工具cid:link_216FusionCare修改密码无响应问题cid:link_317kubectl无法登陆DWS容器，命令异常https://bbs.huaweicloud.com/forum/thread-185210-1-1.html18806巡检工具，添加环境信息报错cid:link_419FusionCare对接环境显示巡检项为空https://bbs.huaweicloud.com/forum/thread-184321-1-1.html20巡检报告检测元数据一致性，脚本执行超时解决方案cid:link_521ELK环境巡检工具报错：Python3 command not foundhttps://bbs.huaweicloud.com/forum/thread-183572-1-1.html22【gfreeze】事务号推进工具使用说明cid:link_6

序号标题链接1GaussDB 200 内存问题定位指南https://bbs.huaweicloud.com/forum/thread-62387-1-1.html2某据点磁盘不均衡问题处理办法https://bbs.huaweicloud.com/forum/thread-59749-1-1.html3列存表并发更新时时出现锁等待问题https://bbs.huaweicloud.com/forum/thread-113880-1-1.html4GaussDB(DWS)现网常见问题案例总结（个人收藏）https://bbs.huaweicloud.com/forum/thread-113501-1-1.html5theaerhttps://bbs.huaweicloud.com/forum/thread-110466-1-1.html6c80 elk迁移至8.0   gaussdb之后，读取hdfs外表时部分字段乱码https://bbs.huaweicloud.com/forum/thread-108779-1-1.html7某局点跑批业务出现卡住https://bbs.huaweicloud.com/forum/thread-106278-1-1.html8【GuassDB   8.0产品】【列存储功能】CU大小不固定，对齐8K是什么意思 ？https://bbs.huaweicloud.com/forum/thread-103651-1-1.html9GaussDB(DWS)gdisk物理文件扫描工具说明https://bbs.huaweicloud.com/forum/thread-103111-1-1.html10【存储】维护宝典汇总贴来啦~https://bbs.huaweicloud.com/forum/thread-100104-1-1.html11Gauss   DB(DWS)GDS服务器文件描述符不够引起业务查询hanghttps://bbs.huaweicloud.com/forum/thread-97477-1-1.html12GaussDB常规锁简介https://bbs.huaweicloud.com/forum/thread-97319-1-1.html13列存表查看CU信息https://bbs.huaweicloud.com/forum/thread-96965-1-1.html14drop/truncate  table后磁盘空间不回收https://bbs.huaweicloud.com/forum/thread-96679-1-1.html15如何根据relfilenode查找表名https://bbs.huaweicloud.com/forum/thread-94650-1-1.html16GaussDB (DWS)实例状态   build failedhttps://bbs.huaweicloud.com/forum/thread-93755-1-1.html17如何在有drop   table业务情况下grant schemahttps://bbs.huaweicloud.com/forum/thread-92750-1-1.html18如何查询表的脏页率https://bbs.huaweicloud.com/forum/thread-92731-1-1.html19GaussDB(DWS)集群长时间catchup（三）之带索引导入、delete表、频繁update、truncatehttps://bbs.huaweicloud.com/forum/thread-92411-1-1.html20nvarchar   、nvarchar2、varchar区别https://bbs.huaweicloud.com/forum/thread-91980-1-1.html21GaussDB(DWS)   roach备份失败案例总结（一）https://bbs.huaweicloud.com/forum/thread-90889-1-1.html22常见系统表的字段关系https://bbs.huaweicloud.com/forum/thread-90487-1-1.html23vacuum   full回收机制——oldestXminhttps://bbs.huaweicloud.com/forum/thread-90486-1-1.html24【GaussDB   A】安装MPP集群preinstall时报core错误https://bbs.huaweicloud.com/forum/thread-90472-1-1.html25GaussDB（DWS）磁盘使用率100%集群不可用应急案例（一）https://bbs.huaweicloud.com/forum/thread-89229-1-1.html26GaussDB（DWS）机房断电后GaussDB集群紧急恢复方案https://bbs.huaweicloud.com/forum/thread-86182-1-1.html27GaussDB   (DWS)集群均衡失败原理分析&&应急恢复https://bbs.huaweicloud.com/forum/thread-84788-1-1.html28避免将绝对表空间建在容量较小的磁盘上https://bbs.huaweicloud.com/forum/thread-84249-1-1.html29升级报错sequence找不到https://bbs.huaweicloud.com/forum/thread-83913-1-1.html30GaussDB   （DWS）集群状态异常应急案例https://bbs.huaweicloud.com/forum/thread-83202-1-1.html31GaussDB   （DWS）集群状态长时间显示catchup应急案例（一）https://bbs.huaweicloud.com/forum/thread-83196-1-1.html32GaussDB (DWS)   xlog积压引起磁盘满应急案例（一）https://bbs.huaweicloud.com/forum/thread-83191-1-1.html33obs外表路径定义不规范，导致各种报错https://bbs.huaweicloud.com/forum/thread-83116-1-1.html34gs_replace修复节点时容易遇到的坑https://bbs.huaweicloud.com/forum/thread-82856-1-1.html35一分钟定位等锁问题https://bbs.huaweicloud.com/forum/thread-82664-1-1.html36HCS8.0-DWS   停止roach备份任务https://bbs.huaweicloud.com/forum/thread-81969-1-1.html37文件系统异常导致文件Structure   needs cleaning报错的规避方法https://bbs.huaweicloud.com/forum/thread-81648-1-1.html38drop table if   exists语法误区https://bbs.huaweicloud.com/forum/thread-81620-1-1.html39GaussDB A日志目录清单https://bbs.huaweicloud.com/forum/thread-81562-1-1.html40vacuum full慢的常见场景https://bbs.huaweicloud.com/forum/thread-81310-1-1.html41GDS常见问题FAQhttps://bbs.huaweicloud.com/forum/thread-81039-1-1.html42【SQL on Hadoop】 用户配置   SQL on Hadoop 查询报错https://bbs.huaweicloud.com/forum/thread-79924-1-1.html43delete误删除数据后的恢复方法https://bbs.huaweicloud.com/forum/thread-79861-1-1.html44常用集群磁盘检查与只读参数介绍https://bbs.huaweicloud.com/forum/thread-78802-1-1.html45GaussDB   集群常用操作&&GaussDB;基本知识点https://bbs.huaweicloud.com/forum/thread-78789-1-1.html46列存表有PCK时执行vacuum   full特别慢https://bbs.huaweicloud.com/forum/thread-76006-1-1.html47对表进行delete并做vacuum   full，但是空间没有回收https://bbs.huaweicloud.com/forum/thread-76005-1-1.html48客户反馈磁盘使用率突然下降20%https://bbs.huaweicloud.com/forum/thread-76004-1-1.html49列存表导入时报错 cu.cpp : 249   : The parameter destMax is equal ...https://bbs.huaweicloud.com/forum/thread-76002-1-1.html50事务ID 32位 or   64位，事务id如何回收（推进）https://bbs.huaweicloud.com/forum/thread-75942-1-1.html51Gauss   DB（DWS）集群状态长时间显示catchup应急案例（二）https://bbs.huaweicloud.com/forum/thread-75411-1-1.html52ELK替换故障节点https://bbs.huaweicloud.com/forum/thread-75323-1-1.html53GaussDB如何判断实例redo进度https://bbs.huaweicloud.com/forum/thread-75275-1-1.html54对小表执行vacuum full特别慢https://bbs.huaweicloud.com/forum/thread-70944-1-1.html55DWS 内存问题定位三板斧https://bbs.huaweicloud.com/forum/thread-68376-1-1.html56【磁盘满系列案例2】vacuum   full遇到磁盘空间不足https://bbs.huaweicloud.com/forum/thread-67344-1-1.html57存储过程执行慢问题https://bbs.huaweicloud.com/forum/thread-153297-1-1.html

序号标题链接1更换ntp服务器https://bbs.huaweicloud.com/forum/thread-147725-1-1.html2修改iphttps://bbs.huaweicloud.com/forum/thread-145809-1-1.html3安装LVShttps://bbs.huaweicloud.com/forum/thread-145807-1-1.html4重装主机https://bbs.huaweicloud.com/forum/thread-145803-1-1.html5清理系统表https://bbs.huaweicloud.com/forum/thread-145800-1-1.html6gs_replace修复实例https://bbs.huaweicloud.com/forum/thread-145788-1-1.html7增加CNhttps://bbs.huaweicloud.com/forum/thread-145792-1-1.html8删除CNhttps://bbs.huaweicloud.com/forum/thread-145796-1-1.html9GaussDB(DWS)维护案例发帖模板https://bbs.huaweicloud.com/forum/thread-187075-1-1.html10开源软件漏洞确认列表cid:link_011主动预防-DWS集群gdb安装cid:link_112主动预防-DWS关键工具安装确认cid:link_213主动预防-DWSJDBC驱动版本判断cid:link_314主动预防-DWS-纯软core配置方案cid:link_415主动预防-DWS-HC/HCS/HCSO配core方案cid:link_5