createuser: error: creation of new role failed: ERROR: role "renderer" already exists
Opened this issue · 5 comments
Hi. I tried run this project from start and always received the same error. Any suggestions why this can be? Thanks in advance.
Log:
docker-openstreetmap$ sudo docker system prune -a
docker-openstreetmap$ sudo ./import.sh
Creating docker volumes
osm-data
osm-tiles
valhalla-data
nominatim-data
Importing data for tile server
Unable to find image 'overv/openstreetmap-tile-server:latest' locally
latest: Pulling from overv/openstreetmap-tile-server
2ab09b027e7f: Pull complete
bde11ea69849: Pull complete
40e160805737: Pull complete
f41c5ad11c98: Pull complete
97f4186ff19a: Pull complete
9655f23e0670: Pull complete
0eedff74b024: Pull complete
16b05075cf30: Pull complete
b5ce7d269856: Pull complete
3f30db876d55: Pull complete
2f71bb5e820d: Pull complete
b2caf47dca6f: Pull complete
f98b089d4989: Pull complete
e1c78a130923: Pull complete
4ffe18c9d9aa: Pull complete
d387c64d8ca1: Pull complete
a546b1960c43: Pull complete
8c42b7cf71bc: Pull complete
77ad13bf8c69: Pull complete
720ebe1774fb: Pull complete
3b353e6d6687: Pull complete
97ccc8f4d48f: Pull complete
3f579f6b6d85: Pull complete
ccd55a53aeca: Pull complete
Digest: sha256:59e9eefcefd961f30a3473287d4be56b737b645b9a1f7ad2d55f983b79e8c81d
Status: Downloaded newer image for overv/openstreetmap-tile-server:latest
++ ls -A /data/style/
- '[' '!' '' ']'
- mv /home/renderer/src/openstreetmap-carto-backup/CARTOGRAPHY.md /home/renderer/src/openstreetmap-carto-backup/CHANGELOG.md /home/renderer/src/openstreetmap-carto-backup/CODE_OF_CONDUCT.md /home/renderer/src/openstreetmap-carto-backup/CONTRIBUTING.md /home/renderer/src/openstreetmap-carto-backup/DOCKER.md /home/renderer/src/openstreetmap-carto-backup/Dockerfile /home/renderer/src/openstreetmap-carto-backup/Dockerfile.db /home/renderer/src/openstreetmap-carto-backup/Dockerfile.import /home/renderer/src/openstreetmap-carto-backup/INSTALL.md /home/renderer/src/openstreetmap-carto-backup/LICENSE.txt /home/renderer/src/openstreetmap-carto-backup/README.md /home/renderer/src/openstreetmap-carto-backup/RELEASES.md /home/renderer/src/openstreetmap-carto-backup/USECASES.md /home/renderer/src/openstreetmap-carto-backup/docker-compose.yml /home/renderer/src/openstreetmap-carto-backup/external-data.yml /home/renderer/src/openstreetmap-carto-backup/indexes.sql /home/renderer/src/openstreetmap-carto-backup/indexes.yml /home/renderer/src/openstreetmap-carto-backup/openstreetmap-carto.lua /home/renderer/src/openstreetmap-carto-backup/openstreetmap-carto.style /home/renderer/src/openstreetmap-carto-backup/patterns /home/renderer/src/openstreetmap-carto-backup/preview.png /home/renderer/src/openstreetmap-carto-backup/project.mml /home/renderer/src/openstreetmap-carto-backup/road-colors.yaml /home/renderer/src/openstreetmap-carto-backup/scripts /home/renderer/src/openstreetmap-carto-backup/style /home/renderer/src/openstreetmap-carto-backup/symbols /data/style/
- '[' '!' -f /data/style/mapnik.xml ']'
- cd /data/style/
- carto project.mml
- '[' import == import ']'
- mkdir -p /data/database/postgres/
- chown renderer: /data/database/
- chown -R postgres: /var/lib/postgresql /data/database/postgres/
- '[' '!' -f /data/database/postgres/PG_VERSION ']'
- createPostgresConfig
- cp /etc/postgresql/15/main/postgresql.custom.conf.tmpl /etc/postgresql/15/main/conf.d/postgresql.custom.conf
- sudo -u postgres echo 'autovacuum = on'
- cat /etc/postgresql/15/main/conf.d/postgresql.custom.conf
Suggested minimal settings from
https://ircama.github.io/osm-carto-tutorials/tile-server-ubuntu/
shared_buffers = 128MB
min_wal_size = 1GB
max_wal_size = 2GB # Overridden below
maintenance_work_mem = 256MB
Suggested settings from
https://github.com/openstreetmap/chef/blob/master/roles/tile.rb#L38-L45
max_connections = 250
temp_buffers = 32MB
work_mem = 128MB
wal_buffers = 1024kB
wal_writer_delay = 500ms
commit_delay = 10000
checkpoint_segments = 60 # unrecognized in psql 10.7.1
max_wal_size = 2880MB
random_page_cost = 1.1
track_activity_query_size = 16384
autovacuum_vacuum_scale_factor = 0.05
autovacuum_analyze_scale_factor = 0.02
listen_addresses = '*'
autovacuum = on
- service postgresql start
- Starting PostgreSQL 15 database server
...done.
- sudo -u postgres createuser renderer
createuser: error: creation of new role failed: ERROR: role "renderer" already exists
Hello! Is your PBF file copied under ./osm-pbf
and named region.osm.pbf
? This issue seems to suggest the error occurs when the pbf can't be found: Overv/openstreetmap-tile-server#12
Are there any other logs that might have warnings/errors in them?
Thanks a lot for so fast reply.
Yes. PBF file copied under ./osm-pbf and named region.osm.pbf
Maybe any suggestions?
user@home:/media/user/2TB/docker-openstreetmap$ cd ./osm-pbf
user@home:/media/user/2TB/docker-openstreetmap/osm-pbf$ ls -la
total 71958816
drwxrwxrwx 1 user user 0 May 2 06:30 .
drwxrwxrwx 1 user user 4096 May 2 05:25 ..
-rwxrwxrwx 1 user user 73685819550 May 2 03:18 region.osm.pbf
Maybe try docker system prune --volumes
also? docker system prune -a
only removes images
Thanks a lot for new recommendation, but unfortunately result the same. Maybe you know where I can find this line?
sudo -u postgres createuser renderer
I believe that line is coming from this Dockerfile:
https://github.com/Overv/openstreetmap-tile-server
You might want to try following the instructions in that repo with your pbf file and see if you get the same error.