Postgres SQL 8.4 regularly craches

From: Hungerbühler Philipp (hune) <philipp(dot)hungerbuehler(at)zhaw(dot)ch>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres SQL 8.4 regularly craches
Date: 2013-12-16 10:24:19
Message-ID: 598D22D6BDE64643A70C7482562BBEEC7BAFA107@srv-mail-101.zhaw.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all

We have a postgres server on Windows 2008 R2 used by tree services. This worked quite for a long time (several years) but lately the Postgres service regularly crashes

2013-12-11 14:03:10 CET LOG: Serverprozess (PID 3576) wurde durch Ausnahme 0xC0000043 beendet (sorry German)

I researched and found that this exception is related to:

0xC0000043
STATUS_SHARING_VIOLATION

A file cannot be opened because the share access flags are incompatible.

I also found a Microsoft fix (http://support.microsoft.com/kb/2707576/en-us) related to this error, but the fix does not apply to our system. I defragmented the drive were the Postgres data resides. But still the service crashes all several days.

Any idea how I could fix this or how I could find out, why the service is crashing? It does not seem to be related to the application using the Postgres DBs, because there seem to be no requests to Postgres exactly at the time it crashes.

Any help would be appreciated. For the moment an upgrade to Postgres 9 is not possibly, because the applications using Postgres DBs are quite vital.

Regards
Philipp
_____________________________________________________________

ZHAW Zürcher Hochschule für Angewandte Wissenschaften
ICT, Server & Systeme

Philipp Hungerbühler
Gertrudstrasse 15
CH-8401 Winterthur

Tel: +41 58 934 69 44
E-Mail: philipp(dot)hungerbuehler(at)zhaw(dot)ch<mailto:philipp(dot)hungerbuehler(at)zhaw(dot)ch>
_____________________________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-12-16 11:30:21 pg_dump behaves differently for different archive formats
Previous Message Vincent Veyron 2013-12-16 08:36:50 Re: Some good news ([info@arin.net: [arin-announce] ARIN Database Migration Completed])