Shulou(Shulou.com)06/01 Report--

Mysql startup error (InnoDB: Operating system error number 13)

Environment: mysq 5.6.35, centos 7.3

Problem description:

It was said that the development library could not be connected this afternoon. After logging in to the server, I found that the mysql process down

Start mysql:

/ bin/sh / usr/local/mysql/bin/mysqld_safe-- defaults-file=/etc/my.cnf &

Error starting Times, unable to start mysql normally

Query alarm log file

If the error message is as follows

2018-07-03 15:19:11 7f6e0dc9e700 InnoDB: Operating system error number 13 in a file operation.

InnoDB: The error means mysqld does not have the access rights to

InnoDB: the directory.

2018-07-03 15:19:11 7f6e0dc9e700 InnoDB: Assertion failure in thread 140110654465792 in file fil0fil.cc line 875

InnoDB: Failing assertion: ret

InnoDB: We intentionally generate a memory trap.

InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

InnoDB: If you get repeated assertion failures or crashes, even

InnoDB: immediately after the mysqld startup, there may be

InnoDB: corruption in the InnoDB tablespace. Please refer to

InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html

InnoDB: about forcing recovery.

07:19:11 UTC-mysqld got signal 6

This could be because you hit a bug. It is also possible that this binary

Or one of the libraries it was linked against is corrupt, improperly built

Or misconfigured. This error can also be caused by malfunctioning hardware.

We will try our best to scrape up some info that will hopefully help

Diagnose the problem, but since we have already crashed

Something is definitely wrong and this may fail.

Key_buffer_size=8388608

Read_buffer_size=262144

Max_used_connections=5

Max_threads=1024

Thread_count=3

Connection_count=3

It is possible that mysqld could use up to

Key_buffer_size + (read_buffer_size + sort_buffer_size) * max_threads = 545584 K bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x511a8b0

Attempting backtrace. You can use the following information to find out

Where mysqld died. If you see no messages after this, something went

Terribly wrong...

Stack_bottom = 7f6e0dc9de90 thread_stack 0x30000

/ usr/local/mysql/bin/mysqld (my_print_stacktrace+0x35) [0x9122f5]

/ usr/local/mysql/bin/mysqld (handle_fatal_signal+0x3d8) [0x675f18]

/ lib64/libpthread.so.0 (+ 0xf370) [0x7f6e7ca9a370]

/ lib64/libc.so.6 (gsignal+0x37) [0x7f6e7b6991d7]

/ lib64/libc.so.6 (abort+0x148) [0x7f6e7b69a8c8]

/ usr/local/mysql/bin/mysqld [0xa74431]

/ usr/local/mysql/bin/mysqld [0xa7462b]

/ usr/local/mysql/bin/mysqld [0xa7d319]

/ usr/local/mysql/bin/mysqld [0xa480f0]

/ usr/local/mysql/bin/mysqld [0xa489cb]

/ usr/local/mysql/bin/mysqld [0xa36643]

/ usr/local/mysql/bin/mysqld [0xa2177f]

/ usr/local/mysql/bin/mysqld [0x9cb948]

/ usr/local/mysql/bin/mysqld [0x92cf30]

/ usr/local/mysql/bin/mysqld [0x924799]

/ usr/local/mysql/bin/mysqld [0x92cc69]

/ usr/local/mysql/bin/mysqld (_ ZN7handler11ha_rnd_nextEPh+0x64) [0x58cf54]

/ usr/local/mysql/bin/mysqld (_ Z13rr_sequentialP11READ_RECORD+0x37) [0x841ba7]

/ usr/local/mysql/bin/mysqld (_ Z10sub_selectP4JOINP13st_join_tableb+0x10f) [0x6d472f]

/ usr/local/mysql/bin/mysqld (_ ZN4JOIN4execEv+0x435) [0x6d21e5]

/ usr/local/mysql/bin/mysqld [0x719839]

/ usr/local/mysql/bin/mysqld (_ Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xbc) [0x719b6c]

/ usr/local/mysql/bin/mysqld (_ Z13handle_selectP3THDP13select_resultm+0x184) [0x719d84]

/ usr/local/mysql/bin/mysqld [0x6f3da9]

/ usr/local/mysql/bin/mysqld (_ Z21mysql_execute_commandP3THD+0x3ab7) [0x6f9457]

/ usr/local/mysql/bin/mysqld (_ Z11mysql_parseP3THDPcjP12Parser_state+0x377) [0x6fcb77]

/ usr/local/mysql/bin/mysqld (_ Z16dispatch_command19enum_server_commandP3THDPcj+0x19ed) [0x6fec8d]

/ usr/local/mysql/bin/mysqld (_ Z10do_commandP3THD+0xd7) [0x7000e7]

/ usr/local/mysql/bin/mysqld (_ Z24do_handle_one_connectionP3THD+0x116) [0x6c6ca6]

/ usr/local/mysql/bin/mysqld (handle_one_connection+0x45) [0x6c6d85]

/ usr/local/mysql/bin/mysqld (pfs_spawn_thread+0x126) [0xae5796]

/ lib64/libpthread.so.0 (+ 0x7dc5) [0x7f6e7ca92dc5]

/ lib64/libc.so.6 (clone+0x6d) [0x7f6e7b75b76d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (7f6db4013740): is an invalid pointer

Connection ID (thread ID): 194

Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

Information that should help you find out what is causing the crash.

Through the analysis of the contents of the error log mentioned above, it may be caused by permissions.

Error 13 indicates that there are no permissions. Use the command

Chmod-R 777 can solve the problem.

[root@dev mysql] # chmod-R 777 / usr/local/mysql/

[root@dev mysql] # chown-R mysql:mysql / usr/local/mysql/

[root@dev mysql] # chmod-R 777 / mysql/data/

[root@dev mysql] # chown-R mysql:mysql / mysql/data/

Hint: this error number is the error number of the system and the errorno in the program.

Attach the error code message of linux

Errno.00 is: Success successful

Errno.01 is: Operation not permitted does not allow such operations

Errno.02 is: No such file or directory does not have this file or directory

Errno.03 is: No such process does not have this process

Errno.04 is: Interrupted system call interrupts the system call

Errno.05 is: Input/output error input / output error

Errno.06 is: No such device or address does not have this device or address

Errno.07 is: Argument list too long parameter is too long

Errno.08 is: Exec format error execution format error

Errno.09 is: invalid file descriptor for Bad file descriptor

Errno.10 is: there are no child processes in No child processes

Errno.11 is: Resource temporarily unavailable resources are temporarily unavailable

Errno.12 is: Cannot allocate memory failed to allocate memory

Errno.13 is: Permission denied permission error

Errno.14 is: Bad address address error

Errno.15 is: Block device required block device request

Errno.16 is: Device or resource busy devices or resources are busy

Errno.17 is: the File exists file already exists

Errno.18 is: Invalid cross-device link invalid cross-connect device

Errno.19 is: No such device does not have this device

Errno.20 is: Not a directory is not a directory

Errno.21 is: Is a directory is a directory

Errno.22 is: illegal Invalid argument parameter

Errno.23 is: the Too many open files in system system opens too many files

Errno.24 is: Too many open files opens too many files

Errno.25 is: the Inappropriate ioctl for device equipment department supports this operation

Errno.26 is: Text file busy text files are busy

Errno.27 is: the File too large file is too large

Errno.28 is: No space left on device devices have no space and are generally storage devices

Errno.29 is: illegal seek operation of Illegal seek

Errno.30 is: Read-only file system read-only file system

Errno.31 is: Too many links too many connections

Errno.32 is: Broken pipe pipe rupture

Errno.33 is: Numerical argument out of domain numerical parameter is out of range

Errno.34 is: Numerical result out of range numerical result is out of range

Errno.35 is: Resource deadlock avoided resource deadlock

Errno.36 is: the File name too long file name is too long

Errno.37 is: No locks available has no available locks

Errno.38 is: the Function not implemented function is not executed

Errno.39 is: the Directory not empty directory is not empty

Errno.40 is: Too many levels of symbolic links too multi-level symbolic connection

Errno.41 is: Unknown error 41 41 unknown error

Errno.42 is: message types for which No message of desired type is not accepted

Errno.43 is: the Identifier removed identifier has been deleted

Errno.44 is: Channel number out of range .

Errno.45 is: Level 2 not synchronized

Errno.46 is: Level 3 halted

Errno.47 is: Level 3 reset

Errno.48 is: Link number out of range

Errno.49 is: Protocol driver not attached

Errno.50 is: No CSI structure available

Errno.51 is: Level 2 halted

Errno.52 is: Invalid exchange

Errno.53 is: Invalid request descriptor

Errno.54 is: Exchange full

Errno.55 is: No anode

Errno.56 is: Invalid request code

Errno.57 is: Invalid slot

Errno.58 is: Unknown error 58

Errno.59 is: Bad font file format

Errno.60 is: Device not a stream

Errno.61 is: No data available

Errno.62 is: Timer expired

Errno.63 is: Out of streams resources

Errno.64 is: Machine is not on the network

Errno.65 is: Package not installed

Errno.66 is: Object is remote

Errno.67 is: Link has been severed

Errno.68 is: Advertise error

Errno.69 is: Srmount error

Errno.70 is: Communication error on send

Errno.71 is: Protocol error

Errno.72 is: Multihop attempted

Errno.73 is: RFS specific error

Errno.74 is: Bad message

Errno.75 is: Value too large for defined data type

Errno.76 is: Name not unique on network

Errno.77 is: File descriptor in bad state

Errno.78 is: Remote address changed

Errno.79 is: Can not access a needed shared library

Errno.80 is: Accessing a corrupted shared library

Errno.81 is: .lib secion in a.out corrupted

Errno.82 is: Attempting to link in too many shared libraries

Errno.83 is: Cannot exec a shared library directly

Errno.84 is: Invalid or incomplete multibyte or wide character

Errno.85 is: Interrupted system call should be restarted

Errno.86 is: Streams pipe error

Errno.87 is: Too many users

Errno.88 is: Socket operation on non-socket

Errno.89 is: Destination address required

Errno.90 is: Message too long

Errno.91 is: Protocol wrong type for socket

Errno.92 is: Protocol not available

Errno.93 is: Protocol not supported

Errno.94 is: Socket type not supported

Errno.95 is: Operation not supported

Errno.96 is: Protocol family not supported

Errno.97 is: Address family not supported by protocol

Errno.98 is: Address already in use

Errno.99 is: Cannot assign requested address

Errno.100 is: Network is down

Errno.101 is: Network is unreachable

Errno.102 is: Network dropped connection on reset

Errno.103 is: Software caused connection abort

Errno.104 is: Connection reset by peer

Errno.105 is: No buffer space available

Errno.106 is: Transport endpoint is already connected

Errno.107 is: Transport endpoint is not connected

Errno.108 is: Cannot send after transport endpoint shutdown

Errno.109 is: Too many references: cannot splice

Errno.110 is: Connection timed out

Errno.111 is: Connection refused

Errno.112 is: Host is down

Errno.113 is: No route to host

Errno.114 is: Operation already in progress

Errno.115 is: Operation now in progress

Errno.116 is: Stale NFS file handle

Errno.117 is: Structure needs cleaning

Errno.118 is: Not a XENIX named type file

Errno.119 is: No XENIX semaphores available

Errno.120 is: Is a named type file

Errno.121 is: Remote I/O error

Errno.122 is: Disk quota exceeded

Errno.123 is: No medium found

Errno.124 is: Wrong medium type

Errno.125 is: Operation canceled

Errno.126 is: Required key not available

Errno.127 is: Key has expired

Errno.128 is: Key has been revoked

Errno.129 is: Key was rejected by service

Errno.130 is: Owner died

Errno.131 is: State not recoverable

Errno.132 is: Unknown error 132

132255are all Unknown error

Error code message of windows

NumberMacroDescription1ERROR_INVALID_FUNCTIONIncorrect function.2ERROR_FILE_NOT_FOUNDThe system cannot find the file specified.3ERROR_PATH_NOT_FOUNDThe system cannot find the path specified.4ERROR_TOO_MANY_OPEN_FILESThe system cannot open the file.5ERROR_ACCESS_DENIEDAccess is denied.6ERROR_INVALID_HANDLEThe handle is invalid.7ERROR_ARENA_TRASHEDThe storage control blocks were destroyed.8ERROR_NOT_ENOUGH_MEMORYNot enough storage is available to process this command.9ERROR_INVALID_BLOCKThe storage control block address is invalid.10ERROR_BAD_ENVIRONMENTThe environment is incorrect.11ERROR_BAD_FORMATAn Attempt was made to load a program with an incorrect format.12ERROR_INVALID_ACCESSThe access code is invalid.13ERROR_INVALID_DATAThe data is invalid.14ERROR_OUTOFMEMORYNot enough storage is available to complete this operation.15ERROR_INVALID_DRIVEThe system cannot find the drive specified.16ERROR_CURRENT_DIRECTORYThe directory cannot be removed.17ERROR_NOT_SAME_DEVICEThe system cannot move the file to a different disk drive.18ERROR_NO_MORE_FILESThere are no more files.19ERROR_WRITE_PROTECTThe media is write protected.20ERROR_BAD_UNITThe system cannot find the device specified.21ERROR_NOT _ READYThe device is not ready.22ERROR_BAD_COMMANDThe device does not recognize the command.23ERROR_CRCData error (cyclic redundancy check) .24ERROR_BAD_LENGTHThe program issued a command but the command length is incorrect.25ERROR_SEEKThe drive cannot locate a specific area or track on the disk.26ERROR_NOT_DOS_DISKThe specified disk or diskette cannot be accessed.27ERROR_SECTOR_NOT_FOUNDThe drive cannot find the sector requested.28ERROR_OUT_OF_PAPERThe printer is out of paper.29ERROR_WRITE_FAULTThe system cannot write to the specified device.30ERROR_READ_FAULTThe System cannot read from the specified device.31ERROR_GEN_FAILUREA device attached to the system is not functioning.32ERROR_SHARING_VIOLATIONThe process cannot access the file because it is being used by another process.33ERROR_LOCK_VIOLATIONThe process cannot access the file because another process has locked a portion of the file.34ERROR_WRONG_DISKThe wrong diskette is in the drive. Insert 2 (Volume Serial Number: 3) into drive% 1.36ERROR_SHARING_BUFFER_EXCEEDEDToo many files opened for sharing.38ERROR_HANDLE_EOFReached the end of the file.39ERROR_HANDLE_DISK_FULLThe disk is full.87ERROR_INVALID_PARAMETERThe parameter is incorrect.112ERROR_DISK_FULLThe disk is full.123ERROR_INVALID_NAMEThe file name, directory name, or volume label syntax is incorrect.1450ERROR_NO_SYSTEM_RESOURCESInsufficient system resources exist to complete the requested service

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.