phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Batyrshin Alexander <0x62...@gmail.com>
Subject Re: Table dead lock: ERROR 1120 (XCL20): Writes to table blocked until index can be updated
Date Thu, 20 Sep 2018 18:01:41 GMT
Our setup:
HBase-1.4.7
Phoenix-4.14-hbase-1.4


> On 20 Sep 2018, at 20:19, Batyrshin Alexander <0x62ash@gmail.com> wrote:
> 
>  Hello,
> Looks live we got dead lock with repeating "ERROR 1120 (XCL20)" exception. At this time
all indexes is ACTIVE.
> Can you help to make deeper diagnose?
> 
> java.sql.SQLException: ERROR 1120 (XCL20): Writes to table blocked until index can be
updated. tableName=TBL_MARK
> 	at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:494)
> 	at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
> 	at org.apache.phoenix.execute.MutationState.validateAndGetServerTimestamp(MutationState.java:815)
> 	at org.apache.phoenix.execute.MutationState.validateAll(MutationState.java:789)
> 	at org.apache.phoenix.execute.MutationState.send(MutationState.java:981)
> 	at org.apache.phoenix.execute.MutationState.send(MutationState.java:1514)
> 	at org.apache.phoenix.execute.MutationState.commit(MutationState.java:1337)
> 	at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:670)
> 	at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:666)
> 	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> 	at org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:666)
> 	at x.persistence.phoenix.PhoenixDao.$anonfun$doUpsert$1(PhoenixDao.scala:103)
> 	at scala.util.Try$.apply(Try.scala:209)
> 	at x.persistence.phoenix.PhoenixDao.doUpsert(PhoenixDao.scala:101)
> 	at x.persistence.phoenix.PhoenixDao.$anonfun$batchInsert$2(PhoenixDao.scala:45)
> 	at x.persistence.phoenix.PhoenixDao.$anonfun$batchInsert$2$adapted(PhoenixDao.scala:45)
> 	at scala.collection.immutable.Stream.flatMap(Stream.scala:486)
> 	at scala.collection.immutable.Stream.$anonfun$flatMap$1(Stream.scala:494)
> 	at scala.collection.immutable.Stream.$anonfun$append$1(Stream.scala:252)
> 	at scala.collection.immutable.Stream$Cons.tail(Stream.scala:1169)
> 	at scala.collection.immutable.Stream$Cons.tail(Stream.scala:1159)
> 	at scala.collection.immutable.Stream.length(Stream.scala:309)
> 	at scala.collection.SeqLike.size(SeqLike.scala:105)
> 	at scala.collection.SeqLike.size$(SeqLike.scala:105)
> 	at scala.collection.AbstractSeq.size(Seq.scala:41)
> 	at scala.collection.TraversableOnce.toArray(TraversableOnce.scala:285)
> 	at scala.collection.TraversableOnce.toArray$(TraversableOnce.scala:283)
> 	at scala.collection.AbstractTraversable.toArray(Traversable.scala:104)
> 	at x.persistence.phoenix.PhoenixDao.$anonfun$batchInsert$1(PhoenixDao.scala:45)
> 	at scala.util.Try$.apply(Try.scala:209)
> 	at x.persistence.phoenix.PhoenixDao.batchInsert(PhoenixDao.scala:45)
> 	at x.persistence.phoenix.PhoenixDao.$anonfun$insert$2(PhoenixDao.scala:35)
> 	at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:655)
> 	at scala.util.Success.$anonfun$map$1(Try.scala:251)
> 	at scala.util.Success.map(Try.scala:209)
> 	at scala.concurrent.Future.$anonfun$map$1(Future.scala:289)
> 	at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:29)
> 	at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:29)
> 	at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:60)
> 	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)
> 


Mime
View raw message