Unable to drop the table

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Unable to drop the table

raviteja.152@gmail.com
I am getting an error whenever I try to drop the table.

[impl.ThriftTransportPool] WARN : Thread "shell" stuck on IO to
ip-XXXXXinternal:9999 (0) for at least 120038 ms



--
Sent from: http://apache-accumulo.1065345.n5.nabble.com/Developers-f3.html
Reply | Threaded
Open this post in threaded view
|

Re: Unable to drop the table

Josh Elser-2
Please inspect the Accumulo Master log running on the host identified by
the IP address in the warning message. Look for any Exceptions or ERROR
messages reported in that log file.

On 10/23/17 12:57 PM, [hidden email] wrote:

> I am getting an error whenever I try to drop the table.
>
> [impl.ThriftTransportPool] WARN : Thread "shell" stuck on IO to
> ip-XXXXXinternal:9999 (0) for at least 120038 ms
>
>
>
> --
> Sent from: http://apache-accumulo.1065345.n5.nabble.com/Developers-f3.html
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to drop the table

Michael Wall
What version of Accumulo are you running?  Maybe you are hitting
https://issues.apache.org/jira/browse/ACCUMULO-4143?

If so, see search the user mailing list for how to fix a hanging droptable

Mike
On Mon, Oct 23, 2017 at 1:38 PM Josh Elser <[hidden email]> wrote:

> Please inspect the Accumulo Master log running on the host identified by
> the IP address in the warning message. Look for any Exceptions or ERROR
> messages reported in that log file.
>
> On 10/23/17 12:57 PM, [hidden email] wrote:
> > I am getting an error whenever I try to drop the table.
> >
> > [impl.ThriftTransportPool] WARN : Thread "shell" stuck on IO to
> > ip-XXXXXinternal:9999 (0) for at least 120038 ms
> >
> >
> >
> > --
> > Sent from:
> http://apache-accumulo.1065345.n5.nabble.com/Developers-f3.html
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to drop the table

raviteja.152@gmail.com
I am running accumulo 1.7.2

When I ran accumulo org.apache.accumulo.master.util.FateAdmin print

This tool has been deprecated

FATE administration now available within 'accumulo shell'

$ fate fail <txid>... | delete <txid>... | print [<txid>...]


txid: 2f4a34db8b75eb5b  status: IN_PROGRESS         op: ExportTable
  locked:
[R:1, R:3l]     locking: []              top: WriteExportFiles

txid: 4129f8afbc75ee46  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:4]           top: DeleteTable

txid: 278528f2556667c7  status: IN_PROGRESS         op: RenameTable
  locked:
[R:1]           locking: [W:e]           top: RenameTable

txid: 6077280525d6ccc6  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:i]           top: DeleteTable

txid: 3291ed14d4ef3b70  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:h]           top: DeleteTable

txid: 5bad94142c37acf0  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:5]           top: DeleteTable

txid: 01c9148b565dec3b  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1, W:h]      locking: []              top: CleanUp

txid: 0f4cf2ac81e81420  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:i]           top: DeleteTable

txid: 2193c89247878233  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:e]           top: DeleteTable

txid: 0ec036f35be085d3  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1]           locking: [W:5]           top: DeleteTable

txid: 4edd6822f8c48ef5  status: IN_PROGRESS         op: ExportTable
  locked:
[R:1, R:3t]     locking: []              top: WriteExportFiles

txid: 276294ca8f5a13ec  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1, W:i]      locking: []              top: CleanUp

txid: 1e90b13efb1cc9ae  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1, W:e]      locking: []              top: CleanUp

txid: 5fdee8a97540128b  status: IN_PROGRESS         op:
ChangeTableState  locked:
[R:1]           locking: [W:e]           top: ChangeTableState

txid: 51c0c7b055a2ca42  status: IN_PROGRESS         op:
ChangeTableState  locked:
[R:1]           locking: [W:e]           top: ChangeTableState

txid: 7f80bc339b826e7d  status: IN_PROGRESS         op:
ChangeTableState  locked:
[R:1]           locking: [W:e]           top: ChangeTableState

txid: 3635386bb4179733  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1, W:5]      locking: []              top: CleanUp

txid: 415a00837cf58a6a  status: IN_PROGRESS         op: DeleteTable
  locked:
[R:1, W:4]      locking: []              top: CleanUp

On Tue, Oct 24, 2017 at 10:07 AM, Michael Wall <[hidden email]> wrote:

> What version of Accumulo are you running?  Maybe you are hitting
> https://issues.apache.org/jira/browse/ACCUMULO-4143?
>
> If so, see search the user mailing list for how to fix a hanging droptable
>
> Mike
>
> On Mon, Oct 23, 2017 at 1:38 PM Josh Elser <[hidden email]> wrote:
>
>> Please inspect the Accumulo Master log running on the host identified by
>> the IP address in the warning message. Look for any Exceptions or ERROR
>> messages reported in that log file.
>>
>> On 10/23/17 12:57 PM, [hidden email] wrote:
>> > I am getting an error whenever I try to drop the table.
>> >
>> > [impl.ThriftTransportPool] WARN : Thread "shell" stuck on IO to
>> > ip-XXXXXinternal:9999 (0) for at least 120038 ms
>> >
>> >
>> >
>> > --
>> > Sent from: http://apache-accumulo.1065345.n5.nabble.com/
>> Developers-f3.html
>> >
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to drop the table

Michael Wall
Ok, you shouldn't been hitting that bug I linked since you are running
1.7.2.

What is the table id for the table you are trying to drop?  I am seeing
some duplicates in your fate output.

Can you look at the log for ip-XXXXXinternal:9999 and see if there are
errors or something repeating?

Mike

On Tue, Oct 24, 2017 at 12:53 PM Ravi Teja Kankanala <[hidden email]>
wrote:

> I am running accumulo 1.7.2
>
> When I ran accumulo org.apache.accumulo.master.util.FateAdmin print
>
> This tool has been deprecated
>
> FATE administration now available within 'accumulo shell'
>
> $ fate fail <txid>... | delete <txid>... | print [<txid>...]
>
>
> txid: 2f4a34db8b75eb5b  status: IN_PROGRESS         op: ExportTable      locked:
> [R:1, R:3l]     locking: []              top: WriteExportFiles
>
> txid: 4129f8afbc75ee46  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:4]           top: DeleteTable
>
> txid: 278528f2556667c7  status: IN_PROGRESS         op: RenameTable      locked:
> [R:1]           locking: [W:e]           top: RenameTable
>
> txid: 6077280525d6ccc6  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:i]           top: DeleteTable
>
> txid: 3291ed14d4ef3b70  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:h]           top: DeleteTable
>
> txid: 5bad94142c37acf0  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:5]           top: DeleteTable
>
> txid: 01c9148b565dec3b  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1, W:h]      locking: []              top: CleanUp
>
> txid: 0f4cf2ac81e81420  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:i]           top: DeleteTable
>
> txid: 2193c89247878233  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:e]           top: DeleteTable
>
> txid: 0ec036f35be085d3  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1]           locking: [W:5]           top: DeleteTable
>
> txid: 4edd6822f8c48ef5  status: IN_PROGRESS         op: ExportTable      locked:
> [R:1, R:3t]     locking: []              top: WriteExportFiles
>
> txid: 276294ca8f5a13ec  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1, W:i]      locking: []              top: CleanUp
>
> txid: 1e90b13efb1cc9ae  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1, W:e]      locking: []              top: CleanUp
>
> txid: 5fdee8a97540128b  status: IN_PROGRESS         op: ChangeTableState  locked:
> [R:1]           locking: [W:e]           top: ChangeTableState
>
> txid: 51c0c7b055a2ca42  status: IN_PROGRESS         op: ChangeTableState  locked:
> [R:1]           locking: [W:e]           top: ChangeTableState
>
> txid: 7f80bc339b826e7d  status: IN_PROGRESS         op: ChangeTableState  locked:
> [R:1]           locking: [W:e]           top: ChangeTableState
>
> txid: 3635386bb4179733  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1, W:5]      locking: []              top: CleanUp
>
> txid: 415a00837cf58a6a  status: IN_PROGRESS         op: DeleteTable      locked:
> [R:1, W:4]      locking: []              top: CleanUp
>
> On Tue, Oct 24, 2017 at 10:07 AM, Michael Wall <[hidden email]> wrote:
>
>> What version of Accumulo are you running?  Maybe you are hitting
>> https://issues.apache.org/jira/browse/ACCUMULO-4143?
>>
>> If so, see search the user mailing list for how to fix a hanging droptable
>>
>> Mike
>>
>> On Mon, Oct 23, 2017 at 1:38 PM Josh Elser <[hidden email]> wrote:
>>
>>> Please inspect the Accumulo Master log running on the host identified by
>>> the IP address in the warning message. Look for any Exceptions or ERROR
>>> messages reported in that log file.
>>>
>>> On 10/23/17 12:57 PM, [hidden email] wrote:
>>> > I am getting an error whenever I try to drop the table.
>>> >
>>> > [impl.ThriftTransportPool] WARN : Thread "shell" stuck on IO to
>>> > ip-XXXXXinternal:9999 (0) for at least 120038 ms
>>> >
>>> >
>>> >
>>> > --
>>> > Sent from:
>>> http://apache-accumulo.1065345.n5.nabble.com/Developers-f3.html
>>> >
>>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to drop the table

raviteja.152@gmail.com
Table id with e, but there are many other tables which I want to drop and I
am having issue with _records.

On Tue, Oct 24, 2017 at 11:59 AM, Michael Wall <[hidden email]> wrote:

> Ok, you shouldn't been hitting that bug I linked since you are running
> 1.7.2.
>
> What is the table id for the table you are trying to drop?  I am seeing
> some duplicates in your fate output.
>
> Can you look at the log for ip-XXXXXinternal:9999 and see if there are
> errors or something repeating?
>
> Mike
>
> On Tue, Oct 24, 2017 at 12:53 PM Ravi Teja Kankanala <
> [hidden email]> wrote:
>
>> I am running accumulo 1.7.2
>>
>> When I ran accumulo org.apache.accumulo.master.util.FateAdmin print
>>
>> This tool has been deprecated
>>
>> FATE administration now available within 'accumulo shell'
>>
>> $ fate fail <txid>... | delete <txid>... | print [<txid>...]
>>
>>
>> txid: 2f4a34db8b75eb5b  status: IN_PROGRESS         op: ExportTable      locked:
>> [R:1, R:3l]     locking: []              top: WriteExportFiles
>>
>> txid: 4129f8afbc75ee46  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:4]           top: DeleteTable
>>
>> txid: 278528f2556667c7  status: IN_PROGRESS         op: RenameTable      locked:
>> [R:1]           locking: [W:e]           top: RenameTable
>>
>> txid: 6077280525d6ccc6  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:i]           top: DeleteTable
>>
>> txid: 3291ed14d4ef3b70  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:h]           top: DeleteTable
>>
>> txid: 5bad94142c37acf0  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:5]           top: DeleteTable
>>
>> txid: 01c9148b565dec3b  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1, W:h]      locking: []              top: CleanUp
>>
>> txid: 0f4cf2ac81e81420  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:i]           top: DeleteTable
>>
>> txid: 2193c89247878233  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:e]           top: DeleteTable
>>
>> txid: 0ec036f35be085d3  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1]           locking: [W:5]           top: DeleteTable
>>
>> txid: 4edd6822f8c48ef5  status: IN_PROGRESS         op: ExportTable      locked:
>> [R:1, R:3t]     locking: []              top: WriteExportFiles
>>
>> txid: 276294ca8f5a13ec  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1, W:i]      locking: []              top: CleanUp
>>
>> txid: 1e90b13efb1cc9ae  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1, W:e]      locking: []              top: CleanUp
>>
>> txid: 5fdee8a97540128b  status: IN_PROGRESS         op: ChangeTableState
>> locked: [R:1]           locking: [W:e]           top: ChangeTableState
>>
>> txid: 51c0c7b055a2ca42  status: IN_PROGRESS         op: ChangeTableState
>> locked: [R:1]           locking: [W:e]           top: ChangeTableState
>>
>> txid: 7f80bc339b826e7d  status: IN_PROGRESS         op: ChangeTableState
>> locked: [R:1]           locking: [W:e]           top: ChangeTableState
>>
>> txid: 3635386bb4179733  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1, W:5]      locking: []              top: CleanUp
>>
>> txid: 415a00837cf58a6a  status: IN_PROGRESS         op: DeleteTable      locked:
>> [R:1, W:4]      locking: []              top: CleanUp
>>
>> On Tue, Oct 24, 2017 at 10:07 AM, Michael Wall <[hidden email]> wrote:
>>
>>> What version of Accumulo are you running?  Maybe you are hitting
>>> https://issues.apache.org/jira/browse/ACCUMULO-4143?
>>>
>>> If so, see search the user mailing list for how to fix a hanging
>>> droptable
>>>
>>> Mike
>>>
>>> On Mon, Oct 23, 2017 at 1:38 PM Josh Elser <[hidden email]> wrote:
>>>
>>>> Please inspect the Accumulo Master log running on the host identified by
>>>> the IP address in the warning message. Look for any Exceptions or ERROR
>>>> messages reported in that log file.
>>>>
>>>> On 10/23/17 12:57 PM, [hidden email] wrote:
>>>> > I am getting an error whenever I try to drop the table.
>>>> >
>>>> > [impl.ThriftTransportPool] WARN : Thread "shell" stuck on IO to
>>>> > ip-XXXXXinternal:9999 (0) for at least 120038 ms
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> > Sent from: http://apache-accumulo.1065345.n5.nabble.com/
>>>> Developers-f3.html
>>>> >
>>>>
>>>
>>