pg_dump strangeness - Mailing list pgsql-general
From | Lane Rollins |
---|---|
Subject | pg_dump strangeness |
Date | |
Msg-id | 000501c2e763$47bf67a0$fd03000a@Lanedell Whole thread Raw |
Responses |
Re: pg_dump strangeness
Re: pg_dump strangeness |
List | pgsql-general |
I’m having an issue with pg_dump crashing one of my servers. I was running PG 7.2.1 now running 7.2.4 on RedHat 7.3 with up to date patches. It happens when I’m dumping a largish (for me) database. The database has two tables one with 1.2 million entries the other has 3.5 million entries, there are also about 700,000 blobs with signatures. The exact command I’m using is…
pg_dump -Fc -b docarc >docarc.cust
It usually doesn’t happen on the first iteration it’s the second that brings the box down. I ran it by hand on the console Saturday and it slowly destabilized the system. I lost the title bars on the windows and then the gnome task bar. Only the mouse cursor moved but it did not responded to clicks or keyboard. I was able to restart the box from a telnet session.
I added more memory to the box and that seems to be helping. It now takes four runs to kill the box.
Any clue to the root of the problem? OS, hardware, postgresql, something misconfigured???
Thanks,
Lane
From the system logfile -
Mar 10 02:34:08 internal kernel: Unable to handle kernel NULL pointer dereference at virtual address 00000020
Mar 10 02:34:08 internal kernel: printing eip:
Mar 10 02:34:08 internal kernel: c013bbee
Mar 10 02:34:08 internal kernel: *pde = 00000000
Mar 10 02:34:08 internal kernel: Oops: 0000
Mar 10 02:34:08 internal kernel: sis sisfb agpgart 8139too mii usb-ohci usbcore ext3 jbd dpt_i2o sd_mod scsi_mod
Mar 10 02:34:08 internal kernel: CPU: 0
Mar 10 02:34:08 internal kernel: EIP: 0010:[<c013bbee>] Not tainted
Mar 10 02:34:08 internal kernel: EFLAGS: 00010286
Mar 10 02:34:08 internal kernel:
Mar 10 02:34:08 internal kernel: EIP is at block_read_full_page [kernel] 0xe (2.4.18-26.7.x)
Mar 10 02:34:08 internal kernel: eax: 00000000 ebx: e1025d34 ecx: 00000000 edx: 00000000
Mar 10 02:34:08 internal kernel: esi: c15d46f0 edi: c02d4a24 ebp: c15d470c esp: e2261d90
Mar 10 02:34:08 internal kernel: ds: 0018 es: 0018 ss: 0018
Mar 10 02:34:08 internal kernel: Process pg_dump (pid: 13593, stackpage=e2261000)
Mar 10 02:34:08 internal kernel: Stack: 00000001 ded15500 e1043540 c01cc410 dd36b600 c020dd17 e2260000 0000000c
Mar 10 02:34:08 internal kernel: e2261eb0 0000000c e1043540 00000282 c01cc431 dd36b600 00000000 00000000
Mar 10 02:34:08 internal kernel: c01cd39b 00000283 0000000c e1025d34 c15d46f0 c02d4a24 00001417 c0128a23
Mar 10 02:34:08 internal kernel: Call Trace: [<c01cc410>] sock_wfree [kernel] 0x0 (0xe2261d9c))
Mar 10 02:34:08 internal kernel: [<c020dd17>] unix_write_space [kernel] 0x37 (0xe2261da4))
Mar 10 02:34:08 internal kernel: [<c01cc431>] sock_wfree [kernel] 0x21 (0xe2261dc0))
Mar 10 02:34:08 internal kernel: [<c01cd39b>] kfree_skbmem [kernel] 0xb (0xe2261dd0))
Mar 10 02:34:08 internal kernel: [<c0128a23>] __remove_inode_page [kernel] 0x33(0xe2261dec))
Mar 10 02:34:08 internal kernel: [<e7946a20>] ext3_get_block [ext3] 0x0 (0xe2261df4))
Mar 10 02:34:08 internal kernel: [<c012fdac>] reclaim_page [kernel] 0x1ec (0xe2261dfc))
Mar 10 02:34:08 internal kernel: [<c0132171>] __alloc_pages_limit [kernel] 0x71(0xe2261e1c))
Mar 10 02:34:08 internal kernel: [<c0132239>] __alloc_pages [kernel] 0x99 (0xe2261e30))
Mar 10 02:34:08 internal kernel: [<c0126cb0>] do_anonymous_page [kernel] 0x50 (0xe2261e64))
Mar 10 02:34:08 internal kernel: [<e7948e65>] ext3_mark_iloc_dirty [ext3] 0x35 (0xe2261e68))
Mar 10 02:34:08 internal kernel: [<c0126da3>] do_no_page [kernel] 0x33 (0xe2261e88))
Mar 10 02:34:08 internal kernel: [<c01cb02c>] sys_recvfrom [kernel] 0xec (0xe2261eac))
Mar 10 02:34:08 internal kernel: [<c0126fea>] handle_mm_fault [kernel] 0xca (0xe2261ec0))
Mar 10 02:34:08 internal kernel: [<c01324a0>] __get_free_pages [kernel] 0x10 (0xe2261ee0))
Mar 10 02:34:08 internal kernel: [<c0146b83>] __pollwait [kernel] 0x33 (0xe2261ee4))
Mar 10 02:34:08 internal kernel: [<c011456a>] do_page_fault [kernel] 0x12a (0xe2261f08))
Mar 10 02:34:08 internal kernel: [<c01286e9>] do_brk [kernel] 0x249 (0xe2261f44))
Mar 10 02:34:08 internal kernel: [<c01cb05d>] sys_recv [kernel] 0x1d (0xe2261f6c))
Mar 10 02:34:08 internal kernel: [<c0127452>] sys_brk [kernel] 0xb2 (0xe2261f94))
Mar 10 02:34:08 internal kernel: [<c0114440>] do_page_fault [kernel] 0x0 (0xe2261fb0))
Mar 10 02:34:08 internal kernel: [<c0108a4c>] error_code [kernel] 0x34 (0xe2261fb8))
pgsql-general by date: