[debian-mysql] Bug#607489: Bug#607489: mysql-server-5.1: mysql processes kernel segfault when out of memory

[Radosław Antoniuk]

Hello,

Yes, after upgrading to 5.1.49-3:

Dec 20 00:33:17 db mysqld: 101220  0:33:17 [ERROR] /usr/sbin/mysqld:
Out of sort memory; increase server sort buffer size
Dec 20 00:33:17 db mysqld: 101220  0:33:17 [ERROR] /usr/sbin/mysqld:
Sort aborted
Dec 20 00:36:36 db kernel: printk: 4 messages suppressed.
Dec 20 00:36:36 db kernel: mysqld invoked oom-killer:
gfp_mask=0x280d2, order=0, oomkilladj=0
Dec 20 00:36:36 db kernel:
Dec 20 00:36:36 db kernel: Call Trace:
Dec 20 00:36:36 db kernel: [<ffffffff802524a0>] out_of_memory+0x70/0x1e0
Dec 20 00:36:36 db kernel: [<ffffffff80253dcb>] __alloc_pages+0x24b/0x2f0
Dec 20 00:36:36 db kernel: [<ffffffff80251c93>] mempool_alloc+0x43/0x110
Dec 20 00:36:36 db kernel: [<ffffffff80260bd1>] __handle_mm_fault+0x811/0x10c0
Dec 20 00:36:36 db kernel: [<ffffffff80668ff6>] __down_read+0xd6/0xf2
Dec 20 00:36:36 db kernel: [<ffffffff80217349>] do_page_fault+0xe79/0x1280
Dec 20 00:36:37 db kernel: [<ffffffff803c080f>] __make_request+0x49f/0x650
Dec 20 00:36:37 db kernel: [<ffffffff8047e119>] notify_remote_via_irq+0x29/0x90
Dec 20 00:36:37 db kernel: [<ffffffff8047efcd>]
gnttab_free_grant_references+0x1d/0xb0
Dec 20 00:36:37 db kernel: [<ffffffff806699e7>] error_exit+0x0/0x79
Dec 20 00:36:37 db kernel: [<ffffffff8024ee41>] file_read_actor+0x71/0x170
Dec 20 00:36:37 db kernel: [<ffffffff8024f8e0>]
do_generic_mapping_read+0x170/0x430
Dec 20 00:36:37 db kernel: [<ffffffff8024edd0>] file_read_actor+0x0/0x170
Dec 20 00:36:37 db kernel: [<ffffffff80251a1c>]
generic_file_aio_read+0x16c/0x1b0
Dec 20 00:36:37 db kernel: [<ffffffff80276a2f>] do_sync_read+0xcf/0x120
Dec 20 00:36:37 db kernel: [<ffffffff80241710>]
autoremove_wake_function+0x0/0x30
Dec 20 00:36:37 db kernel: [<ffffffff802669a3>] sys_mprotect+0xae3/0xbc0
Dec 20 00:36:37 db kernel: [<ffffffff8027731a>] vfs_read+0xba/0x160
Dec 20 00:36:37 db kernel: [<ffffffff802777e3>] sys_read+0x53/0x90
Dec 20 00:36:37 db kernel: [<ffffffff80209f86>] system_call+0x86/0x8b
Dec 20 00:36:37 db kernel: [<ffffffff80209f00>] system_call+0x0/0x8b
Dec 20 00:36:37 db kernel:
Dec 20 00:36:37 db kernel: Mem-info:
Dec 20 00:36:37 db kernel: DMA per-cpu:
Dec 20 00:36:37 db kernel: CPU    0: Hot: hi:  186, btch:  31 usd:  21
  Cold: hi:   62, btch:  15 usd:  50
Dec 20 00:36:37 db kernel: CPU    1: Hot: hi:  186, btch:  31 usd:  15
  Cold: hi:   62, btch:  15 usd:  28
Dec 20 00:36:37 db kernel: CPU    2: Hot: hi:  186, btch:  31 usd:  16
  Cold: hi:   62, btch:  15 usd:  53
Dec 20 00:36:37 db kernel: CPU    3: Hot: hi:  186, btch:  31 usd:  34
  Cold: hi:   62, btch:  15 usd:  12
Dec 20 00:36:37 db kernel: Active:3120656 inactive:916585 dirty:0
writeback:0 unstable:0
Dec 20 00:36:37 db kernel: free:4311 slab:3572 mapped:72
pagetables:13378 bounce:0
Dec 20 00:36:37 db kernel: DMA free:17244kB min:16176kB low:20220kB
high:24264kB active:12482624kB inactive:3666340kB present:16362000kB
pages_scanned:35936872 all_unreclaimable? yes
Dec 20 00:36:37 db kernel: lowmem_reserve[]: 0 0 0
Dec 20 00:36:37 db kernel: DMA: 299*4kB 7*8kB 12*16kB 2*32kB 2*64kB
1*128kB 0*256kB 0*512kB 1*1024kB 1*2048kB 3*4096kB = 17124kB
Dec 20 00:36:37 db kernel: Swap cache: add 19233408, delete 19233387,
find 4207501/5732333, race 4+56
Dec 20 00:36:37 db kernel: Free swap  = 0kB
Dec 20 00:36:37 db kernel: Total swap = 10485752kB
Dec 20 00:36:37 db kernel: Free swap:            0kB
Dec 20 00:36:37 db kernel: 4147200 pages of RAM
Dec 20 00:36:37 db kernel: 80986 reserved pages
Dec 20 00:36:37 db kernel: 897 pages shared
Dec 20 00:36:37 db kernel: 48 pages swap cached
Dec 20 00:36:37 db kernel: Out of memory: kill process 325
(mysqld_safe) score 29362471 or a child
Dec 20 00:36:37 db kernel: Killed process 524 (mysqld)
Dec 20 01:03:25 db kernel: fffff802516d5>] filemap_nopage+0x155/0x330
Dec 20 01:03:25 db kernel: [<ffffffff802607e8>] __handle_mm_fault+0x428/0x10c0
Dec 20 01:03:25 db kernel: [<ffffffff8025cc46>] unmap_vmas+0x676/0xbe0
Dec 20 01:03:25 db kernel: [<ffffffff80217349>] do_page_fault+0xe79/0x1280
Dec 20 01:03:25 db kernel: [<ffffffff803ca091>] _atomic_dec_and_lock+0x41/0x80
Dec 20 01:03:25 db kernel: [<ffffffff802639fc>] remove_vma+0x4c/0x60
Dec 20 01:03:25 db kernel: [<ffffffff8026471f>] do_munmap+0x29f/0x2f0
Dec 20 01:03:25 db kernel: [<ffffffff806699e7>] error_exit+0x0/0x79


Regards,
Radek Antoniuk