bchapuis commented on PR #532:
URL:
https://github.com/apache/incubator-baremaps/pull/532#issuecomment-1317319099
Thanks for the corrections. We still have an issue with the simplification
queries at scale. Here, is the error for the planet osm:
```
CREATE MATERIALIZED VIEW osm_natural_grouped AS
SELECT
min(id) as id,
jsonb_build_object('natural', tags -> 'natural') as tags,
(st_dump(st_union(st_buildarea(st_exteriorring(st_makevalid(geom)))))).geom AS
geom
FROM osm_natural
GROUP BY tags -> 'natural'
java.util.concurrent.ExecutionException:
org.apache.baremaps.workflow.WorkflowException:
org.apache.baremaps.workflow.WorkflowException:
org.postgresql.util.PSQLException: ERROR: invalid memory alloc request size
1765186736
at
java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396)
at
java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073)
at org.apache.baremaps.cli.workflow.Execute.call(Execute.java:48)
at org.apache.baremaps.cli.workflow.Execute.call(Execute.java:29)
at picocli.CommandLine.executeUserObject(CommandLine.java:1953)
at picocli.CommandLine.access$1300(CommandLine.java:145)
at
picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2358)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2352)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2314)
at
picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
at picocli.CommandLine$RunLast.execute(CommandLine.java:2316)
at picocli.CommandLine.execute(CommandLine.java:2078)
at org.apache.baremaps.cli.Baremaps.main(Baremaps.java:83)
Caused by: org.apache.baremaps.workflow.WorkflowException:
org.apache.baremaps.workflow.WorkflowException:
org.postgresql.util.PSQLException: ERROR: invalid memory alloc request size
1765186736
at
org.apache.baremaps.workflow.WorkflowExecutor.lambda$initStep$3(WorkflowExecutor.java:99)
at
java.base/java.util.concurrent.CompletableFuture$UniRun.tryFire(CompletableFuture.java:787)
at
java.base/java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:482)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.apache.baremaps.workflow.WorkflowException:
org.postgresql.util.PSQLException: ERROR: invalid memory alloc request size
1765186736
at
org.apache.baremaps.workflow.tasks.ExecuteSql.lambda$execute$0(ExecuteSql.java:45)
at
java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992)
at
java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:762)
at
org.apache.baremaps.workflow.tasks.ExecuteSql.execute(ExecuteSql.java:38)
at
org.apache.baremaps.workflow.WorkflowExecutor.lambda$initStep$3(WorkflowExecutor.java:97)
... 5 more
Caused by: org.postgresql.util.PSQLException: ERROR: invalid memory alloc
request size 1765186736
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:290)
at
com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at
org.apache.baremaps.workflow.tasks.ExecuteSql.lambda$execute$0(ExecuteSql.java:42)
... 9 more
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
