pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPG 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