From: | "Henrik Steffen" <steffen(at)city-map(dot)de> |
---|---|
To: | "pg" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Serious Crash last Friday |
Date: | 2002-06-19 09:35:19 |
Message-ID: | 024401c21774$a0e061a0$7100a8c0@topconcepts.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
--------------------------------------------------------
----- Original Message -----
From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
Cc: "pg" <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, June 18, 2002 11:15 AM
Subject: Re: [GENERAL] Serious Crash last Friday
> well, I don't work with transactions at all...
>
> and I can't see no dupes...
>
>
> 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: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
> To: "Henrik Steffen" <steffen(at)city-map(dot)de>
> Sent: Tuesday, June 18, 2002 1:25 AM
> Subject: Re: [GENERAL] Serious Crash last Friday
>
>
> > On Mon, Jun 17, 2002 at 05:28:23PM +0200, Henrik Steffen wrote:
> > > yes, I was doing it on a living database... not good?
> > >
> > > I was not using -a
> >
> > It doesn't really matter if you're doing it on a live database, it just
> > means that it won't see stuff that is in WAL that has not been committed
> to
> > the main storage.
> >
> > If you're not using -a then something else is going on. Do you have many
> > uncomitted transactions? The program is not particularly intelligent
about
> > which rows are currently active, so you will probably see some
duplicates.
> > Look at the oids shown on the right of each tuple. Also, I've just
> uploaded
> > a new version which deals with dates and times much better.
> >
> > --
> > Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> > > There are 10 kinds of people in the world, those that can do binary
> > > arithmetic and those that can't.
>
>
> ---------------------------(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 | Bjoern Metzdorf | 2002-06-19 10:21:39 | Re: db grows and grows |
Previous Message | BRINER Cedric | 2002-06-19 09:33:45 | Re: compiling problem: tab-complete.c |