Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread ivanybma
Hi, sorry to reply late. that is just a part of my hbase-site.xml. below is the full content: hbase/conf/hbase.site.xml** hbase.rootdir hdfs://broker.xxx-xxx.local:9000/hbase hbase.zookeeper.quorum

Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread Josh Elser
The hbase-site.xml elements you shared earlier, were those your entire hbase-site contents or just part of it? Make sure you have the required properties set as described on https://phoenix.apache.org/secondary_indexing.html for your indexes. If you're still seeing problems, you may need to

Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread ivanybma
thanks for your suggestion. I found something interesting, not sure if that is some potential reason. That is my indexes created on my tables. I created a lot of indexes. After I removed all of the indexes, it seems things went better(no more hanging like that). So I am suspecting there is

Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread Josh Elser
Have you looked at DEBUG logging client and server(HBase) side? The "Call exception" log messages imply that the client is repeatedly trying to issue an RPC to a RegionServer and failing. This should be where you focus your attention. It may be something trivial to fix related to

sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-08 Thread ivanybma
Hi, I got below tricky problem: Situation: I successfully did a upsert into multiple tables with transaction enabled(and there are many index created on these table). Problem: after the fist time upsert done successfully, I tried to do the 2nd, 3rd and next same upsert, sometime, the 2nd