Postmaster cannot start - Mailing list pgsql-general
| From | Chun Yit\(Chronos\) |
|---|---|
| Subject | Postmaster cannot start |
| Date | |
| Msg-id | 001701c6780f$d9410f40$a279640a@Beh Whole thread Raw |
| List | pgsql-general |
Hi,
my postgresql version 7.4.5 cannot start until this morning, when i check the log file, it give me this error
this is part of my log file
DEBUG: vacuuming "pg_catalog.pg_class"
DEBUG: "pg_class": found 9823 removable, 1017 nonremovable row versions in 205 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 148 to 196 bytes long.
There were 20 unused item pointers.
Total free space (including removable row versions) is 1477460 bytes.
183 pages are or will become empty, including 183 at the end of the table.
9 pages containing 19260 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: index "pg_class_oid_index" now contains 1017 row versions in 35 pages
DETAIL: 9823 index row versions were removed.
28 index pages have been deleted, 28 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
DEBUG: index "pg_class_relname_nsp_index" now contains 726 row versions in 197 pages
DETAIL: 6124 index row versions were removed.
126 index pages have been deleted, 126 are currently reusable.
CPU 0.00s/0.03u sec elapsed 0.18 sec.
WARNING: index "pg_class_relname_nsp_index" contains 726 row versions, but table contains 1017 row versions
HINT: Rebuild the index with REINDEX.
DEBUG: "pg_class": moved 57 row versions, truncated 205 to 20 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.34 sec.
DEBUG: index "pg_class_oid_index" now contains 1017 row versions in 35 pages
DETAIL: 57 index row versions were removed.
28 index pages have been deleted, 28 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
ERROR: could not open segment 1 of relation "pg_class_relname_nsp_index" (target block 1183847760): No such file or directory
DEBUG: AbortCurrentTransaction
PANIC: cannot abort transaction 14135438, it was already committed
DEBUG: child process (PID 4834) was terminated by signal 6
LOG: server process (PID 4834) was terminated by signal 6
LOG: terminating any other active server processes
DEBUG: sending SIGQUIT to process 3337
DEBUG: sending SIGQUIT to process 3336
DEBUG: sending SIGQUIT to process 3335
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
DEBUG: "pg_class": found 9823 removable, 1017 nonremovable row versions in 205 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 148 to 196 bytes long.
There were 20 unused item pointers.
Total free space (including removable row versions) is 1477460 bytes.
183 pages are or will become empty, including 183 at the end of the table.
9 pages containing 19260 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: index "pg_class_oid_index" now contains 1017 row versions in 35 pages
DETAIL: 9823 index row versions were removed.
28 index pages have been deleted, 28 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
DEBUG: index "pg_class_relname_nsp_index" now contains 726 row versions in 197 pages
DETAIL: 6124 index row versions were removed.
126 index pages have been deleted, 126 are currently reusable.
CPU 0.00s/0.03u sec elapsed 0.18 sec.
WARNING: index "pg_class_relname_nsp_index" contains 726 row versions, but table contains 1017 row versions
HINT: Rebuild the index with REINDEX.
DEBUG: "pg_class": moved 57 row versions, truncated 205 to 20 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.34 sec.
DEBUG: index "pg_class_oid_index" now contains 1017 row versions in 35 pages
DETAIL: 57 index row versions were removed.
28 index pages have been deleted, 28 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
ERROR: could not open segment 1 of relation "pg_class_relname_nsp_index" (target block 1183847760): No such file or directory
DEBUG: AbortCurrentTransaction
PANIC: cannot abort transaction 14135438, it was already committed
DEBUG: child process (PID 4834) was terminated by signal 6
LOG: server process (PID 4834) was terminated by signal 6
LOG: terminating any other active server processes
DEBUG: sending SIGQUIT to process 3337
DEBUG: sending SIGQUIT to process 3336
DEBUG: sending SIGQUIT to process 3335
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
Can someone please explain to me what happen to my database, cause i not so clear,
i have a daily maintenance routine that always trigger at 4am morning.
1) will run end of day job. (every day)
2) will run vacuum full database. (every day)
3) will run analyze database. (every day)
4) will run reindex database. (every day)
saw from the log file, it's possible that server crash during vacuum process...
Question :
1) what happen to my database server? what the error meaning?
2) it is my daily maintenance routine causing that?
3) it is ok to run vacuum full every day ?
4) how can i solve this problem?
Thanks
Regards
Beh
pgsql-general by date: