MapD core: problem connecting to mapd server


#1

Hi,

I have been trying to use mapd, I started with running the provided script startmapd,
But I get:

Thrift: Thu Dec 21 21:22:08 2017 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
Thrift: Thu Dec 21 21:22:08 2017 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
E1221 21:22:09.098605 11226 MapDHandler.cpp:178] No GPUs detected, falling back to CPU mode

And it gets stuck there. I tried to visit http://localhost:9092 for mapd immerse, the page loads, but when I click connect, it gives: *Error: Unable to connect to Hostname or Port

I also tried to start mapdql manually as documented in the readme file, but I have the same problem.

I run the mapd_server as well as mapd_web_server, when I run insert_sample_data, it copies the data but then the connection breaks:

User mapd connected to database mapd
Thrift: Thu Dec 21 21:56:25 2017 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
Thrift: Thu Dec 21 21:56:25 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift error: connect() failed: Connection refused
Thrift: Thu Dec 21 21:56:25 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift error: connect() failed: Connection refused
Thrift: Thu Dec 21 21:56:25 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
Thrift error: connect() failed: Connection refused
- inserting file: /home/david/mapd/mapd-core/build/sample_datasets/flights_2008_10k/flights_2008_10k.csv
Thrift: Thu Dec 21 21:56:25 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
terminate called after throwing an instance of ‘apache::thrift::transport::TTransportException’
what(): connect() failed: Connection refused
…/insert_sample_data: line 104: 11694 Done echo "copy table from '{csv}’ with (quoted=‘true’);"
11695 Aborted (core dumped) | ./bin/mapdql mapd -u mapd -p HyperInteractive --port “$MAPD_TCP_PORT”

This is the log for using startmapd script:

Log file created at: 2017/12/21 21:22:08
Running on machine: david-System-Product-Name
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
I1221 21:22:08.764114 11226 MapDServer.cpp:511] MapD started with data directory at 'data’
I1221 21:22:08.764472 11226 MapDServer.cpp:518] Watchdog is set to 1
I1221 21:22:08.764503 11226 MapDServer.cpp:540] cuda block size 0
I1221 21:22:08.764521 11226 MapDServer.cpp:541] cuda grid size 0
I1221 21:22:08.764549 11226 MapDServer.cpp:542] calcite JVM max memory 1024
I1221 21:22:08.764564 11226 MapDServer.cpp:543] MapD Server Port 9091
I1221 21:22:08.765125 11226 MapDServer.cpp:544] MapD Calcite Port 9093
I1221 21:22:08.765261 11226 MapDHandler.cpp:139] MapD Server 3.3.2dev-20171220-ad361a0
E1221 21:22:08.765310 11226 MapDHandler.cpp:146] This build isn’t CUDA enabled, will run on CPU
I1221 21:22:08.765694 11226 DataMgr.cpp:120] cpuSlabSize is 4096M
I1221 21:22:08.766427 11226 FileMgr.cpp:173] Completed Reading table’s file metadata, Elasped time : 0ms Epoch: 0 files read: 0 table location: 'data/mapd_data/table_0_0/'
I1221 21:22:08.766528 11226 Calcite.cpp:156] Creating Calcite Handler, Calcite Port is 9093 base data dir is data
I1221 21:22:08.766556 11226 Calcite.cpp:95] Running calcite server as a daemon
I1221 21:22:09.089257 11226 Calcite.cpp:124] Calcite server start took 300 ms
I1221 21:22:09.089439 11226 Calcite.cpp:125] ping took 16 ms
I1221 21:22:09.097934 11226 Calcite.cpp:299] [{“name”:“Tan”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__”,“ret”:“float”,“args”:[“float”,“i32”]},{“name”:“ln”,“ret”:“double”,“args”:[“double”]},{“name”:“distance_in_meters__”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“Floor__”,“ret”:“float”,“args”:[“float”]},{“name”:“Floor__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Floor__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“rect_pixel_bin”,“ret”:“float”,“args”:[“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Truncate”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“Floor__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“radians”,“ret”:“double”,“args”:[“double”]},{“name”:“degrees”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil__”,“ret”:“float”,“args”:[“float”]},{“name”:“ln__”,“ret”:“double”,“args”:[“float”]},{“name”:“approx_distance_in_meters”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“reg_hex_vert_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“reg_hex_vert_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Ceil__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Ceil__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“Ceil__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“power”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“conv_4326_900913_x”,“ret”:“double”,“args”:[“double”]},{“name”:“reg_hex_horiz_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“conv_4326_900913_y”,“ret”:“double”,“args”:[“double”]},{“name”:“Atan”,“ret”:“double”,“args”:[“double”]},{“name”:“reg_hex_horiz_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Floor”,“ret”:“double”,“args”:[“double”]},{“name”:“Log10”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__1”,“ret”:“i16”,“args”:[“i16”,“i32”]},{“name”:“Truncate__2”,“ret”:“i32”,“args”:[“i32”,“i32”]},{“name”:“Log”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__3”,“ret”:“i64”,“args”:[“i64”,“i32”]},{“name”:“Cos”,“ret”:“double”,“args”:[“double”]},{“name”:“Log__”,“ret”:“double”,“args”:[“float”]},{“name”:“Log10__”,“ret”:“double”,“args”:[“float”]},{“name”:“Asin”,“ret”:“double”,“args”:[“double”]},{“name”:“Cot”,“ret”:“double”,“args”:[“double”]},{“name”:“Tan__”,“ret”:“double”,“args”:[“float”]},{“name”:“rect_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“i32”]},{“name”:“rect_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“i32”]},{“name”:“distance_in_meters”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”]},{“name”:“round_to_digit”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“Atan2”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“Acos”,“ret”:“double”,“args”:[“double”]},{“name”:“pi”,“ret”:“double”,“args”:[]},{“name”:“Sin”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil”,“ret”:“double”,“args”:[“double”]},{“name”:“Exp”,“ret”:“double”,“args”:[“double”]}]
E1221 21:22:09.098605 11226 MapDHandler.cpp:178] No GPUs detected, falling back to CPU mode
I1221 21:22:09.098675 11226 MapDHandler.cpp:187] Started in CPU mode
I1221 21:22:51.814543 11264 MapDHandler.cpp:325] User mapd connected to database mapd
I1221 21:22:54.563419 11264 MapDHandler.cpp:335] User mapd disconnected from database mapd
I1221 21:22:54.590219 11264 MapDHandler.cpp:325] User mapd connected to database mapd
I1221 21:39:51.859426 11226 MapDServer.cpp:127] Interrupt signal (15) received.

And this is the log for using mapdql manually:

Log file created at: 2017/12/21 21:56:08
Running on machine: david-System-Product-Name
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
I1221 21:56:08.100750 11657 MapDServer.cpp:511] MapD started with data directory at 'data’
I1221 21:56:08.101120 11657 MapDServer.cpp:518] Watchdog is set to 1
I1221 21:56:08.101147 11657 MapDServer.cpp:540] cuda block size 0
I1221 21:56:08.101161 11657 MapDServer.cpp:541] cuda grid size 0
I1221 21:56:08.101181 11657 MapDServer.cpp:542] calcite JVM max memory 1024
I1221 21:56:08.101193 11657 MapDServer.cpp:543] MapD Server Port 9091
I1221 21:56:08.101636 11657 MapDServer.cpp:544] MapD Calcite Port 9093
I1221 21:56:08.101724 11657 MapDHandler.cpp:139] MapD Server 3.3.2dev-20171220-ad361a0
E1221 21:56:08.101760 11657 MapDHandler.cpp:146] This build isn’t CUDA enabled, will run on CPU
I1221 21:56:08.102110 11657 DataMgr.cpp:120] cpuSlabSize is 4096M
I1221 21:56:08.102866 11657 FileMgr.cpp:173] Completed Reading table’s file metadata, Elasped time : 0ms Epoch: 0 files read: 0 table location: 'data/mapd_data/table_0_0/'
I1221 21:56:08.102967 11657 Calcite.cpp:156] Creating Calcite Handler, Calcite Port is 9093 base data dir is data
I1221 21:56:08.102995 11657 Calcite.cpp:95] Running calcite server as a daemon
E1221 21:56:08.105656 11657 Calcite.cpp:101] Appears to be orphaned Calcite serve already running, shutting it down
E1221 21:56:08.105744 11657 Calcite.cpp:102] Please check that you are not trying to run two servers on same port
E1221 21:56:08.105769 11657 Calcite.cpp:103] Attempting to shutdown orphaned Calcite server
E1221 21:56:08.116042 11657 Calcite.cpp:109] orphaned Calcite server shutdown
I1221 21:56:08.441218 11657 Calcite.cpp:124] Calcite server start took 300 ms
I1221 21:56:08.441320 11657 Calcite.cpp:125] ping took 16 ms
I1221 21:56:08.452685 11657 Calcite.cpp:299] [{“name”:“Tan”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__”,“ret”:“float”,“args”:[“float”,“i32”]},{“name”:“ln”,“ret”:“double”,“args”:[“double”]},{“name”:“distance_in_meters__”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“Floor__”,“ret”:“float”,“args”:[“float”]},{“name”:“Floor__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Floor__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“rect_pixel_bin”,“ret”:“float”,“args”:[“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Truncate”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“Floor__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“radians”,“ret”:“double”,“args”:[“double”]},{“name”:“degrees”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil__”,“ret”:“float”,“args”:[“float”]},{“name”:“ln__”,“ret”:“double”,“args”:[“float”]},{“name”:“approx_distance_in_meters”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“reg_hex_vert_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“reg_hex_vert_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Ceil__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Ceil__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“Ceil__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“power”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“conv_4326_900913_x”,“ret”:“double”,“args”:[“double”]},{“name”:“reg_hex_horiz_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“conv_4326_900913_y”,“ret”:“double”,“args”:[“double”]},{“name”:“Atan”,“ret”:“double”,“args”:[“double”]},{“name”:“reg_hex_horiz_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Floor”,“ret”:“double”,“args”:[“double”]},{“name”:“Log10”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__1”,“ret”:“i16”,“args”:[“i16”,“i32”]},{“name”:“Truncate__2”,“ret”:“i32”,“args”:[“i32”,“i32”]},{“name”:“Log”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__3”,“ret”:“i64”,“args”:[“i64”,“i32”]},{“name”:“Cos”,“ret”:“double”,“args”:[“double”]},{“name”:“Log__”,“ret”:“double”,“args”:[“float”]},{“name”:“Log10__”,“ret”:“double”,“args”:[“float”]},{“name”:“Asin”,“ret”:“double”,“args”:[“double”]},{“name”:“Cot”,“ret”:“double”,“args”:[“double”]},{“name”:“Tan__”,“ret”:“double”,“args”:[“float”]},{“name”:“rect_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“i32”]},{“name”:“rect_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“i32”]},{“name”:“distance_in_meters”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”]},{“name”:“round_to_digit”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“Atan2”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“Acos”,“ret”:“double”,“args”:[“double”]},{“name”:“pi”,“ret”:“double”,“args”:[]},{“name”:“Sin”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil”,“ret”:“double”,“args”:[“double”]},{“name”:“Exp”,“ret”:“double”,“args”:[“double”]}]
E1221 21:56:08.453487 11657 MapDHandler.cpp:178] No GPUs detected, falling back to CPU mode
I1221 21:56:08.453538 11657 MapDHandler.cpp:187] Started in CPU mode
I1221 21:56:19.320746 11690 MapDHandler.cpp:325] User mapd connected to database mapd
I1221 21:56:19.322737 11690 MapDHandler.cpp:577] sql_execute :f87ka5BDLm1Fwapy1xZHGLFMAfcj2vKu:query_str:drop table if exists flights_2008_10k;
I1221 21:56:19.323316 11690 MapDHandler.cpp:2398] passing query to legacy processor

And this is the mapd.conf.sanple file:

port = 9091
http-port = 9090
data = "data"
read-only = false
verbose = false
[web]
port = 9092
frontend = “frontend”


#2

Howdy:

Have you tried the systemctl commands? We still document startmapd for legacy customers, but the systemctl commands are the preferred method at this time.

Starting MapD Core Using systemd

To manually start MapD Core using systemd, go to $MAPD_HOME and run:

sudo systemctl start mapd_server
sudo systemctl start mapd_web_server

Stopping MapD Core Using systemd

To manually stop MapD Core using systemd, go to $MAPD_HOME and run:

sudo systemctl stop mapd_server
sudo systemctl stop mapd_web_server

Enabling MapD Core on Startup

To enable the MapD Core services to start on restart, go to $MAPD_HOME and run:

sudo systemctl enable mapd_server
sudo systemctl enable mapd_web_server

#3

When using systemd method, following the instrcutions in this link:
https://www.mapd.com/docs/latest/getting-started/starting-mapd/
Nothing happens on the terminal. And visiting localhost:9092 from the browser gives the same error.
When I run the mapdql after starting mapdcore, it gives the same reponse:

Thrift: Fri Dec 22 13:57:26 2017 TSocket::open() connect() <Host: localhost Port: 9091>Connection refused
terminate called after throwing an instance of 'apache::thrift::transport::TTransportException’
what(): connect() failed: Connection refused
Aborted (core dumped)


#4

Hi

It looks like.you are running your own dev build here.

Just to start from somewhere a little.more known, could you download the community cpu edition and confirm you can get that to work on your hardware

Regards