[jira] [Created] (PHOENIX-5154) 'Exception thrown when renewing lease' generates java.lang.NullPointerException
Hans Deragon created PHOENIX-5154:
-
Summary: 'Exception thrown when renewing lease' generates
java.lang.NullPointerException
Key: PHOENIX-5154
URL: https://issues.apache.org/jira/browse/PHOENIX-5154
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.14.0
Reporter: Hans Deragon
Got the following under sqlline.py, at the cursor, doing nothing:
{noformat}
0: jdbc:phoenix:> 19/02/21 20:41:16 ERROR query.ConnectionQueryServicesImpl:
Exception thrown when renewing lease
java.lang.NullPointerException
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.setRenew(ScannerCallableWithReplicas.java:101)
at
org.apache.hadoop.hbase.client.ClientScanner.renewLease(ClientScanner.java:571)
at
org.apache.phoenix.iterate.TableResultIterator.renewLease(TableResultIterator.java:284)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$RenewLeaseTask.run(ConnectionQueryServicesImpl.java:4425)
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)
{noformat}
Previously though, I got a lot of timeout exception while performing 'select
count(*) from mytable' while I was inserting in a different terminal 3 000 000
rows into it. These exceptions might be related.
Still, NullPointerException should never happens. There is some bug lingering
somewhere.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Created] (PHOENIX-5110) java.lang.IllegalArgumentException when using hint with delete.
Hans Deragon created PHOENIX-5110:
-
Summary: java.lang.IllegalArgumentException when using hint with
delete.
Key: PHOENIX-5110
URL: https://issues.apache.org/jira/browse/PHOENIX-5110
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.14.0
Reporter: Hans Deragon
Running the following works:
{noformat}
jdbc:phoenix:> select /*+ USE_SORT_MERGE_JOIN */ * from mytable where not
exists (select primarykey from mytable_staging where mytable.primarykey =
mytable_staging.primarykey);
All rows that exist in mytable but do not exist in mytable_staging show
up.{noformat}
Replace 'select' with 'delete', remove the '*' with the hope to delete the
rows. The following error occurs:
{noformat}
jdbc:phoenix:> delete /*+ USE_SORT_MERGE_JOIN */ from mytable where not exists
(select primarykey from mytable_staging where mytable.primarykey =
mytable_staging.primarykey);
java.lang.IllegalArgumentException
at org.apache.phoenix.index.IndexMaintainer.create(IndexMaintainer.java:141)
at org.apache.phoenix.compile.DeleteCompiler.deleteRows(DeleteCompiler.java:216)
at org.apache.phoenix.compile.DeleteCompiler.access$000(DeleteCompiler.java:98)
at
org.apache.phoenix.compile.DeleteCompiler$ClientSelectDeleteMutationPlan.execute(DeleteCompiler.java:937)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1825)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:813)
at sqlline.SqlLine.begin(SqlLine.java:686)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:291){noformat}
Using: *phoenix-4.14.0-1.amzn1.noarch*
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
