[05:39:00] <marostegui>	 I am going to put phabricator in RO for a few seconds to switch its database master
[07:47:43] <marostegui>	 I am going to make this change to phabricator dbs https://gerrit.wikimedia.org/r/c/operations/puppet/+/978850
[09:53:47] <hashar>	 marostegui: would it be possible that some settings are different between the servers?  I have noticed Phabricator complains about a couple ones
[09:53:55] <marostegui>	 like?
[09:53:59] <hashar>	 MySQL STRICT_ALL_TABLES Mode Not Set
[09:54:14] <hashar>	 Unsafe MySQL "local_infile" Setting Enabled
[09:54:30] <hashar>	 which shows up as a notification in the web UI (since i am an admin)
[09:54:31] <hashar>	 https://phabricator.wikimedia.org/config/issue/
[09:54:41] <hashar>	 but I think that rquires admin rights to be seen
[09:54:50] <hashar>	 I guess I can report it on the task you used?
[09:55:02] <marostegui>	 let me see
[09:55:46] <hashar>	 ah I am writing on https://phabricator.wikimedia.org/T352360 :)
[09:55:52] <marostegui>	 should be fixed now
[09:55:53] <marostegui>	 can you check?
[09:56:09] <hashar>	 the local_infile has vanished
[09:56:14] <hashar>	 STRICT_ALL_TABLES is still there
[09:56:17] <hashar>	 it is magic
[09:56:36] <marostegui>	 still?
[09:56:38] <marostegui>	 can you refresh?
[09:56:50] <hashar>	 solved!
[09:56:59] <marostegui>	 the old master will be back tomorrow anyways! :)
[09:57:01] <hashar>	 who said database administration is hard?
[09:57:03] <marostegui>	 haha
[09:57:09] <marostegui>	 thanks for letting me know!
[09:59:34] <hashar>	 I have documented it at https://phabricator.wikimedia.org/T352360#9370197
[10:00:04] <marostegui>	 perfect!
[10:00:06] <marostegui>	 thank you
[10:00:24] <hashar>	 is that cause the my.cnf was not in sync between the two servers?
[10:00:52] <marostegui>	 yeah db1119 is a floating host I am using across all the misc sections
[10:01:12] <hashar>	 ok so it is known and on track :-]
[10:01:18] <marostegui>	 yeah, expected
[10:01:27] <marostegui>	 as it is just temporary host I don't bother changing its role all the time
[10:01:33] <hashar>	 beside that, I haven't noticed anything and nobody has complained about issues regarding Phabricator
[10:01:34] <marostegui>	 but you did well pinging me :)
[10:02:20] <marostegui>	 hashar: I have changed something in the old master, it will cache more things, so tomorrow it will be back, and if anything, it should be a bit faster than it used to be
[10:02:31] <marostegui>	 this https://gerrit.wikimedia.org/r/c/operations/puppet/+/978850
[10:05:16] <hashar>	 one day I will have to poke you about tuning MySQL for the Mediawiki CI jobs :)
[10:05:22] <hashar>	 we use the stock defaults :D
[10:05:49] <hashar>	 then it is mostly CPU bounds 
[10:12:03] <marostegui>	 i am sure it is full of terrible queries XD
[10:12:41] <hashar>	 definitely :-]