MySQL Bugs: #10143: Perror not showing error description

Bug #10143	Perror not showing error description
Submitted:	25 Apr 2005 12:50	Modified:	6 Mar 2010 18:27
Reporter:	[ name withheld ] (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	4.0, 4.1, 5.0	OS:	Any (*)
Assigned to:	Marc ALFF	CPU Architecture:	Any
Tags:	qc, usability

Description:
I got this error back from MySQL:

ERROR 1062 (23000): Duplicate entry '...' for key 1

Perror seems unable to describe this error.

How to repeat:
Try running:

C:\>perror 1062
Illegal error code: 1062

I also tried the following in doubt of which was the right number:

C:\>perror 23000
Illegal error code: 23000

this is a general problem: perror does not know about the error codes >=1000
i find myself using grep ever so often to look them up, it's a real shame that 
perror is not able to help with this rather simple task ... :(

see also bug 25177

I planned to put all error codes in extras/perror.c and have perror the program dump a stream of C++ "#define"s when given a certain parameter.

Execute it, redirecting to a file that the server uses.

Here's a patch that is 80% done, but needs some dependency problems worked out first.

Chad's first pass at a solution. Needs a tiny amount of work.

Attachment: p (application/octet-stream, text), 14.78 KiB.

Still happens:

[miguel@light 5.0]$ bin/perror 1062
Illegal error code: 1062

Other perror bugs:  bug #23028,#30003, #25177

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50969

2745 Marc Alff	2008-08-05
      Bug#10143 (Perror not showing error description)
      
      Before this fix, errors described in sql/share/errmsg.txt were not
      displayed by the perror utility.
      
      With this fix, perror now is aware of these errors.
      
      Fixed the code generation for include/mysqld_ername.h to add the error
      message text.
      
      Fixed perror to lookup errors in include/mysqld_ername.h.
      
      Note that since the code is automatically generated,
      any new error created in sql/share/errmsg.txt (the source code)
      will be automatically recognized by perror, preventing the perror utility
      to get out of sync with the main source code.

Revno 2745 is good with me.  The capitalized "ER" in the function name may bother others, but I think it's okay.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51046

2748 Marc Alff	2008-08-06
      Bug#10143
      
      Fixed the test result for ndb_basic, which is using perror.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51047

2748 Marc Alff	2008-08-06
      Bug#10143
      
      Fixed the test result for ndb_basic, which is using perror.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51138

2744 Marc Alff	2008-08-07 [merge]
      Merge mysql-6.0-bugteam -> local bugfix branch

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51322

2765 Davi Arnaut	2008-08-11 [merge]
      Merge mysql-6.0-bugteam into mysql-6.0 main.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51420

2765 Davi Arnaut	2008-08-12 [merge]
      Merge mysql-6.0-bugteam into mysql-6.0 main.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51423

2765 Davi Arnaut	2008-08-12 [merge]
      Merge mysql-6.0-bugteam into mysql-6.0 main.

Pushed into 6.0.7-alpha  (revid:marc.alff@sun.com-20080806221607-m7q3g7gm144z9smp) (version source revid:davi.arnaut@sun.com-20080812141852-8e6knbqclpfd8irn) (pib:3)

Noted in 6.0.7 changelog.

perror did not work for errors described in the sql/share/errmsg.txt
file.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51602

2684 He Zhenxing	2008-08-14 [merge]
      Merge 6.0 -> 6.0-rpl-testfixes

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51603

2684 He Zhenxing	2008-08-14 [merge]
      Merge 6.0 -> 6.0-rpl-testfixes

Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)

Pushed into 6.0.7-alpha  (revid:marc.alff@sun.com-20080806221607-m7q3g7gm144z9smp) (version source revid:vvaintroub@mysql.com-20080804094710-jb2qpqxpf2ir2gf3) (pib:3)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/101268

2982 Marc Alff	2010-02-23
      Bug#10143 Perror not showing error description
      
      Backport to 5.5.99

Backport for 5.5.99 queued in mysql-next-mr-bugfixing

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100225194420-p60r4u90tszj8q2x) (version source revid:wlad@sun.com-20100224014249-ztsx39z7p85vr0pe) (merge vers: 6.0.14-alpha) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100225194305-h49uyjrlfl3mwo60) (version source revid:wlad@sun.com-20100224012055-l03398ur9fid1bry) (pib:16)

Setting report to Need Merge pending push of Celosia to release tree.

Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:alik@sun.com-20100225195857-farb6yvy8x06bylj) (merge vers: 5.5.99-m3) (pib:16)

Noted in 5.5.3 changelog.