[jira] [Created] (PHOENIX-5639) Exception during DROP TABLE CASCADE with VIEW and INDEX

["Lars Hofhansl (Jira)" <ji...@apache.org>]

Lars Hofhansl created PHOENIX-5639:
--------------------------------------

             Summary: Exception during DROP TABLE CASCADE with VIEW and INDEX
                 Key: PHOENIX-5639
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5639
             Project: Phoenix
          Issue Type: Test
            Reporter: Lars Hofhansl
             Fix For: 4.15.1


{code:java}
> CREATE TABLE TEST_5 (ID INTEGER NOT NULL PRIMARY KEY, HOST VARCHAR(10), FLAG BOOLEAN);

> CREATE VIEW TEST_5_VIEW (col1 INTEGER, col2 INTEGER, col3 INTEGER, col4 INTEGER, col5 INTEGER) AS SELECT * FROM TEST_5 WHERE ID>10;

> CREATE INDEX TEST_5_INDEX ON TEST_5_VIEW(COL4);

> DROP TABLE test_5 CASCASE;{code}
Table, view, and index are dropped, but in the server's log I see:
{code:java}
19/12/18 07:17:41 WARN iterate.BaseResultIterators: Unable to find parent table "TEST_5_VIEW" of table "TEST_5_INDEX" to determine USE_STATS_FOR_PARALLELIZATION
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=TEST_5_VIEW
        at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:73)
        at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.java:584)
        at org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil.getStatsForParallelizationProp(PhoenixConfigurationUtil.java:712)
        at org.apache.phoenix.iterate.BaseResultIterators.<init>(BaseResultIterators.java:513)
        at org.apache.phoenix.iterate.ParallelIterators.<init>(ParallelIterators.java:62)
        at org.apache.phoenix.iterate.ParallelIterators.<init>(ParallelIterators.java:69)
        at org.apache.phoenix.execute.AggregatePlan.newIterator(AggregatePlan.java:287)
        at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:365)
        at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:217)
        at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:212)
        at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:207)
        at org.apache.phoenix.compile.PostDDLCompiler$PostDDLMutationPlan.execute(PostDDLCompiler.java:273)
        at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:4426)
        at org.apache.phoenix.query.DelegateConnectionQueryServices.updateData(DelegateConnectionQueryServices.java:166)
        at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:3238)
        at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:3055)
        at org.apache.phoenix.util.ViewUtil.dropChildViews(ViewUtil.java:218)
        at org.apache.phoenix.coprocessor.tasks.DropChildViewsTask.run(DropChildViewsTask.java:63)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.phoenix.coprocessor.TaskRegionObserver$SelfHealingTask.run(TaskRegionObserver.java:203)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)