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

Re: [HACKERS] Postgres server goes in recovery mode repeteadly

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: kunal sharma <ksharma(dot)linux(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Postgres server goes in recovery mode repeteadly
Date: 2009-09-29 16:27:39
Message-ID: 4AC2357B.9000302@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers

kunal sharma wrote:
> Hi ,
>         We are using Postgres 8.4 and its been found going into 
> recovery mode couple of times. The server process seems to fork 
> another child process which is another postgres server running under 
> same data directory and after some time it goes away while the old 
> server is still running. There were few load issues on the server but 
> the load didnt went above "32".
>
>    We are running opensuse 10.2 x86_64 with 32Gb of physical memory.
> Checking the logs I found that theres a segmentation fault ,
>  
>
> Sep 26 05:39:54 pace kernel: postgres[28694]: segfault at 
> 0000000000000030 rip 000000000066ba8c rsp 00007fffd364da30 error 4
>
> gdb dump shows this
>
> Reading symbols from /lib64/libdl.so.2...done.
> Loaded symbols for /lib64/libdl.so.2
> Reading symbols from /lib64/libm.so.6...done.
> Loaded symbols for /lib64/libm.so.6
> Reading symbols from /lib64/libc.so.6...done.
> Loaded symbols for /lib64/libc.so.6
> Reading symbols from /lib64/ld-linux-x86-64.so.2...done.
> Loaded symbols for /lib64/ld-linux-x86-64.so.2
> Reading symbols from /lib64/libnss_files.so.2...done.
> Loaded symbols for /lib64/libnss_files.so.2
> 0x00002ad6d7b8c2b3 in __select_nocancel () from /lib64/libc.so.6
> (gdb)
>
>
>  
>

Please try to get a backtrace from gdb.

cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-09-29 16:28:03
Subject: Re: Postgres server goes in recovery mode repeteadly
Previous:From: Mark MielkeDate: 2009-09-29 16:23:05
Subject: Re: Rejecting weak passwords

pgsql-admin by date

Next:From: Tom LaneDate: 2009-09-29 16:28:03
Subject: Re: Postgres server goes in recovery mode repeteadly
Previous:From: kunal sharmaDate: 2009-09-29 16:22:06
Subject: Postgres server goes in recovery mode repeteadly

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