pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PG crashes MacOS 10.3.4
2+ messages / 2 participants
[nested] [flat]

* PG crashes MacOS 10.3.4
@ 2004-07-24 19:40 Colin Stagner <cbs228@earthlink.net>
  2004-07-29 16:38 ` Re: PG crashes MacOS 10.3.4 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Colin Stagner @ 2004-07-24 19:40 UTC (permalink / raw)
  To: 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-----




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PG crashes MacOS 10.3.4
  2004-07-24 19:40 PG crashes MacOS 10.3.4 Colin Stagner <cbs228@earthlink.net>
@ 2004-07-29 16:38 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-07-29 16:38 UTC (permalink / raw)
  To: Colin Stagner <cbs228@earthlink.net>; +Cc: pgsql-admin

Colin Stagner <cbs228@earthlink.net> writes:
> 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.

As an unprivileged process, Postgres *cannot* crash the machine --- at
least not on sanely-written operating systems, and OS X qualifies.  A
system-wide lockup is either a hardware fault or a kernel bug.

My money is on an intermittent hardware problem.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-29 16:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-24 19:40 PG crashes MacOS 10.3.4 Colin Stagner <cbs228@earthlink.net>
2004-07-29 16:38 ` Tom Lane <tgl@sss.pgh.pa.us>

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