pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Colin Stagner <cbs228@earthlink.net>
To: pgsql-admin@postgresql.org
Subject: PG crashes MacOS 10.3.4
Date: Sat, 24 Jul 2004 14:40:43 -0500
Message-ID: <59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I am having some backend stability problems with postgresql 7.4.3 on 
MacOS 10.3.4 ($OSTYPE=darwin7.0). I compiled 7.4.3 from the source less 
than two weeks ago.

At random intervals that seem to vary by database uptime and usage, a 
COPY [table] FROM [file] statement involving maybe 20k - 80k rows 
(larger amounts of data than I usually work with, but nothing the 
server shouldn't be able to handle) will crash the machine. The screen 
freezes, except for the mouse which freezes after about 30 seconds, and 
the machine doesn't respond to keyboard or mouse input. Attempts to SSH 
into the machine fail-- its not just the GUI locking up. The machine 
must be cold-booted with the reset button. After the machine reboots, 
the exact same COPY FROM statement can be executed without incident. 
Nothing revealing is written to system.log, console.log, or the 
postgresql logfile in debug mode.

I have confirmed it is the database server itself, and not the client 
(which in this case happens to be DBD::Pg), which is crashing by 
running the client on another machine.

I have not changed any of the defaults in postgresql.conf.

Any ideas?

- -Colin Stagner


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFBArs/uq9VKK6yTRkRAo9RAJ0fIoZiPLiIDYO9H+j/IPBEJ2DF6wCdFvpo
DUypd+v5j5ggcW0SWfOL2fY=
=/Gm7
-----END PGP SIGNATURE-----




view thread (2+ messages)  latest in thread

Message-ID: <59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net>
Permalink:  ../59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net/
Also on:    postgresql.org/message-id/59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: cbs228@earthlink.net
  Subject: Re: PG crashes MacOS 10.3.4
  In-Reply-To: <59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net>
  References: <59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox