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

Fata error 1?!

From: Jack Zhu <jzhu(at)netcom-sys(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fata error 1?!
Date: 2000-04-13 22:40:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
6.5.3 for Red Hat Linux 6.0, RAM is 128 MB, IBM-PC.

start 'postmaster' by using 'nohup postmaster -i -d  > pgserver.log 2>&1

A table 'tab_a' has about 100000 rows. when I do 'select count(*) from
tab_a;', I got an  error as following and be kicked out of 'psql':

pqReadData()--backend closed the channel unexpectally. This probably
means the back end terminates abnormally before or while processing the
request. We have lost the connection to backend, so further processing
is impossible. Terminating.

I also check the 'pgserver.log' file, it shows:

FATA1: memeory exhausted in AllocSetAlloc()
proc_exit(0)   [#0]
shmem_exit(0)  [#0]
/usr/local/pgsql/bin/postmaster: reaping dead process.....
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 670 exit with status

I restart postmaster with '-B 3096' option to assign more buffers to
postgreSQL, but I got the same error.

Could anyone help me out? And one suggestion: we really should create a
news group for PostgreSQL!!!!!!

Thanks all,

pgsql-admin by date

Next:From: Donald FowlerDate: 2000-04-13 23:00:09
Subject: postgres on WIN32
Previous:From: Margarita BarvinokDate: 2000-04-13 17:26:22
Subject: Error in Compilation

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