Re: Total crash of my db-server

Dear Justin,

I am not sure whether it's really a hardware problem,
because I have had similar problems with different machines
and different os- and pgsql-versions before... If you
browse the archive you will find postings from me about
crashes and problems the last 2-3 years...

I can only tell, that the mysql-servers we are running
have never had similar trouble - and they are run on identical
hardware and os-types under almost identical load.

Currently, I am running postgres 7.3 on a Redhat Linux
(Kernel 2.4.19). Most important software packages are
always up2date.



--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Justin Clift" <justin@postgresql.org>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, December 15, 2002 3:16 PM
Subject: Re: [GENERAL] Total crash of my db-server


Hi Henrik,

This *really* sounds like you have a system wide problem, not just a
PostgreSQL problem.

Can't imagine how moving to MySQL will help with that.  ;-)

What Operating System are you using, and when was the last time you
patched/updated it with the vendor recommended patches?

Regards and best wishes,

Justin Clift


Henrik Steffen wrote:
> Hello all,
>
> sometimes I experience a total crash of my
> db-server while e.g. doing automated maintainance tasks:
>
> At 2:30 am every night the webserver is shut
> down, so there won't be any concurrent accesses to the
> db-server. then there will be done a
> VACUUM FULL
>
> This is what happened tonight while fully vacuuming:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> Then, the script selects all user tables and starts
> reindexing them. Tonight, reindexeing the first table
> started and seconds later the whole server crashed.
>
> No ping, nothing else possible....
>
> This is the list of recent crashes:
> Tonight 02:42 am
> Yesterday night 02:39 am
> Tuesday at 10:34 am
> Last saturday at 10:44 am
> Last Tuesday at 02:19 am
> The saturday before at 04:01 am
> The thursday before at 04:02 am
> the tuesday before at 02:25 am
>
> Always complete crashes... only reset helped.
>
> Most crashes occur while maintainance tasks.
> However, there are some other crashes, too.
>
> There are never any hints in /var/log/messages
>
> I upgraded to postgresql 7.3 recently, but it doesn't
> seem to help either.
>
> I am almost desperate.
>
> We are running some mysql-servers here, too, and I
> more and more often try to imagine to move my whole
> system to a mysql-server... my collegues NEVER have
> had such trouble with their mysql-servers yet....
>
> Do you have any hints for me? What can I do? My last
> choice would be to move to mysql, but I am almost
> desperate....
>
> thanks for your help
>
> --
>
> Mit freundlichem Gruß
>
> Henrik Steffen
> Geschäftsführer
>
> top concepts Internetmarketing GmbH
> Am Steinkamp 7 - D-21684 Stade - Germany
> --------------------------------------------------------
> http://www.topconcepts.com          Tel. +49 4141 991230
> mail: steffen@topconcepts.com       Fax. +49 4141 991233
> --------------------------------------------------------
> 24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
> --------------------------------------------------------
> Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
> System-Partner gesucht: http://www.franchise.city-map.de
> --------------------------------------------------------
> Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
> --------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi