[12:57:56] 10DBA, 10Operations, 10Patch-For-Review: mysql user and group should be a system user/group - https://phabricator.wikimedia.org/T100501#3370277 (10jcrespo) @faidon unless I am mistaken, this task you asked me to do some time ago is already fixed on puppet- "only" thing pending is to reimage the whole fleet i... [14:40:17] 10DBA, 103d, 10Multimedia, 10Patch-For-Review: Have search recognise STL files as a new kind of media file ('type:3d' or whatever) - https://phabricator.wikimedia.org/T157348#3370698 (10MarkTraceur) @jcrespo since this change is only really necessary on the beta cluster right now, do we need to file a tick... [14:55:24] 10DBA, 103d, 10Multimedia, 10Patch-For-Review: Have search recognise STL files as a new kind of media file ('type:3d' or whatever) - https://phabricator.wikimedia.org/T157348#3370745 (10jcrespo) I have no power over there... on beta. That is supposedly to be used for people to test their changes before any... [14:58:21] https://gerrit.wikimedia.org/r/360859 [15:07:28] we finally have our first stretch hosts with no puppet errors: https://icinga.wikimedia.org/cgi-bin/icinga/status.cgi?search_string=db2072 [15:20:22] 10DBA, 10Operations, 10Patch-For-Review: Adapt wmf-mariadb101 package for stretch and adapt its service to systemd - https://phabricator.wikimedia.org/T116903#3370853 (10jcrespo) The currrent package works ok, but there are 2 little details, which I am not 100% sure if to solve as config defaults or as packa... [15:23:53] 10DBA, 10Operations, 10Patch-For-Review: Adapt wmf-mariadb101 package for stretch and adapt its service to systemd - https://phabricator.wikimedia.org/T116903#3370861 (10Marostegui) +1 to place it on config rather than in package. I would prefer to be able to configure it thru puppet instead of hardcoding it... [15:49:37] 10DBA, 10Operations, 10Patch-For-Review: Adapt wmf-mariadb101 package for stretch and adapt its service to systemd - https://phabricator.wikimedia.org/T116903#3370951 (10jcrespo) [16:08:23] https://icinga.wikimedia.org/cgi-bin/icinga/status.cgi?search_string=db2072&scroll=297 that is a stretch host with all green [16:24:10] 10DBA, 10Operations, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3371135 (10Andrew) [16:25:50] 10DBA, 10Operations, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3369055 (10Andrew) [16:36:24] 10Blocked-on-schema-change, 10DBA: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3371212 (10MarkTraceur) [17:08:22] 10DBA, 10Operations, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3371363 (10Andrew) [17:37:10] 10DBA, 10Operations: Drop wikilove_image_log table from Wikimedia wikis - https://phabricator.wikimedia.org/T127219#3371477 (10kaldari) No worries. The purpose of this table was fulfilled years ago. It is safe to burn with fire. [17:39:56] 10DBA, 10Operations: Drop wikilove_image_log table from Wikimedia wikis - https://phabricator.wikimedia.org/T127219#3371497 (10kaldari) No worries. The purpose of this table was fulfilled years ago. It is safe to burn with fire. [19:21:08] 10DBA, 10Operations, 10Patch-For-Review: Prepare mysql hosts for stretch - https://phabricator.wikimedia.org/T168356#3371867 (10jcrespo) [19:21:11] 10DBA, 10Operations, 10Patch-For-Review: Adapt wmf-mariadb101 package for stretch and adapt its service to systemd - https://phabricator.wikimedia.org/T116903#3371865 (10jcrespo) 05Open>03Resolved I am going to resolve this because technically, the package and systemd are correct- the things missing are... [19:21:37] 10DBA, 10Operations, 10Patch-For-Review: Prepare mysql hosts for stretch - https://phabricator.wikimedia.org/T168356#3362038 (10jcrespo) [19:21:40] 10DBA, 10Operations, 10Patch-For-Review: Adapt wmf-mariadb101 package for stretch and adapt its service to systemd - https://phabricator.wikimedia.org/T116903#3371870 (10jcrespo) [19:22:09] 10DBA, 10Operations, 10Patch-For-Review: mysql user and group should be a system user/group - https://phabricator.wikimedia.org/T100501#3371873 (10jcrespo) 05Open>03stalled Blocked on full stretch migration. [19:22:12] 10DBA, 10Operations, 10Patch-For-Review: Prepare mysql hosts for stretch - https://phabricator.wikimedia.org/T168356#3362038 (10jcrespo) [19:24:46] 10DBA, 10Operations, 10Patch-For-Review: Prepare mysql hosts for stretch - https://phabricator.wikimedia.org/T168356#3371880 (10jcrespo) Aside from socket, datadir, basedir configurable on hiera: T148507 we need to create user systemd customizable templates (e.g. to increase the number of max file connections). [19:25:28] 10DBA, 10Operations, 10Patch-For-Review: Prepare mysql hosts for stretch - https://phabricator.wikimedia.org/T168356#3371882 (10jcrespo) a:03jcrespo For now, db2062 and db2072 are stretch hosts with systemd-driven mysqls. [21:33:09] 10DBA, 10Operations, 10cloud-services-team: Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3372376 (10madhuvishy) Hi all, So current status is: - labsdb1001 and 1003: Cloud team needs to announce user maintenance, and handle dns switchover during reboots(I'm not sure what t...