Comments on: MySQL error handling on server side: a NO GO! https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go Blog by Shlomi Noach Thu, 02 Aug 2012 06:26:54 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Things that can’t (and some that can) be done from within a MySQL stored routine | code.openark.org https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go/comment-page-1#comment-111246 Thu, 02 Aug 2012 06:26:54 +0000 https://shlomi-noach.github.io/blog/?p=5082#comment-111246 […] MySQL error handling on server side: a NO GO! […]

]]> By: Log Buffer #278, A Carnival of the Vanities for DBAs | The Pythian Blog https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go/comment-page-1#comment-108589 Fri, 20 Jul 2012 07:01:59 +0000 https://shlomi-noach.github.io/blog/?p=5082#comment-108589 […] is no reasonable way to catch and diagnose errors on server side. It is nearly impossible to know exactly what went […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go/comment-page-1#comment-108377 Thu, 19 Jul 2012 13:41:46 +0000 https://shlomi-noach.github.io/blog/?p=5082#comment-108377 @Roland,

Wow. Here are a couple comments on that report, that are of interest. Just to put one in the scale of time.

———————————–
[19 Oct 2006 18:53] Marc Grue

Urgently needing this feature! Hope this feature will make it into 5.2!!

Aside from the suggested @@SQLSTATE and @@SQLSTATE_MESSAGE, another global @@MYSQLERROR (the MySql error number) would be highly appreciated with it’s more detailed mysql-specific error mapping.

———————————–
[14 Mar 2007 9:11] Peter Schwager

This is by far the most SERIOUS weak point of MYSQL from my point of view. We have written complex SP and are not able to proberly track exceptions due to this bug.

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go/comment-page-1#comment-108339 Thu, 19 Jul 2012 11:27:06 +0000 https://shlomi-noach.github.io/blog/?p=5082#comment-108339 http://bugs.mysql.com/bug.php?id=11660,
“Expose either SQLState, mysql_error() or other diagnostics in stored procedures”, 30 Jun 2005 11:53, status: verified.

I’m gonna go shopping, ttl :p

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go/comment-page-1#comment-107991 Wed, 18 Jul 2012 06:58:46 +0000 https://shlomi-noach.github.io/blog/?p=5082#comment-107991 Davi,

Thanks!
But also: such brief comment makes it appear as if there is such a feature.
It’s great to learn that this feature is available in 5.6. But it’s also important to know that 5.6 is not GA at this stage. It will take years to come before 5.5 and 5.1 are gone from production systems. It would be great to have such issues resolved in those versions as well. Ok, 5.1 is stretching it, I suppose.

I’m very happy with many new 5.6 features. Many of these are Metadata related. It will take time before I even catch up with all the new featureset. Thanks for noting down this new one!

]]> By: Davi Arnaut https://shlomi-noach.github.io/blog/mysql/mysql-error-handling-on-server-side-a-no-go/comment-page-1#comment-107985 Wed, 18 Jul 2012 06:23:44 +0000 https://shlomi-noach.github.io/blog/?p=5082#comment-107985 GET DIAGNOSTICS?

]]>