Unable to connect to Hostname or Port


#1

When I execute the query, sometimes the query time is very long, has not returned the results, then if I refresh the page, it will report ‘Error: Unable to connect to Hostname or Port’, then you must restart MapD server. I would like to ask this question should be how to solve?


#2

Hi,

Your query (which I assume you are running from Immerse) I suspect is crashing the server.

Please share the mapd_server.INFO log for one of the crashes plus schema details and some details about the size and cardinality of your tables being worked on.

regards


#4

Hi, the following is the contents of map_server.INFO

Log file created at: 2017/10/15 12:29:54
Running on machine: 3e3f4da83116
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
I1015 12:29:54.903862 6 MapDServer.cpp:602] MapD started with data directory at '/mapd-storage/data’
I1015 12:29:54.904197 6 MapDServer.cpp:609] Watchdog is set to 1
I1015 12:29:54.904211 6 MapDServer.cpp:631] cuda block size 0
I1015 12:29:54.904222 6 MapDServer.cpp:632] cuda grid size 0
I1015 12:29:54.904230 6 MapDServer.cpp:633] calcite JVM max memory 1024
I1015 12:29:54.904239 6 MapDServer.cpp:634] MapD Server Port 9091
I1015 12:29:54.904248 6 MapDServer.cpp:635] MapD Calcite Port 9093
I1015 12:29:54.904275 6 MapDHandler.cpp:162] MapD Server 3.2.1-20170826-327e7ee
E1015 12:29:54.904291 6 MapDHandler.cpp:169] This build isn’t CUDA enabled, will run on CPU
I1015 12:29:54.909798 6 DataMgr.cpp:120] cpuSlabSize is 4096M
I1015 12:29:54.910248 6 FileMgr.cpp:116] Read table metadata, Epoch is 0 for table data at '/mapd-storage/data/mapd_data/table_0_0/'
I1015 12:29:54.910392 6 Calcite.cpp:156] Creating Calcite Handler, Calcite Port is 9093 base data dir is /mapd-storage/data
I1015 12:29:54.910408 6 Calcite.cpp:95] Running calcite server as a daemon
I1015 12:29:56.039726 6 Calcite.cpp:124] Calcite server start took 1100 ms
I1015 12:29:56.039789 6 Calcite.cpp:125] ping took 19 ms
I1015 12:29:56.051893 6 Calcite.cpp:281] [{“name”:“Tan”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__”,“ret”:“float”,“args”:[“float”,“i32”]},{“name”:“ln”,“ret”:“double”,“args”:[“double”]},{“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”:“Floor__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“degrees”,“ret”:“double”,“args”:[“double”]},{“name”:“approx_distance_in_meters”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“Ceil__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Ceil__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“Ceil__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“Log10”,“ret”:“double”,“args”:[“double”]},{“name”:“Log”,“ret”:“double”,“args”:[“double”]},{“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”:“Sin”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil”,“ret”:“double”,“args”:[“double”]},{“name”:“distance_in_meters__”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“Floor__”,“ret”:“float”,“args”:[“float”]},{“name”:“Truncate”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“radians”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil__”,“ret”:“float”,“args”:[“float”]},{“name”:“ln__”,“ret”:“double”,“args”:[“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”:“Round”,“ret”:“double”,“args”:[“double”]},{“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”:“Truncate__1”,“ret”:“i16”,“args”:[“i16”,“i32”]},{“name”:“Truncate__2”,“ret”:“i32”,“args”:[“i32”,“i32”]},{“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”:“pi”,“ret”:“double”,“args”:[]},{“name”:“Exp”,“ret”:“double”,“args”:[“double”]}]
E1015 12:29:56.052530 6 MapDHandler.cpp:201] No GPUs detected, falling back to CPU mode
I1015 12:29:56.052608 6 MapDHandler.cpp:210] Started in CPU mode
I1015 12:32:25.982019 62 MapDHandler.cpp:359] User mapd connected to database mapd
I1015 12:32:38.576941 62 MapDHandler.cpp:555] sql_execute :frdwXcZKzmv5CCNqq43W9pD0xKJMWyWv:query_str:select * from flights
I1015 12:32:38.578001 62 Calcite.cpp:247] User mapd catalog mapd sql 'select * from flights’
I1015 12:32:40.080968 56 FileMgr.cpp:116] Read table metadata, Epoch is 3 for table data at '/mapd-storage/data/mapd_data/table_1_814/'
I1015 12:32:41.930784 62 Calcite.cpp:260] Time in Thrift 12 (ms), Time in Java Calcite server 3340 (ms)
I1015 12:32:42.000880 78 BufferMgr.cpp:266] ALLOCATION slab of 8388608 pages (4294967296B) created in 0 ms CPU_MGR:0
I1015 12:32:42.001436 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 3424 (ms), Execution: 3422 (ms)


#5

Hi

Everything here looks fine. Did the non reponsive behaviour happen during this 3 minutes of log file?

regards


#6

I1016 01:50:51.695637 57 Calcite.cpp:247] User mapd catalog mapd sql 'select count(distinct b.gmsfhm) from ka_39ce603a06f1dd0971b05c_tmp b,ka_07877aa6cd90982d661726_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;'
I1016 01:50:51.713294 57 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 16 (ms)
I1016 01:50:51.755151 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 60 (ms), Execution: 60 (ms)
I1016 01:54:44.007619 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:drop table if exists ka_8e392fcdfacfde034f5ec0_tmp;
I1016 01:54:44.007850 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.041512 57 Calcite.cpp:179] Time to updateMetadata 1 (ms)
I1016 01:54:44.054567 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 46 (ms), Execution: 27 (ms)
I1016 01:54:44.055919 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:create table ka_8e392fcdfacfde034f5ec0_tmp ( xm VARCHAR(4000), gmsfhm VARCHAR(4000), csrq DATE, lxdh VARCHAR(4000), hyzk VARCHAR(4000));
I1016 01:54:44.055985 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.080935 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.081007 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 25 (ms), Execution: 5 (ms)
I1016 01:54:44.081951 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:drop table if exists ka_fd2ddd6ed593b09ef80071_tmp;
I1016 01:54:44.082016 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.115109 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.118319 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 36 (ms), Execution: 15 (ms)
I1016 01:54:44.119149 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:create table ka_fd2ddd6ed593b09ef80071_tmp ( gmsfhm VARCHAR(4000));
I1016 01:54:44.119200 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.141989 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.142216 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 23 (ms), Execution: 3 (ms)
I1016 01:54:44.196844 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:drop table if exists ka_f6609cc97c8f2d8b2dd9e6_tmp;
I1016 01:54:44.196919 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.230334 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.234395 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 37 (ms), Execution: 17 (ms)
I1016 01:54:44.235159 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:create table ka_f6609cc97c8f2d8b2dd9e6_tmp ( gmsfhm VARCHAR(4000));
I1016 01:54:44.235227 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.263079 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.263335 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 28 (ms), Execution: 4 (ms)
I1016 01:54:44.263921 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:drop table if exists ka_89e8f710fe448263fb8a69_tmp;
I1016 01:54:44.263983 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.303098 57 Calcite.cpp:179] Time to updateMetadata 1 (ms)
I1016 01:54:44.317766 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 53 (ms), Execution: 30 (ms)
I1016 01:54:44.318673 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:create table ka_89e8f710fe448263fb8a69_tmp ( xm VARCHAR(4000), gmsfhm VARCHAR(4000), csrq DATE, lxdh VARCHAR(4000), hyzk VARCHAR(4000));
I1016 01:54:44.318742 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.344818 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.344907 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 26 (ms), Execution: 5 (ms)
I1016 01:54:44.400971 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:drop table if exists ka_07877aa6cd90982d661726_tmp;
I1016 01:54:44.401082 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.432806 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.436164 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 35 (ms), Execution: 15 (ms)
I1016 01:54:44.436976 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:create table ka_07877aa6cd90982d661726_tmp ( gmsfhm VARCHAR(4000));
I1016 01:54:44.437027 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.460176 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.460258 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 23 (ms), Execution: 3 (ms)
I1016 01:54:44.461053 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:drop table if exists ka_39ce603a06f1dd0971b05c_tmp;
I1016 01:54:44.461103 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.492463 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.509223 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 48 (ms), Execution: 29 (ms)
I1016 01:54:44.510022 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:create table ka_39ce603a06f1dd0971b05c_tmp ( csrq VARCHAR(4000), hyzk VARCHAR(4000), lxdh VARCHAR(4000), gmsfhm VARCHAR(4000), xm VARCHAR(4000));
I1016 01:54:44.510073 57 MapDHandler.cpp:2806] passing query to legacy processor
I1016 01:54:44.536097 57 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 01:54:44.536217 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 26 (ms), Execution: 6 (ms)
I1016 01:54:45.811131 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:select count(distinct b.gmsfhm) from ka_8e392fcdfacfde034f5ec0_tmp b,ka_fd2ddd6ed593b09ef80071_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;
I1016 01:54:45.812276 57 Calcite.cpp:247] User mapd catalog mapd sql 'select count(distinct b.gmsfhm) from ka_8e392fcdfacfde034f5ec0_tmp b,ka_fd2ddd6ed593b09ef80071_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;'
I1016 01:54:45.836035 57 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 22 (ms)
I1016 01:54:45.880038 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 68 (ms), Execution: 67 (ms)
I1016 01:54:49.349877 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:select count(distinct b.gmsfhm) from ka_89e8f710fe448263fb8a69_tmp b,ka_f6609cc97c8f2d8b2dd9e6_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;
I1016 01:54:49.351030 57 Calcite.cpp:247] User mapd catalog mapd sql 'select count(distinct b.gmsfhm) from ka_89e8f710fe448263fb8a69_tmp b,ka_f6609cc97c8f2d8b2dd9e6_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;'
I1016 01:54:49.367244 57 Calcite.cpp:260] Time in Thrift 2 (ms), Time in Java Calcite server 14 (ms)
I1016 01:54:49.420511 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 70 (ms), Execution: 69 (ms)
I1016 01:54:50.560258 59 MapDHandler.cpp:555] sql_execute :2VqAS2AGz8cLnwFF0XIYO2xmXd9577zL:query_str:select ka_07877aa6cd90982d661726.CSRQ CSRQ, ka_07877aa6cd90982d661726.HYZK HYZK, ka_07877aa6cd90982d661726.LXDH LXDH, ka_07877aa6cd90982d661726.GMSFHM GMSFHM, ka_07877aa6cd90982d661726.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_89e8f710fe448263fb8a69_tmp b,ka_f6609cc97c8f2d8b2dd9e6_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_07877aa6cd90982d661726 limit 2 OFFSET 10000;
I1016 01:54:50.560611 56 MapDHandler.cpp:555] sql_execute :dsiNkfhV0M4DnX4eIskP0pBaeqIFWpzO:query_str:select ka_07877aa6cd90982d661726.CSRQ CSRQ, ka_07877aa6cd90982d661726.HYZK HYZK, ka_07877aa6cd90982d661726.LXDH LXDH, ka_07877aa6cd90982d661726.GMSFHM GMSFHM, ka_07877aa6cd90982d661726.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_89e8f710fe448263fb8a69_tmp b,ka_f6609cc97c8f2d8b2dd9e6_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_07877aa6cd90982d661726 limit 10000 OFFSET 0;
I1016 01:54:50.560972 60 MapDHandler.cpp:555] sql_execute :eYyVFBZTIazLmEITznaNvjMxEfqZasPe:query_str:select ka_39ce603a06f1dd0971b05c.CSRQ CSRQ, ka_39ce603a06f1dd0971b05c.HYZK HYZK, ka_39ce603a06f1dd0971b05c.LXDH LXDH, ka_39ce603a06f1dd0971b05c.GMSFHM GMSFHM, ka_39ce603a06f1dd0971b05c.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_8e392fcdfacfde034f5ec0_tmp b,ka_fd2ddd6ed593b09ef80071_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_39ce603a06f1dd0971b05c limit 2 OFFSET 10000;
I1016 01:54:50.561213 57 MapDHandler.cpp:555] sql_execute :EV31go3KL9cLI1XanaTnTgW8CcwFTF8N:query_str:select ka_39ce603a06f1dd0971b05c.CSRQ CSRQ, ka_39ce603a06f1dd0971b05c.HYZK HYZK, ka_39ce603a06f1dd0971b05c.LXDH LXDH, ka_39ce603a06f1dd0971b05c.GMSFHM GMSFHM, ka_39ce603a06f1dd0971b05c.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_8e392fcdfacfde034f5ec0_tmp b,ka_fd2ddd6ed593b09ef80071_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_39ce603a06f1dd0971b05c limit 10000 OFFSET 0;
I1016 01:54:50.561703 59 Calcite.cpp:247] User mapd catalog mapd sql 'select ka_07877aa6cd90982d661726.CSRQ CSRQ, ka_07877aa6cd90982d661726.HYZK HYZK, ka_07877aa6cd90982d661726.LXDH LXDH, ka_07877aa6cd90982d661726.GMSFHM GMSFHM, ka_07877aa6cd90982d661726.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_89e8f710fe448263fb8a69_tmp b,ka_f6609cc97c8f2d8b2dd9e6_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_07877aa6cd90982d661726 limit 2 OFFSET 10000;'
I1016 01:54:50.561910 56 Calcite.cpp:247] User mapd catalog mapd sql 'select ka_07877aa6cd90982d661726.CSRQ CSRQ, ka_07877aa6cd90982d661726.HYZK HYZK, ka_07877aa6cd90982d661726.LXDH LXDH, ka_07877aa6cd90982d661726.GMSFHM GMSFHM, ka_07877aa6cd90982d661726.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_89e8f710fe448263fb8a69_tmp b,ka_f6609cc97c8f2d8b2dd9e6_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_07877aa6cd90982d661726 limit 10000 OFFSET 0;'
I1016 01:54:50.562157 60 Calcite.cpp:247] User mapd catalog mapd sql 'select ka_39ce603a06f1dd0971b05c.CSRQ CSRQ, ka_39ce603a06f1dd0971b05c.HYZK HYZK, ka_39ce603a06f1dd0971b05c.LXDH LXDH, ka_39ce603a06f1dd0971b05c.GMSFHM GMSFHM, ka_39ce603a06f1dd0971b05c.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_8e392fcdfacfde034f5ec0_tmp b,ka_fd2ddd6ed593b09ef80071_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_39ce603a06f1dd0971b05c limit 2 OFFSET 10000;'
I1016 01:54:50.562438 57 Calcite.cpp:247] User mapd catalog mapd sql 'select ka_39ce603a06f1dd0971b05c.CSRQ CSRQ, ka_39ce603a06f1dd0971b05c.HYZK HYZK, ka_39ce603a06f1dd0971b05c.LXDH LXDH, ka_39ce603a06f1dd0971b05c.GMSFHM GMSFHM, ka_39ce603a06f1dd0971b05c.XM XM from (select t.CSRQ CSRQ,t.GMSFHM GMSFHM,t.HYZK HYZK,t.LXDH LXDH,t.XM XM from(select * from ( select b.xm XM,b.gmsfhm GMSFHM,b.csrq CSRQ,b.lxdh LXDH,b.hyzk HYZK from ka_8e392fcdfacfde034f5ec0_tmp b,ka_fd2ddd6ed593b09ef80071_tmp c where b.gmsfhm=c.gmsfhm )t)t) ka_39ce603a06f1dd0971b05c limit 10000 OFFSET 0;'
I1016 01:54:50.594547 57 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 31 (ms)
I1016 01:54:50.594910 60 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 32 (ms)
I1016 01:54:50.595384 57 RelAlgOptimizer.cpp:301] ID=7 (RelProject<140138174175600> (RexInput 2 140138139627024) (RexInput 1 140138139627024) (RexInput 4 140138139627024) (RexInput 3 140138139627024) (RexInput 0 140138139627024)) deleted!
I1016 01:54:50.595458 57 RelAlgOptimizer.cpp:301] ID=6 (RelProject<140138174158784> (RexInput 0 140138139627024) (RexInput 1 140138139627024) (RexInput 2 140138139627024) (RexInput 3 140138139627024) (RexInput 4 140138139627024)) deleted!
I1016 01:54:50.595499 57 RelAlgOptimizer.cpp:301] ID=5 (RelProject<140138173961632> (RexInput 0 140138139627024) (RexInput 1 140138139627024) (RexInput 2 140138139627024) (RexInput 3 140138139627024) (RexInput 4 140138139627024)) deleted!
I1016 01:54:50.595513 60 RelAlgOptimizer.cpp:301] ID=7 (RelProject<140133643547664> (RexInput 2 140133686069744) (RexInput 1 140133686069744) (RexInput 4 140133686069744) (RexInput 3 140133686069744) (RexInput 0 140133686069744)) deleted!
I1016 01:54:50.595579 60 RelAlgOptimizer.cpp:301] ID=6 (RelProject<140133643534992> (RexInput 0 140133686069744) (RexInput 1 140133686069744) (RexInput 2 140133686069744) (RexInput 3 140133686069744) (RexInput 4 140133686069744)) deleted!
I1016 01:54:50.595620 60 RelAlgOptimizer.cpp:301] ID=5 (RelProject<140133643541968> (RexInput 0 140133686069744) (RexInput 1 140133686069744) (RexInput 2 140133686069744) (RexInput 3 140133686069744) (RexInput 4 140133686069744)) deleted!
I1016 01:54:50.597796 59 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 35 (ms)
I1016 01:54:50.601012 56 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 38 (ms)
I1016 01:54:50.601387 59 RelAlgOptimizer.cpp:301] ID=7 (RelProject<140133594318800> (RexInput 2 140133576927264) (RexInput 1 140133576927264) (RexInput 4 140133576927264) (RexInput 3 140133576927264) (RexInput 0 140133576927264)) deleted!
I1016 01:54:50.601814 56 RelAlgOptimizer.cpp:301] ID=7 (RelProject<140138340469072> (RexInput 2 140138340450640) (RexInput 1 140138340450640) (RexInput 4 140138340450640) (RexInput 3 140138340450640) (RexInput 0 140138340450640)) deleted!
I1016 01:54:50.603843 59 RelAlgOptimizer.cpp:301] ID=6 (RelProject<140133047297648> (RexInput 0 140133576927264) (RexInput 1 140133576927264) (RexInput 2 140133576927264) (RexInput 3 140133576927264) (RexInput 4 140133576927264)) deleted!
I1016 01:54:50.604123 56 RelAlgOptimizer.cpp:301] ID=6 (RelProject<140138341220064> (RexInput 0 140138340450640) (RexInput 1 140138340450640) (RexInput 2 140138340450640) (RexInput 3 140138340450640) (RexInput 4 140138340450640)) deleted!
I1016 01:54:50.606842 59 RelAlgOptimizer.cpp:301] ID=5 (RelProject<140133603828096> (RexInput 0 140133576927264) (RexInput 1 140133576927264) (RexInput 2 140133576927264) (RexInput 3 140133576927264) (RexInput 4 140133576927264)) deleted!
I1016 01:54:50.606962 56 RelAlgOptimizer.cpp:301] ID=5 (RelProject<140138383814640> (RexInput 0 140138340450640) (RexInput 1 140138340450640) (RexInput 2 140138340450640) (RexInput 3 140138340450640) (RexInput 4 140138340450640)) deleted!
I1016 01:54:50.620647 57 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 59 (ms), Execution: 52 (ms)
I1016 01:54:50.634608 60 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 73 (ms), Execution: 50 (ms)
I1016 01:54:50.649791 59 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 89 (ms), Execution: 64 (ms)
I1016 01:54:50.667048 56 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 106 (ms), Execution: 64 (ms)
I1016 01:54:52.242862 56 MapDHandler.cpp:555] sql_execute :dsiNkfhV0M4DnX4eIskP0pBaeqIFWpzO:query_str:select count(distinct b.gmsfhm) from ka_39ce603a06f1dd0971b05c_tmp b,ka_07877aa6cd90982d661726_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;
I1016 01:54:52.244053 56 Calcite.cpp:247] User mapd catalog mapd sql 'select count(distinct b.gmsfhm) from ka_39ce603a06f1dd0971b05c_tmp b,ka_07877aa6cd90982d661726_tmp c where b.gmsfhm=c.gmsfhm LIMIT 100000;'
I1016 01:54:52.258972 56 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 13 (ms)
I1016 01:54:52.294145 56 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 50 (ms), Execution: 49 (ms)
I1016 02:16:15.259663 62 MapDHandler.cpp:359] User mapd connected to database mapd
I1016 02:16:15.267177 62 MapDHandler.cpp:369] User mapd disconnected from database mapd
I1016 02:16:15.272279 62 MapDHandler.cpp:359] User mapd connected to database mapd
I1016 02:16:15.282296 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:drop table if exists ka_71e108e527a70217c9adcd_tmp;
I1016 02:16:15.282366 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:15.315910 62 FileMgr.cpp:116] Read table metadata, Epoch is 1 for table data at '/mapd-storage/data/mapd_data/table_1_2560/'
I1016 02:16:16.741504 62 Calcite.cpp:179] Time to updateMetadata 5 (ms)
I1016 02:16:16.748181 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 1465 (ms), Execution: 1446 (ms)
I1016 02:16:16.766021 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:create table ka_71e108e527a70217c9adcd_tmp ( hkgs VARCHAR(4000), hbh NUMERIC(10), zjhm VARCHAR(4000));
I1016 02:16:16.766106 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:16.792047 62 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 02:16:16.792121 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 26 (ms), Execution: 5 (ms)
I1016 02:16:16.792924 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:drop table if exists ka_5183192c1a44b1cde2d167_tmp;
I1016 02:16:16.792994 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:16.823886 62 FileMgr.cpp:116] Read table metadata, Epoch is 1 for table data at '/mapd-storage/data/mapd_data/table_1_2561/'
I1016 02:16:18.139132 62 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 02:16:18.275650 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 1482 (ms), Execution: 1463 (ms)
I1016 02:16:18.276834 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:create table ka_5183192c1a44b1cde2d167_tmp ( xm VARCHAR(4000), lkywm VARCHAR(4000), qfjc VARCHAR(4000), ddjc VARCHAR(4000), zjhm VARCHAR(4000));
I1016 02:16:18.276921 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:18.303267 62 Calcite.cpp:179] Time to updateMetadata 1 (ms)
I1016 02:16:18.303434 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 26 (ms), Execution: 7 (ms)
I1016 02:16:18.551985 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:drop table if exists ka_71e108e527a70217c9adcd_tmp;
I1016 02:16:18.552147 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:18.576102 62 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 02:16:18.576483 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 24 (ms), Execution: 5 (ms)
I1016 02:16:18.577477 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:create table ka_71e108e527a70217c9adcd_tmp ( hkgs VARCHAR(4000), hbh NUMERIC(10), zjhm VARCHAR(4000));
I1016 02:16:18.577544 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:18.601078 62 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 02:16:18.601145 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 23 (ms), Execution: 4 (ms)
I1016 02:16:18.602021 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:drop table if exists ka_5183192c1a44b1cde2d167_tmp;
I1016 02:16:18.602140 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:18.626262 62 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 02:16:18.626883 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 24 (ms), Execution: 5 (ms)
I1016 02:16:18.627914 62 MapDHandler.cpp:555] sql_execute :P6VU4M7wK6HT7oiwmgqCX3TFrJ6Dcffb:query_str:create table ka_5183192c1a44b1cde2d167_tmp ( xm VARCHAR(4000), lkywm VARCHAR(4000), qfjc VARCHAR(4000), ddjc VARCHAR(4000), zjhm VARCHAR(4000));
I1016 02:16:18.627975 62 MapDHandler.cpp:2806] passing query to legacy processor
I1016 02:16:18.652685 62 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I1016 02:16:18.652880 62 MapDHandler.cpp:567] sql_execute-COMPLETED Total: 24 (ms), Execution: 5 (ms)


#7

Hi,

There are no errors or exceptions here that I can see. Can you reproduce the error repeatably?

regards


#9

Hi,

You could be potentially running out of sessions to connect to MapD. How many connections are you running max. If you are not doing backend render you can up the threadcount high.

See Unable to connect after a few hours for more information

I do still suspect you have an error in your process somewhere which is killing the server please look at the end of your INFO logs for any CHECK or exceptions

regards


#10

I configured the threadpool-size parameter in the mapd.conf.in file, and the contents of mapd.conf.in are as follows:

=====================================================
port = 9091
http-port = 9090
data = "@MAPD_DATA@"
null-div-by-zero = true
threadpool-size = 30

[web]
port = 9092
frontend = “@MAPD_PATH@/frontend”

=================================================
Is it configured in this file, and is “threadpool-size = 30” correct?


#11

Hi,

The parameter is tthreadpool-size.

This limitation is removed in the next release of MapD and is already removed in the OS version.

regards


#12

When will the next version of MAPD be released? Thank you


#13

can you tell me when will the next version of MAPD be released? Thank you


#14

Hi,

We are in the process of creating the release currently, we try to release around every two weeks, so look out for something some time next week, but no promises.

As an aside, I am not convinced your issue is related solely to the connections limit so if you are waiting for the new release to fix that then I think you should do more testing, unless you have some some additional information. Are you using backend render?

regards


#15

When I set little concurrent volumes, this problem does not occur, so I suspect that the thread concurrency is too large, causing the connection pool to be insufficient . In addition,What does “backend render” mean?


#16

The rendering of some objects like point map, geo heat map and scatter plot in immerse/mapd charting


#17

I use the JDBC connection to query mapD data。。。
Sometimes, when I execute a statement, it execute it for a long time, then I will not connect the MapD server ,the content of mapd_server.info as shown in the following figure:

the Immerse report ‘Error: Unable to connect to Hostname or Port’ ,like this:
error2

why?Please!!