Обсуждение: BUG #6481: postgres shuts down unexpectedly

Поиск
Список
Период
Сортировка

BUG #6481: postgres shuts down unexpectedly

От
michal.rakoczy@sb-betting.com
Дата:
The following bug has been logged on the website:

Bug reference:      6481
Logged by:          Micha=C5=82 Rakoczy
Email address:      michal.rakoczy@sb-betting.com
PostgreSQL version: 9.0.5
Operating system:   Windows Server 2008 R2 Enterprise x64 SP1
Description:=20=20=20=20=20=20=20=20

Hi

I'm struggling with this problem since few days.=20

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.=20

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.=20=20

 DETAIL -=20
 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

Re: BUG #6481: postgres shuts down unexpectedly

От
Robert Haas
Дата:
On Wed, Feb 22, 2012 at 7:28 AM,  <michal.rakoczy@sb-betting.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A06481
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Micha=C5=82 Rakoczy
> Email address: =C2=A0 =C2=A0 =C2=A0michal.rakoczy@sb-betting.com
> PostgreSQL version: 9.0.5
> Operating system: =C2=A0 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, wh=
en
> 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.
>
> =C2=A0DETAIL -
> =C2=A02 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.

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