Re: 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

[Victor Shcherb]

Hi 

I will redirect it google groups, I think Pavol knows more .

Best Regards,

Victor

2011/9/1 S Or <tuu...@gmail.com>

Hi Victor,

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

Regards

Skip

--
Best Regards,

Victor

[Tuut84]

Fixed by Pavol.

On 1 sep, 09:55, Victor Shcherb <vics...@gmail.com> wrote:
> Hi
> I will redirect it google groups, I think Pavol knows more .
>
> Best Regards,
> Victor
> 2011/9/1 S Or <tuu...@gmail.com>
>
>
>
>
>
> > Hi Victor,
>
> > 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:15­5)

> > 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.j­ava: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.jav­a:496)
> > at
> > net.osmand.data.index.IndexBatchCreator.downloadFilesAndGenerateIndex(Index­BatchCreator.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:15­5)

> > 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.j­ava: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.jav­a:496)
> > at
> > net.osmand.data.index.IndexBatchCreator.downloadFilesAndGenerateIndex(Index­BatchCreator.java:340)
> > at
> > net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:310­)
> > at
> > net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:265­)