Page MenuHomePhabricator

Postgres replication is not working
Closed, ResolvedPublic

Description

Tried creating a table "test" on maps-test2001, it didn't propagate to 2002. Also, the functions created on 2001 are not present on any other.

Event Timeline

MaxSem raised the priority of this task from to Needs Triage.
MaxSem updated the task description. (Show Details)
MaxSem added projects: Maps-Sprint, acl*sre-team.
MaxSem added subscribers: MaxSem, Yurik, akosiaris, jcrespo.
Yurik set Security to None.
Yurik moved this task from Backlog to Stalled/Waiting on the Maps-Sprint board.

This is apparently the cause of slaves not having spatial indexes:

maps-test2001:

gis=> \d+ planet_osm_polygon;
. . .
Indexes:
    "planet_osm_polygon_index" gist (way)
    "planet_osm_polygon_pkey" btree (osm_id)

maps-test2002:

Indexes:
    "planet_osm_polygon_pkey" btree (osm_id)

All queries for tile generation are hitting 2001 only for now.

stop postgres on maps-test200{2,3,4} and resyncing right now

Yurik claimed this task.

Awesome, works, thanks!

So this was due to a config change back in Jul 19th. https://phabricator.wikimedia.org/rOPUP5a7adbb4a5be5f49633efd778879f284fe6f8af9

I did not propagate it to the slaves as well and replication broke due to max_connections being different between master and slaves. Fixed it with https://phabricator.wikimedia.org/rOPUPf58ecf11318948395b47db7bfa8595b244b46da3
after a very very long resyncing process

Restricted Application added a subscriber: StudiesWorld. · View Herald Transcript