[00:04:08] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Ladsgroup) [00:20:37] 10DBA: db1110 has 5 important database drifts that are unqiue to the host - https://phabricator.wikimedia.org/T249973 (10Ladsgroup) [01:41:59] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) Are we sure about these? `lang=sql MariaDB [labswiki]> show create table searchindex; +-------------+-------------------------------------------------... [01:43:37] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [01:44:26] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [01:45:29] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [01:49:03] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [01:51:13] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [01:55:17] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [02:02:20] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [02:04:46] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) It seems {T172514} didn't get applied on wikitech [02:07:16] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [02:14:35] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) [02:16:55] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) >>! In T249972#6048173, @Reedy wrote: > Are we sure about these? > > `lang=sql > MariaDB [labswiki]> show create table searchindex; > +-------------+-... [02:20:01] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Reedy) I think this is done for wikitech now, and I dropped a couple of other orphaned extra indexes that aren't in tables.sql [06:44:08] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Ladsgroup) 05Open→03Resolved a:03Reedy >What does index-mismatch-prod-extra even mean? ;) it means the index doesn't exist in the code but exists in pro... [06:46:38] https://medium.com/@rbranson/10-things-i-hate-about-postgresql-20dbab8c2791 [07:37:04] 10DBA, 10wikitech.wikimedia.org: Wikitech has lots of database drifts with core and rest of the databases - https://phabricator.wikimedia.org/T249972 (10Ladsgroup) >>! In T249972#6048199, @Reedy wrote: > I'm pretty sure this one is right, as in prod we don't use the table, so it's a false positive Yup, thanks... [13:30:56] 10DBA, 10wikitech.wikimedia.org, 10cloud-services-team (Kanban): Cannot sql to labtestwiki - https://phabricator.wikimedia.org/T250002 (10Reedy) [20:39:53] 10DBA, 10wikitech.wikimedia.org, 10cloud-services-team (Kanban): Labtestwiki database not reachable from deploy1001 using the standard `sql` helper script - https://phabricator.wikimedia.org/T250002 (10bd808)