some error messages in postgeslog

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: some error messages in postgeslog
Date: 2006-04-19 13:44:09
Message-ID: 8626C1B7EB748940BCDD7596134632BE39867B@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I use PostgreSQL 8.0.0

it seems that the disk was close to full,

i executed a program (in C++) which opens a connection to Postgres using PQConnectdb.

and then it reads from a particluar table, and simply displays the values on the console.

after doing that it will close the connection using PQfinish

and thats when these error messages come....

<2006-04-05 17:10:47 CDT%idle>LOG: disconnection: session time: 0:00:00.00 user=sdc database=dbexpress host=[local] port=
<2006-04-05 17:10:47 CDT%idle>LOG: disconnection: session time: 7:41:26.70 user=sdc database=dbexpress host=[local] port=
<2006-04-05 17:10:47 CDT%>ERROR: could not access status of transaction 0
<2006-04-05 17:10:47 CDT%>DETAIL: could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:48 CDT%>LOG: could not close temporary statistics file "/export/home1/sdc_image_pool/dbx/global/pgstat.tm
p.24783": No space left on device
<2006-04-05 17:10:49 CDT%>ERROR: could not access status of transaction 0
<2006-04-05 17:10:49 CDT%>DETAIL: could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:50 CDT%>ERROR: could not access status of transaction 0
<2006-04-05 17:10:50 CDT%>DETAIL: could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device


is it true that for starting a connection to postgres read a table and then closing connection disk space will be needed.

Is it because of this reason these error messages are coming?



i have another question i have also noticed this error message in the postgres log, what are its implications and what happened that this error message came
:
2006-04-05 09:22:08 CDT%>LOG: received fast shutdown request
<2006-04-05 09:22:08 CDT%>LOG: aborting any active transactions
<2006-04-05 09:22:08 CDT%>LOG: checkpoints are occurring too frequently (16 seconds apart)
<2006-04-05 09:22:08 CDT%>HINT: Consider increasing the configuration parameter "checkpoint_segments".


Thanks,
regards
Surabhi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2006-04-19 14:18:56 Re: Bulk inserts within a Perl script?
Previous Message Ian Harding 2006-04-19 13:26:57 Re: Categories and Sub Categories (Nested)