Re: Table dead lock: ERROR 1120 (XCL20): Writes to table blocked until index can be updated

2018-09-26 Thread Vincent Poon
We are planning a Phoenix 4.14.1 release which will have this fix On Wed, Sep 26, 2018 at 3:36 PM Batyrshin Alexander <0x62...@gmail.com> wrote: > Thank you. We will try somehow... > Is there any chance that this fix will be included in next release for > HBASE-1.4 (not 2.0)? > > On 27 Sep 2018,

Re: Table dead lock: ERROR 1120 (XCL20): Writes to table blocked until index can be updated

2018-09-26 Thread Batyrshin Alexander
Thank you. We will try somehow... Is there any chance that this fix will be included in next release for HBASE-1.4 (not 2.0)? > On 27 Sep 2018, at 01:04, Ankit Singhal wrote: > > You might be hitting PHOENIX-4785 > , you can apply the patch

Re: Table dead lock: ERROR 1120 (XCL20): Writes to table blocked until index can be updated

2018-09-26 Thread Ankit Singhal
You might be hitting PHOENIX-4785 , you can apply the patch on top of 4.14 and see if it fixes your problem. Regards, Ankit Singhal On Wed, Sep 26, 2018 at 2:33 PM Batyrshin Alexander <0x62...@gmail.com> wrote: > Any advices? Helps? > I can

Re: Table dead lock: ERROR 1120 (XCL20): Writes to table blocked until index can be updated

2018-09-26 Thread Batyrshin Alexander
Any advices? Helps? I can reproduce problem and capture more logs if needed. > On 21 Sep 2018, at 02:13, Batyrshin Alexander <0x62...@gmail.com> wrote: > > Looks like lock goes away 30 minutes after index region split. > So i can assume that this issue comes from cache that configured by this >

Re: org.apache.phoenix.shaded.org.apache.thrift.TException: Unable to discover transaction service. -> TException: Unable to discover transaction service.

2018-09-26 Thread Josh Elser
If you're using HBase with Hadoop3, HBase should have Hadoop3 jars. Re-build HBase using the -Dhadoop.profile=3.0 (I think it is) CLI option. On 9/26/18 7:21 AM, Francis Chuang wrote: Upon further investigation, it appears that this is because

Re: org.apache.phoenix.shaded.org.apache.thrift.TException: Unable to discover transaction service. -> TException: Unable to discover transaction service.

2018-09-26 Thread Francis Chuang
Upon further investigation, it appears that this is because org.apache.hadoop.security.authentication.util.KerberosUtil.hasKerberosKeyTab is only available in Hadoop 2.8+. HBase ships with Hadoop 2.7.4 jars. I noticed that Hadoop was bumped from 2.7.4 to 3.0.0 a few months ago to fix

Re: org.apache.phoenix.shaded.org.apache.thrift.TException: Unable to discover transaction service. -> TException: Unable to discover transaction service.

2018-09-26 Thread Francis Chuang
I wonder if this is because: - HBase's binary distribution ships with Hadoop 2.7.4 jars. - Phoenix 5.0.0 has Hadoop 3.0.0 declared in its pom.xml: https://github.com/apache/phoenix/blob/8a819c6c3b4befce190c6ac759f744df511de61d/pom.xml#L70 - Tephra has Hadoop 2.2.0 declared in its pom.xml:

org.apache.phoenix.shaded.org.apache.thrift.TException: Unable to discover transaction service. -> TException: Unable to discover transaction service.

2018-09-26 Thread Francis Chuang
Hi all, I am using Phoenix 5.0.0 with HBase 2.0.0. I am seeing errors while trying to create transactional tables using Phoenix. I am using my Phoenix + HBase all in one docker image available here: https://github.com/Boostport/hbase-phoenix-all-in-one This is the error: