Skip site navigation (1) Skip section navigation (2)

Re: BUG #6481: postgres shuts down unexpectedly

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: michal(dot)rakoczy(at)sb-betting(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6481: postgres shuts down unexpectedly
Date: 2012-04-09 14:27:26
Message-ID: CA+TgmoZupFOcmi3NW4TFHkNZqJ3Pxem2yfH0uEEk=QD1aPPg5w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Feb 22, 2012 at 7:28 AM,  <michal(dot)rakoczy(at)sb-betting(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6481
> Logged by:          Michał Rakoczy
> Email address:      michal(dot)rakoczy(at)sb-betting(dot)com
> PostgreSQL version: 9.0.5
> Operating system:   Windows Server 2008 R2 Enterprise x64 SP1
> Description:
>
> Hi
>
> I'm struggling with this problem since few days.
>
> My environment contains two PostgreSQL instances with build-in streaming
> replication. Master host is being queried by JBoss application server, when
> slave works in read-only mode, as db backup in case of master host crash.
>
> Suddenly PostgreSQL shuts down unexpectedly without any reason.
>
> Event viewer log :
>
> Windows detected your registry file is still in use by other applications or
> services. The file will be unloaded now. The applications or services that
> hold your registry file may not function properly afterwards.
>
>  DETAIL -
>  2 user registry handles leaked from
> \Registry\User\S-1-5-21-1897005561-2437030572-477490838-1005:
> Process 1400 (\Device\HarddiskVolume3\Windows\System32\conhost.exe) has
> opened key
> \REGISTRY\USER\S-1-5-21-1897005561-2437030572-477490838-1005\Control
> Panel\International
> Process 9020 (\Device\HarddiskVolume5\PostgreSQL\9.0\bin\postgres.exe) has
> opened key
> \REGISTRY\USER\S-1-5-21-1897005561-2437030572-477490838-1005\Control
> Panel\International

I think we need to see the PostgreSQL log, rather than this.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2012-04-09 14:30:23
Subject: Re: BUG #6565: GEQO documentation discrepancy after 9.0 change?
Previous:From: Robert HaasDate: 2012-04-09 14:20:59
Subject: Re: BUG #6464: Installer (postgresql-9.1.2-1-windows-x64.exe) doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group