Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5378

We are looking for a solution to connect to our Apache phoenix cluster from a node.js external IP.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.7.0
    • Fix Version/s: 4.7.0
    • Component/s: None
    • Flags:
      Patch

      Description

      We are able to connect internally to Apache Phoenix using node.js from the internal cluster that contains more than 30 Virtual machines. We are now trying to connect from my local node.js backend to Apache Phoenix and extract the data.

      We did the following:

      • Imported the configuration files "Hbase-site.xml" and "core-site.xml" and "hdfs-site.xml" from the server,
      • We added a line to read those files like the following:

      jinst.setupClasspath([

      '/usr/local/HBase/lib/phoenix-4.7.0.2.6.4.0-91-client.jar',

      './hdp'

      ])

      }

      • Changed the internal IP address to the external IP address of the Zookeeper server like the following: url: 'jdbc:phoenix:<external_IP>:2181:/hbase-unsecure'

      We start the node.js backend, the connection with the main Zookeeer has been established ,but it is enable to establish connection with some of the one of the nodes with the following error:
      2019-06-26 13:09:06,153 INFO [hconnection-0xea4a92b-shared--pool1-t1] client.RpcRetryingCaller: Call exception, tries=10, retries=35, started=166981 ms ago, cancelled=false, msg=10000 millis timeout while waiting for channel to be ready for connect. ch : java.nio.channels.SocketChannel[connection-pending remote=namenode/10.0.0.4:16020] row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=namenode,16020,1560527811592, seqNum=0

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Zayati Ahmed
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified