WDCP运行一段时间后数据库会挂掉到不到原因
每天都会出现数据库挂掉,重启又OK了,找不到原因,附上以下日志,望各老大能帮忙看看!谢谢了![list][*]操作系统CentOS 6.8 64位[*]CPU1核[*]内存1GB[*]系统盘20GB(本地磁盘)[*]公网带宽1Mbps[/list]
当前版本: 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 看像是有内存溢出 [b]回复 [url=http://www.wdlinux.cn/bbs/redirect.php?goto=findpost&pid=98775&ptid=57783]2#[/url] [i]admin[/i] [/b]
我的网站都没有其它人访问的。就只有我一个人打开……有没有办法帮忙处理一下:handshake 删除mysql data下的 ib_logfile0、ib_logfile1这2个文件,然后启动MYSQL就好了。 [b]回复 [url=http://www.wdlinux.cn/bbs/redirect.php?goto=findpost&pid=98791&ptid=57783]4#[/url] [i]nong2106[/i] [/b]
这个试过了,还是一样过一段时间会卡死掉。 如果流量大的话 1G内存是不是有点小? [b]回复 [url=http://www.wdlinux.cn/bbs/redirect.php?goto=findpost&pid=98807&ptid=57783]6#[/url] [i]qiuss[/i] [/b]
每天才2个独立 IP,基本上都是自己在访问。流量很小的 解决了,应该是WDCP和系统冲突导致的,换了另一家的LANP,运行了一个星期都没挂过 wdcp是不会和系统冲突的,就算会,也不可能会影响到mysql这些WEB应用环境
系统版本,mysql版本,以及相关设置或配置,则是有可能冲突的 我的也经常出现这样的问题,数据库一挂就得重启,没多长时间就又挂掉,所有动态程序包括后台就打不开了。这个问题一直没解决。 前几天重起的服务器,昨天数据库又挂了,这个问题一直有。一天也没多少IP .
页:
[1]