The Heap™ – Consultancy ©®

« first day (3441 days earlier) ← previous day next day → last day (1419 days later) »

Evan Carroll

4:26 AM

What the hell are we doing in here. I leave you kids alone FOR A FEW MONTHS...

Next thing you're all stalky stalky

I do a lot of things. Real estate is only one of them.

5 hours later…

Andriy M

9:24 AM

@EvanCarroll My theory is it's some kind of an overcompensation thing for sitting at home for days on end.

Vérace

9:47 AM

Morning all - nice walk at 07:30 this morning along the beach! Blustery and cold North-Easterly but was warm enough because I kept moving. Last week we had sub-tropical weather, now it's sub-Artic!

@Johnakahot2use - gotta love database humour!

@PeterVandivier what special school did this Gary Johnson chap go to?

Vérace

10:03 AM

@yp

@ypercubeᵀᴹ - this guy likes writing GIF decoders in SQL inter alia - check out his site - some real esoteric stuff!

ypercubeᵀᴹ

10:31 AM

Quassnoi? Yeah, he has some good stuff there.

I learned how to write OUTER APPLY queries for mysql from one of his posts at SO, many years ago.

1 hour later…

Vérace

11:51 AM

@ypercubeᵀᴹ - it's easy to see why he has a stellar rep! I just wish I had the time to study all the weird and wonderful things he manages to do with SQL - I particularly like that he appears to be a PostgreSQL fan!

6 hours later…

Colin 't Hart

6:20 PM

Q: MySQL deadlock: upsert query acquiring gap lock twice?

I am trying to debug a deadlock scenario which has been puzzling me for quite some time now. I am wondering if someone can shed any light into how this can happen. Here is the deadlock output: ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2019-06-28 14:04:18 0x7fe9a...