What is the way to remove tablets that still exist in accumulo but do not have an online, offline or deleting table?
Some of these tablets say ASSIGNED TO DEAD SERVER but the tserver they refer to is up and working properly. From: Hart, Andrew <[email protected]> Sent: 25 September 2020 13:52 To: [email protected] Subject: RE: Continuous tablets unloaded and fails to balance from accumulo master EXTERNAL SENDER: Do not click any links or open any attachments unless you trust the sender and know the content is safe. EXPÉDITEUR EXTERNE: Ne cliquez sur aucun lien et n’ouvrez aucune pièce jointe à moins qu’ils ne proviennent d’un expéditeur fiable, ou que vous ayez l'assurance que le contenu provient d'une source sûre. Thanks for your help. In looking for this I think I have found that there are deleted tables that still have a lot of tablets in the metadata table. I need to solve that before coming back to find the 1 unloaded tablet. Cheers And. From: Mike Miller <[email protected]<mailto:[email protected]>> Sent: 24 September 2020 16:08 To: [email protected]<mailto:[email protected]> Subject: Re: Continuous tablets unloaded and fails to balance from accumulo master EXTERNAL SENDER: Do not click any links or open any attachments unless you trust the sender and know the content is safe. EXPÉDITEUR EXTERNE: Ne cliquez sur aucun lien et n’ouvrez aucune pièce jointe à moins qu’ils ne proviennent d’un expéditeur fiable, ou que vous ayez l'assurance que le contenu provient d'une source sûre. That might be OK, could just mean it hasn't been assigned yet. The only way I can think of is to populate a list of all tablets from the metadata table and find the one without a "loc" column family. On Thu, Sep 24, 2020 at 10:55 AM Hart, Andrew <[email protected]<mailto:[email protected]>> wrote: No, no future entries in the table. From: Mike Miller <[email protected]<mailto:[email protected]>> Sent: 24 September 2020 15:10 To: [email protected]<mailto:[email protected]> Subject: Re: Continuous tablets unloaded and fails to balance from accumulo master EXTERNAL SENDER: Do not click any links or open any attachments unless you trust the sender and know the content is safe. EXPÉDITEUR EXTERNE: Ne cliquez sur aucun lien et n’ouvrez aucune pièce jointe à moins qu’ils ne proviennent d’un expéditeur fiable, ou que vous ayez l'assurance que le contenu provient d'une source sûre. You should be able to figure out the unloaded tablet from the "accumulo.metadata" table. The metadata table will list the tablet location using the "loc" column family to indicate it has loaded a tablet that it was assigned. For example the tablet "n;9" will have an entry like: n;9 loc:1000041fbf00006 [] ip-172-31-87-51.ec2.internal:9997 From my understanding, the unloaded tablet should have a "future" column family, meaning it has been assigned a new location but not loaded yet. If the tablet doesn't have a "loc" or "future" column family then that is a problem. On Thu, Sep 24, 2020 at 6:32 AM Hart, Andrew <[email protected]<mailto:[email protected]>> wrote: Hi, I am getting “Not balancing due to 1 outstanding migrations” and “[Normal tablets]: 1 tablets unloaded”. This means that the cluster never balances unless I restart the master, after which I get a 1 off balance and then it returns to the above messages. How do I identify the tablet that is unloaded? It isn’t in the logs that I can see. Is it possible to tell from the contents of the accumulo.metadata table? Is there a way to use FindOfflineTablets? And.
