Greetings,
I'm getting errors as a result of making queries. The attached log from
the last two queries gives an idea as to what is happening.
I suspect I must have done something bad when I upgraded via cvsup.
Does this mean that I should do an initdb?
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-- Please refrain from using HTML or WORD attachments in e-mails to me
--
chris=# select * from pupil where number=127;
-[ RECORD 1 ]-+---
number| 127
first_name| Savannah
last_name | Palme
date_of_birth | 1991-10-17
mother_name | Lesley
mother_phone | 384-5151
father_name | Philip
father_phone | 338-1857
home_phone| 366-3588
doctor_name | Carl Denny
doctor_phone | 377-6014
class_number |
lessons | {0,0}
chris=# select first_name, last_name from pupil;
FATAL 2: XLogFlush: request is not satisfied
FATAL 2: XLogFlush: request is not satisfied
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Server process (pid 10700)
exited with status 512 at Fri Mar 16 15:38:49 2001
Terminating any active server processes...
Server processes were terminated at Fri Mar 16 15:38:49 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
Failed.
!# DEBUG: database system was interrupted at 2001-03-16 15:10:46 NZDT
DEBUG: CheckPoint record at (0, 108)
DEBUG: Redo record at (0, 108); Undo record at (0, 0); Shutdown FALSE
DEBUG: NextTransactionId: 117853; NextOid: 201268
DEBUG: database system was not properly shut down; automatic recovery in progress...
DEBUG: redo starts at (0, 172)
DEBUG: ReadRecord: record with zero len at (0, 376)
DEBUG: redo done at (0, 340)
FATAL 2: XLogFlush: request is not satisfied
./bin/postmaster: Startup proc 10797 exited with status 512 - abort
!#
!#
!# \q
15:39:44 postgres@berty:~ $ ./bin/pg_ctl -o -i start
postmaster successfully started
15:40:18 postgres@berty:~ $ DEBUG: database system shutdown was interrupted at
2001-03-16 15:38:49 NZDT
DEBUG: CheckPoint record at (0, 108)
DEBUG: Redo record at (0, 108); Undo record at (0, 0); Shutdown FALSE
DEBUG: NextTransactionId: 117853; NextOid: 201268
DEBUG: database system was not properly shut down; automatic recovery in progress...
DEBUG: redo starts at (0, 172)
DEBUG: ReadRecord: record with zero len at (0, 376)
DEBUG: redo done at (0, 340)
FATAL 2: XLogFlush: request is not satisfied
./bin/postmaster: Startup proc 10808 exited with status 512 - abort
15:40:20 postgres@berty:~ $
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html