phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Phoenix admin?
Date Sat, 24 Feb 2018 03:09:45 GMT
Nope, no tools down in Phoenix.

You can just use the normal `alter` command in the HBase shell to clean 
it up.

On 2/22/18 10:04 PM, Reid Chan wrote:
> Hi team,
> 
> I created a table through HBase api, and then created a view for it on 
> Phoenix.
> And for some reasons, i dropped the view, but coprocessors are still 
> attached on this table.
> 
>  From hbase webui:
> 'recommend:vulgar_feed', {TABLE_ATTRIBUTES => {coprocessor$1 => 
> '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', 
> coprocessor$2 => 
> '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|805306366|', 
> coprocessor$3 => 
> '|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|805306366|', 
> coprocessor$4 => 
> '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|'}, 
> {NAME => 'b'}
> 
>  From regionserver log:
> 2018-02-16 17:42:50,022 WARN 
> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver: Unable 
> to collect stats for recommend:vulgar_feed
> java.io.IOException: Unable to initialize the guide post depth
>          at 
> org.apache.phoenix.schema.stats.DefaultStatisticsCollector.init(DefaultStatisticsCollector.java:369)
>          at 
> org.apache.phoenix.schema.stats.DefaultStatisticsCollector.createCompactionScanner(DefaultStatisticsCollector.java:359)
>          at 
> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver$2.run(UngroupedAggregateRegionObserver.java:923)
>          at 
> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver$2.run(UngroupedAggregateRegionObserver.java:912)
>          at java.security.AccessController.doPrivileged(Native Method)
>          at javax.security.auth.Subject.doAs(Subject.java:422)
>          at 
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>          at 
> org.apache.hadoop.security.SecurityUtil.doAsUser(SecurityUtil.java:445)
>          at 
> org.apache.hadoop.security.SecurityUtil.doAsLoginUser(SecurityUtil.java:426)
>          at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
>        at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>          at java.lang.reflect.Method.invoke(Method.java:498)
>          at org.apache.hadoop.hbase.util.Methods.call(Methods.java:39)
>          at 
> org.apache.hadoop.hbase.security.User.runAsLoginUser(User.java:210)
> at 
> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.preCompact(UngroupedAggregateRegionObserver.java:912)
>          at 
> org.apache.hadoop.hbase.coprocessor.BaseRegionObserver.preCompact(BaseRegionObserver.java:195)
>          at 
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$9.call(RegionCoprocessorHost.java:595)
>          at 
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1673)
>          at 
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1749)
>          at 
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1722)
>          at 
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.preCompact(RegionCoprocessorHost.java:590)
>          at 
> org.apache.hadoop.hbase.regionserver.compactions.Compactor.postCreateCoprocScanner(Compactor.java:253)
>          at 
> org.apache.hadoop.hbase.regionserver.compactions.DefaultCompactor.compact(DefaultCompactor.java:94)
>          at 
> org.apache.hadoop.hbase.regionserver.DefaultStoreEngine$DefaultCompactionContext.compact(DefaultStoreEngine.java:119)
>          at 
> org.apache.hadoop.hbase.regionserver.HStore.compact(HStore.java:1223)
>          at 
> org.apache.hadoop.hbase.regionserver.HRegion.compact(HRegion.java:1856)
>          at 
> org.apache.hadoop.hbase.regionserver.CompactSplitThread$CompactionRunner.doCompaction(CompactSplitThread.java:526)
>          at 
> org.apache.hadoop.hbase.regionserver.CompactSplitThread$CompactionRunner.run(CompactSplitThread.java:562)
>          at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>          at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>          at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 
> (42M03): Table undefined. tableName=recommend.vulgar_feed
>          at 
> org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:71)
>          at 
> org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.java:575)
>          at 
> org.apache.phoenix.util.PhoenixRuntime.getTable(PhoenixRuntime.java:444)
>          at 
> org.apache.phoenix.schema.stats.DefaultStatisticsCollector.initGuidepostDepth(DefaultStatisticsCollector.java:160)
>          at 
> org.apache.phoenix.schema.stats.DefaultStatisticsCollector.init(DefaultStatisticsCollector.java:367)
> 
> 
> My question is, is it possible to drop those coprocessors through 
> like phoenix admin, or some tools i missed? Although no harm done, i 
> just think this drop not clean enough...

Mime
View raw message