How to capture the MySql error code?

Question

For example:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction ROLLING BACK

I get this message from a PDOEception thrown inside my code. I would like to intercept the error code (1213) and give it specific treatment.

Why?
For example deadlock means I just have to resubmit the query after a microsecond or so. Other errors, means I need to alert developers etc).

Right now I have to code (inside a class inheriting PDO):

    try{
        $this->lastStatement = $sql;
        $this->lastStatement->execute($params);
    }catch (PDOException $e){
        return $this->error($e);
    }

I can not use the getCode of $E as it seems to not have the total range of errors MySQL has. For example, the following error: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction will return HY000 Which is a very general code. Used on many different error types.

Should I parse the error message?

What about using $e->getCode()? Does it return anything meaningfull? — David Müller
– David Müller, Commented Nov 14, 2012 at 16:55

deceze · Accepted Answer · 2012-11-14 16:55:59Z

2

$e->getCode();

It contains the SQLSTATE code, where 40001 means "deadlock".

answered Nov 14, 2012 at 16:55

deceze♦

525k89 gold badges807 silver badges954 bronze badges

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

2 Comments

Itay Moav -Malimovka Over a year ago

Check this error which is lock related and I have to take care of the same way, but it gives the general error this time: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

deceze Over a year ago

Yeah, that's more of a problem. I don't know any way of getting the more detailed error codes, besides "reading" the string programatically. Sorry.

Itay Moav -Malimovka · Accepted Answer · 2012-11-14 17:17:54Z

0

Right now, The only choice I see is parsing the error message itself and extract the four digits error code.

$s='SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction';
$p='/\b[0-9]+/';
preg_match($p,$s,$m);
var_dump($m);

answered Nov 14, 2012 at 17:17

Itay Moav -Malimovka

53.8k68 gold badges198 silver badges292 bronze badges

Comments

Ross · Accepted Answer · 2013-09-03 14:31:16Z

0

PDO Statements have a function ->errorInfo() which returns an array of useful info - check $err[2] where $err is the array returned from the above mentioned function.

http://php.net/manual/en/pdo.errorinfo.php

answered Sep 3, 2013 at 14:31

Ross

1,6791 gold badge18 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to capture the MySql error code?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related