more or less spontaneous reboots with Suse 6.4 / Postgresql 7.0.2
Hi all,
I use Suse Linux 6.4 (kernel 2.2.14) and when I'm executing SQL
statements in batch to postgresql (like: psql db < schema.sql) I have a
fair chance that Linux reboots. No entries about the mishap are logged
in the postgres logfile and neither in /var/log/messages. There's no
telling when it exactly happens but when one of the statements contains
an error the chance is really high that the system reboots.
I have no idea if Postgres is to blame or the linux kernel. I have to
admit that I'm still using the generic kernel, but I think it is a bit
silly that a user process like postmaster could bring the whole server down.
If anyone has had a simulair experience and found a solution I would
like to know about it.
Thanks in advance,
Nils Zonneveld
--
"Misschien is niets geheel waar, en zelfs dat niet"
Multatuli (Eduard Douwes Dekker) - Idee 1
If there isn't any kernel panic (or other error message) displayed then I'd
bet it's a memory problem (it's almost certainly a hardware problem),
PostgreSQL is just triggering it (probably by using the damaged memory).
I've seen this happen before with other programs... Try switching out the
RAM and running the queries again..
-Mitch
----- Original Message -----
From: "Nils Zonneveld" <nils@casema.net>
To: <pgsql-general@postgresql.org>
Sent: Monday, September 25, 2000 2:23 PM
Subject: [GENERAL] more or less spontaneous reboots with Suse 6.4 /
Postgresql 7.0.2
Hi all,
I use Suse Linux 6.4 (kernel 2.2.14) and when I'm executing SQL
statements in batch to postgresql (like: psql db < schema.sql) I have a
fair chance that Linux reboots. No entries about the mishap are logged
in the postgres logfile and neither in /var/log/messages. There's no
telling when it exactly happens but when one of the statements contains
an error the chance is really high that the system reboots.I have no idea if Postgres is to blame or the linux kernel. I have to
admit that I'm still using the generic kernel, but I think it is a bit
silly that a user process like postmaster could bring the whole server
down.
Show quoted text
If anyone has had a simulair experience and found a solution I would
like to know about it.Thanks in advance,
Nils Zonneveld
--
"Misschien is niets geheel waar, en zelfs dat niet"
Multatuli (Eduard Douwes Dekker) - Idee 1
* Nils Zonneveld <nils@casema.net> [000925 14:43] wrote:
Hi all,
I use Suse Linux 6.4 (kernel 2.2.14) and when I'm executing SQL
statements in batch to postgresql (like: psql db < schema.sql) I have a
fair chance that Linux reboots. No entries about the mishap are logged
in the postgres logfile and neither in /var/log/messages. There's no
telling when it exactly happens but when one of the statements contains
an error the chance is really high that the system reboots.I have no idea if Postgres is to blame or the linux kernel. I have to
admit that I'm still using the generic kernel, but I think it is a bit
silly that a user process like postmaster could bring the whole server down.If anyone has had a simulair experience and found a solution I would
like to know about it.
Can't you get a traceback or crash dump with the Linux kernel?
And no, postgresql shouldn't be able to trash/crash your system
unless you have it configured in such a way that it can exhaust
all resources.
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."