Yikes
| От | Chad Thompson |
|---|---|
| Тема | Yikes |
| Дата | |
| Msg-id | 119e01c2a069$cf4a2bb0$32021aac@chad обсуждение исходный текст |
| Ответы |
Re: Yikes
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| Список | pgsql-novice |
It seems that my postgres server was rebooted in the middle of a vacuum full.
I am able to start and stop the server successfully, but when i connect to it w/ pgadmin, postgres restarts. Here are the logs
--successfully shut down postgres
--started it back up w/ "su postgres -c 'pg_ctl start -o -i -D /var/lib/pgsql/data'"
postmaster successfully started
[root@sqlsvr root]# DEBUG: database system was shut down at 2002-12-10 09:25:32 MST
DEBUG: checkpoint record is at 20/2ABC0884
DEBUG: redo record is at 20/2ABC0884; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 7457784; next oid: 846358289
DEBUG: database system is ready
[root@sqlsvr root]# DEBUG: database system was shut down at 2002-12-10 09:25:32 MST
DEBUG: checkpoint record is at 20/2ABC0884
DEBUG: redo record is at 20/2ABC0884; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 7457784; next oid: 846358289
DEBUG: database system is ready
--go to pgadmin and connect. All the databases have red X's through them. Drilled down the tables and brought up contents of a table .. then
[root@sqlsvr root]# DEBUG: server process (pid 22187) was terminated by signal 11
DEBUG: terminating any other 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.
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2002-12-10 09:25:47 MST
DEBUG: checkpoint record is at 20/2ABC0884
DEBUG: redo record is at 20/2ABC0884; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 7457784; next oid: 846358289
DEBUG: database system was not properly shut down; automatic recovery in progress
FATAL 1: The database system is starting up
DEBUG: ReadRecord: record with zero length at 20/2ABC08C4
DEBUG: redo is not required
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
DEBUG: database system is ready
DEBUG: server process (pid 22196) was terminated by signal 11
DEBUG: terminating any other 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.
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.
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2002-12-10 09:26:07 MST
DEBUG: checkpoint record is at 20/2ABC08C4
DEBUG: redo record is at 20/2ABC08C4; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 7457784; next oid: 846358289
DEBUG: database system was not properly shut down; automatic recovery in progress
FATAL 1: The database system is starting up
DEBUG: ReadRecord: record with zero length at 20/2ABC0904
DEBUG: redo is not required
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
DEBUG: database system is ready
DEBUG: terminating any other 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.
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2002-12-10 09:25:47 MST
DEBUG: checkpoint record is at 20/2ABC0884
DEBUG: redo record is at 20/2ABC0884; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 7457784; next oid: 846358289
DEBUG: database system was not properly shut down; automatic recovery in progress
FATAL 1: The database system is starting up
DEBUG: ReadRecord: record with zero length at 20/2ABC08C4
DEBUG: redo is not required
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
DEBUG: database system is ready
DEBUG: server process (pid 22196) was terminated by signal 11
DEBUG: terminating any other 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.
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.
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2002-12-10 09:26:07 MST
DEBUG: checkpoint record is at 20/2ABC08C4
DEBUG: redo record is at 20/2ABC08C4; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 7457784; next oid: 846358289
DEBUG: database system was not properly shut down; automatic recovery in progress
FATAL 1: The database system is starting up
DEBUG: ReadRecord: record with zero length at 20/2ABC0904
DEBUG: redo is not required
FATAL 1: The database system is starting up
FATAL 1: The database system is starting up
DEBUG: database system is ready
Please help.. dont know where to go from here.
Thanks
Chad
В списке pgsql-novice по дате отправления:
Предыдущее
От: "Graham Bartlett"Дата:
Сообщение: How many connections can a Postgress database support...