In the latest OsmMapCreator build (from today) i get the following error when generating the benelux map. H2 database is used.
I have created Issue 627 for this error.
INFO: Preindexing address and map ways... started after 110 ms - 94431
sep 01, 2011 8:27:41 AM net.osmand.data.preparation.IndexCreator generateIndexes
SEVERE: Log exception
org.h2.jdbc.JdbcSQLException: Column "
N.ID" must be in the GROUP BY list; SQL statement:
select count(*) from node n inner join tags t on
n.id =
t.id and t.type = 0 order by
n.id [90016-158]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:155)
at org.h2.command.dml.Select.queryGroup(Select.java:338)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:612)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.command.dml.Query.query(Query.java:37)
at org.h2.command.CommandContainer.query(CommandContainer.java:80)
at org.h2.command.Command.executeQuery(Command.java:181)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at net.osmand.data.preparation.OsmDbAccessor.computeRealCounts(OsmDbAccessor.java:263)
at net.osmand.data.preparation.OsmDbAccessor.iterateOverEntities(OsmDbAccessor.java:220)
at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:438)
at net.osmand.data.index.IndexBatchCreator.generateIndex(IndexBatchCreator.java:496)
at net.osmand.data.index.IndexBatchCreator.downloadFilesAndGenerateIndex(IndexBatchCreator.java:340)
at net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:310)
at net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:265)
at net.osmand.data.index.IndexBatchCreator.main(IndexBatchCreator.java:137)
sep 01, 2011 8:27:42 AM net.osmand.data.index.IndexBatchCreator generateIndex
SEVERE: Exception generating indexes for benelux_Europe.osm.pbf
org.h2.jdbc.JdbcSQLException: Column "
N.ID" must be in the GROUP BY list; SQL statement:
select count(*) from node n inner join tags t on
n.id =
t.id and t.type = 0 order by
n.id [90016-158]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:155)
at org.h2.command.dml.Select.queryGroup(Select.java:338)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:612)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.command.dml.Query.query(Query.java:37)
at org.h2.command.CommandContainer.query(CommandContainer.java:80)
at org.h2.command.Command.executeQuery(Command.java:181)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at net.osmand.data.preparation.OsmDbAccessor.computeRealCounts(OsmDbAccessor.java:263)
at net.osmand.data.preparation.OsmDbAccessor.iterateOverEntities(OsmDbAccessor.java:220)
at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:438)
at net.osmand.data.index.IndexBatchCreator.generateIndex(IndexBatchCreator.java:496)
at net.osmand.data.index.IndexBatchCreator.downloadFilesAndGenerateIndex(IndexBatchCreator.java:340)
at net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:310)
at net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:265)
at net.osmand.data.index.IndexBatchCreator.main(IndexBatchCreator.java:137)
sep 01, 2011 8:27:42 AM net.osmand.data.index.IndexBatchCreator uploadIndex
INFO: Upload index Benelux_europe_1.poi.odb
sep 01, 2011 8:27:42 AM net.osmand.data.index.IndexBatchCreator uploadIndex
INFO: Upload index nodes.tmp.odb.h2.db
sep 01, 2011 8:27:42 AM net.osmand.data.index.IndexBatchCreator uploadIndex
INFO: Upload index nodes.tmp.odb.lock.db
sep 01, 2011 8:27:42 AM net.osmand.data.index.IndexBatchCreator uploadIndex
INFO: Upload index nodes.tmp.odb.trace.db