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: 38F64CC6.AFF93069@netcom-sys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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]
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead process.....
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 670 exit with status
0.

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,
Jack

Browse pgsql-admin by date

  From Date Subject
Next Message Donald Fowler 2000-04-13 23:00:09 postgres on WIN32
Previous Message Margarita Barvinok 2000-04-13 17:26:22 Error in Compilation