Mysql suddenly hung up, failed to restart, asked for help

error log is as follows:

2018-07-17T08:36:53.397517Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-- explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-17T08:36:53.399199Z 0 [Note] / usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 23554.
2018-07-17T08:36:53.404243Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-17T08:36:53.404288Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-17T08:36:53.404300Z 0 [Note] InnoDB: Uses event mutexes
2018-07-17T08:36:53.404306Z 0 [Note] InnoDB: GCC builtin _ atomic_thread_fence () is used for memory barrier
2018-07-17T08:36:53.404313Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-07-17T08:36:53.404322Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-17T08:36:53.404691Z 0 [Note] InnoDB: Number of pools: 1
2018-07-17T08:36:53.404845Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-07-17T08:36:53.406591Z 0 [Note] InnoDB: Initializing buffer pool, Total size = 128m, instances = 1, chunk size = 128m
2018-07-17T08:36:53.421430Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-17T08:36:53.424100Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority ().
2018-07-17T08:36:53.436515Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-17T08:36:53.438026Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 27659290414
2018-07-17T08:36:53.456641Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 27659553841
2018-07-17T08:36:53.456779Z 0 [Note] InnoDB: Database was not shutdown normalization!
2018-07-17T08:36:53.456913Z 0 [Note ] InnoDB: Starting crash recovery.
2018-07-17T08:36:53.475256Z 0 [Note] InnoDB: Transaction 49069703 was in the XA prepared state.
2018-07-17T08:36:53.475706Z 0 [Note] InnoDB: Transaction 49069704 was in the XA prepared state.
2018-07-17T08:36:53.475754Z 0 [Note] InnoDB: Transaction 49069705 was in the XA prepared state.
2018-07-17T08:36:53.475781Z 0 [Note] InnoDB: 3 transaction (s) which must be rolled back or cleaned up in total 0 row operations To undo
2018-07-17T08:36:53.475807Z 0 [Note] InnoDB: Trx id counter is 49070080
2018-07-17T08:36:53.475892Z 0 [Note] InnoDB: Starting an apply batch of log records to the database.
InnoDB: Progress in percent: 67 89 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 29 30 31 33 33 35 37 38 39 40 41 43 44 45 46 48 49 51 52 53 55 56 57 59 60 61 63 65 66 67 68 69 70 71 72 73 74 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 97 98 99
2018-07-17T08:36:53.989412Z 0 [Note] InnoDB: Apply batch completed
2018-07-17T08:36:53.989477Z 0 [Note] InnoDB: Last MySQL binlog file position 0901475605, File name master-bin.000012
2018-07-17T08:36:54.096249Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-17T08:36:54.096249Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
2018-07-17T08:36:54.096352Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2018-07-17T08:36:54.096379Z 0 [Note] InnoDB: Setting file". / ibtmp1" size to 12 MB. Physically writing the file full; Please wait.
2018-07-17T08:36:54.105279Z 0 [Warning] InnoDB: 1048576 bytes should have been written. Only 491520 bytes written. Retrying for the remaining bytes.
2018-07-17T08:36:54.105340Z 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2018-07-17T08:362018-07-17T08:36:54.609409Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-17T08:36:54.609464Z 0 [ERROR] Plugin "InnoDB" init function returned error.
2018-07-17T08:36:54.609485Z 0 [ERROR] Plugin" InnoDB" registration as a STORAGE ENGINE failed.
2018-07-17T08: 36RV 54.609497Z 0 [ERROR] Failed to initialize plugins.
2018-07-17T08:36:54.609505Z 0 [ERROR] Aborting

2018-07-17T08:36:54.609549Z 0 [Note] Binlog end
2018-07-17T08:36:54.609636Z 0 [Note] Shutting down plugin "CSV"
2018-07-17T08:36:54.610055Z 0 [Note] / usr/sbin/mysqld: Shutdown complete

what is the reason for this?

Mar.28,2021

disk space is full

Menu