Thread: Unable to start
Hi I'am unable to start, here is the log 2002-01-09 16:13:20 [2777] DEBUG: database system was shut down at 2002-01-09 15:47:42 CET 2002-01-09 16:13:20 [2777] DEBUG: CheckPoint record at (0, 2600056740) 2002-01-09 16:13:20 [2777] DEBUG: Redo record at (0, 2600056740); Undo record at (0, 0); Shutdown TRUE 2002-01-09 16:13:20 [2777] DEBUG: NextTransactionId: 351604; NextOid: 2138874 2002-01-09 16:13:20 [2777] FATAL 2: ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left on device /usr/bin/postmaster: Startup proc 2777 exited with status 512 - abort Any help ?? Michel BELLON LCIE - Informatique appliquée 33 (0)1 40 95 60 35
Hi > 2002-01-09 16:13:20 [2777] FATAL 2: > ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left > on device > /usr/bin/postmaster: Startup proc 2777 exited with status 512 - abort > seems like you disk is full. type df ( if your on linux ) on the prompt to see if thats the case. HTH, Wieger -- Wieger Uffink tel: +31 20 468 6868 fax: +31 20 470 6905 web: http://www.usmedia.nl email: wieger@usmedia.nl --
BELLON Michel <Michel.Bellon@lcie.fr> writes: > Hi > > I'am unable to start, here is the log > > > 2002-01-09 16:13:20 [2777] FATAL 2: > ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left > on device This isn't clear? -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863
You /usr partition is full, see below: ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left on device However, do not delete your xlogs. You can move your pg_xlog directory to a more suitable location and use "ln" to link it back. If you have any problems, feel free to call us at 503-736-4609. Ask for Josh or John. Sincerely, Joshua Drake Co-Author: Practical PostgreSQL http://www.postgresql.info On Wed, 9 Jan 2002, BELLON Michel wrote: > Hi > > I'am unable to start, here is the log > > > 2002-01-09 16:13:20 [2777] DEBUG: database system was shut down at > 2002-01-09 15:47:42 CET > 2002-01-09 16:13:20 [2777] DEBUG: CheckPoint record at (0, 2600056740) > 2002-01-09 16:13:20 [2777] DEBUG: Redo record at (0, 2600056740); Undo > record at (0, 0); Shutdown TRUE > 2002-01-09 16:13:20 [2777] DEBUG: NextTransactionId: 351604; NextOid: > 2138874 > 2002-01-09 16:13:20 [2777] FATAL 2: > ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left > on device > /usr/bin/postmaster: Startup proc 2777 exited with status 512 - abort > > > Any help ?? > > Michel BELLON > LCIE - Informatique appliquée > 33 (0)1 40 95 60 35 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- -- by way of pgsql-general@commandprompt.com http://www.postgresql.info/ http://www.commandprompt.com/
From your log it seems you have run out of disk space Do a df and verify that you have free space left Darren Darren Ferguson On Wed, 9 Jan 2002, BELLON Michel wrote: > Hi > > I'am unable to start, here is the log > > > 2002-01-09 16:13:20 [2777] DEBUG: database system was shut down at > 2002-01-09 15:47:42 CET > 2002-01-09 16:13:20 [2777] DEBUG: CheckPoint record at (0, 2600056740) > 2002-01-09 16:13:20 [2777] DEBUG: Redo record at (0, 2600056740); Undo > record at (0, 0); Shutdown TRUE > 2002-01-09 16:13:20 [2777] DEBUG: NextTransactionId: 351604; NextOid: > 2138874 > 2002-01-09 16:13:20 [2777] FATAL 2: > ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left > on device > /usr/bin/postmaster: Startup proc 2777 exited with status 512 - abort > > > Any help ?? > > Michel BELLON > LCIE - Informatique appliqu�e > 33 (0)1 40 95 60 35 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
On Wed, 9 Jan 2002, BELLON Michel wrote: > Hi > > I'am unable to start, here is the log > > ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left > on device > > Any help ?? > Is your disk full? Try a df -k /usr/share/pgsql/data/pg_xlog ABS -- Alaric B. Snell, Developer abs@frontwire.com
Maybe there is not enough space allocated for the PostgreSQL?
ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left on device
~ Troy Campano ~
-----Original Message-----
From: BELLON Michel [mailto:Michel.Bellon@lcie.fr]
Sent: Wednesday, January 09, 2002 10:17 AM
To: pgsql-general@PostgreSQL.org
Subject: [GENERAL] Unable to start
Hi
I'am unable to start, here is the log
2002-01-09 16:13:20 [2777] DEBUG: database system was shut down at
2002-01-09 15:47:42 CET
2002-01-09 16:13:20 [2777] DEBUG: CheckPoint record at (0, 2600056740)
2002-01-09 16:13:20 [2777] DEBUG: Redo record at (0, 2600056740); Undo
record at (0, 0); Shutdown TRUE
2002-01-09 16:13:20 [2777] DEBUG: NextTransactionId: 351604; NextOid:
2138874
2002-01-09 16:13:20 [2777] FATAL 2:
ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left on device
/usr/bin/postmaster: Startup proc 2777 exited with status 512 - abort
Any help ??
Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@PostgreSQL.org)
On Wed, 9 Jan 2002, BELLON Michel wrote:
> I'am unable to start, here is the log
>
> ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left
> on device
Seems pretty clear to me. You're out of disk space.
Best,
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
Le Wednesday 09 January 2002 16:16, BELLON Michel a écrit : > ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left > on device He says : No space left on device You can try df at the command prompt. You have no space left on the partition containing /usr/share/pgsql/data/pg_xlog/xlogtemp.2777 -- cordialement, William WAISSE fpr = 9CCD 7DA2 7050 8805 F471 03D1 DF76 B78C 690B 4E07 -- Computers are like air conditionners. They work better when you close windows. -- Visitez donc mon site perso (version 0.4 du 29/05/2001) : http://www.neofutur.net -- Vous habitez dans l'Essonne et vous aimez les Pingouins ??? visitez donc la GAULE(=LUG91) : http://www.gaule.org -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GCS/E/MU d- s: a- C++++ UL+++ P+ L++++ E--- W++ N o-- K- w--- O- M- V- PS+ PE-- Y++ PGP++ t+ 5 X++ R++ tv- b+++ DI- D G e++ h* r++ y+++ ------END GEEK CODE BLOCK------
BELLON Michel <Michel.Bellon@lcie.fr> writes:
> 2002-01-09 16:13:20 [2777] FATAL 2:
> ZeroFill(/usr/share/pgsql/data/pg_xlog/xlogtemp.2777) failed: No space left
> on device
Looks like you've run out of disk space. It's trying to create another
16MB WAL segment file, and evidently there's not enough space.
regards, tom lane