From: | "Henrik Steffen" <steffen(at)city-map(dot)de> |
---|---|
To: | "Bertin, Philippe" <philippe(dot)bertin(at)barco(dot)com> |
Cc: | "pg" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Serious Crash last Friday |
Date: | 2002-06-20 07:34:21 |
Message-ID: | 020e01c2182c$e5555e40$7100a8c0@topconcepts.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Philippe,
I have always been using the VACUUM ANALYZE on a daily basis.
I recently changed this cronjob into "VACUUM FULL ANALYZE" - which
didn't help either.
What seems to be helpful is, to drop all user indexes and recreate them
on a daily basis (before, I did this only on a weekly basis once every
sunday)
What exactly is XID wraparound? How can I make sure I am using it? Is it
anything
I shouldn't use? Or should I change anything to make my system run more
stable?
Any help highly appreciated
thanks
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(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------
----- Original Message -----
From: "Bertin, Philippe" <philippe(dot)bertin(at)barco(dot)com>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Sent: Thursday, June 20, 2002 9:06 AM
Subject: RE: [GENERAL] Serious Crash last Friday
Henrik,
I think it was Martijn who asked at a certain point if you made sure there
was no ... (XID ?) wraparound. As it's a heavily used database, couldn't
this be the cause ? i.e., did you try since then to regularly perform the
vacuum analyze (as I see this, on a daily basis) ?
Regards,
Philippe Bertin
Software Development Engineer Avionics
---------------------------------------------------
> -----Original Message-----
> From: Henrik Steffen [SMTP:steffen(at)city-map(dot)de]
> Sent: donderdag 20 juni 2002 8:54
> To: pg
> Subject: Re: [GENERAL] Serious Crash last Friday
>
>
> Hello all,
>
> unfortunately I didn't get a really helping answer from the list yet.
>
> Additionally yesterday night there was again a problem with some SELECTs:
>
> NOTICE: Message from PostgreSQL backend:
> The Postmaster has informed me that some other backend
> died abnormally and possibly corrupted shared memory.
> I have rolled back the current transaction and am
> going to terminate your database system connection and exit.
> Please reconnect to the database system and repeat your query.
> DB-Error in /web/intern.city-map.de/www/vertrieb/wiedervorlage.pl Code 7:
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> Command was:
> SELECT name
> FROM regionen
> WHERE region='0119';
> at /web/pm/CityMap/Abfragen.pm line 135
>
> This is really annoying.
>
> When I noticed it this morning, I dropped all indexes and recreated them.
> Then I ran a VACUUM FULL VERBOSE ANALYZE - afterwards the same query
> worked
> properly again.
>
> I have now created a cronjob that will drop and recreate all indexes on a
> daily basis.
>
> But shouldn't this be unnecessary ?
>
>
>
> 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(at)topconcepts(dot)com Fax. +49 4141 991233
> --------------------------------------------------------
> 24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
> --------------------------------------------------------
> System-Partner gesucht: http://www.franchise.city-map.de
> --------------------------------------------------------
> Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
> --------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Haw | 2002-06-20 09:03:01 | views and rules |
Previous Message | Manfred Koizar | 2002-06-20 07:08:22 | Re: Optimizing queries |