{"id":237,"date":"2016-11-25T09:42:30","date_gmt":"2016-11-25T11:42:30","guid":{"rendered":"http:\/\/portal.venidera.com\/kb\/?p=237"},"modified":"2018-07-26T13:39:50","modified_gmt":"2018-07-26T16:39:50","slug":"english-cleaning-opentsdb-schema-on-hbase-normal-and-crash-situations","status":"publish","type":"post","link":"https:\/\/portal.venidera.com\/kb\/2016\/11\/25\/english-cleaning-opentsdb-schema-on-hbase-normal-and-crash-situations\/","title":{"rendered":"(English) Cleaning OpenTSDB schema on Hbase (normal and crash situations)"},"content":{"rendered":"

Desculpe-nos, mas este texto est\u00e1 apenas dispon\u00edvel em English<\/a>. For the sake of viewer convenience, the content is shown below in the alternative language. You may click the link to switch the active language.<\/p>

Suppose that for any reason you need to clean the OpenTSDB<\/a>\u00a0schema. There is an easy way, you can do:<\/p>\n[code]\n$ hbase shell
\nhbase(main):001:0> disable ‘tsdb’
\nhbase(main):002:0> disable ‘tsdb-meta’
\nhbase(main):003:0> disable ‘tsdb-tree’
\nhbase(main):004:0> disable ‘tsdb-uid’
\nhbase(main):005:0> drop ‘tsdb’
\nhbase(main):006:0> drop ‘tsdb-meta’
\nhbase(main):007:0> drop ‘tsdb-tree’
\nhbase(main):008:0> drop ‘tsdb-uid’[\/code]\n

Ok, no problem. Just ‘disable’ and then ‘drop’ them.
\nThis is the common procedure in standalone Hbase, also in consistent HDFS.
\nBut, if you can’t see the tables when you do:<\/p>\n[code]\n$ hbase shell
\nhbase(main):001:0> list[\/code]\n

And you try to create the OpenTSDB tables and it fails telling you that the tables already exists. So you can’t create the tables but also can’t disable and drop them.
\nIn this case you must use the zookeeper client, so you will need to:<\/p>\n[code]\nroot@hb-nodeX:\/# hbase zkcli
\nls \/hbase[replication, meta-region-server, rs, splitWAL, backup-masters, table-lock, flush-table-proc, region-in-transition, online-snapshot, master, running, recovering-regions, draining, namespace, hbaseid, table]\nls \/hbase\/table[tsdb, tsdb-uid, tsdb-meta, tsdb-tree, hbase:meta]\nrmr \/hbase\/table\/tsdb
\nrmr \/hbase\/table\/tsdb-uid
\nrmr \/hbase\/table\/tsdb-meta
\nrmr \/hbase\/table\/tsdb-tree
\nrmr \/hbase\/table\/hbase:meta
\nquit[\/code]\n

And now you can create the schema again (change the commands below according your system):<\/p>\n[code]\nroot@hb-nodeX:\/# export COMPRESSION=LZO
\nroot@hb-nodeX:\/# export HBASE_HOME=\/usr\/lib\/hbase
\nroot@hb-nodeX:\/# export JAVA_HOME=\/usr\/lib\/jvm\/java-8-oracle
\nroot@hb-nodeX:\/# \/usr\/share\/opentsdb\/tools\/create_table.sh[\/code]\n

And OpenTSDB will work again!!<\/p>\n

Reference:
\nKilling zombie tables<\/a>

<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,5],"tags":[],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-hbase","category-infra"],"_links":{"self":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":5,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":282,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/posts\/237\/revisions\/282"}],"wp:attachment":[{"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portal.venidera.com\/kb\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}