From: | Alessio Bragadini <alessio(at)albourne(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | adriaan(at)albourne(dot)com |
Subject: | Strange error, probably WAL-related |
Date: | 2001-06-06 14:53:43 |
Message-ID: | 3B1E43F7.994369CD@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I've installed a fresh postgresql-7.1.2 on a Debian GNU/Linux, when
importing my first database from a dump I got this error:
ERROR: ExecAppend: Fail to add null value in not null attribute
fc_state
FATAL 2: ZeroFill(/data/postgres/pg_xlog/xlogtemp.1223) failed: No such
file or directory
Server process (pid 1223) exited with status 512 at Wed Jun 6 14:59:58
2001
Terminating any active server processes...
Server processes were terminated at Wed Jun 6 14:59:58 2001
Reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2001-06-06 14:58:56 BST
DEBUG: CheckPoint record at (0, 1522068)
DEBUG: Redo record at (0, 1522068); Undo record at (0, 0); Shutdown
TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system was not properly shut down; automatic recovery
in progress...
DEBUG: redo starts at (0, 1522132)
DEBUG: open(logfile 0 seg 3) failed: No such file or directory
DEBUG: redo done at (0, 50331512)
FATAL 2: ZeroFill(/data/postgres/pg_xlog/xlogtemp.1224) failed: No such
file or directory
/usr/local/pgsql/bin/postmaster: Startup proc 1224 exited with status
512 - abort
and now the database cannot be started again. I have no idea where to
start looking...
--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2001-06-06 15:00:11 | Re: REPLACE INTO table a la mySQL |
Previous Message | Tom Lane | 2001-06-06 14:52:58 | Re: vacuumdb -a -z hangs |