提問三步曲: 提問先看教程/FAQ索引(wdcp,wdcp_v3,一鍵包)及搜索,會讓你更快解決問題
1 提供詳細,如系統(tǒng)版本,wdcp版本,軟件版本等及錯誤的詳細信息,貼上論壇或截圖發(fā)論壇
2 做過哪些操作或改動設置等
溫馨提示:信息不詳,很可能會沒人理你!論壇有教程說明的,也可能沒人理!因為,你懂的
[求助] mysql服務運行好好的無故會出現(xiàn)連接不上的問題
- 180221 18:59:58 InnoDB: Waiting for the background threads to start
- 180221 18:59:59 InnoDB: 5.5.54 started; log sequence number 6827662
- 180221 18:59:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 180221 18:59:59 [Note] - '0.0.0.0' resolves to '0.0.0.0';
- 180221 18:59:59 [Note] Server socket created on IP: '0.0.0.0'.
- 180221 18:59:59 [Note] Event Scheduler: Loaded 0 events
- 180221 18:59:59 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
- Version: '5.5.54' socket: '/tmp/mysql.sock' port: 3306 Source distribution
- 180222 3:27:38 [Note] Plugin 'FEDERATED' is disabled.
- 180222 3:27:38 InnoDB: The InnoDB memory heap is disabled
- 180222 3:27:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 180222 3:27:38 InnoDB: Compressed tables use zlib 1.2.3
- 180222 3:27:38 InnoDB: Initializing buffer pool, size = 128.0M
- InnoDB: mmap(137363456 bytes) failed; errno 12
- 180222 3:27:38 InnoDB: Completed initialization of buffer pool
- 180222 3:27:38 InnoDB: Fatal error: cannot allocate memory for the buffer pool
- 180222 3:27:38 [ERROR] Plugin 'InnoDB' init function returned error.
- 180222 3:27:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- 180222 3:27:38 [ERROR] Unknown/unsupported storage engine: InnoDB
- 180222 3:27:38 [ERROR] Aborting
- 180222 3:27:38 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: Shutdown complete
- 180222 15:09:14 [Note] Plugin 'FEDERATED' is disabled.
- 180222 15:09:14 InnoDB: The InnoDB memory heap is disabled
- 180222 15:09:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 180222 15:09:14 InnoDB: Compressed tables use zlib 1.2.3
- 180222 15:09:14 InnoDB: Initializing buffer pool, size = 128.0M
- 180222 15:09:14 InnoDB: Completed initialization of buffer pool
- 180222 15:09:14 InnoDB: highest supported file format is Barracuda.
- InnoDB: The log sequence number in ibdata files does not match
- InnoDB: the log sequence number in the ib_logfiles!
- 180222 15:09:14 InnoDB: Database was not shut down normally!
- InnoDB: Starting crash recovery.
- InnoDB: Reading tablespace information from the .ibd files...
- InnoDB: Restoring possible half-written data pages from the doublewrite
- InnoDB: buffer...
- 180222 15:09:15 InnoDB: Waiting for the background threads to start
- 180222 15:09:16 InnoDB: 5.5.54 started; log sequence number 6827672
- 180222 15:09:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 180222 15:09:16 [Note] - '0.0.0.0' resolves to '0.0.0.0';
- 180222 15:09:16 [Note] Server socket created on IP: '0.0.0.0'.
- 180222 15:09:16 [Note] Event Scheduler: Loaded 0 events
- 180222 15:09:16 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
- Version: '5.5.54' socket: '/tmp/mysql.sock' port: 3306 Source distribution
復制代碼
摘取以上錯誤日志,昨晚7點重啟后恢復,凌晨3點就出現(xiàn)錯誤了,下午15點重啟后又恢復正常。經(jīng)常出現(xiàn)這個問題,需要手動重啟才行?床欢罩荆蟠笊駧椭。 |