6.8.2 perror — Display MySQL Error Message Information (original) (raw)

6.8.2 perror — Display MySQL Error Message Information

perror displays the error message for MySQL or operating system error codes. Invokeperror like this:

perror [options] errorcode ...

perror attempts to be flexible in understanding its arguments. For example, for theER_WRONG_VALUE_FOR_VAR error,perror understands any of these arguments:1231, 001231,MY-1231, or MY-001231, orER_WRONG_VALUE_FOR_VAR.

$> perror 1231
MySQL error code MY-001231 (ER_WRONG_VALUE_FOR_VAR): Variable '%-.64s'
can't be set to the value of '%-.200s'

If an error number is in the range where MySQL and operating system errors overlap, perror displays both error messages:

$> perror 1 13
OS error code   1:  Operation not permitted
MySQL error code MY-000001: Can't create/write to file '%s' (OS errno %d - %s)
OS error code  13:  Permission denied
MySQL error code MY-000013: Can't get stat of '%s' (OS errno %d - %s)

To obtain the error message for a MySQL Cluster error code, use the ndb_perror utility.

The meaning of system error messages may be dependent on your operating system. A given error code may mean different things on different operating systems.

perror supports the following options.