Charcoal HQ

ArtOfCode

00:00

@Undo just looking at some of the reports around Meltdown/Spectre... looks like the worst affected systems are poorly indexed/cached databases. Which means we're gonna have to do some optimization work with the MS DB.

"indexing the indexes" may not have been such a joke after all...

iBug

Drop indices and use jQuery?

in six to eight weeks?

ArtOfCode

:P

iBug

😊

angussidney

Urgh, this CPU thing is such good going away news

iBug

@angussidney Intel's bug?

angussidney

00:04

@iBug yeah, I have intel chips in basically all of my computers

iBug

I'm a fan of Intel, LOL.

ArtOfCode

@angussidney the effect is being over-exaggerated as usual, though

iBug

Though I think that bug won't have a huge impact to consumer-class users.

angussidney

Still, this would increase AMD competition, which is always a good thing for consumers

ArtOfCode

Day-to-day use is affected, obviously, but the impact isn't likely to be measurable

angussidney

00:05

@iBug yeah

ArtOfCode

The 20-30% impact numbers being thrown around are worst-case impact figures for specific kinds of usage

like databases

angussidney

Not that good for us developers then

I feel sorry for the poor people who are going to be fired because their bosses aren’t following the news

iBug

@angussidney Partially.

The price of GeForce, Quadro and Tesla won't drop.

ArtOfCode

@angussidney no, but if any group of users is going to be affected it may as well be developers, because at least we have the tools and knowledge to mitigate the impact

iBug

Use AMD EPYC?

ArtOfCode

00:09

index your databases properly

and make judicious use of caching

angussidney

@iBug Eh, Radeon technologies has been separated from AMD for a while now, and Vega hasn’t gone too well on the high end

@iBug I still find that stuff utterly amazing. Shame not many cloud providers use it yet.

ArtOfCode

> 99989 total reports

stop gloating metasmoke

iBug

Because Intel has dominated the server market for so many years?

angussidney

C’mon spammers.... I’m losing connection in about 10 mins and I want to see this happen

iBug

Yeah it's exciting to see the 100k milestone!

angussidney

00:13

@iBug yeah. I’m all in for more competition - means lower prices and better products for all

iBug

@angussidney Maybe everything is optimized for Xeon and EPYC is coming too late?

@angussidney Lol. When GeForce drops its price I can play 3A games with a lower cost.

Every gamer has a dream of possessing a GTX 1080

SmokeDetector

[ SmokeDetector | MS ] Offensive answer detected, repeating characters in answer: How did Toru and Koji pass the entrance exam in My Hero Academia? by G Gghyt on anime.SE

ArtOfCode

@iBug eh, nice but unnecessary. I'm running triple-A games on an i3-6100 and R380

solid 60fps

angussidney

I’ve just ordered an ultrawide monitor.... I can’t wait to see how it looks, but I’m afraid that my 1060 won’t like it

Maybe I should try overclocking

SmokeDetector

tpu by micsthepick

iBug

00:16

@ArtOfCode On my laptop, i7-4710HQ + GTX 860M

angussidney

@iBug ti*

ArtOfCode

@iBug the M is where you went wrong :P

iBug

Bought that top in July 2014 and it's tuned well by myself.

@ArtOfCode For some reasons a desktop computer isn't suitable for me.

E.g. can't be brought from home to university, nor can be taken into class.

ArtOfCode

@iBug depends how you do your trips to university...

I do it with my desktop, but I don't have to use public transport

angussidney

Ok, leaving now, happy 100k everyone!

iBug

00:18

My dad drove through 1000 km

ArtOfCode

and I have a Galaxy Book to take to class

iBug

taking all the stuff I needed, then

ArtOfCode

@iBug ouch, that's a fair trip

I only have to do 100 mi or so

SmokeDetector

tpu- by ByteCommander

iBug

They then moved on to another city to take care of their parents.

SmokeDetector

00:21

[ SmokeDetector | MS ] Offensive answer detected: I sent ETH to ETC from coinbase to Bitsane how do I get my coins back? by Doesn't matter on ethereum.SE

tpu- by ByteCommander

iBug

@SmokeDetector tp-

Do we need a consensus whether to blacklist users for posting offense?

Mithrandir

@iBug We already have one. We do.

iBug

@Mithrandir Oops.

Mithrandir

If it's an edit, we don't blacklist.

Otherwise... yes.

Byte Commander

We do, if it seems to be a troll and the whole post is an insult-fest. We don't if it's just a single slipped word and the rest of the post is fine after editing.

iBug

00:24

Thanks.

Mithrandir

Yeah, ^^that

iBug

Copy.

iBug

00:43

Spammers, you've done a great job and there's only 9 to go :)

Thanks for your "cooperation" for training our models :)

SmokeDetector

01:04

[ SmokeDetector | MS ] Username similar to website in answer: Is there a way with Hyper-V to use the wireless network on my server? by Dietrich Schroff on serverfault.com

iBug

@SmokeDetector Given that it's old, I prefer to leave it alone

Hey,

I see a lot of FPs in Mostly dots.

Quite a few of them looks like

How can I solve {a short problem statement}? Thanks........................................................

Which is a good hit for that reason.

@SmokeDetector n

SmokeDetector

02:09

API quota rolled over with 8038 requests remaining. Current quota: 19999.

math: 210
stackoverflow: 149
superuser: 46
codegolf: 43
askubuntu: 30
physics: 28
serverfault: 25
bitcoin: 25
english: 23
security: 21
unix: 20
apple: 20
drupal: 17
engineering: 16
academia: 15
interpersonal: 14
money: 11
gaming: 11
electronics: 11
scifi: 10
gis: 10
judaism: 10
ethereum: 10
skeptics: 9
arduino: 9
ell: 9
mathematica: 8
worldbuilding: 8
sharepoint: 8
islam: 8
es.stackoverflow: 8
travel: 8
mathoverflow.net: 7
webapps: 7
dba: 7
meta: 6
android: 6
diy: 6
chemistry: 5
wordpress: 5
stats: 5

iBug

What is API quota?

Tetsuya Yamamoto

Also what happens if API quota number reaches zero (which is unlikely to happen in daily basis)?

SmokeDetector

[ SmokeDetector | MS ] Blacklisted user: PayPal Sandbox - impossible edit business info profile settings by GJ51 on stackoverflow.com (@quartata @iBug @TetsuyaYamamoto)

iBug

@SmokeDetector naa-

SmokeDetector

naa- by Tetsuya Yamamoto

quartata

02:15

I actually don't think Smokey has ever run out of API quota

iBug

I'm getting 500 helpful flags today :)

quartata

But if it did it'd say API reports no quota left! May be a glitch.

iBug

@quartata Yeah. 20k quota daily with a maximum estimation of 15k posts rodat.

But what exactly is the API quota?

quartata

Well if we made one call per post we'd definitely run out of quota

We don't do that

@iBug just API calls per day

iBug

Restricted number of SE API calls?

quartata

02:16

yes

iBug

Spammers are extraordinarily silent today...

iBug

02:34

LOL.

I had nearly posted a wrong comment when I spotted it.

Welcome to Where Developers Learn, Share, & Build Careers! Please don't add "thank you" as an answer. Once you have sufficient reputation, you will be able to vote up questions and answers that you found helpful.

Obviously the SITENAME went wrong, haha

!!/test appngamereskin.com

SmokeDetector

> Potentially bad keyword in body, potentially bad keyword in title, potentially bad keyword in username
----------
Title - Position 1-19: appngamereskin.com
Body - Position 1-19: appngamereskin.com
Username - Position 1-19: appngamereskin.com

[ SmokeDetector | MS ] Bad keyword with email in answer, pattern-matching email in answer: failed to find pdf file by julia jeehee on tex.SE

tpu- by Tetsuya Yamamoto

iBug

@SmokeDetector k

iBug

03:05

@Glorfindel How did you earn "Fanatic" on various sites where you have zero Q and zero A?

quartata

@iBug it's just based on visiting

iBug

@quartata So I can create an account everywhere and expect effortless "Fanatic" by visiting CHQ?

quartata

no

visiting that particular site

iBug

What's the motivation?

But in fact, I have a 7-day streak on Super User where I am sure I don't.

quartata

Remember it's UTC

iBug

03:17

I'm sure I didn't visit SU for that period

I know it's UTC.

Undo

03:34

@iBug Have autoflagging turned on?

yeah, that's not it. We didn't flag anything with your account on SU, ever

@ArtOfCode T-6 posts

The 100k one had better not be an FP

iBug

@Undo Autoflag on but no SU flags.

Wait.

I see 5 flags in the past few days.

Definitely cast by Metasmoke.

Alright. That's the explanation.

Undo

03:53

@iBug Hrm?

metasmoke.erwaysoftware.com/flagging/users/347/logs

None on SU

iBug

@Undo I see unfamiliar spam flags cast

??????

Oh NO!

I'm recognising them.

When Smokey posts a report I go check it before giving feedback.

That included SU.

LOL, had a bad mind

Undo

heh

iBug

Confirmed.

I developed the habit of inspecting the real post before taking review actions in the LQP queue on SO

and I brought that habit here

Undo

Probably not a bad habit

iBug

Yeah.

What I do in the actual page usually is casting an extra NAA/VLQ flag (for badge) and leaving some (auto) comments.

Sometimes I stop reviewing the LQP queue when it reaches 19, and keep skipping after flagging, because when I do the 20th review I no longer have access until the next day.

Hmmm... I'm expecting the spam hour

It's 4:04 AM UTC and 8:04 AM in India

!!/alive

SmokeDetector

04:05

@iBug Of course

Undo

weird

iBug

@Undo Can mod check if there's any post recently deleted as spam?

Kinda like some statistics that should surely be available to ♦s.

MS record count stuck at 99994.

Undo

Nothing on SO for 8 hours

SmokeDetector

[ SmokeDetector | MS ] URL in title, bad keyword in body, blacklisted website in body, blacklisted website in title, link at end of body, +2 more: alphajackedhelp.com/alpha-xr/ by ulmllyskahtq on meta.SE (@iBug @TetsuyaYamamoto)

tpu- by Tetsuya Yamamoto

iBug

@SmokeDetector tpu- Just wondered.

Before I came here, I had always wondered why spam posts showed up with -2 or -3 instead of the regular zero.

iBug

04:27

!!/test ..........

SmokeDetector

> Mostly dots in body, mostly dots in title, title has only one unique char
----------
Title - Position 1-11: ..........
Title - Post contains 10 dots out of 10 characters
Post - Post contains 10 dots out of 10 characters

iBug

!!/test-a ..........

SmokeDetector

> Mostly dots in answer
----------
Post - Post contains 10 dots out of 10 characters

Undo

04:40

C'mon. It's 100k night and they're waiting us out

!!/queuestate

SmokeDetector

@Undo No such command 'queuestate'.

Undo

!!/queuestatus

SmokeDetector

tex.stackexchange.com: 1
blender.stackexchange.com: 4
matheducators.stackexchange.com: 1
cogsci.stackexchange.com: 1
mechanics.stackexchange.com: 1
korean.stackexchange.com: 1
economics.stackexchange.com: 1
computergraphics.stackexchange.com: 1
chemistry.stackexchange.com: 1
wordpress.stackexchange.com: 1
portuguese.stackexchange.com: 1
devops.stackexchange.com: 1
scifi.stackexchange.com: 1
spanish.stackexchange.com: 1
hinduism.stackexchange.com: 1
stats.stackexchange.com: 2
gamedev.stackexchange.com: 1

iBug

Queue?

Undo

maybe we won. maybe there is no more spam left.

iBug

04:41

Looks like there nothing too special in India.

Tomorrow is a restricted holiday that should not affect any business.

India's External Affairs Minister is visiting Thailand, Indonesia and Singapore and departing today.

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with email in answer, pattern-matching email in answer: React page does not rerender on url query change by charles steven on stackoverflow.com (@quartata @iBug @TetsuyaYamamoto)

tpu- by Tetsuya Yamamoto

iBug

@SmokeDetector k

SmokeDetector

[ SmokeDetector | MS ] Offensive answer detected: Why Saitama doesn't want to unleash his full power? by user37460 on anime.SE

tpu- by Undo

tpu by micsthepick

Undo

I.... think?

micsthepick

so do I

iBug

04:45

@SmokeDetector k

How does Smokey have 301 rep on SO?

Someone gave it a bounty on a deleted answer?

Undo

we pumped it for a while for flag privs when we were going a different direction on autoflagging

some people got upset at the idea of robots flagging stuff, so we went the distributed accounts route instead. More flags, less drama

micsthepick

(In the end it is the same thing)

iBug

Well then, 301 seems to be 201 + assoc bonus.

Undo

@micsthepick Except more sustainable for us

Now we can easily scale to however many flags we want

iBug

@micsthepick Basic difference: distributed flags can be manually retracted.

quartata

04:48

SO account came first, no association bonus

iBug

301???

quartata

Also that would start at 101

+200

@iBug ?

iBug

Why is it 301?

quartata

Rep from edits?

Undo

@iBug eh, we could more easily write an auto-retractor thing for a single account. That's a disadvantage

SmokeDetector

04:49

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, pattern-matching product name in body, +1 more: Vexan Male Enhancement It seems like a tall order by terseitern on askubuntu.com (@ThomasWard @quartata @TetsuyaYamamoto)

Undo

here we go

SmokeDetector

tpu- by Tetsuya Yamamoto

quartata

@Undo Oh, I thought we said we weren't doing that because EC2 gets ratelimited

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body: Biogenic XR Satisfactory of all by Aldammartin on askubuntu.com (@ThomasWard @quartata @TetsuyaYamamoto)

tpu- by Tetsuya Yamamoto

Undo

@quartata We can't do it because we don't have login creds for autoflagging accounts

If we had a single account, we probably could

quartata

04:51

Right I meant aside from that

I vaguely remember you saying that scraping SE didn't work so well

Undo

It can be sketchy.

We could probably figure that one out if we wanted to

but yeah

One more post

Getting ready to rebalance the flux capacitors

iBug

Flux capacitor?

quartata

Duckroll inbound

Undo

Dec 5 '17 at 10:50, by ArtOfCode

Psssst! If you're not on https://charcoal-se.org/people and you think you should be, now is a very very good time to make sure you're on it

^ valid for a limited time

quartata

!!/coffee

SmokeDetector

04:55

@quartata brews a cup of Ristretto for @quartata

quartata

Nice

Rob

@Undo Would it be possible to put me up as a team member?

Undo

yes

iBug

I prefer to stay for some more time before requesting to be put up as a team member.

Undo

k

Rob

04:56

Great

SmokeDetector

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: healthpurelives.com/primal-xl/ by pajkczqfw on askubuntu.com (@ThomasWard @quartata @TetsuyaYamamoto)

iBug

We have reached the 100,000th-Metasmoke-record milestone! The milestone record

Undo

100k posts. Thank you all, and congratulations. Someone should be in touch, SE is sending everyone stickers

25

SmokeDetector

tpu- by Tetsuya Yamamoto

thesecretmaster

@Undo There was a list of site mods to ping that I wanted to be on. Is this it?

Nope. Maybe I should've looked at the list first...

Tetsuya Yamamoto

04:59

Actually this is the 100,000th post: metasmoke.erwaysoftware.com/post/100000

Undo

@TetsuyaYamamoto The IDs lie.

SmokeDetector

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, +2 more: What Does Testo Rev Do? by enetordon on meta.SE (@iBug @TetsuyaYamamoto)

tpu- by Tetsuya Yamamoto

iBug

This is all we have :)

SmokeDetector

[ SmokeDetector | MS ] Offensive answer detected: Why did Misty leave the Pokemon anime? by baddad on anime.SE

Undo

@Undo @ArtOfCode's idea and scheming that got us free stickers.

SmokeDetector

05:00

tpu- by Tetsuya Yamamoto

Rob

@Undo Do I need to make a pull request somewhere or some-such?

Undo

If you're not on the list and you should be, ping me/Art ASAP and we'll review it.

@Rob I'm handling it

Rob

Ah, cheers

Undo

gotta figure out how to add to that list

quartata

what are these stickers

SmokeDetector

05:02

Restart: API quota is 19115.

[ SmokeDetector | MS ] Offensive answer detected, blacklisted user: How was Boruto able to throw the Rasengan and use Gentle Fist? by baddad on anime.SE

tpu- by Tetsuya Yamamoto

A J

@SmokeDetector k

thesecretmaster

Dunno who I should ping, but I get a JS error when I go to charcoal-se.org/pings/mods and the list never loads.

Undo

@quartata SE stickers, likely. I don't know what exactly is planned, just that we've been scheming for a while

@thesecretmaster It's not updated to work with the new API. Or the new API is broken

quartata

The usual swag ones then

Undo

You should be on that list

@quartata Suspect so. They're pretty good laptop stickers.

iBug

05:04

Oppose :)

Intel's stickers are the best

Undo

For ideas from four-years-ago-me:

42

A: May we have some more SO stickers, please?

STICKERS!!! Where would I place stickers? My laptop, top and bottom (it's too thin to put them on the sides) Every door I see (because people couldn't help seeing them as they open the door) My car (because I go a lot of places) Other peoples' cars (because they might go a lot of places) The b...

thesecretmaster

@Undo I checked couple months ago I wasn't but wanted to be, that's why I was checking again.

Undo

@iBug but they leak data

@thesecretmaster Oh, probably because of the metasmoke mod sites issue. That one is resolved.

thesecretmaster

Yay!

Undo

I'll look you up and see for sure

Tetsuya Yamamoto

05:05

@thesecretmaster Yep, I found an error: 'JSON.parse: unexpected character at line 1 column 1 of the JSON data'.

thesecretmaster

@Undo Thanks!

quartata

Empty response

So v1

iBug

I just bought 30+ Intel stickers and placed them everywhere

Mostly electronic products like laptop/phone/SSD/

Tetsuya Yamamoto

AFK for lunch in 30 minutes :)

Undo

@thesecretmaster yeah, you should be set up once the API display-side issue is fixed.

thesecretmaster

05:08

Yay!

My site has gotten ... 5 spam posts, ever. I promise I'm useful here :)

iBug

@thesecretmaster ?

thesecretmaster

I'm a pro-tem mod on a new low-traffic site, and so we get pretty much no spam.

iBug

CS Educators...

thesecretmaster

Yep

iBug

Public Beta?

thesecretmaster

05:10

Yep

iBug

Good

SmokeDetector

[ charcoal-se.github.io ] continuous-integration/travis-ci/push success on 19eeb57: The Travis CI build passed

Undo

done @Rob

Rob

@Undo Perfect, thanks

Undo

(@quartata this is the mysterious flux capacitor rebalance)

SmokeDetector

05:13

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: www.healthdietalert.com/levira-ageless-facial-serum/ by user270582 on apple.SE

tpu- by Undo

Undo

I'll let @ArtOfCode send the email in the next timezone, to give folks a little more time to get on the list. Might mention that Rob was a late add.

SmokeDetector

05:29

[ SmokeDetector | MS ] URL-only title, bad keyword in body, blacklisted website in body, blacklisted website in title, link at end of body: juvalifegermanyhelp.com/vortaxel/ by Dianoluciy on askubuntu.com (@ThomasWard @quartata @TetsuyaYamamoto)

Suraj Rao

sd k

iBug

@SmokeDetector k

@Undo Am I eligible for MS Reviewer and MS Core?

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, pattern-matching website in body: Testo SS Boost - Helps maintain a balanced testosterone level by emmacalderon on superuser.com (@TetsuyaYamamoto @iBug)

tpu- by Tetsuya Yamamoto

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: healthpurelives.com/primal-xl/ by pajkczqfw on apple.SE

tpu- by Tetsuya Yamamoto

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, pattern-matching website in body: Testo SS Boost is really works? by suzainena on astronomy.SE

tpu- by Tetsuya Yamamoto

[ SmokeDetector | MS ] URL-only title, bad keyword in body, bad keyword in title, bad keyword in username, pattern-matching product name in body, +2 more: www.supplementdeal.co.uk/testro-t3/ by Testro T3 on askubuntu.com (@ThomasWard @quartata @TetsuyaYamamoto)

tpu- by Tetsuya Yamamoto

[ SmokeDetector | MS ] Bad keyword with email in answer: How to access "Saved Audiences" with the Facebook Ad API? by Stack on stackoverflow.com (@quartata @iBug @TetsuyaYamamoto)

tripleee

05:48

@SmokeDetector n

!!/watch 744357761

SmokeDetector

@tripleee Added 744357761 to watchlist

iBug

@tripleee You needn't have done so.

SmokeDetector

CI on 25c2760 succeeded. Message contains 'autopull', pulling...

iBug

It's a regular user and this term is unlikely to show up again.

SmokeDetector

[ SmokeDetector ] SmokeDetector started at rev 25c2760 (SmokeDetector: Auto watch of 744357761 by tripleee --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 18794.

iBug

05:58

As well, blocking a QQ number (a popular IM platform in China) won't have a great effect.

tripleee

@iBug if they did it once they might do it again ... though I agree that these entries have a limited lifetime and should be pruned from the watch list if they are not producing any hits

iBug

@tripleee Either you forgot, or I didn't at all, that I disclosed that I'm Chinese.

Transcript for