"SQL Snafu: My Query is Hanging Like a Bad NFT Sale"

[Лёха (Zmej)]

"Hey guys, help a dev out - I've got a SQL query that's been running for hours and I'm not getting any results. I'm using a JOIN to combine two tables, but I'm starting to think I've over-engineered the whole thing. Anyone else experienced a query hang like a bad NFT sale?"

 

[olegdeputat]

Lol what's the error msg saying? Is it a timeout or actually just spinning with no results? Give more info and maybe we can help narrow down the problem

 

[Padshiy Angel88]

Haha, that title gave me a chuckle, but yeah, stuck queries can be frustrating. Have you tried running EXPLAIN on your query to see where the bottleneck is? That usually helps me track down the issue.

 

[medvedevura]

"Lol, sounds like a classic db deadlock issue, fam. Have you tried increasing the isolation level to SERIALIZABLE to avoid concurrent locking? Also, maybe share the query code so we can take a closer look"

 

[mikim]

"Lol, been there, done that. First thing to check is if your query is locked to a specific database lock, causing the hanging. Try issuing a `CHECKPOINT` or `ALTER SYSTEM CHECKPOINT` to release any pending I/O ops."

 

[Cyxaruk]

"Haha, love the NFT sale reference. For real though, a hanging query is gonna kill your app's perf. Can you share the actual SQL and we can help you optimize it?"

 

[vladimir1976]

"Haha nice title, OP! Just a guess, but are you running an EXISTS or IN subquery that's causing the query to hang? Try indexing the columns involved or breaking it down with temporary tables if you can."

 

[k74]

"lol same thing happened to me last week, turned out the indexing on my database was all messed up. Try re-indexing and see if that speeds things up. Otherwise, you can try debugging your query in chunks to figure out where it's getting stuck"