[Question]Object has invalid state?

2017-06-14 Thread Liu, Yuan (Yuan)
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

RE: [Question]Object has invalid state?

2017-06-14 Thread Anoop Sharma
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.

RE: [Question]Object has invalid state?

2017-06-14 Thread Liu, Yuan (Yuan)
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

RE: [Question]Object has invalid state?

2017-06-14 Thread Prashanth Vasudev
Hi Yuan, >From the error message, TRAFODION.CDH.JL_AMSE has outstanding transactions >that are not yet resolved. Disable/Drop of table when there are outstanding >transactions will block until transactions against the table is resolved( >commit or abort). Please check the health of eco system,