Hi, Thanks for your response.
I am not able to find out the core file. but in log file its giving the message like: LOG: server process (PID 29225) was terminated by signal 11: Segmentation fault LOG: terminating any other active server processes LOG: all server processes terminated; reinitializing FATAL: the database system is in recovery mode LOG: database system was interrupted; last known up at 2009-06-23 12:49:49 IST FATAL: the database system is in recovery mode FATAL: the database system is in recovery mode I have searched for the core file for this pid. Is there any spcefic path for the postgres executable? I have already checked for ulimit -c unlimited etc. On my system core file for some other application are generating properly. With Regards, Bhushan On 6/24/09, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > > Bhushan Verma wrote: > > I am doing some database related queries and this is working fine at > fedora > > core 4. > > But the same database queries giving the FATAL error on fedora 9. > > > > If I restarts the database on fedora core 9 then this is perfectlry > working > > without giving any error. > > > > My postgres version is > > On Fedora core-9[FC9] Machine: > > $ rpm -qa|grep postgres > > postgresql-server-8.3.1-1.fc9.i386 > > postgresql-devel-8.3.1-1.fc9.i386 > > postgresql-python-8.3.1-1.fc9.i386 > > postgresql-8.3.1-1.fc9.i386 > > postgresql-libs-8.3.1-1.fc9.i386 > > > It probably won't solve this problem, but you need to upgrade. The > latest 8.3 release is 8.3.7. See > http://www.postgresql.org/support/versioning > > > > On Fedora core-4[FC49] Machine: > > $ rpm -qa|grep postgres > > postgresql-server-8.0.3-1 > > > ... > > Same here. Latest 8.0 minor release is 8.0.21 > > > > Problem is: > > ---------------- > > server closed the connection unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > > > connection to server was lost > > > > psql: FATAL: the database system is in recovery mode > > > ... > > > > > server closed the connection unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > connection to server was lost > > psql: FATAL: the database system is in recovery mode > > > > -------------- > > > > Is this database bug or there is any versioning incopatability. > > > You'll have to give more details or no-one will be able to help you. > Please share the query that caused the crash, and CREATE statements of > all the tables involved in the query. Is there any triggers or anything > else involved? > > Can you get a core dump and post stack trace from it? Something along > the lines of: > 1. ulimit -c unlimited > 2. pg_ctl start > 3. <induce crash> > 4. gdb /usr/bin/postgres <datadir>/core > 5. bt > > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > -- With Regards, Bhushan
