#dev | Logs for 2018-02-07

« return
[00:08:44] <Bytram> ~remind 1440 m Remind TheMightyBuzzard to fix template_tool
[00:08:45] <exec> *** reminder set for Bytram: Remind TheMightyBuzzard to fix template_tool
[03:16:34] -!- cortex has quit [Quit: Textual IRC Client: www.textualapp.com]
[20:52:42] <TheMightyBuzzard> huh, it doesn't appear most any of the db updates went live with that patch that should have.
[21:20:16] <Bytram> TheMightyBuzzard: what are we missing?
[21:22:26] <TheMightyBuzzard> all the core updates and the plugin updates i didn't run manually.
[21:22:52] <TheMightyBuzzard> got a couple alter table statements that are going to take a while to complete.
[21:23:07] <Bytram> I see you are working on it atm; I'll wait until you are done for the whole story.
[21:23:27] <TheMightyBuzzard> naw. i'm watching an alter table statement sit there and work.
[21:23:34] <Bytram> nod nod
[21:23:42] <TheMightyBuzzard> for long enough now that i had time for a smoke break.
[21:23:51] <Bytram> *chuckles*
[21:24:00] <Bytram> what clued you in that something was amiss?
[21:24:25] <TheMightyBuzzard> random stray thought and the need to check that all was as it should be.
[21:24:34] <Bytram> good good
[21:25:19] <TheMightyBuzzard> right now it's turning the story notes from varchar to text. next up is doing the same on the submissions table which'll take even longer.
[21:25:49] <Bytram> ahhh, got it
[21:26:39] <TheMightyBuzzard> forgot how long this took on dev and dev ain't got near the content prod does.
[21:31:03] <Bytram> too bad there was no way to copy and update the old stuff to a tables, and then do, essentially, a rename of each new-table to old-table... iow, do transformation in the background with only a small window of downtime...
[21:31:16] <Bytram> problem would be any activity on those tables while the migration was happening
[21:31:26] <TheMightyBuzzard> well we could but it'd take just as long.
[21:31:43] <TheMightyBuzzard> and yeah, the site would need to be down during
[21:31:56] <Bytram> nod nod
[21:32:16] <Bytram> it's more of a WIBNI (Wouldn't It Be Nice If...) than anything else
[21:32:22] <TheMightyBuzzard> yup
[21:32:46] * Bytram goes back to playing sudoku
[22:08:14] <chromas> mysql doesn't alter tables while running? fpos
[22:35:33] <TheMightyBuzzard> hmmm... i think i'll put up a shit's broke page on the load balancer
[22:36:53] <chromas> Make it say exactly that
[22:36:57] <chromas> Maybe with a poo glyph
[22:37:25] <chromas> Tell 'em to come bitch in irc; we need fresh meat
[22:40:19] <TheMightyBuzzard> think i will
[22:52:28] -!- caffeine [caffeine!~andrew@101.191.jiq.nmq] has joined #dev
[23:28:24] -!- caffeine has quit [Ping timeout: 250 seconds]