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
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) |