• 全部
  • 經驗案例
  • 典型配置
  • 技術公告
  • FAQ
  • 漏洞說明
  • 全部
  • 全部
  • 大數據引擎
  • 知了引擎
產品線
搜索
取消
案例類型
發布者
是否解決
是否官方
時間
搜索引擎
匹配模式
高級搜索

h3 DataEngine MPP master不能正常啟動

  • 0關注
  • 1收藏,1904瀏覽
粉絲:0人 關注:0人

問題描述:

節假日意外斷電,導致HDP、MPP集群宕機,出現MPP服務不正常啟動。h3 DataEngine MPP master無論是停止所有服務,還是單獨在各個節點均不能正常啟動


組網及組網描述:



3 個回答
粉絲:107人 關注: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表示命令執行的時間戳。


找不到這個可執行文件?請確認?

zhiliao_XtYsXJ 發表時間:2022-05-20 更多>>

你這個不行,你這是MPP2 vertica的維護手冊,現場是MPP1數據庫,是兩個產品

GRL 發表時間:2022-05-20

[gpadmin@node4 /]$ admintools -t view_cluster -x -bash: admintools: command not found

zhiliao_XtYsXJ 發表時間:2022-05-20

[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 ~]#

zhiliao_XtYsXJ 發表時間:2022-05-20

找不到這個可執行文件?請確認?

zhiliao_XtYsXJ 發表時間:2022-05-20
GRL 九段
粉絲:53人 關注:17人

聯係400吧,需要遠程看下;MPP 如果有HA的話應該不影響數據庫服務;需要看下pg數據庫狀態,及HA切換是否完成了

這是我聯係華三400結果。無語死了。【BOB登陆 】歡迎致電BOB登陆 400服務熱線!技術問題請訪問H3C知了社區:zhiliao.h3c.com,100%的問題30分鍾內答複。如需人工幫助,請關注微信公眾號“BOB登陆 服務”,使用“自助服務”中“400一鍵撥入”可直達工程師。

zhiliao_XtYsXJ 發表時間:2022-05-20 更多>>

400電話,讓我找當地辦事處技術人員,辦事處也沒有搞定,一直沒有消息。搞得我太鬱悶,當初買時承諾一堆,後來我們把華三拒絕了,買華三,才知道上當了。

zhiliao_XtYsXJ 發表時間:2022-05-20

還是華為好用

zhiliao_XtYsXJ 發表時間:2022-05-20

這是我聯係華三400結果。無語死了。【BOB登陆 】歡迎致電BOB登陆 400服務熱線!技術問題請訪問H3C知了社區:zhiliao.h3c.com,100%的問題30分鍾內答複。如需人工幫助,請關注微信公眾號“BOB登陆 服務”,使用“自助服務”中“400一鍵撥入”可直達工程師。

zhiliao_XtYsXJ 發表時間:2022-05-20
zhiliao_XtYsXJ 知了小白
粉絲:0人 關注:0人

HA沒有自動切換,MPP處於停止服務狀態

編輯答案

你正在編輯答案

如果你要對問題或其他回答進行點評或詢問,請使用評論功能。

分享擴散:

提出建議

    +

親~登錄後才可以操作哦!

確定

親~檢測到您登陸的賬號未在http://hclhub.h3c.com進行注冊

注冊後可訪問此模塊

跳轉hclhub

你的郵箱還未認證,請認證郵箱或綁定手機後進行當前操作

舉報

×

侵犯我的權益 >
對根叔社區有害的內容 >
辱罵、歧視、挑釁等(不友善)

侵犯我的權益

×

泄露了我的隱私 >
侵犯了我企業的權益 >
抄襲了我的內容 >
誹謗我 >
辱罵、歧視、挑釁等(不友善)
騷擾我

泄露了我的隱私

×

您好,當您發現根叔知了上有泄漏您隱私的內容時,您可以向根叔知了進行舉報。 請您把以下內容通過郵件發送到pub.zhiliao@h3c.com 郵箱,我們會盡快處理。
  • 1. 您認為哪些內容泄露了您的隱私?(請在郵件中列出您舉報的內容、鏈接地址,並給出簡短的說明)
  • 2. 您是誰?(身份證明材料,可以是身份證或護照等證件)

侵犯了我企業的權益

×

您好,當您發現根叔知了上有關於您企業的造謠與誹謗、商業侵權等內容時,您可以向根叔知了進行舉報。 請您把以下內容通過郵件發送到 pub.zhiliao@h3c.com 郵箱,我們會在審核後盡快給您答複。
  • 1. 您舉報的內容是什麼?(請在郵件中列出您舉報的內容和鏈接地址)
  • 2. 您是誰?(身份證明材料,可以是身份證或護照等證件)
  • 3. 是哪家企業?(營業執照,單位登記證明等證件)
  • 4. 您與該企業的關係是?(您是企業法人或被授權人,需提供企業委托授權書)
我們認為知名企業應該坦然接受公眾討論,對於答案中不準確的部分,我們歡迎您以正式或非正式身份在根叔知了上進行澄清。

抄襲了我的內容

×

原文鏈接或出處

誹謗我

×

您好,當您發現根叔知了上有誹謗您的內容時,您可以向根叔知了進行舉報。 請您把以下內容通過郵件發送到pub.zhiliao@h3c.com 郵箱,我們會盡快處理。
  • 1. 您舉報的內容以及侵犯了您什麼權益?(請在郵件中列出您舉報的內容、鏈接地址,並給出簡短的說明)
  • 2. 您是誰?(身份證明材料,可以是身份證或護照等證件)
我們認為知名企業應該坦然接受公眾討論,對於答案中不準確的部分,我們歡迎您以正式或非正式身份在根叔知了上進行澄清。

對根叔社區有害的內容

×

垃圾廣告信息
色情、暴力、血腥等違反法律法規的內容
政治敏感
不規範轉載 >
辱罵、歧視、挑釁等(不友善)
騷擾我
誘導投票

不規範轉載

×

舉報說明