Logging with MYSQL Handlers

Question

I'm hoping this isn't just duplicating this question.

I have read the documentation but I don't think I fully understand how to use this properly yet.

I would like to catch errors thrown in my stored procedures and log those errors in a table. This is mostly for experimental purposes. I am wondering is there a way to catch any error and then log the code and error to a table.

So far it looks like I have to declare a different handler for each error. Is this correct or is there a way to catch all errors and get the code and message.

For example in each stored procedure I'm declaring a couple of handlers

DECLARE EXIT HANDLER FOR 1062
BEGIN
    SELECT 'Attempt to create a duplicate entry occurred';
END;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
ROLLBACK;
SELECT 'Unexpected Error Ocurred';
END;

Instead of

 SELECT 'custom message';

I want to do

INSERT INTO errorLogs(code, message);

Is this possible without declaring a load of handlers and adding each code manually?

Really appreciate any help pointing me in the right direction.

Community · Accepted Answer · 2017-04-13 12:42:36Z

0

It looks like this is not really possible until I can use an updated version of MYSQL with DIAGNOSTICS. I found this question which is basically the same as mine. Ah well.

edited Apr 13, 2017 at 12:42

CommunityBot

11 silver badge

answered Mar 6, 2012 at 11:14

Ruairi O'Brien

1,2295 gold badges20 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Logging with MYSQL Handlers

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related