Tavern on the Meta

Quill

12:52 AM

in The Nineteenth Byte on The Stack Exchange Network Chat, 2 mins ago, by Doorknob

user202362

don't be close to python, they will bite you in the butt

tchrist

@Quill :%s/if everything was/if everything were/

Quill

@Telkitty another good reason to not use Python

tchrist

@Telkitty Wrong butt.

user315433

1:20 AM

@doppelgreener This one? Rolling question rate limits are now network-wide by Tim Post on meta.stackexchange.com

doppelgreener

1:39 AM

@sandwich That's exactly the one. Thank you very much.

John

We're sorry, but there are NO new users allowed here on meta! Privilege: create posts awarded at 2 reputation.

Quill

That was a temporary response to a wave of off-topic questions

John

I know. The off-topic junk is because a ton of people were reading the "we have updated our terms of service" inbox notification, and not realizing they were no longer on stack overflow. I think a better solution would be to make it so that if you are not a member of the meta or you only have one reputation on meta, all links on the "we have updated our terms of service" page are invalid and the "unanswered... ask question" banner is not showed on that page only.

That way they would have to hit the back button to ask, which would bring them back to stackoverflow

Quill

1:54 AM

silent blocks are much more productive

John

I'm not suggesting a non-silent block, I'm suggesting for all links on the "we have updated our terms of service" page to be invalidated.

@SmokeDetector why don't you ever beep when you discover smoke?

Quill

2:10 AM

he can beep github.com/normalhuman/Userscripts/blob/master/…

John

Then why don't I hear it? Is there some glitch with my profile?

Quill

it's a userscript, meaning it's not part of standard chat

John

Oh.

John

2:26 AM

greetings, @bjb568

bjb568

2:36 AM

15

A: Can limits be thought of as linear functionals (or operators, depending on context)?

Limits can definitely be seen as functionals. The problem is that to consider them as a functional, you need the limit to be defined on all elements of a vector space. If you are dealing with continuous functions on a compact set (or an interval, to make things simpler), then the limit is just ...

Interesting math fight in comments.

@John Hallo

SmokeDetector

4:10 AM

[ SmokeDetector ] Link at end of body, pattern-matching website in body: TestX Core What if there is a method by balndharry on drupal.stackexchange.com …

[ SmokeDetector ] Offensive answer detected: Under what conditions will healers switch targets? by Owen Curran on gaming.stackexchange.com …

[ SmokeDetector ] Bad keyword in body, link at end of body, pattern-matching website in body: Evening lotion applied at bedtime by nokithomn jpei on arduino.stackexchange.com …

[ SmokeDetector ] Bad keyword in body, link at end of body, link following arrow in body, pattern-matching website in body: Now could be the ideal time for you to inspire by user22730 on arduino.stackexchange.com …

[ SmokeDetector ] Bad keyword with email in answer, email in answer: Knowing the bad credit (for loans) in Austria (KSV and similar) by Loan Loan on money.stackexchange.com …

Quill

sd 5k

SmokeDetector

[ SmokeDetector ] URL in title, bad keyword in body, bad keyword in title, link at end of body, pattern-matching website in body, pattern-matching website in title: http://musclebuildingbuy.com/dermaserre/ by Camzocozz on security.stackexchange.com …

[ SmokeDetector ] Bad keyword in body, bad keyword in title, link at end of body, link following arrow in title, pattern-matching website in body, pattern-matching website in title: 10 Stategies To Increase Natural Testosterone Production..>>> mylaviveeyeserum.com/staminon-reviews by boydmcmillan on askubuntu.com (@kos)

Quill

sd 2k

SmokeDetector

4:46 AM

[ SmokeDetector ] Bad keyword in body, link at end of body, pattern-matching website in body: Ways To Bulk Up Build Strength Quickly by danielsstuart on superuser.com …

SmokeDetector

5:08 AM

[ SmokeDetector ] Link at end of body, pattern-matching website in body: How Does Megamaximus work? by rokkythomas on superuser.com …

Quill

ccccccombo breaker

sd 2k

SmokeDetector

5:25 AM

[ SmokeDetector ] URL in title, bad keyword in body, link at end of body, link following arrow in body, pattern-matching website in body: http://iqilicaqenagi.tumblr.com/ by user22734 on arduino.stackexchange.com …

SmokeDetector

5:35 AM

[ SmokeDetector ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, pattern-matching website in body: — Other key fixings in Gavali Advance Skincare by Anall1965 on arduino.stackexchange.com …

Quill

sd 2k

user202362

6:14 AM

user202362

Umm ... Why?

Bart

7:05 AM

Why what?

SmokeDetector

[ SmokeDetector ] Pattern-matching website in answer: What is a word for "loosely mirror" something/someone else? by cleomliddle on english.stackexchange.com …

Quill

8:08 AM

turns out I did get an email from Fog Creek about HyperDev...

> Thanks again for your interest and participation; user feedback has been so incredibly helpful to us the last few months. In fact, we'd like to send you a thank you gift! Can you please respond with the best mailing address to reach you? We'll only use this information for good :)

it went to my junk inbox ;-;

user202362

@Bart 2 x 2 hours later?

user202362

I refreshed .. same probem

bjb568

8:25 AM

Muted user?

SmokeDetector

[ SmokeDetector ] Bad keyword with email in body, email in body: thanks to dr solution for bringing back my lover by AINA on travel.stackexchange.com …

[ SmokeDetector ] Bad keyword with email in answer, email in answer: Should I use IRA money to pay down my student loans? by Murilo moore on money.stackexchange.com …

[ SmokeDetector ] URL in title, link at end of body, link following arrow in body: https://bodybuildingreview721.wordpress.com/ by jagoweuuvi amihxu on arduino.stackexchange.com …

[ SmokeDetector ] Bad keyword in answer: How does a two-piece water softener work and what maintenance does it require? by Abirami on diy.stackexchange.com …

Shadow Wizard

9:22 AM

(@bjb568 is right, you ignore Feeds for some reason.)

SmokeDetector

[ SmokeDetector ] Bad keyword in body, blacklisted website in body, link at end of body: you're going through drawback? by catherinbandi on askubuntu.com (@kos) …

Shadow Wizard

sd 5k

SmokeDetector

[ SmokeDetector ] Mostly non-Latin answer: Call PHP files like index.php?page=PAGEHERE by 犀利士 on wordpress.stackexchange.com …

Shadow Wizard

9:44 AM

@Shog9 @balpha are you aware that stackexchange.com/sites is down for an hour now?

(reported here originally: meta.stackexchange.com/questions/279982/…)

Bart

Seems to be up now @ShadowWizard?

SmokeDetector

[ SmokeDetector ] Mostly non-Latin answer: 502 errors on WordPress / nginx / php5-fpm by 犀利士 on serverfault.com …

Shadow Wizard

@Bart not for me.

Maybe some server side cache going wrong for some users, I think they got several "cache centers", or something like that.

Bart

I do see the 0 visitors thing, but the /sites is up for me it seems.

user202362

@ShadowWizard can't blame myself, I am very productive person despite spending most of my time idle ...

user202362

9:57 AM

</shameless self promotion>

bacon

pro-crastination

Shadow Wizard

@Bart for me it redirect to the panda after a minute or so. Well, if it's working for SE team guess all is good.

user202362

TIL there are many types of door and window seals ...

user202362

Marc Gravell

@ShadowWizard thanks; it should work now - please let me know

we did a SQL upgrade on the weekend; I think the cardinality estimator really, really hated a particular query

user202362

10:10 AM

yesterday, by sandwich

5 out of 6 is 83%, good enough for a B.

user202362

I would smack him a little too

Shadow Wizard

@MarcGravell yes, working now. "cardinality estimator"? Sounds... Stack Exchange-ish... ;)

@Marc also, what about the 0 visitors/day in beta site stats? This one isn't fixed yet.

Marc Gravell

no, that's SQL Server; that is the part of the engine that looks at your query, glances at the table, and says "meh, that'll probably be 100 rows; that bit over there will be 10000 rows" - which helps it decide what strategy to use

if the CE gets it wrong, the strategy picked can be wildly inappropriate

@ShadowWizard context? is that a new thing? or something that has just always been that way?

Shadow Wizard

5

Q: Site Stats data showing "0 visitors/day" in all beta sites and link to stack exchange timing out

I just noticed that all beta sites show 0 visitors/day in the Site Stats. I checked Spanish Language, Personal Productivity and many others, and all have the problem. Furthermore, clicking on the "stack exchange" link on that Site Stats block times out: the page http://stackexchange.com/sites se...

(mentioned it before, though easily missed :))

Since it was reported together, assumed it's related.

@MarcGravell so, leading to a time out?

Marc Gravell

leading to hundreds and hundreds and hundreds of timeouts, yes

I think the zero thing is unrelated

fedorqui

10:20 AM

Yep, I reported them together since both things come in the "stats box"

Marc Gravell

that's fair

fedorqui

but let's not be attached to formality: I can split this in two questions ; )

Marc Gravell

@ShadowWizard the reason it worked for @bart and not you is that ?view=grid was fine, ?view=list was ... very much not

Shadow Wizard

@MarcGravell oh, I see. Thanks!

Just curious, what is the misbehaving query?

user202362

shadow is ready for some SQL injection ...

Bart

10:37 AM

Ah, so @ShadowWizard is one of those list people ... for shame.

Marc Gravell

@ShadowWizard sure thing; there's nothing business critical here - basically, simply this:

DECLARE @p0 datetime = '2016-05-23T09:49:19',
        @p1 tinyint = '1',
        @p2 tinyint = '2';

SELECT COUNT(*) AS [Count], [t0].[SiteId], [t0].[PostTypeId]
FROM [dbo].[NetworkPosts] AS [t0]
WHERE ([t0].[DeletionDate] IS NULL) AND ([t0].[CreationDate] > @p0) AND ([t0].[PostTypeId] IN (@p1, @p2))
GROUP BY [t0].[SiteId], [t0].[PostTypeId];

which is a LINQ-generated query that looks at two post-types (questions and answers) in a given time range

the parameterization of the post-types confused it

this, conversely, is absolutely fine:

DECLARE @p0 datetime = '2016-05-23T09:49:19'

SELECT COUNT(*) AS [Count], [t0].[SiteId], [t0].[PostTypeId]
FROM [dbo].[NetworkPosts] AS [t0]
WHERE ([t0].[DeletionDate] IS NULL) AND ([t0].[CreationDate] > @p0) AND ([t0].[PostTypeId] IN (1, 2))
GROUP BY [t0].[SiteId], [t0].[PostTypeId];

so basically, I ripped out the LINQ part and replaced it with "dapper", which is especially convenient because dapper has a handy "literal injection" feature which means we don't have to hard-code the ids

but the time still ends up parameterized

Shadow Wizard

Awesome, thanks!

Marc Gravell

the "posts by post-type" is massively skewed towards answers > questions > .... > everything-else (a few other post types exist, but tiny tiny quantities) - if the CE made decisions based on the other possible post types ids, it would have been many orders of magnitude wrong

PostTypeId Count
---------- -----------
2          29620905
1          20156575
4          192
5          192
10         1

so... yeah, if it suggested a strategy based on 4/5/10: lolz

Shadow Wizard

10:54 AM

Glad you find it funny! :-D

Quill

oh I missed some code talk from Marc Gravell ;-;

user202362

you missed live show, code is still on the board

SmokeDetector

11:28 AM

[ SmokeDetector ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, link following arrow in body: Training Will Modernise Fat Burning by jimyrivers on drupal.stackexchange.com …

Abhishek Bhatia

12:02 PM

hi guys!

I have a question, can a RO in chat-room ban you permanently?

Quill

12:19 PM

nope only kick mute

Shadow Wizard

@AbhishekBhatia what Quill said is true, and RO can kick for one minute every time. Several kicks in a row will create automatic flag so moderators can come and take a look.

(either to handle the problematic user, or RO who might abuse their power)

Abhishek Bhatia

In one room, the RO kicks me as soon as I ask a question. chat.stackoverflow.com/transcript/message/30975541#30975541

in Python Trash - The Rotating Knives on Stack Overflow Chat, 15 hours ago, by Abhishek Bhatia

cbg!

Shadow Wizard

@AbhishekBhatia it's not kicking, it's moving messages to a different room.

Abhishek Bhatia

And he is barring me to ask any questions in the room. He kicks even before I can complete my question chat.stackoverflow.com/transcript/message/30975632#30975632

It doesn't show but he kicked me both times, I can't verify that through log though.

There was a similar with the same guy before meta.stackoverflow.com/questions/320204/…

Is there any way I ask questions in that room, without creating an new account or posting it directly to the main site?

Shadow Wizard

12:35 PM

@AbhishekBhatia sorry it's really between you and him and/or that chat room. I don't think we need a moderator to intervene, it's not kindergarten.

Quill

sd k

Abhishek Bhatia

hmm... I think it is an abuse of power from stopping a guy who is contributing to the community to ask a question.

Transcript for