vacuumdb -a -z hangs 
Author Message
 vacuumdb -a -z hangs

I have a cronjob that does a vacuumdb -a -z every night.
When i came to work this morning i saw a lot of postgres processes{*filter*}
on wait.

The last thing i see before it hangs is this:

-------------------------------------------------------------
NOTICE:  --Relation pg_toast_1216--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail.
Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE:  Index pg_toast_1216_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE:  Analyzing...
-------------------------------------------------------------

is this a known problem?
Postgres is version 7.1.1.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 Programmer/Networker [|] Magnus Naeslund
 PGP Key: http://www.***.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 23 Nov 2003 22:19:29 GMT
 vacuumdb -a -z hangs

Quote:

> I have a cronjob that does a vacuumdb -a -z every night.
> When i came to work this morning i saw a lot of postgres processes{*filter*}
> on wait.

Sounds to me like you have an open transaction that is holding a lock
that everybody else needs.  Very likely it's not the VACUUM that's at
fault, at least not directly.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sun, 23 Nov 2003 23:44:58 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. pgsql/src/bin/scripts (vacuumdb)

2. Regarding Vacuumdb

3. backup/restore and vacuumdb

4. Regarding vacuumdb

5. pgsql/src/bin/scripts (createdb createlang.sh createuser dropdb droplang dropuser vacuumdb)

6. vacuumdb runtime

7. vacuumdb locked.

8. Regarding vacuumdb

9. pgsql/src/bin/scripts (createdb createlang.sh createuser dropdb droplang dropuser vacuumdb)

10. Fw: [JDBC] Regarding vacuumdb

11. Vacuumdb message: AbortTransaction and not in-progress ...

12. Vacuumdb warnings


 
Powered by phpBB® Forum Software