Localhost Port: 9093>Connection refused


#1

During the installation facing this issue and not able to access the MAPD database. Same issue observed in two separate server installations.

Details are as following
OS : CentOS Linux release 7.4.1708 (Core)
3.10.0-693.21.1.el7.x86_64

Firewall Status
[root@homecentos ]# service firewalld status
Redirecting to /bin/systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
[root@homecentos ]#

[root@homecentos mapd]# service mapd_server status
Redirecting to /bin/systemctl status mapd_server.service
● mapd_server.service - MapD database server
Loaded: loaded (/usr/lib/systemd/system/mapd_server.service; enabled; vendor preset: disabled)
Active: active (running) since Sat 2018-04-21 00:04:37 EDT; 48s ago
Main PID: 15458 (mapd_server)
CGroup: /system.slice/mapd_server.service
├─15458 /opt/mapd/bin/mapd_server --config /var/lib/mapd/mapd.conf
└─15468 -Xmx1024m -jar /opt/mapd/bin/calcite-1.0-SNAPSHOT-jar-with-dependencies.jar -e /opt/mapd/QueryEngine/ -d /var/lib/mapd/data -p 9093 -m 9091

Apr 21 00:04:37 homecentos systemd[1]: Started MapD database server.
Apr 21 00:04:37 homecentos systemd[1]: Starting MapD database server…
Apr 21 00:04:37 homecentos mapd_server[15458]: E0421 00:04:37.867332 15458 MapDHandler.cpp:154] This build isn’t CUDA enabled, will run on CPU
Apr 21 00:04:37 homecentos mapd_server[15458]: Thrift: Sat Apr 21 00:04:37 2018 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
Apr 21 00:04:37 homecentos mapd_server[15458]: Thrift: Sat Apr 21 00:04:37 2018 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
Apr 21 00:04:38 homecentos mapd_server[15458]: E0421 00:04:38.110381 15458 MapDHandler.cpp:186] No GPUs detected, falling back to CPU mode
[root@homecentos mapd]#

[root]# cat /var/lib/mapd/mapd.conf
port = 9091
http-port = 9090
data = “/var/lib/mapd/data”
null-div-by-zero = true

[web]
port = 9092
frontend = “/opt/mapd/frontend”
[root ]#


#2

check if calcite process is running on machine

netstat -tulpn | grep 9093
tcp6 0 0 :::9093 :::* LISTEN 9553/-Xmx1024m
mapd@zion-ubuntu:~$ ps -ef | grep 9553
mapd 9553 9507 0 apr12 ? 00:02:15 -Xmx1024m -jar /opt/mapd/mapd-ce-3.6.0-20180313-7a75b56-Linux-x86_64-render/bin/calcite-1.0-SNAPSHOT-jar-with-dependencies.jar -e /opt/mapd/mapd-ce-3.6.0-20180313-7a75b56-Linux-x86_64-render/QueryEngine/ -d /opt/mapd_storage/data -p 9093 -m 9091

does the installation process with yum has installed the open jdk headless package?

if not try to install by youself with

sudo yum install java-1.8.0-openjdk-headless

i installed the mapd cpu only on a centos withput any problem, but i always use the tarball version, so i am not sure if i am pointing you in the right direction


#3

Hi

@sumit this warning should not be stopping you from doing anything and often happens when starting up mapd.

Can you try running a query and see if things work.

Basically the steps of what are going on here are:

  1. MapD Server starts up
  2. MapD Server execl the calcite server
  3. MapD server starts 'ping’ing the calcite server to see if it is ready
  4. if the calcite server is not ready the thrift connection prints out that message (we think we can better control the noise from thrift in next release 11.)
  5. keep trying until the ping comes back
  6. when ping comes back successfully Mapd Server continues

The mapd_server.INFO log will have some lines like

I0420 09:54:10.730723 32086 Calcite.cpp:178] Creating Calcite Handler,  Calcite Port is 9093 base data dir is data
I0420 09:54:10.730727 32086 Calcite.cpp:113] Running calcite server as a daemon
I0420 09:54:10.941785 32086 Calcite.cpp:142] Calcite server start took 200 ms 
I0420 09:54:10.941817 32086 Calcite.cpp:143] ping took 9 ms 

reporting how long it took for the server to come up

Please confirm you can run a query.

If not, please share the <data>/mapd_logs/mapd_server.LOG

regards


#4

[root@homecentos ~]# netstat -tulpn| grep 9093
tcp6 0 0 :::9093 :::* LISTEN 1597/-Xmx1024m
[root@homecentos ~]# ps -ef| grep 9553
root 7108 3777 0 13:52 pts/1 00:00:00 grep --color=auto 9553
[root@homecentos ~]#


#5

I0421 00:10:05.314409 1591 Calcite.cpp:174] Creating Calcite Handler, Calcite Port is 9093 base data dir is /var/lib/mapd/data
I0421 00:10:05.314433 1591 Calcite.cpp:113] Running calcite server as a daemon
I0421 00:10:05.755237 1591 Calcite.cpp:142] Calcite server start took 200 ms
I0421 00:10:05.755264 1591 Calcite.cpp:143] ping took 238 ms


#6

Hi all,

I get connected to to mapdql

Thanks for all your support and quick response . will proceed with MAPD documentation to check the features.


#7

If the process is listening there aren’t problems as dwainberry said :wink: