InnoDB Chinese Reference Manual---13 error handling

Reference Manual | Chinese InnoDB chinese reference Manual---Dog dog (heart sail) Translation 13 error handling
InnoDB error handling is not always consistent with the ANSI SQL designation. According to the ANSI standard, any errors in an SQL statement will cause the statement to be rolled back. InnoDB sometimes rolls back only part of the statement, sometimes the entire transaction. The following list details the error handling for InnoDB.
If you run out of file space in the tablespace, you will get the MySQL ' table is full ' error, and InnoDB will roll back the SQL statement. A deadlock or lock wait timeout for a transaction will cause the InnoDB to roll back the entire transaction. A duplicate key (duplicate key) will only roll back the inserted detail rows, even in the same as insert INTO ... SELECT ... In one of the statements. This may change, so if the IGNORE option is not specified in the statement, the statement will produce a rollback. A ' row too long ' error rolls back the entire SQL statement. Other errors are primarily discovered by the MySQL code layer, which rolls back the corresponding SQL statements.
　
13.1 Some error codes returned by MySQL
1005 er_cant_create_table cannot establish a table. If the error message string references errno 150, then the table creation failed because the FOREIGN key constraint was not properly formed. 1016 Er_cant_open_file could not find InnoDB tables in the InnoDB data file through the. frm file. Look at the following section, "Discovering and fixing Data dictionary errors". 1114 Er_record_file_full InnoDB The remaining space in the table space. You must add a new data file. 1205 Er_lock_wait_timeout Lock wait timeout expires. Transaction is rolled back. 1213 Er_lock_deadlock transaction deadlock. A transaction needs to be run again. 1216 Er_no_referenced_row The FOREIGN KEY constraint fails when an attempt is made to add a new row, but no parent record exists. The parent record must be added first. 1217 er_row_is_referenced Deletes a parent row that has a child record, and a foreign key constraint fails. Child records must be deleted first.
　
13.2 Error codes for some operating systems
In Unix systems, the PERROR program is used to display the meaning of the operating system error code, which is included in the MySQL distribution.

The following list shows the common Linux system error codes. 1 eperm
Operation not permitted
Operation not allowed 2 enoent
No such file or directory
No this file or directory 3 Esrch
No such process
No this process 4 eintr
Interrupted system call
System call is prohibited 5 Eio
I/O error
I/O error 6 Enxio
No such device or address
No such device or address 7 e2big
ARG list too long
ARG list is too long 8 enoexec
Exec Format Error
Exec Format Error 9 EBADF
Bad file number
Wrong number of files
Ten Echild
No Child Processes
No Child process
One Eagain
Try again
Try it again.
Enomem
Out of memory
Memory overflow
Eacces
Permission denied
Permission denied
Efault
Bad address
The wrong address
Enotblk
Block Device required
Block Device required
Ebusy
Device or resource busy
Device or resource busy
Eexist
File exists
File exists
Exdev
Cross-device Link
Cross Link
Enodev
No such device
No such device
Enotdir
Not directory A
Not a directory
Eisdir
is a directory
is a directory
Einval
Invalid argument
Invalid function argument
Enfile
File Table Overflow
File Table Overflow
Emfile
Too Many open files
Too many open files
Enotty
Inappropriate IOCTL for device

Num Etxtbsy
Text file Busy
Text File busy
Efbig
File too large
File is too large
Enospc
No spaces left on device
Low disk space
Espipe
Illegal seek
Illegal to look for
Erofs
Read-only File System
Read-Only file system
Emlink
Too many links
Too many links
　

The following list shows common Windows system error codes. 1 error_invalid_function
Incorrect function
Function error
2 Error_file_not_found
The system cannot find the file specified
The system could not find the specified file
3 Error_path_not_found
The system cannot find the path specified
The system could not find the specified path
4 Error_too_many_open_files
The system cannot open the file
The system cannot open the file
5 error_access_denied
Access is denied
Access Denied
6 Error_invalid_handle
The handle is invalid
Invalid handle
7 error_arena_trashed
The storage control blocks were destroyed
The storage control block is corrupted
8 Error_not_enough_memory
Not enough storage are available to process this command
There is not enough storage space to execute this instruction
9 Error_invalid_block
The Storage Control invalid
Invalid storage control block address
Ten Error_bad_environment
The environment is incorrect.
Environment error
One Error_bad_format
An attempt is made to load a and incorrect format.
Try to load a program in the wrong format
Error_invalid_access
The access code is invalid.
Invalid access code
Error_invalid_data
The data is invalid.
Invalid data
Error_outofmemory
Not enough storage are available to complete this operation.
There is not enough storage space to complete this operation
Error_invalid_drive
The system cannot find the drive specified.
The system cannot find the specified drive
Error_current_directory
The directory cannot be removed.
Directory could not be removed
Error_not_same_device
The system cannot move the file to a different disk drive.
The system cannot move files to a different disk drive
Error_no_more_files
There are no more files.
No more files.
Error_write_protect
The media is write protected.
Media write Protection Error_bad_unit
The system cannot find the device specified.
The system cannot find the specified device
Error_not_ready
The device is not ready.
The device is not ready.
Error_bad_command
The device does not recognize the command.
Device does not support this directive
Error_crc
Data Error (cyclic redundancy check).
Data error (cyclic redundancy test)
Error_bad_length
The program issued a command but the command length is incorrect.
The program issued a directive, but the length of the instruction was wrong
Error_seek
The drive cannot locate a specific area or track on the disk.
The drive cannot locate the specified area or track on the disk
Num Error_not_dos_disk
The specified disk or diskette cannot be accessed.
The specified disk or disc cannot be accessed
Error_sector_not_found
The drive cannot find the sector requested.
The drive could not find the required sectors
Error_out_of_paper
The printer is out of paper.
Printer missing paper
Error_write_fault
The system cannot write to the specified device.
The system is not able to write to the specified device
Error_read_fault
The system cannot read from the specified device.
The system cannot read from the specified device
Error_gen_failure
A device attached to the system is not functioning.
System attached device is not functioning
Error_sharing_violation
The process cannot access the file because it is being used by another process.
The process cannot access the file because the file is already in use by another process
Error_lock_violation
The process cannot access the file because another process has locked a portion of the file.
The process cannot access the file because the file is locked by another process
Error_wrong_disk
The wrong diskette is in the drive. Insert%2 (Volume serial number:%3) into drive%1.
Disk error in drive. Insert%2 (disk volume serial number:%3) to drive%1
error_sharing_buffer_exceeded
Too many files opened for sharing.
Too many files open for sharing
Error_handle_eof
Reached the end of the file.
Reach End of File
Error_handle_disk_full
The disk is full.
The disk is full
112 Error_disk_full
The disk is full.
The disk is full
123 Error_invalid_name
The filename, directory name, or volume label syntax is incorrect.
File name, directory name, or volume banner method error