#known 2020-01-05

2020-01-05 UTC
[cleverdevil] joined the channel
#
[cleverdevil] FYI [mapkyca] I’ve updated to trunk and the database migration completed successfully, but my site is crashing now on the regular. Pegging MySQL intermittently. Doing a quick upgrade to the MySQL instance to see if it helps and enabling slow query logging.
#
Loqi [cleverdevil]: [jgmac1106] left you a message 3 weeks ago: I pushed a fix and probably a mistake to the Known plug-in
[tantek], [Marlin_Forbes], [fluffy], [kimberlyhirsh] and [cleverdevil] joined the channel
#
[cleverdevil] Okay, reverted to before the schema change and things are back to normal. Lost a few minor posts, but no biggie :)
[mapkyca] joined the channel
#
[mapkyca] Hmm... would be good to have some more information.... was it a hard fatal error, or a speed thing? If it's the latter, was it occurring at certain points (e.g. search)?
jbove, [tantek], [asuh], Stef, kriss1291983 and [mapkyca] joined the channel
#
[mapkyca] Any error logs?
[LewisCowles], [jgmac1106], [jeremycherfas], jbove, [tantek], [Sadik_Shahadu], [email096], [asuh], [CrowderSoup], [Michael_Beckwit and [cleverdevil] joined the channel
#
[cleverdevil] Sorry [mapkyca] I had to run before I could reply.
#
[cleverdevil] Things looked okay, but a lot slower, after initial upgrade.
#
[cleverdevil] Certain pages would take a very very long time to come back, and eventually all of the PHP-fpm workers would hang and my MySQL server would peg the CPU.
#
[cleverdevil] Only resort was to kill all the PHP workers and restart everything.
#
[cleverdevil] Specific pages that were very slow included my “On this Day” page, and my “Overview” pages.
#
[cleverdevil] After rollback everything is super fast again.
#
[cleverdevil] I didn’t check the PHP error logs but interestingly wasn’t seeing anything in the MySQL slow query log. But I may not have enabled it properly.
[mapkyca] joined the channel
#
[mapkyca] Hmmm... it sounds like it might be an indexing issue, but hard to say. Turning on slow query with logging for unindexed queries would be useful. I might have missed something in the patching - it assumes full text, but that might not be true.
#
[mapkyca] That's my hunch, anyway
#
[cleverdevil] Eventually I’ll have some time to spin up a separate install to test with :)
[LewisCowles], Googol303623[m], [Michael_Beckwit and [tantek] joined the channel