Member since
12-17-2018
14
Posts
0
Kudos Received
0
Solutions
06-18-2019
09:25 AM
Hi @Gevorg KHACHATURYAN java.sql.SQLException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Can't get the location for replica 0 at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2492) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2384) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2384) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at com.petpe.util.PhoenixConnection.getConnnection(PhoenixConnection.java:26) at com.petpe.hbase.utill.ManageAccessMangement.getHbaseUser(ManageAccessMangement.java:363) at com.petpe.users.action.UsersAction.userLogin(UsersAction.java:541) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) I am getting database connectivity issue and i checked all the configurations and properties,still i am facing this issue.what else i need to do. Can u suggest me???? Thanks in advance.
... View more
04-11-2019
09:55 AM
Hey Apoorva, You performance stats are pretty good. My Cluster load is like it takes 400,000 records in 1min through Phoenix. I have made some config changes but didn't achieve what I need. Can you please help me out. I use a 3 Node Cluster with 64GB RAM and 8 Core processor. Please help me out.
... View more
01-08-2019
08:57 AM
No still working on it.
... View more
01-08-2019
08:55 AM
@Geoffrey Shelton Okot Ok! Thank You for your suggestions. Is there any way to recover the system back in my present situation??
... View more
01-07-2019
05:04 PM
@Geoffrey Shelton Thank you for your response. As i said unexpectedly it is showing above attached page .i.e., it is a displaying a page that when we open ambari UI on 8080 port for the 1st time immediately after setting up the ambari-server . we didn't took the ambari database backup previously .will it help if we do it now.
... View more
01-07-2019
03:17 PM
I have a ambari single node cluster.But unfortunately it was reset by mistake ,now i am getting the below page(refer pic attached). capture.png how can i revert back my server
... View more
Labels:
01-07-2019
12:45 PM
Both the servers are in different security groups and VPC's.
... View more
01-03-2019
02:29 PM
I am trying to connect from a server in AWS in one security group to server in AWS which is in another security group. I am using public FQDN in phoenix jdbc url and I opened corresponding port in AWS. -->i am able to ping and telnet with port i am using to corresponding host which i am connecting to .
... View more
01-03-2019
11:14 AM
I have posted the related details U have asked for can u kindly refer that n provide some suggestions. I have uploaded the error logs please find the post in answers above
... View more
01-02-2019
10:58 AM
@Geoffrey Shelton Okot We are using 3 -node cluster out of 2 are edge node and 1 is master node . i am trying to connect to phoenix using edge node using JDBC connection to a server which is in another network but i'm unable to connect to Phoenix and getting TimOutException and SQL exception. Can u please help me in resolving this issue.. Thanks, Teja
... View more
12-28-2018
06:47 PM
Can we install pheonix client in different server where hbase is not installed ?if yes how to install?
... View more
12-28-2018
10:47 AM
I'm trying to connect to Phoenix query server from my application which is deployed on a server which is another network using JDBC Zookeeper URL, I'm getting connection timeout.error, How do i resolve it??
... View more
12-17-2018
04:05 PM
Can you please explain the solution in detail?
... View more