I recently tried to remove some tables, during which I was getting a shell thread stuck on IO error. A fate print plus some digging into the logs revealed they were stuck waiting on WAL resources. I found a thread in which Eric Newton explained how to manually remove the tables removing lines from the !METADATA table using "deletemany -c file," then cleaning up the /accumulo/tables/<id> in hdfs. I've done that, however the fate threads are still locked and I am unable to delete or fail them. Additionally, the tables I removed from !METADATA and hdfs still appear in the list returned by the "tables" command in shell. Below is the result of a "fate print." To note, tables id a and b are the two which I've removed.
test@c4s> fate print txid: 4136e024209602eb status: IN_PROGRESS op: ChangeTableState locked: [] locking: [W:b] top: ChangeTableState txid: 439193592e93e230 status: IN_PROGRESS op: TableRangeOp locked: [] locking: [W:b] top: TableRangeOp txid: 1576dca47dfa2c65 status: IN_PROGRESS op: TableRangeOp locked: [] locking: [W:b] top: TableRangeOp txid: 3ee6232db200f2c7 status: IN_PROGRESS op: TableRangeOp locked: [] locking: [W:b] top: TableRangeOp txid: 19e5d3349679ff6e status: IN_PROGRESS op: TableRangeOp locked: [W:a] locking: [] top: TableRangeOpWait txid: 29204be9d141dc88 status: IN_PROGRESS op: TableRangeOp locked: [] locking: [W:b] top: TableRangeOp txid: 7d07c50ceb5ac487 status: IN_PROGRESS op: DeleteTable locked: [] locking: [W:b] top: DeleteTable txid: 72895b4b1a5a1640 status: IN_PROGRESS op: DeleteTable locked: [] locking: [W:b] top: DeleteTable txid: 6902bcb06c4f5ae7 status: IN_PROGRESS op: DeleteTable locked: [] locking: [W:b] top: DeleteTable txid: 08db2316eb783ba1 status: IN_PROGRESS op: TableRangeOp locked: [] locking: [W:b] top: TableRangeOp txid: 6b0b135ca643b709 status: IN_PROGRESS op: TableRangeOp locked: [] locking: [W:b] top: TableRangeOp txid: 0e174c9af5092e54 status: IN_PROGRESS op: TableRangeOp locked: [W:b] locking: [] top: TableRangeOpWait 12 transactions Thanks in advance for your help. losco
