PG crashes MacOS 10.3.4

From: Colin Stagner <cbs228(at)earthlink(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: PG crashes MacOS 10.3.4
Date: 2004-07-24 19:40:43
Message-ID: 59BCCE76-DDA9-11D8-AF0A-0050E490FE72@earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----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-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2004-07-24 20:35:10 Re: [HACKERS] Point in Time Recovery
Previous Message mike g 2004-07-24 03:23:23 Re: Backup