I'm using a servlet-engine and the PostgreSQL JDBC driver to connect to a Cygwin version of PostgreSQL 7.0.3 that I have compiled ... using also ipc-daemon 1.8 i think the version is ... whatever the latest is .. anyways i've been having this problem today and I can't figure out why .. it happens when i shut down the servlet-engine and abruptly kill connections ..

and it has never happened before

/usr/local/pgsql/bin/postmaster: ServerLoop: select failed: No children
proc_exit(1)
shmem_exit(1)
NOTICE: IpcMemoryDetach: shmdt(0x0x7190000): Invalid argument
NOTICE: IpcMemoryDetach: shmdt(0x0x7060000): Invalid argument
NOTICE: IpcMemoryDetach: shmdt(0x0x7050000): Invalid argument
exit(1)

anyone have any ideas what this might be?

i'm running a win2000 box

-a

Search Discussions

  • Yutaka tanida at Jan 18, 2001 at 9:22 am
    Hi,

    On Thu, 18 Jan 2001 00:31:06 -0800
    Andrew Lombardi wrote:
    I'm using a servlet-engine and the PostgreSQL JDBC driver to connect to a Cygwin version of PostgreSQL 7.0.3 that I have compiled ... using also ipc-daemon 1.8 i think the version is ... whatever the latest is .. anyways i've been having this problem today and I can't figure out why .. it happens when i shut down the servlet-engine and abruptly kill connections ..

    and it has never happened before

    /usr/local/pgsql/bin/postmaster: ServerLoop: select failed: No children
    proc_exit(1)
    shmem_exit(1)
    NOTICE: IpcMemoryDetach: shmdt(0x0x7190000): Invalid argument
    NOTICE: IpcMemoryDetach: shmdt(0x0x7060000): Invalid argument
    NOTICE: IpcMemoryDetach: shmdt(0x0x7050000): Invalid argument
    exit(1)

    anyone have any ideas what this might be?
    It's a harmless bug of cygipc . Please use this patch against cygipc
    1.08.

    --
    Yutaka tanida <yutaka@hi-net.zaq.ne.jp>
  • Jason Tishler at Jan 18, 2001 at 1:21 pm
    Yutaka,
    On Thu, Jan 18, 2001 at 06:27:47PM +0900, Yutaka tanida wrote:
    anyone have any ideas what this might be?
    It's a harmless bug of cygipc . Please use this patch against cygipc
    1.08.
    Thanks for another patch. Have you been submitting these patches to:

    Charles Wilson <cwilson@ece.gatech.edu>

    Thanks,
    Jason

    --
    Jason Tishler
    Director, Software Engineering Phone: +1 (732) 264-8770 x235
    Dot Hill Systems Corp. Fax: +1 (732) 264-8798
    82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
    Hazlet, NJ 07730 USA WWW: http://www.dothill.com
  • Jason Tishler at Feb 6, 2001 at 2:41 pm
    Yutaka,
    On Thu, Jan 18, 2001 at 06:27:47PM +0900, Yutaka tanida wrote:
    It's a harmless bug of cygipc . Please use this patch against cygipc 1.08.
    It appears that this patch is no longer necessary when running against
    the latest Cygwin CVS. Do you think that Chris Faylor's recent signal
    handling work fixed this problem too?

    Thanks,
    Jason

    --
    Jason Tishler
    Director, Software Engineering Phone: +1 (732) 264-8770 x235
    Dot Hill Systems Corp. Fax: +1 (732) 264-8798
    82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
    Hazlet, NJ 07730 USA WWW: http://www.dothill.com
  • Yutaka tanida at Feb 6, 2001 at 3:15 pm
    Jason,

    On Tue, 6 Feb 2001 09:45:49 -0500
    Jason Tishler wrote:
    It appears that this patch is no longer necessary when running against
    the latest Cygwin CVS.
    No. It fixes a bug that is not related on this one.
    Do you think that Chris Faylor's recent signal
    handling work fixed this problem too?
    I agree it was fixed. But I think there's more bugs not related
    PostgreSQL....


    ---
    Yutaka tanida<yutaka@hi-net.zaq.ne.jp>
  • Jason Tishler at Feb 9, 2001 at 2:27 am

    On Tue, Feb 06, 2001 at 09:45:49AM -0500, Jason Tishler wrote:
    On Thu, Jan 18, 2001 at 06:27:47PM +0900, Yutaka tanida wrote:
    It's a harmless bug of cygipc . Please use this patch against cygipc 1.08.
    It appears that this patch is no longer necessary when running against
    the latest Cygwin CVS. Do you think that Chris Faylor's recent signal
    handling work fixed this problem too?
    Yutaka's patch *is* still needed to eliminated this annoying cygipc error
    message. I thought that I was using an unmodified cygipc-1.08 when I
    wrote this email. Unfortunately, I was wrong -- I was still using the
    patched version. Sorry, for the noise...

    Jason

    --
    Jason Tishler
    Director, Software Engineering Phone: +1 (732) 264-8770 x235
    Dot Hill Systems Corp. Fax: +1 (732) 264-8798
    82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
    Hazlet, NJ 07730 USA WWW: http://www.dothill.com
  • Jason Tishler at Jan 18, 2001 at 1:17 pm
    Andrew,
    On Thu, Jan 18, 2001 at 12:31:06AM -0800, Andrew Lombardi wrote:
    I'm using a servlet-engine and the PostgreSQL JDBC driver to connect
    to a Cygwin version of PostgreSQL 7.0.3 that I have compiled ... using
    also ipc-daemon 1.8 i think the version is ... whatever the latest is
    .. anyways i've been having this problem today and I can't figure out
    why .. it happens when i shut down the servlet-engine and abruptly kill
    connections ..

    and it has never happened before

    /usr/local/pgsql/bin/postmaster: ServerLoop: select failed: No children
    The above problem is discussed in the thread that begins with:

    http://www.postgresql.org/mhonarc/pgsql-ports/2000-12/msg00046.html

    It has been fixed and is available in 7.1 Beta 3:

    ftp://postgresql.readysetnet.com/pub/postgresql/dev/postgresql-7.1beta3.tar.gz

    or from CVS:

    http://www.postgresql.org/devel-corner/docs/postgres/anoncvs.htm

    Jason

    --
    Jason Tishler
    Director, Software Engineering Phone: +1 (732) 264-8770 x235
    Dot Hill Systems Corp. Fax: +1 (732) 264-8798
    82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
    Hazlet, NJ 07730 USA WWW: http://www.dothill.com
  • Tom Lane at Jan 27, 2001 at 5:56 am

    Andrew Lombardi writes:
    /usr/local/pgsql/bin/postmaster: ServerLoop: select failed: No children
    This is a known bug --- the postmaster's SIGCHLD signal handler needs to
    save and restore errno. Fixed in 7.1, and a patch for 7.0.* has been
    described on the lists a couple of times ...

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJan 18, '01 at 8:30a
activeFeb 9, '01 at 2:27a
posts8
users4
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase