I have 2 queries deadlocking on each other.
The first query is
Select Top 1 NULL From [Table1] with (HOLDLOCK, TABLOCKX)
Second Query is an insert query that only reads from [Table2] to put data into [Table3]
The first query somehow has an exclusive lock on Table2 and tries to grab an exclus...
I would start by verifying the integrity of the data. Then, I would send any rejected rows to a file. You can specify this in your COPY command:
COPY CSI.MKT_RSRCH_AGG_ALL
FROM '/opt/vertica/CSI/MKT_RSRCH_AGG_ALL.txt'
DELIMITER '|'
NULL ''
REJECTED DATA '/path/to/rejected/data'
DIRECT;
Docu...
I got several notifications from The Heap that should have targeted another user.
The notification link to chat is:
http://chat.stackexchange.com/transcript/message/15284325?noredirect=1#15284325
It should have notified this user: http://chat.stackexchange.com/users/115579/max
I imagine the ...
I got several notifications from The Heap that should have targeted another user.
The notification link to chat is:
http://chat.stackexchange.com/transcript/message/15284325?noredirect=1#15284325
It should have notified this user: http://chat.stackexchange.com/users/115579/max
I imagine the ...
This is a known issue. There have been some attempts to fix the problem, but they're not foolproof. See these:
Stack Exchange chat name mention inbox confusion
Getting Marc's chat notifications
What are the rules for when chat messages appear in a user's inbox?
@Kermit the problem is figuring out where in PDO's spaghetti that happens
I changed a WordPress query from SELECT ... to EXEC ... and it's still getting cached separately as a prepared statement for each call (different parameter values to the procedure). Regardless if db is parameterization simple/forced, with or without optimize for ad hoc workloads, etc.
I suppose I'll post a question. This is pretty exotic though - it's in the PDO translations for WordPress on Windows. Not sure there are too many folks doing what I'm doing. I just loathe LAMP that much.
@Kermit unfortunately I'd have to do a lot of unraveling to do that. I am working in pdo.php which gets $query from somewhere else. And query gets passed to $dbh->query($query). So I was trying to intercept that and change SELECT ... to EXEC ... without a ton of reverse engineering.
I thought I would be able to swap out just about every ad hoc junk with procedure calls, and while I can (sort of), I don't get any benefit. The procedure's plan gets re-used but the prepared procedure call still fills up my plan cache with a version of the plan for every parameter value. Quite annoying.
@FreshPhilOfSO right. And I would re-write the thing to not give a shit about MySQL, but then as soon as there's an update, I'm screwed.
CREATE PROC udploop
(
@num varchar(10)
)
AS
BEGIN
DECLARE @len int;
SET @len = LEN(@num);
WHILE (@len > 1)
BEGIN
SELECT @num = RIGHT(@num, @len - 1) ;
PRINT @num;
SET @len = @len;
END
END
4679
679
79
9
3390
390
90
0
9906
906
06
6
EXEC:
EXEC udploop 34679
EXEC udploop 13390
EXEC ...
"udploop"?
So how do you propose you do this, when there are many rows in the table? Call the procedure - in a loop - for every row? So you have a loop that calls a procedure that itself runs a loop. This is definitely not an efficient way to solve this problem. — Aaron Bertrand ♦20 secs ago
I'm just glad all active transactions have been rolled back. Even though I have no idea what transactions it rolled back. I assume only the ones from me clicking "Save", but who knows.... without detailed info there is no way to know. I love developers.
yeah, that's what I assumed too. I'm sure either option "yes" or "no" will likely result in nothing happening beyond the piece of code exiting. I'd just like to know the implication before pressing either one. To find that out, I'd need to locate the person who wrote the app in question, and you know where that leads. Rabbit-hole anyone?
Yeah I wouldn't suspect he would get regular minutes. But having him on the bench to be available for when they need to "not take crap" is just dangerous.
The team should be just as angry/embarrassed, if not more so, than the league.
I have great respect for teams that suspend their own players for conduct issues, whether in lieu of or addition to any league sanctions. And that goes for all sports.
the 'hawks are a more physical, more experienced version of the avs. they are also more consistent with their speed/skill game. i think that the wild have their work cut out for them, but i dont think that the wild will be overmatched
@Zane if nino keeps playing at the same level then he looks like he could be a real difference maker for you. he's been "righthere" all series and really broke through in a big way in gm 7
I think it's going to be a good series which is all I can really ask for.
They need to keep up the aggression. When they are on the move they look good. They are definitely getting a lot of production out of the young guys which is exactly what we need.
@Zane i have to admit that i was a pretty big blackhawks fan as a kid (i lived in florida and my grandparents lived in chicago) so i'm not rooting for the wild. if they make it past the 'hawks then i think i'm free to hope that they make it all the way and beat boston (in the finals)
In order to increase the efficiency with which poor quality questions are closed, it could make sense to have weighted close votes for a small subset of qualified users.
A very good way to measure the qualified users would be to leverage the tag badges. However, it needs to be rationally limite...
@Zane i wonder how he'd be as a goalie if he was an average-sized human being. but yeah, he's quick for being that size and he's rarely out of position.
I use my laptop away from my desk more than at it - bedroom, kitchen, living room, etc. You can't rely on attaching it to a monitor always, else why not just get a mini?
@AaronBertrand The original version shipped with different processor speeds. However they all came with the same processor the clock speed was just determined by which connection was soldered. You could open one up break the low speed connection and create the high speed connection and save yourself some money.
For a little clock speed that hardly seems worth it. Not much you're doing these days is really going to change your day if it is running at 2.4GHz or 2.9GHz.
I don't recall ever paying extra for a clock speed upgrade. None of my workloads are CPU bound.
@JNK the thinking, really, has been - if there is a web portal, and there is something going wrong, how are you going to fix it? You're going to have to RDP or whatever to the environment...
@JNK Well you can deploy and automate reports to any SSRS server, so in essence, yes, you can have a "web portal" that just shows the various reports you want to share
@JNK and only creds to the SQL Sentry database, not any of the monitored databases
> He foudn a way to be condescending to people. The guys aks what is it. But it sounds as if he wonders what Con. means. He said It's when you tlak down to someone. Then the guy has beent alked down upon
@swasheck Sorry man I didn't get a huge amount of work to do. Because these damn offsite team things stole at least 12 hours of productivity from me this week.
I'm not sure what to call a query that... isn't really a query; is "statement" a better word to use in place? Or how about "script"?
Or would something else be more appropriate?
Note: I've seen someone call it a "DELETE query" once
As a person's commitment to the community increases, I think we should make it possible for high-reputation users to fast-track the closure of certain questions. My reasons are many; for brevity, I won't repeat them all in detail here. But you can find them in all of the recent discussions here...
I would feel more comfortable if my vote only weighed 2.5 votes rather than was completely binding. Then if another 20+ user agreed with me, their 2.5 vote would satisfy enough votes to close. — Kermit24 secs ago
Though this question specifically discusses high-rep users, I would propose a tiered close vote system since close votes can be cast beginning with 3,000 reputation. As someone with 20k+ rep, I would not feel comfortable having my vote be binding.
Reputation Close vote weight
3,000 0.5
...
I think the badge-related criteria are too wishy-washy (1) on most sites that means the change is minimal (2) what does it really mean when a question gets re-tagged (3) just because I don't have a gold badge in MySQL doesn't mean I can't recognize an absolute shit MySQL question.