Unable to start

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

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

--

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

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:

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

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/