pg_dump strangeness

From: "Lane Rollins" <laner(at)boyds(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump strangeness
Date: 2003-03-11 00:15:05
Message-ID: 000501c2e763$47bf67a0$fd03000a@Lanedell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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))

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2003-03-11 00:37:37 Re: pg_dump strangeness
Previous Message Bruce Momjian 2003-03-10 23:31:31 Re: 7.4?