[Tile-serving] [openstreetmap/osm2pgsql] Update stuck waiting for postgresql "COPY ... FROM STDIN" to finish (#1273)

[Sarah Hoffmann]

This has definitely nothing to do with `--index-instances` because osm2pgsql is hard-wired to use only 1 process for updates. You can see that in the command line you posted.

We don't do anything fancy at the point where it hangs. osm2pgsql simply waits for COPY to finish. The problem with the gazetteer output is that there is a complicated set of triggers running in the background which might have a bug itself or trigger a Postgresql bug in the background. But we'd need a reproducable test case (preferably with a diff that is significantly smaller than 1 GB) to debug that.

What is the output of `SELECT * FROM pg_stat_activity`?

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1273#issuecomment-694734156
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200918/a52d6532/attachment.htm>