Board logo

标题: [求助] WDCP运行一段时间后数据库会挂掉到不到原因 [打印本页]

作者: linyanqi    时间: 2017-5-19 20:04     标题: WDCP运行一段时间后数据库会挂掉到不到原因

每天都会出现数据库挂掉,重启又OK了,找不到原因,附上以下日志,望各老大能帮忙看看!谢谢了!


当前版本: wdCP v3.2.4
操作系统:2.6.32-642.6.2.el6.x86_64


170518  0:39:03 [Warning] IP address '211.180.107.240' could not be resolved: Name or service not known
170518  0:57:20 [Warning] IP address '123.57.4.56' could not be resolved: Name or service not known
170518  1:13:39 [Warning] IP address '121.41.113.41' could not be resolved: Name or service not known
170518  1:44:35 [Warning] IP address '180.153.100.123' could not be resolved: Name or service not known
170518  2:26:36 [Warning] IP address '118.129.170.41' could not be resolved: Name or service not known
170518  2:33:49 [Warning] IP address '47.90.92.26' could not be resolved: Name or service not known
170518  3:56:22 [Warning] IP address '119.145.255.181' could not be resolved: Name or service not known
170518  5:08:29 [Warning] IP address '222.186.22.243' could not be resolved: Name or service not known
170518  5:15:12 [Warning] IP address '118.184.33.101' could not be resolved: Name or service not known
170518  6:15:35 [Warning] IP address '123.249.27.95' could not be resolved: Temporary failure in name resolution
170518  6:57:04 [Note] Plugin 'FEDERATED' is disabled.
170518  6:57:04 InnoDB: The InnoDB memory heap is disabled
170518  6:57:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170518  6:57:04 InnoDB: Compressed tables use zlib 1.2.3
170518  6:57:04 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
170518  6:57:04 InnoDB: Completed initialization of buffer pool
170518  6:57:04 InnoDB: Fatal error: cannot allocate memory for the buffer pool
170518  6:57:04 [ERROR] Plugin 'InnoDB' init function returned error.
170518  6:57:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170518  6:57:04 [ERROR] Unknown/unsupported storage engine: InnoDB
170518  6:57:04 [ERROR] Aborting

170518  6:57:04 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: Shutdown complete

170519 15:18:27 [Note] Plugin 'FEDERATED' is disabled.
170519 15:18:27 InnoDB: The InnoDB memory heap is disabled
170519 15:18:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170519 15:18:27 InnoDB: Compressed tables use zlib 1.2.3
170519 15:18:27 InnoDB: Initializing buffer pool, size = 128.0M
170519 15:18:27 InnoDB: Completed initialization of buffer pool
170519 15:18:27 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!
170519 15:18:27  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...
InnoDB: Last MySQL binlog file position 0 507869, file name ./mysql-bin.000006
170519 15:18:28  InnoDB: Waiting for the background threads to start
170519 15:18:29 InnoDB: 5.5.54 started; log sequence number 60923990
170519 15:18:29 [Note] Recovering after a crash using mysql-bin
170519 15:18:29 [Note] Starting crash recovery...
170519 15:18:29 [Note] Crash recovery finished.
170519 15:18:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170519 15:18:29 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170519 15:18:29 [Note] Server socket created on IP: '0.0.0.0'.
170519 15:18:29 [Note] Event Scheduler: Loaded 0 events
170519 15:18:29 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
Version: '5.5.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
170519 18:33:35 [Warning] IP address '59.110.6.177' could not be resolved: Name or service not known
作者: admin    时间: 2017-5-19 20:59

看像是有内存溢出
作者: linyanqi    时间: 2017-5-20 14:29

回复 2# admin


  我的网站都没有其它人访问的。就只有我一个人打开……有没有办法帮忙处理一下:handshake
作者: nong2106    时间: 2017-5-20 17:22

删除mysql  data下的 ib_logfile0、ib_logfile1这2个文件,然后启动MYSQL就好了。
作者: linyanqi    时间: 2017-5-21 09:17

回复 4# nong2106


   这个试过了,还是一样过一段时间会卡死掉。
作者: qiuss    时间: 2017-5-21 11:18

如果流量大的话 1G内存是不是有点小?
作者: linyanqi    时间: 2017-5-22 12:45

回复 6# qiuss


   每天才2个独立 IP,基本上都是自己在访问。流量很小的
作者: linyanqi    时间: 2017-6-6 18:29

解决了,应该是WDCP和系统冲突导致的,换了另一家的LANP,运行了一个星期都没挂过
作者: admin    时间: 2017-6-6 19:19

wdcp是不会和系统冲突的,就算会,也不可能会影响到mysql这些WEB应用环境

系统版本,mysql版本,以及相关设置或配置,则是有可能冲突的




欢迎光临 WDlinux官方论坛 (http://www.wdlinux.cn/bbs/) Powered by Discuz! 7.2