Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Accumulo >> mail # user >> locked fate threads


Copy link to this message
-
locked fate threads
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

+
Eric Newton 2013-09-05, 13:18