Start-up and table-load errors


#1

Hello!

I setup the community edition of Mapd 3.2.x on my new GPU box.

The steps I followed are per the manual. I used the sample script to download and ingest some data, plus I used the import feature available thru the UI to insert some data.

I see the table names in the ‘select table’ list (while creating a new dashboard) but when I click on the tables the error ‘Failed to load dashboard’ pops-up.

Here is the error messages that pops up on the log files. Also there is a Thrift error that pops up at the beginning of the server startup.

Appreciate any pointers to fix the issue.

Thx and rgds
Ben

root@XXXXXXXXX:/usr/local/mapd# ./startmapd
Backend TCP: localhost:9091
Backend HTTP: localhost:9090
Frontend Web: localhost:9092
Calcite TCP: localhost:9093

  • sleeping for 5s while server starts
    Thrift: Thu Sep 7 15:41:39 2017 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    Thrift: Thu Sep 7 15:41:39 2017 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    Thrift: Thu Sep 7 15:41:39 2017 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    Thrift: Thu Sep 7 15:41:39 2017 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    E0907 15:45:46.374948 8577 MapDHandler.cpp:2283] Session not valid.
    E0907 15:45:49.979549 8577 MapDHandler.cpp:2283] Session not valid.
    E0907 15:45:58.193513 8577 MapDHandler.cpp:2283] Session not valid.
    Received 1
    Exception in thread “pool-1-thread-5” java.lang.NoSuchMethodError: java.util.Map.putIfAbsent(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
    at com.mapd.metadata.MetaConnect.getTables(MetaConnect.java:182)
    at com.mapd.calcite.parser.MapDSchema.getTableNames(MapDSchema.java:46)
    E0907 15:46:55.016674 8577 MapDHandler.cpp:2818] Exception: No more data to read.
    at org.apache.calcite.jdbc.CachingCalciteSchema$2.build(CachingCalciteSchema.java:73)
    at org.apache.calcite.jdbc.CachingCalciteSchema$2.build(CachingCalciteSchema.java:70)
    at org.apache.calcite.jdbc.CachingCalciteSchema$AbstractCached.get(CachingCalciteSchema.java:256)
    at org.apache.calcite.jdbc.CachingCalciteSchema.getImplicitTable(CachingCalciteSchema.java:124)
    at org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:254)
    at org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:143)
    at org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
    at org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:202)
    at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:104)
    at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:167)
    at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:939)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:920)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2954)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2939)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3181)
    at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
    at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:939)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:920)
    at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:220)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:895)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:605)
    at org.apache.calcite.prepare.MapDPlanner.validate(MapDPlanner.java:205)
    at com.mapd.calcite.parser.MapDParser.queryToSqlNode(MapDParser.java:130)
    at com.mapd.calcite.parser.MapDParser.getRelAlgebra(MapDParser.java:103)
    at com.mapd.parser.server.CalciteServerHandler.process(CalciteServerHandler.java:97)
    at com.mapd.thrift.calciteserver.CalciteServer$Processor$process.getResult(CalciteServer.java:437)
    at com.mapd.thrift.calciteserver.CalciteServer$Processor$process.getResult(CalciteServer.java:421)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
    at java.lang.Thread.run(Thread.java:748)
    Received 1
    E0907 15:47:14.022019 8577 MapDHandler.cpp:2818] Exception: No more data to read.
    Exception in thread “pool-1-thread-6” java.lang.NoSuchMethodError: java.util.Map.putIfAbsent(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
    at com.mapd.metadata.MetaConnect.getTables(MetaConnect.java:182)
    at com.mapd.calcite.parser.MapDSchema.getTableNames(MapDSchema.java:46)
    at org.apache.calcite.jdbc.CachingCalciteSchema$2.build(CachingCalciteSchema.java:73)
    at org.apache.calcite.jdbc.CachingCalciteSchema$2.build(CachingCalciteSchema.java:70)
    at org.apache.calcite.jdbc.CachingCalciteSchema$AbstractCached.get(CachingCalciteSchema.java:256)
    at org.apache.calcite.jdbc.CachingCalciteSchema.getImplicitTable(CachingCalciteSchema.java:124)
    at org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:254)
    at org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:143)
    at org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
    at org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:202)
    at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:104)
    at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:167)
    at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:939)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:920)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2954)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2939)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3181)
    at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
    at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:939)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:920)
    at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:220)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:895)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:605)
    at org.apache.calcite.prepare.MapDPlanner.validate(MapDPlanner.java:205)
    at com.mapd.calcite.parser.MapDParser.queryToSqlNode(MapDParser.java:130)
    at com.mapd.calcite.parser.MapDParser.getRelAlgebra(MapDParser.java:103)
    at com.mapd.parser.server.CalciteServerHandler.process(CalciteServerHandler.java:97)
    at com.mapd.thrift.calciteserver.CalciteServer$Processor$process.getResult(CalciteServer.java:437)
    at com.mapd.thrift.calciteserver.CalciteServer$Processor$process.getResult(CalciteServer.java:421)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
    at java.lang.Thread.run(Thread.java:748)
    Received 1

#2

Some more info, in case this helps:
I setup a sample table and loaded data into it. The load went thru as per the messages and the log. However when I query it I get the same error.

E0907 20:33:18.522332 13770 MapDHandler.cpp:2818] Exception: No more data to read.
Exception in thread “pool-1-thread-4” java.lang.NoSuchMethodError: java.util.Map.putIfAbsent(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
at com.mapd.metadata.MetaConnect.getTables(MetaConnect.java:182)
at com.mapd.calcite.parser.MapDSchema.getTableNames(MapDSchema.java:46)E0907 20:33:18.522332 13770 MapDHandler.cpp:2818] Exception: No more data to read.

This is the list of steps executed:

mapdql> \d chicago_crime_data
CREATE TABLE chicago_crime_data (
ID INTEGER,
Case_Number TEXT ENCODING DICT(32),
Incident_Date TIMESTAMP ENCODING FIXED(32),
Block TEXT ENCODING DICT(32),
IUCR TEXT ENCODING DICT(32),
Primary_Type TEXT ENCODING DICT(32),
Description TEXT ENCODING DICT(32),
Location_Description TEXT ENCODING DICT(32),
Arrest TEXT ENCODING DICT(32),
Domestic TEXT ENCODING DICT(32),
Beat TEXT ENCODING DICT(32),
District TEXT ENCODING DICT(32),
Ward TEXT ENCODING DICT(32),
Community_Area TEXT ENCODING DICT(32),
FBI_Code TEXT ENCODING DICT(32),
X_Coordinate BIGINT ENCODING FIXED(32),
Y_Coordinate BIGINT ENCODING FIXED(32),
Incident_Year TEXT ENCODING DICT(32),
Updated_On TIMESTAMP ENCODING FIXED(32),
Latitude FLOAT,
Longitude FLOAT,
Location TEXT ENCODING DICT(32))
mapdql> copy chicago_crime_date from ‘/tmp/crime_data.csv’ ;
Exception: Table chicago_crime_date does not exist.
mapdql> copy chicago_crime_data from ‘/tmp/crime_data.csv’ ;
Exception: File /tmp/crime_data.csv does not exist.
mapdql> copy chicago_crime_data from ‘/tmp/Crimes_-_2001_to_present.csv’ ;
Result
Loaded: 6225100 recs, Rejected: 0 recs in 24.858000 secs
mapdql> select count(*) from chicago_crime_data ;
Exception: No more data to read.
mapdql>


#3

Hi,

Sorry about you issue.

What is your underlying platform?

I believe your issue is you do not have java 8 installed on your machine. Please check what version of java is in your execution path with java -version

regards


#4

It was the Java version that caused the issue. Once I got Java8 installed, it worked fine.

Thx for the tip.

_Ben