Skip site navigation (1) Skip section navigation (2)

Re: Postmaster hangs

From: Karen Pease <meme(at)daughtersoftiresias(dot)org>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postmaster hangs
Date: 2009-10-31 08:32:36
Message-ID: 1256977956.8127.30.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
Sorry for the delay in responding, and thanks for your help.


> You didn't actually request a backtrace (bt), so all it shows is the top
> stack frame. That doesn't tell us anything except that it's busy in a
> system call in the kernel.

For a newly-started psql process that locks as soon as the password is
entered:

#0  0x00fbe416 in __kernel_vsyscall ()
#1  0x00c7673b in poll () from /lib/libc.so.6
#2  0x00d20eaa in ?? () from /usr/lib/libpq.so.5
#3  0x00d20faa in ?? () from /usr/lib/libpq.so.5
#4  0x00d1b344 in ?? () from /usr/lib/libpq.so.5
#5  0x00d1d571 in PQsetdbLogin () from /usr/lib/libpq.so.5
#6  0x08055662 in geteuid ()
#7  0x00bb36e5 in __libc_start_main () from /lib/libc.so.6
#8  0x0804a9c1 in geteuid ()

And for the process that ran the update commands that locked it:

#0  0x00e12416 in __kernel_vsyscall ()
#1  0x00c7673b in poll () from /lib/libc.so.6
#2  0x00d20eaa in ?? () from /usr/lib/libpq.so.5
#3  0x00d20faa in ?? () from /usr/lib/libpq.so.5
#4  0x00d21023 in ?? () from /usr/lib/libpq.so.5
#5  0x00d2062a in PQgetResult () from /usr/lib/libpq.so.5
#6  0x00d20853 in ?? () from /usr/lib/libpq.so.5
#7  0x0804e97f in geteuid ()
#8  0x080528bb in geteuid ()
#9  0x0804b37c in geteuid ()
#10 0x08055856 in geteuid ()
#11 0x00bb36e5 in __libc_start_main () from /lib/libc.so.6
#12 0x0804a9c1 in geteuid ()


> > > You can find out a bit more about what the kernel is doing using the
> > > "magic" keyboard sequence "ALT-SysRQ-T" from a vconsole (not under X).
> > 
> > Nothing happened.  Nothing useful in dmesg -- certainly no stacktraces.
> 
> Your kernel might not have the "magic sysrq key" enabled. Run:
> 
>   sudo sysctl -w kernel.sysrq=1
> 
> and try again. Note that on some systems with weird keyboards you might
> have to hold the "Fn" key (if you have one) or disable "F-Lock" (if you
> have it) to get SysRq to be recognised. The print screen / PrtScn key is
> usually shared with SysRq even if it's not marked as such.

That sysctl command did the trick.  Here's the relevant sections:

psql          S c1ff7c00     0 13794  13755
       eb383bcc 00200082 f11b1c00 c1ff7c00 eb383bdc c087c67c c087fc00
c087fc00
       c087fc00 c24ecce0 c24ecf54 c1ff7c00 00000002 c1ff7c00 c24ecf54
c1ff7c00
       00000002 c1ff7c00 e7f75b40 c24ecf54 05f35f1a 7cc8a1e3 00005a28
c24ecf54
Call Trace:
 [<c06aaccb>] schedule_timeout+0x17/0xbc
 [<c049e1ef>] ? __pollwait+0xad/0xb6
 [<c0691aa2>] ? unix_poll+0x17/0x8a
 [<c049d41c>] do_sys_poll+0x292/0x348
 [<c049e142>] ? __pollwait+0x0/0xb6
 [<c0428230>] ? default_wake_function+0x0/0xd
 [<c051b115>] ? __next_cpu+0x15/0x25
 [<c0425b31>] ? tg_shares_up+0x165/0x178
 [<c04259cc>] ? tg_shares_up+0x0/0x178
 [<c041fa2f>] ? walk_tg_tree+0x62/0x72
 [<c041fa91>] ? tg_nop+0x0/0x5
 [<c04149bb>] ? apic_wait_icr_idle+0x17/0x21
 [<c04221dc>] ? task_rq_lock+0x49/0x73
 [<c041445e>] ? __send_IPI_dest_field+0x49/0x4e
 [<c0414595>] ? send_IPI_mask_bitmask+0x5e/0x79
 [<c041fc04>] ? update_curr+0x8d/0xf0
 [<c04226d4>] ? dequeue_entity+0x15/0x13a
 [<c0422bd8>] ? dequeue_task_fair+0x3d/0x42
 [<c04036bf>] ? __switch_to+0xb9/0x139
 [<c042b045>] ? finish_task_switch+0x2f/0xb0
 [<c06aa9bf>] ? schedule+0x6ee/0x70d
 [<c045a5c0>] ? utrace_reset+0x1e7/0x1ef
 [<c045af80>] ? utrace_stop+0x19b/0x1ac
 [<c045b00f>] ? finish_resume_report+0x7e/0x8f
 [<c045b85c>] ? utrace_get_signal+0x4a8/0x5b1
 [<c04a2d5b>] ? touch_atime+0xa0/0xba
 [<c0434ef2>] ? ptrace_report_signal+0x0/0x253
 [<c04393da>] ? dequeue_signal+0x92/0x105
 [<c043970f>] ? get_signal_to_deliver+0x2c2/0x2d6
 [<c0403f10>] ? do_notify_resume+0x71/0x679
 [<c042262a>] ? set_next_entity+0x8b/0xf7
 [<c04036bf>] ? __switch_to+0xb9/0x139
 [<c042b045>] ? finish_task_switch+0x2f/0xb0
 [<c06aa9bf>] ? schedule+0x6ee/0x70d
 [<c0461e8f>] ? audit_syscall_entry+0xf9/0x123
 [<c049d74d>] do_restart_poll+0x2f/0x52
 [<c0437017>] sys_restart_syscall+0x11/0x13
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
psql          S c087fc00     0 18118  12388
       ee7a0bdc 00200082 f7836680 c087fc00 c087fc00 c087c67c c087fc00
c087fc00
       c087fc00 c44bc010 c44bc284 c1fecc00 00000001 c1fecc00 cdb9adb4
c44bc284
       05f2d5b0 001280d2 c07fc90c c44bc284 05f53997 ee7a0bc8 ee7a0bc8
00000000
Call Trace:
 [<c06aaccb>] schedule_timeout+0x17/0xbc
 [<c049e1ef>] ? __pollwait+0xad/0xb6
 [<c0691aa2>] ? unix_poll+0x17/0x8a
 [<c049d41c>] do_sys_poll+0x292/0x348
 [<c049e142>] ? __pollwait+0x0/0xb6
 [<c0428230>] ? default_wake_function+0x0/0xd
 [<c051b115>] ? __next_cpu+0x15/0x25
 [<c0425b31>] ? tg_shares_up+0x165/0x178
 [<c04259cc>] ? tg_shares_up+0x0/0x178
 [<c041fa2f>] ? walk_tg_tree+0x62/0x72
 [<c041fa91>] ? tg_nop+0x0/0x5
 [<c06abe09>] ? _spin_lock+0x8/0xb
 [<c04221dc>] ? task_rq_lock+0x49/0x73
 [<c041fc04>] ? update_curr+0x8d/0xf0
 [<c04226d4>] ? dequeue_entity+0x15/0x13a
 [<c0422bd8>] ? dequeue_task_fair+0x3d/0x42
 [<c04036bf>] ? __switch_to+0xb9/0x139
 [<c042b045>] ? finish_task_switch+0x2f/0xb0
 [<c06aa9bf>] ? schedule+0x6ee/0x70d
 [<c040a793>] ? save_i387+0x103/0x19e
 [<c048f651>] ? kmem_cache_free+0x8c/0xa7
 [<c0403e30>] ? setup_sigcontext+0xfa/0x169
 [<c040aaf5>] ? restore_i387+0xdd/0x12f
 [<c040467c>] ? restore_sigcontext+0x151/0x1a8
 [<c0461e8f>] ? audit_syscall_entry+0xf9/0x123
 [<c049d6ee>] sys_poll+0x3a/0x6a
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
postmaster    D c1fc8a00     0 18125   2877
       eb1eeda8 00200082 eb1eed4c c1fc8a00 eb1eed4c c087c67c c087fc00
c087fc00
       c087fc00 c44be680 c44be8f4 c1fecc00 00000001 c1fecc00 f750ae38
eb1eed88
       c041f325 00000000 c1fc8a00 c44be8f4 05edcf8f 00200246 eb1eeddc
eb1eeda8
Call Trace:
 [<c041f325>] ? kunmap_atomic+0x87/0xa7
 [<c043f1e8>] ? prepare_to_wait+0x51/0x58
 [<f8853904>] start_this_handle+0x2cc/0x3dd [jbd2]
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<f8853b7f>] jbd2_journal_start+0x8c/0xb9 [jbd2]
 [<f894de9b>] ext4_journal_start_sb+0x40/0x42 [ext4]
 [<f89420f8>] ext4_dirty_inode+0x24/0x97 [ext4]
 [<c04ac266>] __mark_inode_dirty+0x29/0x143
 [<c04a2d6f>] touch_atime+0xb4/0xba
 [<c04718ab>] generic_file_aio_read+0x4ff/0x53d
 [<c0492b62>] do_sync_read+0xab/0xe9
 [<c0480500>] ? __vma_link+0x6e/0x73
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<c04f683e>] ? security_file_permission+0xf/0x11
 [<c0492ab7>] ? do_sync_read+0x0/0xe9
 [<c0493418>] vfs_read+0x81/0xdc
 [<c049350c>] sys_read+0x3b/0x60
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
postmaster    D 00000002     0 13813   2877
       eb199da8 00200086 c44b9cd8 00000002 eb199d58 c087c67c c087fc00
c087fc00
       c087fc00 c44b99a0 c44b9c14 c1ff7c00 00000002 c1ff7c00 ef2d1900
c087c67c
       c087fc00 ec018600 eb199d94 c44b9c14 05e4138d 00200246 eb199ddc
eb199da8
Call Trace:
 [<c043f1e8>] ? prepare_to_wait+0x51/0x58
 [<f8853904>] start_this_handle+0x2cc/0x3dd [jbd2]
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<f8853b7f>] jbd2_journal_start+0x8c/0xb9 [jbd2]
 [<f894de9b>] ext4_journal_start_sb+0x40/0x42 [ext4]
 [<f89420f8>] ext4_dirty_inode+0x24/0x97 [ext4]
 [<c04ac266>] __mark_inode_dirty+0x29/0x143
 [<c04a2d6f>] touch_atime+0xb4/0xba
 [<c04718ab>] generic_file_aio_read+0x4ff/0x53d
 [<c0492b62>] do_sync_read+0xab/0xe9
 [<c0446572>] ? clockevents_program_event+0xd4/0xe3
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<c041f842>] ? need_resched+0x18/0x22
 [<c06aaab2>] ? _cond_resched+0x8/0x32
 [<c04f683e>] ? security_file_permission+0xf/0x11
 [<c0492ab7>] ? do_sync_read+0x0/0xe9
 [<c0493418>] vfs_read+0x81/0xdc
 [<c049350c>] sys_read+0x3b/0x60
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D e8859ec0     0 16604   3285
       e8859f24 00000082 00000060 e8859ec0 c041f842 c087c67c c087fc00
c087fc00
       c087fc00 eaaf0000 eaaf0274 c2002c00 00000003 c2002c00 c4e99d2e
00005b61
       00000901 00000000 00000000 eaaf0274 000041fd 00000002 00000284
000001f4
Call Trace:
 [<c041f842>] ? need_resched+0x18/0x22
 [<c06ab0ce>] __mutex_lock_common+0x8a/0xd9
 [<c06ab12f>] __mutex_lock_killable_slowpath+0x12/0x14
 [<c06ab15e>] ? mutex_lock_killable+0x2d/0x34
 [<c06ab15e>] mutex_lock_killable+0x2d/0x34
 [<c049ce61>] vfs_readdir+0x41/0x8f
 [<c049cbd0>] ? filldir64+0x0/0xcd
 [<c049cf12>] sys_getdents64+0x63/0xa1
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D e7db6ec0     0 16605   3285
       e7db6f24 00000082 00000060 e7db6ec0 c041f842 c087c67c c087fc00
c087fc00
       c087fc00 eaaf0cd0 eaaf0f44 c2002c00 00000003 c2002c00 bff09b8c
e7db6f60
       00000901 00000000 00000000 eaaf0f44 05f7ea2e 00000002 00000284
000001f4
Call Trace:
 [<c041f842>] ? need_resched+0x18/0x22
 [<c06ab0ce>] __mutex_lock_common+0x8a/0xd9
 [<c06ab12f>] __mutex_lock_killable_slowpath+0x12/0x14
 [<c06ab15e>] ? mutex_lock_killable+0x2d/0x34
 [<c06ab15e>] mutex_lock_killable+0x2d/0x34
 [<c049ce61>] vfs_readdir+0x41/0x8f
 [<c049cbd0>] ? filldir64+0x0/0xcd
 [<c049cf12>] sys_getdents64+0x63/0xa1
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D ea951d80     0 16606   3285
       ea951ddc 00000086 ea951da8 ea951d80 c0498e59 c087c67c c087fc00
c087fc00
       c087fc00 eaaf6680 eaaf68f4 c2002c00 00000003 c2002c00 c04a1bec
ea951e04
       f740c088 00000006 94f29ee3 eaaf68f4 05f8a91b ea951e10 f740c088
ea951e10
Call Trace:
 [<c0498e59>] ? path_to_nameidata+0x11/0x2a
 [<c04a1bec>] ? __d_lookup+0xb3/0xe7
 [<c04a22b2>] ? dput+0x34/0x107
 [<c06ab0ce>] __mutex_lock_common+0x8a/0xd9
 [<c06ab1bf>] __mutex_lock_slowpath+0x12/0x15
 [<c06ab040>] ? mutex_lock+0x29/0x2d
 [<c06ab040>] mutex_lock+0x29/0x2d
 [<c0499133>] do_lookup+0x6b/0x11e
 [<c049a5a1>] __link_path_walk+0x57e/0x6b5
 [<c049aac4>] path_walk+0x4c/0x9b
 [<c049acc0>] do_path_lookup+0x12d/0x175
 [<c049bdbb>] user_path_at+0x3c/0x62
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<c0495b75>] vfs_stat_fd+0x19/0x40
 [<c0495c4b>] vfs_stat+0x11/0x13
 [<c0495c61>] sys_stat64+0x14/0x2b
 [<c0493694>] ? generic_file_llseek+0x3a/0x46
 [<c0461e8f>] ? audit_syscall_entry+0xf9/0x123
 [<c040b098>] ? syscall_trace_enter+0xb5/0xc9
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D db54cec0     0 18182   3285
       db54cf24 00000082 00000060 db54cec0 c041f842 c087c67c c087fc00
c087fc00
       c087fc00 c44bb340 c44bb5b4 c2002c00 00000003 c2002c00 e2abbec3
00005b5c
       00000901 00000000 00000000 c44bb5b4 000041fd 00000002 00000284
000001f4
Call Trace:
 [<c041f842>] ? need_resched+0x18/0x22
 [<c06ab0ce>] __mutex_lock_common+0x8a/0xd9
 [<c06ab12f>] __mutex_lock_killable_slowpath+0x12/0x14
 [<c06ab15e>] ? mutex_lock_killable+0x2d/0x34
 [<c06ab15e>] mutex_lock_killable+0x2d/0x34
 [<c049ce61>] vfs_readdir+0x41/0x8f
 [<c049cbd0>] ? filldir64+0x0/0xcd
 [<c049cf12>] sys_getdents64+0x63/0xa1
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D db755d80     0 21298   3285
       db755ddc 00000082 db755da8 db755d80 c0498e59 c087c67c c087fc00
c087fc00
       c087fc00 ec4d2670 ec4d28e4 c2002c00 00000003 c2002c00 3c45a442
00005b4e
       f740c088 00000006 94f29ee3 ec4d28e4 ea5cfcc0 db755e10 f740c088
db755e10
Call Trace:
 [<c0498e59>] ? path_to_nameidata+0x11/0x2a
 [<c04a22b2>] ? dput+0x34/0x107
 [<c06ab0ce>] __mutex_lock_common+0x8a/0xd9
 [<c06ab1bf>] __mutex_lock_slowpath+0x12/0x15
 [<c06ab040>] ? mutex_lock+0x29/0x2d
 [<c06ab040>] mutex_lock+0x29/0x2d
 [<c0499133>] do_lookup+0x6b/0x11e
 [<c049a5a1>] __link_path_walk+0x57e/0x6b5
 [<c049aac4>] path_walk+0x4c/0x9b
 [<c049acc0>] do_path_lookup+0x12d/0x175
 [<c049bdbb>] user_path_at+0x3c/0x62
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<c0495b75>] vfs_stat_fd+0x19/0x40
 [<c0495c4b>] vfs_stat+0x11/0x13
 [<c0495c61>] sys_stat64+0x14/0x2b
 [<c0493694>] ? generic_file_llseek+0x3a/0x46
 [<c0461e8f>] ? audit_syscall_entry+0xf9/0x123
 [<c040b098>] ? syscall_trace_enter+0xb5/0xc9
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D cc21c700     0 21309   3285
       ee7afeb8 00000086 f893f20d cc21c700 ca80d110 c087c67c c087fc00
c087fc00
       c087fc00 ec4d6680 ec4d68f4 c1fe1c00 00000000 c1fe1c00 00000000
b557abd0
       ee7aff94 ee7afea4 c049cc67 ec4d68f4 05f3a48d 00000246 ee7afeec
ee7afeb8
Call Trace:
 [<f893f20d>] ? ext4_htree_store_dirent+0xdb/0xe6 [ext4]
 [<c049cc67>] ? filldir64+0x97/0xcd
 [<c043f1e8>] ? prepare_to_wait+0x51/0x58
 [<f8853904>] start_this_handle+0x2cc/0x3dd [jbd2]
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<f8853b7f>] jbd2_journal_start+0x8c/0xb9 [jbd2]
 [<f894de9b>] ext4_journal_start_sb+0x40/0x42 [ext4]
 [<f89420f8>] ext4_dirty_inode+0x24/0x97 [ext4]
 [<c04ac266>] __mark_inode_dirty+0x29/0x143
 [<c04a2d6f>] touch_atime+0xb4/0xba
 [<c049ce96>] vfs_readdir+0x76/0x8f
 [<c049cbd0>] ? filldir64+0x0/0xcd
 [<c049cf12>] sys_getdents64+0x63/0xa1
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D c17cf780     0 21310   3285
       ee7c0e14 00000082 c065fe70 c17cf780 ee7c0dc8 c087c67c c087fc00
c087fc00
       c087fc00 ec4d19a0 ec4d1c14 c1fe1c00 00000000 c1fe1c00 00000040
c06d9348
       ee7c0e54 ee7c0e0c c04acb17 ec4d1c14 05f6ab0b 00000246 ee7c0e48
ee7c0e14
Call Trace:
 [<c065fe70>] ? tcp_sendpage+0x0/0x39b
 [<c04acb17>] ? pipe_to_sendpage+0x56/0x61
 [<c043f1e8>] ? prepare_to_wait+0x51/0x58
 [<f8853904>] start_this_handle+0x2cc/0x3dd [jbd2]
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<f8853b7f>] jbd2_journal_start+0x8c/0xb9 [jbd2]
 [<f894de9b>] ext4_journal_start_sb+0x40/0x42 [ext4]
 [<f89420f8>] ext4_dirty_inode+0x24/0x97 [ext4]
 [<c04ac266>] __mark_inode_dirty+0x29/0x143
 [<c04a2d6f>] touch_atime+0xb4/0xba
 [<c04ad5fe>] splice_direct_to_actor+0x144/0x187
 [<c04ad156>] ? direct_splice_actor+0x0/0x1c
 [<c04ad6a8>] do_splice_direct+0x67/0x84
 [<c0492dd5>] do_sendfile+0x188/0x237
 [<c0492ebe>] sys_sendfile64+0x3a/0x7a
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D c1867000     0 21311   3285
       f12b8e14 00000082 c065fe70 c1867000 f12b8dc8 c087c67c c087fc00
c087fc00
       c087fc00 d4da0000 d4da0274 c1fe1c00 00000000 c1fe1c00 64fb23f0
00005a99
       f12b8e54 f12b8e0c c04acb17 d4da0274 f12b8df8 00000246 f12b8e48
f12b8e14
Call Trace:
 [<c065fe70>] ? tcp_sendpage+0x0/0x39b
 [<c04acb17>] ? pipe_to_sendpage+0x56/0x61
 [<c043f1e8>] ? prepare_to_wait+0x51/0x58
 [<f8853904>] start_this_handle+0x2cc/0x3dd [jbd2]
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<f8853b7f>] jbd2_journal_start+0x8c/0xb9 [jbd2]
 [<f894de9b>] ext4_journal_start_sb+0x40/0x42 [ext4]
 [<f89420f8>] ext4_dirty_inode+0x24/0x97 [ext4]
 [<c04ac266>] __mark_inode_dirty+0x29/0x143
 [<c04a2d6f>] touch_atime+0xb4/0xba
 [<c04ad5fe>] splice_direct_to_actor+0x144/0x187
 [<c04ad156>] ? direct_splice_actor+0x0/0x1c
 [<c04ad6a8>] do_splice_direct+0x67/0x84
 [<c0492dd5>] do_sendfile+0x188/0x237
 [<c0492ebe>] sys_sendfile64+0x3a/0x7a
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         D c1867000     0   681   3285
       e7df7e14 00000086 c065fe70 c1867000 e7df7dc8 c087c67c c087fc00
c087fc00
       c087fc00 cc328cd0 cc328f44 c2002c00 00000003 c2002c00 a29652c3
00005aa0
       e7df7e54 e7df7e0c c04acb17 cc328f44 e7df7df8 00000246 e7df7e48
e7df7e14
Call Trace:
 [<c065fe70>] ? tcp_sendpage+0x0/0x39b
 [<c04acb17>] ? pipe_to_sendpage+0x56/0x61
 [<c043f1e8>] ? prepare_to_wait+0x51/0x58
 [<f8853904>] start_this_handle+0x2cc/0x3dd [jbd2]
 [<c043efe2>] ? autoremove_wake_function+0x0/0x33
 [<f8853b7f>] jbd2_journal_start+0x8c/0xb9 [jbd2]
 [<f894de9b>] ext4_journal_start_sb+0x40/0x42 [ext4]
 [<f89420f8>] ext4_dirty_inode+0x24/0x97 [ext4]
 [<c04ac266>] __mark_inode_dirty+0x29/0x143
 [<c04a2d6f>] touch_atime+0xb4/0xba
 [<c04ad5fe>] splice_direct_to_actor+0x144/0x187
 [<c04ad156>] ? direct_splice_actor+0x0/0x1c
 [<c04ad6a8>] do_splice_direct+0x67/0x84
 [<c0492dd5>] do_sendfile+0x188/0x237
 [<c0492ebe>] sys_sendfile64+0x3a/0x7a
 [<c0404c8a>] syscall_call+0x7/0xb
httpd         D e9287ec0     0 14218   3285
       e9287f24 00000082 00000060 e9287ec0 c041f842 c087c67c c087fc00
c087fc00
       c087fc00 eb2c99a0 eb2c9c14 c2002c00 00000003 c2002c00 92108055
00005a55
       00000901 00000000 00000000 eb2c9c14 000041ff 00000009 00000284
000001f4
Call Trace:
 [<c041f842>] ? need_resched+0x18/0x22
 [<c06ab0ce>] __mutex_lock_common+0x8a/0xd9
 [<c06ab12f>] __mutex_lock_killable_slowpath+0x12/0x14
 [<c06ab15e>] ? mutex_lock_killable+0x2d/0x34
 [<c06ab15e>] mutex_lock_killable+0x2d/0x34
 [<c049ce61>] vfs_readdir+0x41/0x8f
 [<c049cbd0>] ? filldir64+0x0/0xcd
 [<c049cf12>] sys_getdents64+0x63/0xa1
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
httpd         S c06aaab2     0 18474   3285
       ef333d94 00000082 ef333d2c c06aaab2 ef333d38 c087c67c c087fc00
c087fc00
       c087fc00 ec6319a0 ec631c14 c1ff7c00 00000002 c1ff7c00 c087c8e8
ef333dc4
       ef333d80 c041f4f5 ef333d6c ec631c14 05f8a33e c04ec457 ef333dc8
ee32dea8
Call Trace:
 [<c06aaab2>] ? _cond_resched+0x8/0x32
 [<c041f4f5>] ? kmap_atomic_prot+0x1b0/0x1da
 [<c04ec457>] ? ipc_lock+0x2b/0x45
 [<c04ee244>] sys_semtimedop+0x4ca/0x579
 [<c047d8fb>] ? handle_mm_fault+0x2e8/0x6ec
 [<c041f325>] ? kunmap_atomic+0x87/0xa7
 [<c06adcde>] ? do_page_fault+0x3ac/0x710
 [<c041f8b4>] ? resched_task+0x3a/0x6e
 [<c06abfcb>] ? _spin_unlock_irqrestore+0x22/0x38
 [<c0422597>] ? __dequeue_entity+0x73/0x7b
 [<c048edad>] ? __slab_alloc+0x56/0x45b
 [<c04036bf>] ? __switch_to+0xb9/0x139
 [<c06abe09>] ? _spin_lock+0x8/0xb
 [<c043f21a>] ? add_wait_queue+0x2b/0x30
 [<c04b99b5>] ? ep_ptable_queue_proc+0x58/0x69
 [<c0407c02>] sys_ipc+0x48/0x149
 [<c040b098>] ? syscall_trace_enter+0xb5/0xc9
 [<c0404c8a>] syscall_call+0x7/0xb
 =======================
Sched Debug Version: v0.07, 2.6.27.37-170.2.104.fc10.i686 #1
now at 100508767.613095 msecs
  .sysctl_sched_latency                    : 60.000000
  .sysctl_sched_min_granularity            : 12.000000
  .sysctl_sched_wakeup_granularity         : 15.000000
  .sysctl_sched_child_runs_first           : 0.000001
  .sysctl_sched_features                   : 15999

cpu#0, 2397.603 MHz
  .nr_running                    : 3
  .load                          : 5169
  .nr_switches                   : 39955626
  .nr_load_updates               : 31722464
  .nr_uninterruptible            : 4294962483
  .jiffies                       : 100208693
  .next_balance                  : 100.207487
  .curr->pid                     : 1419
  .clock                         : 100508693.131789
  .cpu_load[0]                   : 0
  .cpu_load[1]                   : 0
  .cpu_load[2]                   : 0
  .cpu_load[3]                   : 0
  .cpu_load[4]                   : 0

cfs_rq[0]:/
  .exec_clock                    : 7190027.411929
  .MIN_vruntime                  : 9629754.177543
  .min_vruntime                  : 9630117.494520
  .max_vruntime                  : 9630057.048647
  .spread                        : 302.871104
  .spread0                       : 0.000000
  .nr_running                    : 3
  .load                          : 5169
  .yld_exp_empty                 : 0
  .yld_act_empty                 : 0
  .yld_both_empty                : 0
  .yld_count                     : 5798
  .sched_switch                  : 0
  .sched_count                   : 57208443
  .sched_goidle                  : 33335034
  .ttwu_count                    : 21522783
  .ttwu_local                    : 19234927
  .bkl_count                     : 257158
  .nr_spread_over                : 227460
  .shares                        : 0

rt_rq[0]:/
  .rt_nr_running                 : 0
  .rt_throttled                  : 0
  .rt_time                       : 0.000000
  .rt_runtime                    : 950.000000

runnable tasks:
            task   PID         tree-key  switches  prio     exec-runtime
-------------------------------------------------------------------------------
        events/0    15   9630057.048647    166379   115   9630057.048647
6
           httpd  3387   9629754.177543     11379   120   9629754.177543
6
R nspluginviewer  1419   9632731.819953   3910675   120   9632731.819953
782

cpu#1, 2397.603 MHz
  .nr_running                    : 0
  .load                          : 0
  .nr_switches                   : 44557404
  .nr_load_updates               : 26043206
  .nr_uninterruptible            : 4294951028
  .jiffies                       : 100208693
  .next_balance                  : 100.208709
  .curr->pid                     : 0
  .clock                         : 100508772.127200
  .cpu_load[0]                   : 0
  .cpu_load[1]                   : 0
  .cpu_load[2]                   : 0
  .cpu_load[3]                   : 0
  .cpu_load[4]                   : 0

cfs_rq[1]:/
  .exec_clock                    : 10760814.641896
  .MIN_vruntime                  : 0.000001
  .min_vruntime                  : 16030451.392284
  .max_vruntime                  : 0.000001
  .spread                        : 0.000000
  .spread0                       : 6400333.897764
  .nr_running                    : 0
  .load                          : 0
  .yld_exp_empty                 : 0
  .yld_act_empty                 : 0
  .yld_both_empty                : 0
  .yld_count                     : 6012
  .sched_switch                  : 0
  .sched_count                   : 46573288
  .sched_goidle                  : 17609300
  .ttwu_count                    : 24786657
  .ttwu_local                    : 23332714
  .bkl_count                     : 329871
  .nr_spread_over                : 592231
  .shares                        : 0

rt_rq[1]:/
  .rt_nr_running                 : 0
  .rt_throttled                  : 0
  .rt_time                       : 0.000000
  .rt_runtime                    : 950.000000

runnable tasks:
            task   PID         tree-key  switches  prio     exec-runtime
-------------------------------------------------------------------------------

cpu#2, 2397.603 MHz
  .nr_running                    : 0
  .load                          : 0
  .nr_switches                   : 37194792
  .nr_load_updates               : 18136776
  .nr_uninterruptible            : 4294963669
  .jiffies                       : 100208693
  .next_balance                  : 100.208694
  .curr->pid                     : 0
  .clock                         : 100508693.131564
  .cpu_load[0]                   : 0
  .cpu_load[1]                   : 521
  .cpu_load[2]                   : 654
  .cpu_load[3]                   : 654
  .cpu_load[4]                   : 694

cfs_rq[2]:/
  .exec_clock                    : 4935114.000916
  .MIN_vruntime                  : 0.000001
  .min_vruntime                  : 7676888.540213
  .max_vruntime                  : 0.000001
  .spread                        : 0.000000
  .spread0                       : -1953228.954307
  .nr_running                    : 0
  .load                          : 0
  .yld_exp_empty                 : 0
  .yld_act_empty                 : 0
  .yld_both_empty                : 0
  .yld_count                     : 8319
  .sched_switch                  : 0
  .sched_count                   : 38119479
  .sched_goidle                  : 15526926
  .ttwu_count                    : 21012904
  .ttwu_local                    : 19121428
  .bkl_count                     : 108453
  .nr_spread_over                : 356716
  .shares                        : 0

rt_rq[2]:/
  .rt_nr_running                 : 0
  .rt_throttled                  : 0
  .rt_time                       : 0.000000
  .rt_runtime                    : 950.000000

runnable tasks:
            task   PID         tree-key  switches  prio     exec-runtime
-------------------------------------------------------------------------------

cpu#3, 2397.603 MHz
  .nr_running                    : 0
  .load                          : 0
  .nr_switches                   : 39364990
  .nr_load_updates               : 19956577
  .nr_uninterruptible            : 24732
  .jiffies                       : 100208693
  .next_balance                  : 100.208698
  .curr->pid                     : 0
  .clock                         : 100508778.377187
  .cpu_load[0]                   : 0
  .cpu_load[1]                   : 0
  .cpu_load[2]                   : 0
  .cpu_load[3]                   : 0
  .cpu_load[4]                   : 0

cfs_rq[3]:/
  .exec_clock                    : 7390465.685135
  .MIN_vruntime                  : 0.000001
  .min_vruntime                  : 8633311.798439
  .max_vruntime                  : 0.000001
  .spread                        : 0.000000
  .spread0                       : -996805.696081
  .nr_running                    : 0
  .load                          : 0
  .yld_exp_empty                 : 0
  .yld_act_empty                 : 0
  .yld_both_empty                : 0
  .yld_count                     : 4123
  .sched_switch                  : 0
  .sched_count                   : 39982547
  .sched_goidle                  : 15706527
  .ttwu_count                    : 21587076
  .ttwu_local                    : 20679894
  .bkl_count                     : 314888
  .nr_spread_over                : 391794
  .shares                        : 0

rt_rq[3]:/
  .rt_nr_running                 : 0
  .rt_throttled                  : 0
  .rt_time                       : 0.000000
  .rt_runtime                    : 950.000000

runnable tasks:
            task   PID         tree-key  switches  prio     exec-runtime
-------------------------------------------------------------------------------

It's greek to me, but I hope this helps.  Thanks again!

	- Karen



In response to

Responses

pgsql-bugs by date

Next:From: PierreDate: 2009-10-31 11:18:36
Subject: BUG #5156: Problem compiling postgresql-8.5alpha2
Previous:From: David FetterDate: 2009-10-31 05:45:21
Subject: Re: BUG #5150: math bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group