鍍金池/ 問答/數(shù)據(jù)庫/ mysql突然掛掉,重啟失敗,求助

mysql突然掛掉,重啟失敗,求助

錯誤日志如下:

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 normally!
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: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 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 0 901475605, 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:36: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

這是什么原因?

回答
編輯回答
孤酒

磁盤空間滿了

2018年7月11日 14:16