mysql出错导致lnmp自动重启,请问这是什么错误

lostye

刚刚几分钟自动重启了2次,看日志貌似是mysql错误,导致内存不足..

这会负载貌似也很高:1.42 1.67 6.39 1/162

下面是mysql的错误:

"

404

这是启动信息, 没错误

小茶几

我躺枪了

看到楼上签名

lostye

404 发表于 2012-12-22 20:01



这是启动信息, 没错误
这是mysql目录下的.err文件里面的,我i以为是错误信息..

系统错误日志好长,我贴一份部分出来..

Dec 22 19:33:25 MyVPS4401 kernel: init invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0
Dec 22 19:33:25 MyVPS4401 kernel:  [] out_of_memory+0x72/0x1a3
Dec 22 19:33:25 MyVPS4401 kernel:  [] __alloc_pages+0x24e/0x2cf
Dec 22 19:33:25 MyVPS4401 kernel:  [] __do_page_cache_readahead+0xc8/0x18b
Dec 22 19:33:25 MyVPS4401 kernel:  [] filemap_nopage+0x157/0x34c
Dec 22 19:33:25 MyVPS4401 kernel:  [] __handle_mm_fault+0x329/0x1487
Dec 22 19:33:25 MyVPS4401 kernel:  [] do_page_fault+0x0/0xc23
Dec 22 19:33:25 MyVPS4401 kernel:  [] link_path_walk+0x8d/0x95
Dec 22 19:33:25 MyVPS4401 kernel:  [] do_page_fault+0x6c0/0xc23
Dec 22 19:33:25 MyVPS4401 kernel:  [] copy_to_user+0x31/0x48
Dec 22 19:33:25 MyVPS4401 kernel:  [] sys_select+0x15a/0x180
Dec 22 19:33:25 MyVPS4401 kernel:  [] do_page_fault+0x0/0xc23
Dec 22 19:34:18 MyVPS4401 kernel:  [] error_code+0x2b/0x30
Dec 22 19:34:19 MyVPS4401 kernel:  =======================
Dec 22 19:34:20 MyVPS4401 kernel: Mem-info:
Dec 22 19:34:20 MyVPS4401 kernel: DMA per-cpu:
Dec 22 19:34:20 MyVPS4401 kernel: cpu 0 hot: high 186, batch 31 used:34
Dec 22 19:34:21 MyVPS4401 kernel: cpu 0 cold: high 62, batch 15 used:50
Dec 22 19:34:21 MyVPS4401 kernel: cpu 1 hot: high 186, batch 31 used:4
Dec 22 19:34:21 MyVPS4401 kernel: cpu 1 cold: high 62, batch 15 used:1
Dec 22 19:34:21 MyVPS4401 kernel: cpu 2 hot: high 186, batch 31 used:56
Dec 22 19:34:22 MyVPS4401 kernel: cpu 2 cold: high 62, batch 15 used:61
Dec 22 19:34:22 MyVPS4401 kernel: DMA32 per-cpu: empty
Dec 22 19:34:22 MyVPS4401 kernel: Normal per-cpu: empty
Dec 22 19:34:23 MyVPS4401 kernel: HighMem per-cpu:
Dec 22 19:34:23 MyVPS4401 kernel: cpu 0 hot: high 90, batch 15 used:1
Dec 22 19:34:23 MyVPS4401 kernel: cpu 0 cold: high 30, batch 7 used:6
Dec 22 19:34:23 MyVPS4401 kernel: cpu 1 hot: high 90, batch 15 used:12
Dec 22 19:34:23 MyVPS4401 kernel: cpu 1 cold: high 30, batch 7 used:27
Dec 22 19:34:23 MyVPS4401 kernel: cpu 2 hot: high 90, batch 15 used:14
Dec 22 19:34:23 MyVPS4401 kernel: cpu 2 cold: high 30, batch 7 used:25
Dec 22 19:34:23 MyVPS4401 kernel: Free pages:        4848kB (276kB HighMem)
Dec 22 19:34:23 MyVPS4401 kernel: Active:129990 inactive:119519 dirty:0 writeback:0 unstable:0 free:1212 slab:2901 mapped-file:800 mapped-anon:245423 pagetables:2552
Dec 22 19:34:23 MyVPS4401 kernel: DMA free:4572kB min:3452kB low:4312kB high:5176kB active:419528kB inactive:278420kB present:745464kB pages_scanned:1464628 all_unreclaimable? yes
Dec 22 19:34:23 MyVPS4401 kernel: lowmem_reserve[]: 0 0 0 297
Dec 22 19:34:23 MyVPS4401 kernel: DMA32 free:0kB min:0kB low:0kB high:0kB active:0kB inactive:0kB present:0kB pages_scanned:0 all_unreclaimable? no
Dec 22 19:34:23 MyVPS4401 kernel: lowmem_reserve[]: 0 0 0 297
Dec 22 19:34:23 MyVPS4401 kernel: Normal free:0kB min:0kB low:0kB high:0kB active:0kB inactive:0kB present:0kB pages_scanned:0 all_unreclaimable? no
Dec 22 19:34:24 MyVPS4401 kernel: lowmem_reserve[]: 0 0 0 2376
Dec 22 19:34:24 MyVPS4401 kernel: HighMem free:276kB min:296kB low:648kB high:1000kB active:100432kB inactive:199656kB present:304136kB pages_scanned:525628 all_unreclaimable? yes
Dec 22 19:34:24 MyVPS4401 kernel: lowmem_reserve[]: 0 0 0 0
Dec 22 19:34:24 MyVPS4401 kernel: DMA: 9*4kB 1*8kB 27*16kB 10*32kB 11*64kB 2*128kB 1*256kB 1*512kB 0*1024kB 1*2048kB 0*4096kB = 4572kB
Dec 22 19:34:24 MyVPS4401 kernel: DMA32: empty
Dec 22 19:34:24 MyVPS4401 kernel: Normal: empty
Dec 22 19:34:24 MyVPS4401 kernel: HighMem: 7*4kB 1*8kB 1*16kB 1*32kB 1*64kB 1*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 276kB
Dec 22 19:34:24 MyVPS4401 kernel: 4723 pagecache pages
Dec 22 19:34:24 MyVPS4401 kernel: Swap cache: add 1198105, delete 1197866, find 633647/761189, race 6+55
Dec 22 19:34:24 MyVPS4401 kernel: Free swap  = 0kB
Dec 22 19:34:24 MyVPS4401 kernel: Total swap = 262136kB
Dec 22 19:34:24 MyVPS4401 kernel: Free swap:            0kB
Dec 22 19:34:24 MyVPS4401 kernel: 262400 pages of RAM
Dec 22 19:34:24 MyVPS4401 kernel: 76034 pages of HIGHMEM
Dec 22 19:34:24 MyVPS4401 kernel: 3970 reserved pages
Dec 22 19:34:24 MyVPS4401 kernel: 15144 pages shared
Dec 22 19:34:24 MyVPS4401 kernel: 246 pages swap cached
Dec 22 19:34:24 MyVPS4401 kernel: 0 pages dirty
Dec 22 19:34:24 MyVPS4401 kernel: 0 pages writeback
Dec 22 19:34:24 MyVPS4401 kernel: 800 pages mapped
Dec 22 19:34:24 MyVPS4401 kernel: 2901 pages slab
Dec 22 19:34:24 MyVPS4401 kernel: 2552 pages pagetables
Dec 22 19:34:24 MyVPS4401 kernel: Out of memory: Killed process 592, UID 500, (mysqld).
Dec 22 19:34:24 MyVPS4401 kernel: php-cgi invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0
Dec 22 19:34:24 MyVPS4401 kernel:  [] out_of_memory+0x72/0x1a3
Dec 22 19:34:24 MyVPS4401 kernel:  [] __alloc_pages+0x24e/0x2cf
Dec 22 19:34:24 MyVPS4401 kernel:  [] __do_page_cache_readahead+0xc8/0x18b
Dec 22 19:34:24 MyVPS4401 kernel:  [] filemap_nopage+0x157/0x34c
Dec 22 19:34:24 MyVPS4401 kernel:  [] __handle_mm_fault+0x329/0x1487
Dec 22 19:34:24 MyVPS4401 kernel:  [] dput+0x22/0xed
Dec 22 19:34:24 MyVPS4401 kernel:  [] link_path_walk+0x8d/0x95
Dec 22 19:34:24 MyVPS4401 kernel:  [] do_page_fault+0x6c0/0xc23
Dec 22 19:34:24 MyVPS4401 kernel:  [] sys_stat64+0x1e/0x23
Dec 22 19:34:24 MyVPS4401 kernel:  [] do_page_fault+0x0/0xc23
Dec 22 19:34:24 MyVPS4401 kernel:  [] error_code+0x2b/0x30
Dec 22 19:34:24 MyVPS4401 kernel:  =======================

咩咩

看不清楚

loop

不知道。。。。

dvbhack

我一眼望去，映入眼帘的全是

out_of_memory
handle_mm_fault

Out of memory: Killed process 592, UID 500, (mysqld).

lostye

这会负载自己降下去了,明天再看吧..

404

lostye 发表于 2012-12-22 06:05



这是mysql目录下的.err文件里面的,我i以为是错误信息..

系统错误日志好长,我贴一份部分出来..
这里倒全是错误..内存分配囧了....