#Soylent | Logs for 2018-10-11
« return
[00:00:23] <Bytram> some with variant values depending on the where one is on the other axes!
[00:11:10] <Bytram> Boom! 500 error time again.
[00:11:27] <Bytram> while tring to preview a story
[00:11:41] * Bytram tries to refresh main page
[00:11:44] <Bytram> another 500
[00:11:51] <Bytram> again
[00:12:32] <Bytram> styill happenin
[00:13:11] <Bytram> still
[00:13:22] <Bytram> done
[00:13:32] <hopdevil> main page was working for me
[00:13:48] <Bytram> ^^^ was just a second or two after hitting F5 got me a non-500 error response code.
[00:13:50] <TheMightyBuzzard> i should certainly hope it's still happening. i haven't done anything yet.
[00:14:12] <Bytram> yeah, but I was trying to nail down a time stamp for when it started/ended to help narrow down its cause
[00:15:09] <Bytram> I was hitting F5 (reload/refresh) as fast as I could following each 500 error.
[00:15:33] <Bytram> s/fast/soon/
[00:15:34] <exec> <Bytram> I was hitting F5 (reload/refresh) as soon as I could following each 500 error.
[00:15:42] <TheMightyBuzzard> the cause is an O(n^2) query that starts getting cocktastic at a little over seven thousand users
[00:16:29] <Bytram> and what query is that?
[00:16:36] <TheMightyBuzzard> the mod points one
[00:16:52] <Bytram> to decide who gets mod points?
[00:17:05] <TheMightyBuzzard> yes
[00:17:26] <Bytram> ugh. sounds painful.
[00:18:26] <TheMightyBuzzard> annoying. it ran fast enough with 5k users so i didn't give any thought to optimizing it.
[00:18:59] <chromas> Does anyone not get points? What if you don't compare dates or whatever?
[00:19:13] <chromas> Just everyone whose not b&
[00:19:14] <TheMightyBuzzard> everyone with a month or more of time
[00:19:40] <Bytram> and... positive karma or at least over some threshold
[00:19:52] <TheMightyBuzzard> no, just time
[00:20:06] <chromas> Ah. What if you select the first user beyond the time threshold and just do everyone whose uid is lower?
[00:20:53] <TheMightyBuzzard> that's what i've been looking at but i'm trying to figure out how to get it coded so that i don't have to compare every bloody value to find the highest uid to grant to.
[00:21:37] <chromas> select uid where join_date < $current_year - month limit 1
[00:21:42] <TheMightyBuzzard> and right now i'm not even doing that. i'm reading a book.
[00:21:49] <Bytram> select max(users.uid) where users.created < ${one month ago}
[00:21:52] <chromas> oh, order descending by date
[00:22:43] <TheMightyBuzzard> yes, that would be the slowest way possible to do it.
[00:22:46] <chromas> Bytram's is better
[00:23:06] <chromas> Do you have an index on the joined date column?
[00:23:12] <TheMightyBuzzard> i doubt it
[00:23:19] <chromas> That'll make a yuge difference on its own
[00:24:52] <TheMightyBuzzard> we need several indexes added all across the db. i'll get started on it the rest of this week or early next week
[00:25:01] <Bytram> TheMightyBuzzard: Is this the one that gets updated with new mod points? users_info.points
[00:25:12] <TheMightyBuzzard> probably
[00:25:53] <chromas> You could put an index on the query itself >:)
[00:25:59] <TheMightyBuzzard> never remember, always check. you can tell if your eyes are playing tricks on you. your memory, not so much.
[00:28:10] <chromas> You could have a weekly cronjob to check the highest pointworthy uid and store it in a file
[00:28:16] <Bytram> update users_info.mod_points = 10 where (users_info.created_at < OneMonthAgo) AND (users_info.mod_banned < today)
[00:28:37] * Bytram is just waving hands around that one... hasn't looked at actual code.
[00:28:49] * Bytram misses having a VM with up-to-date source he could peruse
[00:30:54] <TheMightyBuzzard> well the size of a gentoo vm isn't going to be something you can acquire over your connection. i'll have to mail you a few dvds.
[00:32:50] <Bytram> gentoo, is that the distro that needs relatively frequent rebuilding? or am I thinking of something else... slackware?
[00:33:03] <Bytram> recompiling, relinking, etc.
[00:34:36] <chromas> Yeah, but I think it's Calculate Linux, which is a binaries-based offshot
[00:34:54] <TheMightyBuzzard> nah, sn uses gentoo and i use calculate
[00:34:59] <chromas> ah
[00:35:22] <Bytram> so how often to we rebuild our image?
[00:35:23] <TheMightyBuzzard> sn stuff pulls pre-built updates from dev though
[00:35:24] <Bender> [SoylentNews] - SETI: Not Successful Because We Are Barely Even Looking? - http://sylnt.us - CAN-YOU-HEAR-ME-NOW?
[00:35:27] <chromas> Should switch to Smakeware Linux
[00:35:33] <TheMightyBuzzard> man, i ain't even finished the image
[00:35:41] <TheMightyBuzzard> #smake chromas
[00:35:41] * MrPlow smakes chromas upside the head with a TEDx speech
[00:35:53] <chromas> Thanks. Now I'm ever more retarted
[00:36:07] <Bytram> #g Pop Tart
[00:36:07] <MrPlow> https://www.kelloggs.com - "Results 1 - 12 of 25 ... Join us as we celebrate all that is special about Pop-Tarts®: the filling, frosting, and sprinkles that dazzle our taste buds and make us dance ..."
[00:36:08] <upstart> ^ 03Pop-Tarts®
[00:36:16] <TheMightyBuzzard> it's all good to go except the db entries but i haven't monkeyed with it in quite some time
[00:36:25] <Bytram> nod nod
[00:36:54] <TheMightyBuzzard> i'm all but certain the populate a new db script isn't going to work properly
[00:37:35] * Bytram would love to help out, but just getting a system that I won't have to futz about with drivers, and rebuilding, and relinking and ... and all to get a running system, want a Just Works(TM) system, if I can.
[00:38:01] <Bytram> TheMightyBuzzard: So that would be a... population explosion?
[00:38:04] <Bytram> ;)
[00:38:31] <TheMightyBuzzard> #smake Bytram
[00:38:31] * MrPlow smakes Bytram upside the head with smoked ribs
[00:38:39] <Bytram> ROFL!!!!!!
[00:39:14] <Bytram> =submit https://www.theregister.co.uk
[00:39:15] <upstart> Submitting "PINs and needled: Experian site blabbed codes to unlock credit accounts for fraudsters"...
[00:39:37] <upstart> Sub-ccess! https://soylentnews.org
[00:39:48] <TheMightyBuzzard> aight, i got evening lazying to do. see yall in the morning.
[00:39:54] <Bytram> umm, I'm getting some really strange display artifacts on dev...
[00:39:58] <Bytram> main page
[00:40:09] <TheMightyBuzzard> don't care. it's dev.
[00:40:16] <Bytram> the story "posted by" line runs off left hand side
[00:40:37] <Bytram> ahhh!
[00:40:40] <TheMightyBuzzard> yeah, that's chromas breaking stuff with his edity powers.
[00:40:58] <TheMightyBuzzard> he bytramed it all up
[00:41:09] * Bytram scrolls down and sees that someone is tring to get story text to hit the left margin of the page after the left hand slash box
[00:41:50] <Bytram> was that a fyngyrz thing?
[00:42:25] <Bytram> is 86+F at my desk... stepping away to cool off for a bit
[00:42:44] * TheMightyBuzzard points at chromas
[00:42:54] <TheMightyBuzzard> anyway, see yall in the morning.
[00:43:02] <Bytram> ~gnight TheMightyBuzzard
[00:43:04] * exec clumsily allocates Santa's bag of companionship for TheMightyBuzzard
[00:43:13] <Bytram> you gets a buddy!
[01:24:19] -!- stderr_dk has quit [Read error: Connection reset by peer]
[01:24:39] -!- stderr_dk [stderr_dk!~poho@2001:470:28:squ:nj:hwtv:wxjm:slnz] has joined #Soylent
[01:32:20] <chromas> Bytram: the errors on dev come from the dept field. On the top story I think
[01:36:35] -!- stderr_dk has quit [Ping timeout: 248 seconds]
[01:38:13] <Bytram> chromas: Dept line, yes... but I see it incorrect for the first 4 stories.
[01:39:39] -!- stderr [stderr!~poho@GetOffMyLawn/stderr] has joined #Soylent
[02:27:00] <Bytram> #g falcon heavy launch price
[02:27:02] <MrPlow> https://en.wikipedia.org - "The published prices for Falcon Heavy launches have changed ... with announced prices for the various versions of Falcon Heavy ..."
[02:27:05] <upstart> ^ 03Falcon Heavy - Wikipedia
[02:35:28] <Bender> [SoylentNews] - Book Review: Rainbows End by Rudy Rucker - http://sylnt.us
[02:40:08] <Bytram> #g SLS max payload GTO
[02:40:10] <MrPlow> https://en.wikipedia.org - "The Space Launch System (SLS) is an American Space Shuttle-derived super heavy-lift .... It would deliver over 20,000 kN (4,500,000 lbf) maximum thrust and weigh 790,000 kg (1,750,000 lb) at ignition. ... In May 2018, NASA updated the payload capability of the SLS Block 1 from 70 to 95 metric tons to low Earth orbit."
[02:40:15] <upstart> ^ 03Space Launch System - Wikipedia
[02:43:49] <Bytram> #g BFR development cost
[02:43:51] <MrPlow> http://www.thespacereview.com - "Oct 9, 2017 ... The assumptions presumably are for a vibrant ship construction industry ... The BFR booster will likely cost about 80 percent of the ITS booster ..."
[03:00:40] <Bytram> ~arthur https://www.bbc.co.uk
[03:00:44] <exec> 1045 stories loaded
[03:00:44] <exec> attempting to submit story: "James Murdoch tipped to lead Tesla board"
[03:01:15] <exec> submission successful - https://soylentnews.org
[03:01:22] <exec> 1044 stories loaded
[03:03:27] <Bytram> ~arthur https://www.sciencedaily.com
[03:03:31] <exec> 1044 stories loaded
[03:03:31] <exec> attempting to submit story: "In the absence of bees, flies are responsible for pollination in the Arctic region"
[03:04:02] <exec> error: something went wrong with your submission - maybe try again in a minute
[03:06:09] <Bytram> ~arthur https://www.sciencedaily.com
[03:06:13] <exec> 1044 stories loaded
[03:06:13] <exec> attempting to submit story: "In the absence of bees, flies are responsible for pollination in the Arctic region"
[03:06:44] <exec> submission successful - https://soylentnews.org
[03:06:50] <exec> 1043 stories loaded
[03:07:26] <Bytram> ~arthur https://www.sciencedaily.com
[03:07:29] <exec> it has been only 45 seconds since the last submission - please wait
[03:07:46] <Bytram> ~arthur https://www.sciencedaily.com
[03:07:51] <exec> 1043 stories loaded
[03:07:51] <exec> attempting to submit story: "Ideal protein to help seniors rebuild lost muscle"
[03:08:21] <exec> error: something went wrong with your submission - maybe try again in a minute
[03:12:14] <Bytram> ~arthur https://threatpost.com
[03:12:18] <exec> 1043 stories loaded
[03:12:18] <exec> attempting to submit story: "PoC Attack Escalates MikroTik Router Bug to ‘As Bad As It Gets’"
[03:12:49] <exec> submission successful - https://soylentnews.org
[03:12:55] <exec> 1043 stories loaded
[03:46:43] <Bytram> #g betteridge headline
[03:46:43] <MrPlow> https://en.wikipedia.org - "Betteridge's law of headlines is an adage that states: \"Any headline that ends in a question mark can be answered by the word no.\" It is named after Ian ..."
[03:46:44] <upstart> ^ 03Betteridge's law of headlines - Wikipedia
[04:07:11] <Bender> [SoylentNews] - Amazon Scraps Secret AI Recruiting Tool That Showed Bias Against Women - http://sylnt.us - unseen-bias-is-still-bias
[04:15:06] <Bytram> time for some shuteye...
[04:15:13] <Bytram> have a great night everybody!
[05:46:30] <Bender> [SoylentNews] - The Military Chooses Which Rockets It Wants Built for the Next Decade - http://sylnt.us - if-these-companies-had-cheerleaders,-would-they-be...booster-boosters?
[07:27:52] <Bender> [SoylentNews] - Publisher Drops Tronc Name, Reverts to Tribune Publishing - http://sylnt.us - a-few-more-sales-and-they'll-rename-Tri-bune-to-Bi-bune
[08:56:01] <Bender> [SoylentNews] - House Passes Bill to Require Minimum Standards for Airplane Seat Size, Legroom - http://sylnt.us - make-seat-backs-thinner
[09:09:21] <chromas> Just pile the passengers into a big heap
[10:29:44] <Bytram> chromas: s/pa.*r/sardine/
[10:29:46] <exec> <Bytram> <chromas> Just pile the sardines into a big heap
[10:30:22] <chromas> Good point. They're in a flying tin can after all
[10:30:38] <chromas> put...put your brine in it
[10:30:55] * chromas doesn't know how sardines are packed
[10:32:27] <Bytram> alternating head to the right and head to the left
[10:32:52] <Bytram> coffee++
[10:32:52] <Bender> karma - coffee: 4363
[10:33:14] <chromas> ah, bass-to-mouth
[10:33:26] <Bytram> ROFL!
[10:36:52] <Bender> [SoylentNews] - Robocallers "Evolved" to Sidestep New Call Blocking Rules, 35 State AGs Tell FCC - http://sylnt.us - No,-I-do-NOT-want-to-hear-you-now!
[10:37:05] <chromas> https://www.ft.com
[10:37:07] <upstart> ^ 03Subscribe to read | Financial Times
[10:37:13] <chromas> ghey
[10:37:27] <chromas> "Space rocket makes emergency landing in Kazakhstan"
[10:37:52] <Bytram> huh?
[10:37:59] <chromas> Financial Times suxx
[10:38:09] * chromas considers deleting from feed
[10:38:29] <Bytram> https://arstechnica.com
[10:38:30] <upstart> ^ 03A Soyuz crew makes an emergency landing after rocket fails ( https://arstechnica.com )
[10:38:31] <chromas> https://www.cnet.com
[10:38:32] <upstart> ^ 03NASA astronaut, Russian cosmonaut make emergency landing after Soyuz rocket failure
[10:44:19] <Bytram> https://blogs.nasa.gov
[10:44:20] <upstart> ^ 03Space Station – Off The Earth, For The Earth
[10:47:52] <chromas> Hehe, more Windows Update failures
[10:48:05] <chromas> Probably why the rocket failed
[10:55:12] <Bytram> Oh? what's broken NOW?
[12:06:33] <Bender> [SoylentNews] - Are Super-Cheap Solar Fields in the Middle East Just Loss-Leaders? - http://sylnt.us - Betteridge-says-"No"
[12:32:18] <Bytram> !uid
[12:32:18] <Bender> The current maximum UID is 7140, owned by popeyelmarino
[13:13:39] <Konomi> reading some crappy scam site and they couldn't get their payload to obfuscate so they just ended up writing it directly into the page
[13:13:43] <Konomi> it's so laughable
[13:45:50] <Bender> [SoylentNews] - There's a New Report on SLS Rocket Management, and It's Pretty Brutal - http://sylnt.us - missive-on-mismanaged-missiles
[14:44:01] -!- arti|work [arti|work!~textual@kpku-40-80-465-497.west.biz.rr.com] has joined #Soylent
[15:16:59] <Bender> [SoylentNews] - Australia Doesn't Care to Break its Coal Habit in the Face of Climate Change - http://sylnt.us - smoke-gets-in-your-eyes-and-lungs-and-clothes-and-environment
[16:15:57] <Bytram> ~time x
[16:15:59] <exec> Thursday, 11 October 2018 @ 4:15 pm UTC - Coordinated Universal Time
[16:24:19] -!- Web_weasel [Web_weasel!~Stefan@ttjn926-10-73-07.range169-39.btcentralplus.com] has joined #Soylent
[16:43:56] -!- Web_weasel has quit [Read error: Connection reset by peer]
[16:47:09] <Bender> [SoylentNews] - PINs and Needled: Experian Site Blabbed Codes to Unlock Credit Accounts for Fraudsters - http://sylnt.us - another-day-another-flaw
[17:15:06] -!- Web_weasel [Web_weasel!~Stefan@ttjn926-10-73-07.range169-39.btcentralplus.com] has joined #Soylent
[17:15:26] -!- Web_weasel has quit [Read error: Connection reset by peer]
[17:16:41] -!- Web_weasel [Web_weasel!~Stefan@ttjn926-10-73-07.range169-39.btcentralplus.com] has joined #Soylent
[17:31:51] <Bytram> =submit https://www.bbc.co.uk
[17:31:56] <upstart> Submitting "Take off for the longest non-stop flight"...
[17:32:18] <upstart> Sub-ccess! https://soylentnews.org
[17:36:29] <AndyTheAbsurd> I would like to register my objection to that story.
[17:37:28] <AndyTheAbsurd> The flight is SIA-EWR; SIA is Singapore, but the story says that the flight is to "New York" but EWR is the airport code for an airport in Newark, NJ.
[17:41:05] <Bytram> EWR is what I saw in that story? Heck, it was on the guy's t-shirt.
[17:41:19] <AndyTheAbsurd> Yes.
[17:41:28] <AndyTheAbsurd> And I fucking HATE Newark Airport.
[17:41:42] -!- EgNagRah [EgNagRah!~93003472@vgnv-356-7-92-209.central.biz.rr.com] has joined #Soylent
[17:41:50] <Bytram> that's why they'll have a non-stop to take you far FAR away from it! =)
[17:49:26] -!- EgNagRah has quit [Quit: Web client closed]
[17:49:52] <AndyTheAbsurd> #submit https://www.ecnmag.com
[17:49:53] <MrPlow> Unable to find a summary for that page
[17:50:00] <AndyTheAbsurd> =submit https://www.ecnmag.com
[17:50:02] <upstart> Submitting "Engineers Develop Process To 3-D Print Cells To Produce Human Tissue Such As Ligaments And Tendons"...
[17:50:23] <upstart> Submit failed: This resource is no longer valid. Please return to the beginning and try again.
[18:00:06] <Bytram> that's why they'll have a non-stop to take you far FAR away from it! =)
[18:00:11] <Bytram> =submit https://www.bbc.co.uk
[18:00:15] <upstart> Submitting "Take off for the longest non-stop flight"...
[18:00:37] <upstart> Sub-ccess! https://soylentnews.org
[18:00:37] <Bytram> !seen TheMightyBuzzard
[18:00:45] <Bytram> ~seen TheMightyBuzzard
[18:00:47] <exec> Bytram, TheMightyBuzzard was last seen in #Soylent 54 days, 23 hours, 40 minutes, 43 seconds ago with message:
[18:00:47] * exec fucks off to a week of sweating and getting bit by bugs
[18:01:06] <Bytram> ~seen Bytram
[18:01:07] <exec> Bytram, Bytram was last seen in #Soylent 55 days, 5 hours, 49 minutes, 59 seconds ago with message: okay, time for me to get ready for work... laters!
[18:01:14] <Bytram> yeah, right. :P
[18:16:15] <Bender> [SoylentNews] - Research Suggests People Know an Average of 5,000 Faces - http://sylnt.us
[18:20:54] <Bytram> #g pseudocumene
[18:20:54] <MrPlow> https://en.wikipedia.org - "1,2,4-Trimethylbenzene, also known as pseudocumene, is an organic compound with the chemical formula C6H3(CH3)3. Classified as an aromatic ..."
[18:20:55] <upstart> ^ 031,2,4-Trimethylbenzene - Wikipedia
[18:22:40] <Bytram> =submit http://timetravellerwiki.com
[18:22:42] <upstart> Submitting "Chemical spills put Italy's underground physics lab in jeopardy"...
[18:23:04] <upstart> Sub-ccess! https://soylentnews.org
[19:47:30] <Bender> [SoylentNews] - Soyuz Crew Vehicle Fails Mid-Flight, Astronauts OK - http://sylnt.us - not-going-to-space-today
[20:06:31] <chromas> You know what SN really needs? Replace mod descriptors with reacts
[20:07:48] <chromas> 😠🤣😢5
[20:14:27] -!- upstart has quit [Ping timeout: 248 seconds]
[20:17:43] -!- upstart [upstart!~systemd@0::1] has joined #Soylent
[21:08:29] -!- Web_weasel has quit [Read error: Connection reset by peer]
[21:25:43] <Bender> [SoylentNews] - HBO, CNN, DC Comics, and More Could Join a Streaming Video Service Under AT&T - http://sylnt.us - merrily-down-the-stream?
[23:06:59] <Bender> [SoylentNews] - Using Firefox Lightbeam for Visualizing On-the-Fly the Benefits of Privacy - http://sylnt.us - see-what-you're-missing
[23:28:07] -!- arti|work has quit [Quit: My Mac has gone to sleep. ZZZzzz…]