search

osm-fr / infrastructure

Handle tickets against osm-fr infrastructure
MIT License
22 stars 4 forks source link

bzh202.vm.openstreetmap.fr ne peut plus se connecter à la base de donnée OSM #525

Closed MaelREBOUX closed 8 months ago

MaelREBOUX commented 8 months ago

Bonjour,

Cette issue pour suivre les investigations sur la vm bzh202.vm.openstreetmap.fr (#478 . En effet je suis persuadé que le tuileur est HS depuis plusieurs semaines. Le cache calculé fait écran mais je vois bien que ça ne calcule plus.

J'ai redémarré manuellement renderd et apache et ai même rebooté : sans succès. Je regarde plus profondément…

MaelREBOUX commented 8 months ago 
service renderd stop
sudo renderd -f -c /data/project/styles/br/renderd/renderd_br.conf 

** INFO: 17:35:46.438: Rendering daemon started
** INFO: 17:35:46.438: Initialising request_queue
** INFO: 17:35:46.438: Parsing section renderd
** INFO: 17:35:46.438: Parsing render section 0
** INFO: 17:35:46.438: Parsing section mapnik
** INFO: 17:35:46.438: Parsing section br
** INFO: 17:35:46.438: Parsing section br_control
** INFO: 17:35:46.438: config renderd: unix socketname=/run/renderd/renderd.sock
** INFO: 17:35:46.438: config renderd: num_threads=8
** INFO: 17:35:46.438: config renderd: num_slaves=0
** INFO: 17:35:46.438: config renderd: tile_dir=/data/tiles
** INFO: 17:35:46.438: config renderd: stats_file=/run/renderd/renderd.stats
** INFO: 17:35:46.438: config mapnik:  plugins_dir=/usr/lib/mapnik/3.1/input/
** INFO: 17:35:46.438: config mapnik:  font_dir=/usr/share/fonts/truetype
** INFO: 17:35:46.438: config mapnik:  font_dir_recurse=1
** INFO: 17:35:46.438: config renderd(0): Active
** INFO: 17:35:46.438: config renderd(0): unix socketname=/run/renderd/renderd.sock
** INFO: 17:35:46.438: config renderd(0): num_threads=8
** INFO: 17:35:46.438: config renderd(0): tile_dir=/data/tiles
** INFO: 17:35:46.438: config renderd(0): stats_file=/run/renderd/renderd.stats
** INFO: 17:35:46.438: config map 0:   name(br) file(/data/project/styles/br/osm_br.xml) uri(/br) htcp() host(tile.openstreetmap.bzh)
** INFO: 17:35:46.438: config map 1:   name(br_control) file(/data/project/styles/br/osm_br_control.xml) uri(/br_control) htcp() host(tile.openstreetmap.bzh)
** INFO: 17:35:46.438: Initialising unix server socket on /run/renderd/renderd.sock
** INFO: 17:35:46.439: Renderd is using mapnik version 3.1.0
** INFO: 17:35:46.555: Running in foreground mode...
** INFO: 17:35:46.555: Loading parameterization function for 
** INFO: 17:35:46.555: Loading parameterization function for 
** INFO: 17:35:46.555: Loading parameterization function for 
** INFO: 17:35:46.555: Loading parameterization function for 
** INFO: 17:35:46.555: Loading parameterization function for 
** INFO: 17:35:46.555: Loading parameterization function for 
** INFO: 17:35:46.556: Loading parameterization function for 
** INFO: 17:35:46.556: Loading parameterization function for 

** (process:3167): ERROR **: 17:35:46.815: An error occurred while loading the map layer 'br': Postgis Plugin: connection to server at "db.openstreetmap.world" (127.0.0.1), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?
Connection string: 'host=db.openstreetmap.world dbname=osm user=osmbr connect_timeout=4'
  encountered during parsing of layer 'landcover_low' in Layer at line 56 of '/data/project/styles/br/osm_br.xml'

dans /etc/hosts/ : 127.0.0.1 db.openstreetmap.world db.openstreetmap.local -> ok normal 

psql -h db.openstreetmap.world -d osm --username osmbr --password 
Password: 
psql: error: connection to server at "db.openstreetmap.world" (127.0.0.1), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?

C'est sans appel : bzh202 ne peut plus se connecter à la base de données. On avait déjà eu un souci au début.

MaelREBOUX commented 8 months ago

Si j'en crois https://wiki.openstreetmap.org/wiki/FR:Serveurs_OpenStreetMap_France La base de données monde est sur osm165

Mais :

ping osm165
PING osm165(2a01:e0a:3c0:1680::165 (2a01:e0a:3c0:1680::165)) 56 data bytes
From 2001:41d0:1008:1f84:1::202 (2001:41d0:1008:1f84:1::202) icmp_seq=1 Destination unreachable: Address unreachable

ping @jocelynj

MaelREBOUX commented 8 months ago

Pour le rendu openstreetmap.fr @cquest pointe un serveur osmdb (voir ici) mais sans plus de détails.

jocelynj commented 8 months ago

En fait, on n'a pas vraiment configurer de base osm2pgsql depuis la migration de bzh sur le cluster OVH.

Vu que le cluster OVH est un peu lent pour du rendu, j'ai créé une nouvelle VM sur le cluster TH3, à connecter sur une future base osm2pgsql monde.

MaelREBOUX commented 8 months ago

Je ferme ici car #527 prend le relais.