Forum OpenACS Q&A: Re: PostgreSQL data disappeared

Collapse
2: Re: PostgreSQL data disappeared (response to 1)
Posted by Jarkko Laine on 12/18/02 02:38 PM
Another odd thing is, that server.log file doesn't give too much information (at least to me): 
NOTICE:  identifier "acs_object_util__get_object_type" will be truncated to "acs_object_util\
__get_object_typ"
NOTICE:  identifier "acs_object_util__get_object_type" will be truncated to "acs_object_util\
__get_object_typ"
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
FATAL 1:  user "root" does not exist
Lock file "/usr/local/pgsql/data/postmaster.pid" already exists.
Is another postmaster (pid 1075) running in "/usr/local/pgsql/data"?
DEBUG:  smart shutdown request
DEBUG:  shutting down
DEBUG:  database system is shut down
Lock file "/tmp/.s.PGSQL.5432.lock" already exists.
Is another postmaster (pid 32391) using "/tmp/.s.PGSQL.5432"?
/usr/local/pgsql/bin/postmaster: cannot create UNIX stream port
DEBUG:  database system was shut down at 2002-09-16 16:30:24 EEST
DEBUG:  checkpoint record is at 0/13FA0A74
DEBUG:  redo record is at 0/13FA0A74; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 1071418; next oid: 216948
DEBUG:  database system is ready
FATAL 1:  Database "testo-dev" does not exist in the system catalog.
FATAL 1:  Database "dotlrn-test" does not exist in the system catalog.
ERROR:  Relation "users" does not exist
FATAL 1:  Database "dotlrn-test" does not exist in the system catalog.
Lock file "/usr/local/pgsql/data/postmaster.pid" already exists.
Is another postmaster (pid 1219) running in "/usr/local/pgsql/data"?
DEBUG:  smart shutdown request
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  shutting down
FATAL 1:  The database system is shutting down
FATAL 1:  The database system is shutting down
FATAL 1:  The database system is shutting down
DEBUG:  database system is shut down
DEBUG:  database system was shut down at 2002-12-18 13:57:42 EET
DEBUG:  checkpoint record is at 0/13FA6C98
DEBUG:  redo record is at 0/13FA6C98; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 1071434; next oid: 216949
DEBUG:  database system is ready
DEBUG:  fast shutdown request
DEBUG:  shutting down
DEBUG:  database system is shut down
DEBUG:  database system was shut down at 2002-12-18 14:05:05 EET
DEBUG:  checkpoint record is at 0/13FA6CD8
DEBUG:  redo record is at 0/13FA6CD8; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 1071437; next oid: 216949
DEBUG:  database system is ready
FATAL 1:  Database "nsadmin" does not exist in the system catalog.dstem is shutting down
FATAL 1:  The database system is shutting down
FATAL 1:  The database system is shutting down
DEBUG:  database system is shut down
DEBUG:  database system was shut down at 2002-12-18 13:57:42 EET