Thread: database corruption on VACUUM ANALYZE, now unable to initdb

database corruption on VACUUM ANALYZE, now unable to initdb

From
Corey Minter
Date:
I wonder if anyone can help...  (I'm running version 7.1.2)

I am trying to rebuild my database after a database corruption
(apparently from a VACUUM ANALYZE).  I moved the old PGDATA directory
aside, but now I can't even run `initdb`.  I don't understand how I
wouldn't be able to run initdb.

--- postgresql log from `initdb`
postmaster successfully started
DEBUG:  database system shutdown was interrupted at 2001-08-14 01:44:45 PDT
DEBUG:  CheckPoint record at (0, 768826048)
DEBUG:  Redo record at (0, 766174000); Undo record at (0, 723411228); Shutdown FALSE
DEBUG:  NextTransactionId: 167461; NextOid: 816519
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 766174000)
DEBUG:  open(logfile 0 seg 48) failed: No such file or directory
DEBUG:  redo done at (0, 805306308)
FATAL 2:  ZeroFill(/var/pgsql/data/pg_xlog/xlogtemp.29805) failed: No such file or directory
/usr/local/pgsql/bin/postmaster: Startup proc 29805 exited with status 512 - abort
postmaster successfully started
DEBUG:  database system shutdown was interrupted at 2001-08-14 01:45:46 PDT
DEBUG:  CheckPoint record at (0, 768826048)
DEBUG:  Redo record at (0, 766174000); Undo record at (0, 723411228); Shutdown FALSE
DEBUG:  NextTransactionId: 167461; NextOid: 816519
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 766174000)
DEBUG:  open(logfile 0 seg 48) failed: No such file or directory
DEBUG:  redo done at (0, 805306308)
FATAL 2:  ZeroFill(/var/pgsql/data/pg_xlog/xlogtemp.29872) failed: No such file or directory
/usr/local/pgsql/bin/postmaster: Startup proc 29872 exited with status 512 - abort

--- postgresql log from VACUUM ANALYZE
DEBUG:  XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG:  MoveOfflineLogs: remove 0000000000000029
DEBUG:  MoveOfflineLogs: remove 000000000000002A
DEBUG:  MoveOfflineLogs: remove 0000000000000028
DEBUG:  XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG:  --Relation pg_type--
DEBUG:  Pages 3: Changed 0, reaped 1, Empty 0, New 0; Tup 192: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 1, MinLen 106,
MaxLen109; Re-using: Free/Avail. Space 2484/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_type_oid_index: Pages 2; Tuples 192: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_type_typname_index: Pages 4; Tuples 192: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_attribute--
DEBUG:  Pages 20: Changed 0, reaped 1, Empty 0, New 0; Tup 1499: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 37, MinLen 98,
MaxLen98; Re-using: Free/Avail. Space 6256/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_attribute_relid_attnam_index: Pages 21; Tuples 1499: Deleted 0. CPU 0.00s/0.01u sec.
DEBUG:  Index pg_attribute_relid_attnum_index: Pages 10; Tuples 1499: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_class--
DEBUG:  Pages 4: Changed 0, reaped 1, Empty 0, New 0; Tup 238: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 27, MinLen 115,
MaxLen152; Re-using: Free/Avail. Space 3252/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_class_oid_index: Pages 4; Tuples 238: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_class_relname_index: Pages 8; Tuples 238: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_group--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 1: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 96, MaxLen
96;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_group_name_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_group_sysid_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_database--
DEBUG:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 17: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 22, MinLen 84,
MaxLen84; Re-using: Free/Avail. Space 6588/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Analyzing...
DEBUG:  --Relation pg_attrdef--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 29: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 141,
MaxLen366; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_attrdef_adrelid_index: Pages 2; Tuples 29. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_1215--
DEBUG:  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. 
DEBUG:  Index pg_toast_1215_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_trigger--
DEBUG:  Pages 5: Changed 0, reaped 0, Empty 0, New 0; Tup 154: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 152,
MaxLen223; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_trigger_tgconstrname_index: Pages 2; Tuples 154. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_trigger_tgconstrrelid_index: Pages 2; Tuples 154. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_trigger_tgrelid_index: Pages 2; Tuples 154. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_inherits--
DEBUG:  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. 
DEBUG:  Index pg_inherits_relid_seqno_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_index--
DEBUG:  Pages 3: Changed 0, reaped 0, Empty 0, New 0; Tup 132: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 164,
MaxLen164; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_index_indrelid_index: Pages 2; Tuples 132. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_index_indexrelid_index: Pages 2; Tuples 132. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_operator--
DEBUG:  Pages 9: Changed 0, reaped 0, Empty 0, New 0; Tup 594: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 116,
MaxLen116; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_operator_oid_index: Pages 4; Tuples 594. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_operator_oprname_l_r_k_index: Pages 9; Tuples 594. CPU 0.00s/0.01u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_opclass--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 29: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 68, MaxLen
68;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_opclass_deftype_index: Pages 2; Tuples 29. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_opclass_name_index: Pages 2; Tuples 29. CPU 0.01s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_am--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 148, MaxLen
148;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_am_name_index: Pages 2; Tuples 4. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_amop--
DEBUG:  Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 169: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46,
MaxLen46; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_amop_opid_index: Pages 2; Tuples 169. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_amop_strategy_index: Pages 2; Tuples 169. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_amproc--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 54: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen
46;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Analyzing...
DEBUG:  --Relation pg_language--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 79, MaxLen
84;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_language_name_index: Pages 2; Tuples 3. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_language_oid_index: Pages 2; Tuples 3. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_largeobject--
DEBUG:  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. 
DEBUG:  Index pg_largeobject_loid_pn_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_aggregate--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 56: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 92, MaxLen
111;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_aggregate_name_type_index: Pages 2; Tuples 56. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_ipl--
DEBUG:  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. 
DEBUG:  Analyzing...
DEBUG:  --Relation pg_inheritproc--
DEBUG:  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. 
DEBUG:  Analyzing...
DEBUG:  --Relation pg_description--
DEBUG:  Pages 10: Changed 0, reaped 0, Empty 0, New 0; Tup 1177: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 42,
MaxLen110; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.02u sec. 
DEBUG:  Index pg_description_objoid_index: Pages 6; Tuples 1177. CPU 0.00s/0.01u sec.
DEBUG:  --Relation pg_toast_17086--
DEBUG:  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. 
DEBUG:  Index pg_toast_17086_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_listener--
DEBUG:  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. 
DEBUG:  Index pg_listener_pid_relname_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_shadow--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 76, MaxLen
93;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Analyzing...
DEBUG:  --Relation pg_proc--
DEBUG:  Pages 28: Changed 0, reaped 0, Empty 0, New 0; Tup 1143: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 177,
MaxLen229; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.01s/0.01u sec. 
DEBUG:  Index pg_proc_oid_index: Pages 6; Tuples 1143. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_proc_proname_narg_type_index: Pages 26; Tuples 1143. CPU 0.01s/0.00u sec.
DEBUG:  --Relation pg_toast_1255--
DEBUG:  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. 
DEBUG:  Index pg_toast_1255_idx: Pages 1; Tuples 0. CPU 0.01s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation options--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 22: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 98, MaxLen
143;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index options_pkey: Pages 2; Tuples 22. CPU 0.00s/0.00u sec.
DEBUG:  Index options_name_key: Pages 2; Tuples 22. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_relcheck--
DEBUG:  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. 
DEBUG:  Index pg_relcheck_rcrelid_index: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_1216--
DEBUG:  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. 
DEBUG:  Index pg_toast_1216_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation flavor_work_weight1b--
DEBUG:  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. 
DEBUG:  Index flavor_work_weight1b_k1: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index flavor_work_weight1b_k2: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_rewrite--
DEBUG:  Pages 4: Changed 0, reaped 0, Empty 0, New 0; Tup 22: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 116,
MaxLen1960; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_rewrite_oid_index: Pages 2; Tuples 22. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_rewrite_rulename_index: Pages 2; Tuples 22. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_17058--
DEBUG:  Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 4: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 461, MaxLen
2034;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_toast_17058_idx: Pages 2; Tuples 4. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation flavor_weight--
DEBUG:  Pages 30: Changed 0, reaped 0, Empty 0, New 0; Tup 3980: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 53,
MaxLen53; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.05s/0.02u sec. 
DEBUG:  Index flavor_weight_pkey: Pages 18; Tuples 3980. CPU 0.03s/0.01u sec.
DEBUG:  Index flavor_weight_k1: Pages 14; Tuples 3980. CPU 0.00s/0.03u sec.
DEBUG:  Index flavor_weight_k2: Pages 14; Tuples 3980. CPU 0.00s/0.01u sec.
DEBUG:  Index flavor_weight_k3: Pages 14; Tuples 3980. CPU 0.00s/0.00u sec.
DEBUG:  Index flavor_weight_k4: Pages 13; Tuples 3980. CPU 0.00s/0.01u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation pg_statistic--
DEBUG:  Pages 6: Changed 4, reaped 4, Empty 0, New 0; Tup 292: Vac 195, Keep/VTL 0/0, Crash 0, UnUsed 19, MinLen 64,
MaxLen1224; Re-using: Free/Avail. Space 17472/17472; EndEmpty/Avail. Pages 0/4. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_statistic_relid_att_index: Pages 4; Tuples 292: Deleted 195. CPU 0.00s/0.01u sec.
DEBUG:  Rel pg_statistic: Pages: 6 --> 4; Tuple(s) moved: 195. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_statistic_relid_att_index: Pages 4; Tuples 292: Deleted 195. CPU 0.00s/0.00u sec.
DEBUG:  --Relation pg_toast_16600--
DEBUG:  Pages 2: Changed 2, reaped 1, Empty 0, New 0; Tup 3: Vac 3, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 1512,
MaxLen2034; Re-using: Free/Avail. Space 6120/6120; EndEmpty/Avail. Pages 0/1. CPU 0.00s/0.00u sec. 
DEBUG:  Index pg_toast_16600_idx: Pages 2; Tuples 3: Deleted 3. CPU 0.00s/0.00u sec.
DEBUG:  Rel pg_toast_16600: Pages: 2 --> 1; Tuple(s) moved: 2. CPU 0.00s/0.00u sec.
DEBUG:  Index pg_toast_16600_idx: Pages 2; Tuples 3: Deleted 2. CPU 0.00s/0.00u sec.
DEBUG:  --Relation flavor_work--
DEBUG:  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. 
DEBUG:  Index flavor_work_pkey: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index flavor_work_k1: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index flavor_work_k2: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index flavor_work_k3: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  --Relation some_table--
DEBUG:  Pages 2439: Changed 1, reaped 2142, Empty 0, New 0; Tup 26935: Vac 188217, Keep/VTL 0/0, Crash 0, UnUsed 0,
MinLen77, MaxLen 134; Re-using: Free/Avail. Space 16745424/16745424; EndEmpty/Avail. Pages 0/2142. CPU 0.22s/0.02u sec. 
DEBUG:  XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG:  Index some_table_pkey: Pages 624; Tuples 26935: Deleted 188217. CPU 1.59s/3.53u sec.
DEBUG:  Index some_table_k1: Pages 637; Tuples 26935: Deleted 188217. CPU 0.45s/3.42u sec.
FATAL 2:  ZeroFill(/var/pgsql/data/pg_xlog/xlogtemp.29764) failed: No such file or directory
Server process (pid 29764) exited with status 512 at Tue Aug 14 01:44:19 2001
Terminating any active server processes...
NOTICE:  Message from PostgreSQL backend:
    The Postmaster has informed me that some other backend    died abnormally and possibly corrupted shared memory.
    I have rolled back the current transaction and am    going to terminate your database system connection and exit.
    Please reconnect to the database system and repeat your query.
Server processes were terminated at Tue Aug 14 01:44:20 2001
Reinitializing shared memory and semaphores

Re: database corruption on VACUUM ANALYZE, now unable to initdb

From
Tom Lane
Date:
Corey Minter <cminter@themus.com> writes:
> I don't understand how I
> wouldn't be able to run initdb.

How much free disk space have you got?

            regards, tom lane