[ 
https://issues.apache.org/jira/browse/PHOENIX-5610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16994283#comment-16994283
 ] 

Lars Hofhansl commented on PHOENIX-5610:
----------------------------------------

I tried to run the SQL script against a phoenix sandbox (see 
bin/phoenix_sandbox.py).

But now for an older client I get:
{code:java}
19/12/11 22:08:38 WARN client.HTable: Error calling coprocessor service 
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService for row 
\x00\x00TEST_1
java.util.concurrent.ExecutionException: 
org.apache.hadoop.hbase.DoNotRetryIOException: 
org.apache.hadoop.hbase.DoNotRetryIOException: ERROR 0 (08001): No suitable 
driver found for jdbc:phoenix:localhost:56930:/hbase;test=true; TEST_1
        at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:113)
        at 
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:2078)
        at 
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:17218)
        at 
org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:8523)
        at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2282)
        at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2264)
        at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:36808)
        at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2399)
        at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124)
        at 
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:311)
        at 
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:291)
Caused by: java.sql.SQLException: No suitable driver found for 
jdbc:phoenix:localhost:56930:/hbase;test=true;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.util.QueryUtil.getConnection(QueryUtil.java:374)
        at 
org.apache.phoenix.util.QueryUtil.getConnectionOnServer(QueryUtil.java:351)
        at 
org.apache.phoenix.util.QueryUtil.getConnectionOnServer(QueryUtil.java:331)
        at 
org.apache.phoenix.util.ViewUtil.getSystemTableForChildLinks(ViewUtil.java:244)
        at 
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1734)
        ... 9 more

{code}
In the Sandbox process.

If we fixed that, we add a simple script for basic backwards compatibility 
testing.

> 4.14 client dropped table but raised ArrayIndexOutOfBoundsException on 4.15 
> server 
> -----------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5610
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5610
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.15.0
>            Reporter: Xinyi Yan
>            Assignee: Lars Hofhansl
>            Priority: Blocker
>             Fix For: 4.15.0
>
>         Attachments: 5610-4.x-HBase-1.5-v2.txt, 5610-4.x-HBase-1.5.txt, 
> Screen Shot 2019-12-10 at 5.15.35 PM.png, Screen Shot 2019-12-10 at 5.24.05 
> PM.png
>
>
> I created a multi-tenant table and a global view on the 4.15 server 
> (hbase1.3.3) from a 4.15 client and then tried to drop the global view from 
> the 4.14 client. The 4.14 client raised ArrayIndexOutOfBoundsException, even 
> though it dropped the global view. I uploaded two screenshots for 4.15 and 
> 4.14 clients along with reproducing steps.
>  
> Command to reproduce :
> 4.15 client:
> CREATE TABLE A (TENANT_ID VARCHAR(15) NOT NULL, A BIGINT NOT NULL, B BIGINT 
> CONSTRAINT PK PRIMARY KEY (TENANT_ID, A)) MULTI_TENANT=true;
> CREATE VIEW B(C BIGINT) AS SELECT * FROM A;
> 4.14 client:
> DROP VIEW B;
>  
> !Screen Shot 2019-12-10 at 5.15.35 PM.png|width=600, height=300!
>  
> !Screen Shot 2019-12-10 at 5.24.05 PM.png|width=600, height=300!



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

Reply via email to