Strange error, probably WAL-related 
Author Message
 Strange error, probably WAL-related

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...

--

APL Financial Services           http://www.***.com/
Nicosia, Cyprus                 phone: +357-2-755750

"It is more complicated than you think"
                -- The Eighth Networking Truth from RFC 1925

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 23 Nov 2003 23:13:46 GMT
 Strange error, probably WAL-related

Quote:

> FATAL 2:  ZeroFill(/data/postgres/pg_xlog/xlogtemp.1223) failed: No such
> file or directory

I think you ran out of disk space.  The error message is misleading :-(

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 24 Nov 2003 00:31:31 GMT
 Strange error, probably WAL-related

Quote:

> I think you ran out of disk space.  The error message is misleading :-(

That was true! Well, thanks...

--

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Mon, 24 Nov 2003 01:19:14 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Strange precision related math errors...

2. Strange performance related question

3. Strange performance related question

4. Strange crashes when I restrict access in related files

5. Strange WebForms error, strange Oracle answer - baffled!

6. error 1105, probably simple.

7. Strange Error Log Error

8. error 12541 - strange error on TNS: no listener

9. Strange Oracle error: ORA-06502 (and Microsoft run-time error -2147467259(80004005))

10. Strange Oracle error: ORA-06502 (and Microsoft run-time error -2147467259(80004005))

11. Strange Error Log Error

12. "Syntax Error in expression" strange error


 
Powered by phpBB® Forum Software