From: | galery(at)transfacil(dot)com(dot)br |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11989: checkpoint not completed |
Date: | 2014-11-17 19:02:01 |
Message-ID: | 20141117190201.2478.7245@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11989
Logged by: Antonio Galery
Email address: galery(at)transfacil(dot)com(dot)br
PostgreSQL version: 9.2.9
Operating system: AIX 7100-03-03-1415
Description:
At 14 November at 23:38 postgresql log records a checkpoint starting and
does not register the checkpoint completed. No other checkpoint was
conducted after the beginning of the checkpoint 23:38. At 23:58 the database
deactivated with the following message: 14/11/2014 23:56:39 GMT + 3
[17,825,796] - [10.57.1.26] [585-1] citgis = db, user = opegis STATEMENT:
SELECT * FROM pcd_22_processamento ($ 1)
14.11.2014 23:58:46 GMT + 3 [12,320,794] - [10.57.1.26] [1-1] = citgis db,
user = opegis PANIC: could not write to file "pg_xlog / xlogtemp.12320794":
No space left on device. Report that the area had pg_xlog size of 7GB but
occupied until then 4gb. Doubled the area in order to reactivate the
database. I found no explanation for this.
Galery.
From | Date | Subject | |
---|---|---|---|
Next Message | santiagocfc | 2014-11-17 20:52:07 | BUG #11990: Installation of OPM |
Previous Message | Tom Lane | 2014-11-17 17:21:39 | Re: [BUGS] ltree::text not immutable? |