h3 DataEngine MPP master不能正常启动
- 0关注
- 1收藏，1361浏览
问题描述：
节假日意外断电，导致HDP、MPP集群宕机，出现MPP服务不正常启动。h3 DataEngine MPP master无论是停止所有服务，还是单独在各个节点均不能正常启动
组网及组网描述：
- 2022-05-20提问
- 举报
-
(0)
您好，以下排查下
10.2 查看DataEngine MPP各节点状态
登录到安装有DataEngine MPP的任意一个节点，然后切换到操作系统用户下（DataEngine MPP操作系统用户和数据库管理员用户同名，在创建集群时设定），执行如下命令：
admintools -t view_cluster -x
会列出当前DataEngine MPP集群所有数据库，所有节点的状态。
DB | Host | State
--------------+---------------+-------
H3C_Database | 10.121.66.152 | UP
H3C_Database | 10.121.66.153 | UP
H3C_Database | 10.121.66.154 | UP
数据库名称为H3C_Database，拥有3个节点，对应IP分别为10.121.66.152--154，所有节点状态都是UP的。若有节点处于DOWN的状态，需查找分析节点DOWN的原因并将DOWN的节点启动。
10.3 DataEngine MPP故障节点日志收集方法
当出现异常情况，比如DataEngine MPP集群或某些节点状态不正常等现象时，可使用Scrutinize命令进行日志收集。
使用数据库管理员用户，在某个DataEngine MPP节点上执行如下命令：
/opt/vertica/bin/scrutinize --by-minute yes -U '<username>' -P '<enter password here>' -n <IP address or hostname>
其中：
· username为命令执行的用户名，在此为操作系统用户。DataEngine MPP操作系统用户和数据库管理员用户同名，在创建集群时设定。
· password为操作系统用户的密码。
· IP address or hostname是DataEngine MPP其他节点的IP地址或hostname。
最终生成的收集内容为一个命名格式如VerticaScrutinize.20190115140836.tar的压缩文件，20190115140836表示命令执行的时间戳。
- 2022-05-20回答
- 评论(4)
- 举报
-
(0)
你这个不行，你这是MPP2 vertica的维护手册，现场是MPP1数据库，是两个产品
[gpadmin@node4 /]$ admintools -t view_cluster -x -bash: admintools: command not found
[root@node6 ~]# find / - name admintools 。。。。。。。。。 /etc/selinux/targeted/active/modules/100/abrt/cil /etc/selinux/targeted/active/modules/100/portmap /etc/selinux/targeted/active/modules/100/portmap/lang_ext /etc/selinux/targeted/active/modules/100/portmap/hll /etc/selinux/targeted/active/modules/100/portmap/cil /etc/selinux/targeted/active/modules/100/cgdcbxd /etc/selinux/targeted/active/modules/100/cgdcbxd/lang_ext /etc/selinux/targeted/active/modules/100/cgdcbxd/hll /etc/selinux/targeted/active/modules/100/cgdcbxd/cil /etc/selinux/targeted/active/modules/100/uucp /etc/selinux/targeted/active/modules/100/uucp/lang_ext /etc/selinux/targeted/active/modules/100/uucp/hll /etc/selinux/targeted/active/modules/100/uucp/cil /etc/selinux/targeted/active/modules/100/networkmanager /etc/selinux/targeted/active/modules/100/networkmanager/lang_ext /etc/selinux/targeted/active/modules/100/networkmanager/hll /etc/selinux/targeted/active/modules/100/networkmanager/cil /etc/selinux/targeted/active/modules/100/aiccu /etc/selinux/targeted/active/modules/100/aiccu/lang_ext /etc/selinux/targeted/active/modules/100/aiccu/hll /etc/selinux/targeted/active/modules/100/aiccu/cil /etc/selinux/targeted/active/modules/100/gssproxy /etc/selinux/targeted/active/modules/100/gssproxy/lang_ext /etc/selinux/targeted/active/modules/100/gssproxy/hll /etc/selinux/targeted/active/modules/100/gssproxy/cil /etc/selinux/targeted/active/modules/100/hddtemp /etc/selinux/targeted/active/modules/100/hddtemp/lang_ext /etc/selinux/targeted/active/modules/100/hddtemp/hll /etc/selinux/targeted/active/modules/100/hddtemp/cil /etc/selinux/targeted/active/modules/100/thin /etc/selinux/targeted/active/modules/100/thin/lang_ext /etc/selinux/targeted/active/modules/100/thin/hll /etc/selinux/targeted/active/modules/100/thin/cil /etc/selinux/targeted/active/modules/100/locallogin /etc/selinux/targeted/active/modules/100/locallogin/lang_ext /etc/selinux/targeted/active/modules/100/locallogin/hll /etc/selinux/targeted/active/modules/100/locallogin/cil /etc/selinux/targeted/active/modules/100/application /etc/selinux/targeted/active/modules/100/application/lang_ext /etc/selinux/targeted/active/modules/100/application/hll /etc/selinux/targeted/active/modules/100/application/cil /etc/selinux/targeted/active/modules/100/hwloc /etc/selinux/targeted/active/modules/100/hwloc/lang_ext /etc/selinux/targeted/active/modules/100/hwloc/hll /etc/selinux/targeted/active/modules/100/hwloc/cil /etc/selinux/targeted/active/modules/100/authlogin /etc/selinux/targeted/active/modules/100/authlogin/lang_ext /etc/selinux/targeted/active/modules/100/authlogin/hll /etc/selinux/targeted/active/modules/100/authlogin/cil /etc/selinux/targeted/active/modules/100/apcupsd /etc/selinux/targeted/active/modules/100/apcupsd/lang_ext /etc/selinux/targeted/active/modules/100/apcupsd/hll /etc/selinux/targeted/active/modules/100/apcupsd/cil /etc/selinux/targeted/active/modules/100/permissivedomains /etc/selinux/targeted/active/modules/100/permissivedomains/lang_ext /etc/selinux/targeted/active/modules/100/permissivedomains/cil /etc/selinux/targeted/active/modules/disabled /etc/selinux/targeted/active/file_contexts /etc/selinux/targeted/active/commit_num /etc/selinux/targeted/active/homedir_template /etc/selinux/targeted/logins /etc/selinux/targeted/semanage.trans.LOCK /etc/selinux/targeted/semanage.read.LOCK /etc/selinux/targeted/setrans.conf /etc/selinux/targeted/modules /etc/selinux/targeted/modules/active /etc/selinux/targeted/modules/active/modules /etc/selinux/targeted/booleans.subs_dist /etc/selinux/targeted/.policy.sha512 /etc/selinux/semanage.conf /etc/selinux/config /etc/selinux/tmp /etc/selinux/final /etc/rc1.d /etc/rdma /etc/rdma/sriov-vfs /etc/rdma/mlx4.conf /etc/rdma/rdma.conf /etc/shadow- /etc/system-release-cpe /etc/crontab /etc/modprobe.d /etc/modprobe.d/tuned.conf /etc/modprobe.d/mlx4.conf /etc/host.conf /etc/hive /etc/hive/2.3.4.0-3485 /etc/hive/2.3.4.0-3485/0 /etc/hive/2.3.4.0-3485/0/ivysettings.xml /etc/hive/2.3.4.0-3485/0/hive-env.sh /etc/hive/2.3.4.0-3485/0/mapred-site.xml /etc/hive/2.3.4.0-3485/0/conf.server /etc/hive/2.3.4.0-3485/0/hive-env.sh.template /etc/hive/2.3.4.0-3485/0/hive-exec-log4j.properties /etc/hive/2.3.4.0-3485/0/hive-site.xml /etc/hive/2.3.4.0-3485/0/hive-default.xml.template /etc/hive/2.3.4.0-3485/0/beeline-log4j.properties.template /etc/hive/2.3.4.0-3485/0/hive-log4j.properties /etc/hive/conf /etc/hive/conf.install /etc/hive/conf.install/ivysettings.xml /etc/hive/conf.install/conf.server /etc/hive/conf.install/hive-env.sh.template /etc/hive/conf.install/hive-exec-log4j.properties /etc/hive/conf.install/hive-site.xml /etc/hive/conf.install/hive-default.xml.template /etc/hive/conf.install/beeline-log4j.properties.template /etc/hive/conf.install/hive-log4j.properties /etc/login.defs /etc/favicon.png /etc/ld.so.conf /etc/mtab /etc/rc6.d /etc/dracut.conf /etc/filesystems /etc/magic /etc/security /etc/security/namespace.conf /etc/security/console.perms.d /etc/security/limits.d /etc/security/limits.d/yarn.conf /etc/security/limits.d/20-nproc.conf /etc/security/limits.d/mapreduce.conf /etc/security/limits.d/gpadmin.conf /etc/security/limits.d/hdfs.conf /etc/security/limits.d/hive.conf /etc/security/console.handlers /etc/security/group.conf /etc/security/console.perms /etc/security/opasswd /etc/security/access.conf /etc/security/namespace.d /etc/security/limits.conf /etc/security/time.conf /etc/security/pwquality.conf /etc/security/sepermit.conf /etc/security/pam_env.conf /etc/security/chroot.conf /etc/security/console.apps /etc/security/console.apps/config-util /etc/security/console.apps/authconfig-gtk /etc/security/console.apps/authconfig /etc/security/console.apps/system-config-authentication /etc/security/console.apps/authconfig-tui /etc/security/namespace.init /etc/group /etc/aliases /etc/centos-release-upstream /etc/GREP_COLORS /etc/.updated /etc/logrotate.conf /etc/ssh /etc/ssh/ssh_config /etc/ssh/ssh_host_ecdsa_key /etc/ssh/ssh_host_rsa_key /etc/ssh/sshd_config /etc/ssh/ssh_host_ed25519_key.pub /etc/ssh/ssh_host_ed25519_key /etc/ssh/ssh_host_ecdsa_key.pub /etc/ssh/moduli /etc/ssh/ssh_host_rsa_key.pub /etc/system-release /etc/dracut.conf.d /etc/pm /etc/pm/config.d /etc/pm/power.d /etc/pm/sleep.d /etc/ntp /etc/ntp/keys /etc/ntp/step-tickers /etc/ntp/crypto /etc/ntp/crypto/pw /etc/machine-id /etc/ld.so.cache /etc/logrotate.d /etc/logrotate.d/syslog /etc/logrotate.d/wpa_supplicant /etc/logrotate.d/ppp /etc/logrotate.d/yum /etc/gnupg /etc/e2fsck.conf /etc/libuser.conf /etc/chkconfig.d /etc/rc5.d /etc/openldap /etc/openldap/ldap.conf /etc/openldap/cacerts /etc/openldap/certs /etc/openldap/certs/secmod.db /etc/openldap/certs/key3.db /etc/openldap/certs/password /etc/openldap/certs/cert8.db /etc/hadoop-httpfs /etc/hadoop-httpfs/conf /etc/hadoop-httpfs/conf/httpfs-log4j.properties /etc/hadoop-httpfs/conf/httpfs-env.sh /etc/hadoop-httpfs/conf/httpfs-site.xml /etc/hadoop-httpfs/conf/httpfs-signature.secret /etc/hadoop-httpfs/tomcat-deployment /etc/hadoop-httpfs/tomcat-deployment/bin /etc/hadoop-httpfs/tomcat-deployment/conf /etc/hadoop-httpfs/tomcat-deployment/conf/server.xml /etc/hadoop-httpfs/tomcat-deployment/conf/catalina.policy /etc/hadoop-httpfs/tomcat-deployment/conf/context.xml /etc/hadoop-httpfs/tomcat-deployment/conf/web.xml /etc/hadoop-httpfs/tomcat-deployment/conf/logging.properties /etc/hadoop-httpfs/tomcat-deployment/conf/tomcat-users.xml /etc/hadoop-httpfs/tomcat-deployment/conf/catalina.properties /etc/hadoop-httpfs/tomcat-deployment/conf/ssl-server.xml /etc/hadoop-httpfs/tomcat-deployment/lib /etc/skel /etc/skel/.bash_logout /etc/skel/.bash_profile /etc/skel/.bashrc /etc/rc2.d /lib find: 鈥鈥 No such file or directory find: 鈥榥ame鈥 No such file or directory find: 鈥榓dmintools鈥 No such file or directory [root@node6 ~]#
找不到这个可执行文件？请确认？
联系400吧，需要远程看下；MPP 如果有HA的话应该不影响数据库服务；需要看下pg数据库状态，及HA切换是否完成了
- 2022-05-20回答
- 评论(3)
- 举报
-
(0)
这是我联系华三400结果。无语死了。【新华三】欢迎致电新华三400服务热线！技术问题请访问H3C知了社区：zhiliao.h3c.com，100%的问题30分钟内答复。如需人工帮助，请关注微信公众号“新华三服务”，使用“自助服务”中“400一键拨入”可直达工程师。
400电话，让我找当地办事处技术人员，办事处也没有搞定，一直没有消息。搞得我太郁闷，当初买时承诺一堆，后来我们把华三拒绝了，买华三，才知道上当了。
还是华为好用
这是我联系华三400结果。无语死了。【新华三】欢迎致电新华三400服务热线！技术问题请访问H3C知了社区：zhiliao.h3c.com，100%的问题30分钟内答复。如需人工帮助，请关注微信公众号“新华三服务”，使用“自助服务”中“400一键拨入”可直达工程师。
编辑答案
亲~登录后才可以操作哦!
确定你的邮箱还未认证，请认证邮箱或绑定手机后进行当前操作
举报
×
侵犯我的权益
×
侵犯了我企业的权益
×
- 1. 您举报的内容是什么？（请在邮件中列出您举报的内容和链接地址）
- 2. 您是谁？（身份证明材料，可以是身份证或护照等证件）
- 3. 是哪家企业？（营业执照，单位登记证明等证件）
- 4. 您与该企业的关系是？（您是企业法人或被授权人，需提供企业委托授权书）
抄袭了我的内容
×
原文链接或出处
诽谤我
×
- 1. 您举报的内容以及侵犯了您什么权益？（请在邮件中列出您举报的内容、链接地址，并给出简短的说明）
- 2. 您是谁？（身份证明材料，可以是身份证或护照等证件）
对根叔社区有害的内容
×
不规范转载
×
举报说明
找不到这个可执行文件？请确认？