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.
Description
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | • Tfinc | T105394 EPIC: Deploy Maps service to production (Q1) | |||
Resolved | Yurik | T108545 Postgres replication is not working |
Event Timeline
Comment Actions
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)
Comment Actions
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