Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 22 Jun 2007 08:42:42 -0500
From:      "Larry Rosenman" <ler@lerctr.org>
To:        <freebsd-current@freebsd.org>
Subject:   PostgreSQL Stats Collector: EINTR on POLL?
Message-ID:  <003f01c7b4d3$3b547b80$b1fd7280$@org>

next in thread | raw e-mail | index | archive | help
Has anyone else seen an issue where the PostgreSQL stats collector will get
into a loop on poll/EINTR?

This seems to be happening a LOT on my amd64 -CURRENT from 6/16 sources.

I don't *THINK* it's a PostgreSQL issue, as this same code runs fine on
6-STABLE.

the ktrace of the process is full of:

  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
  9788 postgres CALL  poll(0x7fffffffd4b0,0x1,0x7d0)
  9788 postgres RET   poll -1 errno 4 Interrupted system call
#

if I kill it off, it'll go back to normal for a while, then get into that
state again.

this is on a dual 5120 system (4 cores).

I *CAN* give ssh access to a developer if they'd like.
# uname -a
FreeBSD borg.lerctr.org 7.0-CURRENT FreeBSD 7.0-CURRENT #28: Sat Jun 16
13:09:27 CDT 2007     root@borg.lerctr.org:/usr/obj/usr/src/sys/BORG  amd64
#

Ideas?

Thanks!



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?003f01c7b4d3$3b547b80$b1fd7280$>