[
https://issues.apache.org/jira/browse/PHOENIX-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974712#comment-16974712
]
Hadoop QA commented on PHOENIX-5545:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12985897/PHOENIX-5545-4.x-HBase-1.3-v4.patch
against 4.x-HBase-1.3 branch at commit
a078ed2f677720591a59a540b48e04a20bc080d1.
ATTACHMENT ID: 12985897
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:red}-1 tests included{color}. The patch doesn't appear to include
any new or modified tests.
Please justify why no new tests are needed for this
patch.
Also please list what manual steps were performed to
verify this patch.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 lineLengths{color}. The patch does not introduce lines
longer than 100
{color:red}-1 core tests{color}. The patch failed these unit tests:
Test results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/3134//testReport/
Console output:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/3134//console
This message is automatically generated.
> DropChildViews Task fails for a base table when its child view has an index
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-5545
> URL: https://issues.apache.org/jira/browse/PHOENIX-5545
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0, 5.1.0
> Reporter: Chinmay Kulkarni
> Assignee: Chinmay Kulkarni
> Priority: Major
> Fix For: 4.15.0, 5.1.0
>
> Attachments: PHOENIX-5545-4.x-HBase-1.3-v1.patch,
> PHOENIX-5545-4.x-HBase-1.3-v2.patch, PHOENIX-5545-4.x-HBase-1.3-v3.patch,
> PHOENIX-5545-4.x-HBase-1.3-v4.patch
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> 1) Start the HBase server with 4.15.0 Phoenix
> 2) Connect with a 4.15.0 client
> 3) Create a base table and a view on top of the base table and create an
> index on top of this view:
> {code:sql}
> CREATE TABLE IF NOT EXISTS Z_BASE_TABLE (ID INTEGER NOT NULL PRIMARY KEY,
> HOST VARCHAR(10), FLAG BOOLEAN);
> CREATE VIEW Z_VIEW1 (col1 INTEGER, col2 INTEGER, col3 INTEGER, col4 INTEGER,
> col5 INTEGER) AS SELECT * FROM Z_BASE_TABLE WHERE ID>10;
> CREATE INDEX V_I ON Z_VIEW1(COL4);
> {code}
> 4) Drop the base table with the cascade option:
> {code:sql}
> DROP TABLE Z_BASE_TABLE CASCADE;
> {code}
> 5) DropChildViewsTask gets added to the SYSTEM.TASK table as expected, but
> when it gets scheduled and subsequently executed, it fails with the following
> exception:
> {code:java}
> 2019-10-24 22:44:34,214 ERROR [pool-121-thread-1] tasks.DropChildViewsTask:
> Exception while dropping a child view task. null.Z_BASE_TABLE with tenant id
> IS NULL and timestamp 292278994-08-16 23:12:55.807
> org.apache.phoenix.exception.PhoenixIOException: Z_BASE_TABLE
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.flushTable(ConnectionQueryServicesImpl.java:4442)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.flushParentPhysicalTable(ConnectionQueryServicesImpl.java:1922)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.dropTable(ConnectionQueryServicesImpl.java:1888)
> at
> org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:3152)
> at
> org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:3060)
> at org.apache.phoenix.util.ViewUtil.dropChildViews(ViewUtil.java:207)
> at
> org.apache.phoenix.coprocessor.tasks.DropChildViewsTask.run(DropChildViewsTask.java:60)
> 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:204)
> 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)
> Caused by: org.apache.hadoop.hbase.TableNotFoundException: Z_BASE_TABLE
> at
> org.apache.hadoop.hbase.client.HBaseAdmin.checkTableExists(HBaseAdmin.java:2863)
> at org.apache.hadoop.hbase.client.HBaseAdmin.flush(HBaseAdmin.java:1904)
> at org.apache.hadoop.hbase.client.HBaseAdmin.flush(HBaseAdmin.java:1949)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.flushTable(ConnectionQueryServicesImpl.java:4440)
> ... 18 more
> {code}
> Note that this marks the DropChildViews task for the base table as failed and
> so *if the base table has any other views, those views will also not be
> dropped*.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
