Thanks Anoop for the feedback. I just checked it from hbase shell, I found the table under "hbase shell", so I tried to drop the table under hbase.
But when I executed "disable table_name", it hung there. Error msg in hbase log as below, [cid:image001.png@01D2E5D6.793ABBA0] So I tried to fix the table using "hbase hbck -repair", but it still failed, erro msg as below, [cid:image002.png@01D2E5D6.F3DD3BD0] Then I restarted HBase, and the table was removed from HBase. Now it worked, though I don't know why. Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540 From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Thursday, June 15, 2017 12:28 PM To: user@trafodion.incubator.apache.org Subject: RE: [Question]Object has invalid state? purgedata internally drops the table from hbase, and then recreates it as an empty table. Invalid state usually means that the object is still in traf metadata but the underlying hbase object has been dropped. Or vica versa. This is an error condition and shouldn't happen under normal conditions. Difficult to say what would have caused it to reach this state. Probably some error happened that caused it to not recreate it correctly. Does this table has indexes on it? Was there any node/process crash during that purgedata? hbase logs may also have some info. You can also try: cleanup metadata, check, return details; This will show inconsistent object and may give more info. (check option will not actually clean it up). anoop From: Liu, Yuan (Yuan) [mailto:yuan....@esgyn.cn] Sent: Wednesday, June 14, 2017 9:05 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: [Question]Object has invalid state? Hi Trafodioners, I encountered below error after I executed "purgedata table_name", [ERROR 4254] Object table_name has invalid state and cannot be accessed. Use cleanup command to drop it. I know I can use "cleanup table table_name" to drop the table, but I want to know in which cases does the issue happen? And can I still recover this table without cleanup it? Can anyone please help on the question? Thanks a lot. Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540
