Postgres Pro
Downloads
Home   >   mailing lists

process exited with status 11 after XLogFlush: request is not satisfied - Mailing list pgsql-general

From Bjoern Metzdorf
Subject process exited with status 11 after XLogFlush: request is not satisfied
Date
Msg-id 023b01c1a98a$2db80460$81c206d4@office.turtleentertainment.de
Whole thread Raw
Responses Re: process exited with status 11 after XLogFlush: request is not satisfied
List pgsql-general
Tree view 
Hello,

I'm running postgres 7.1.2 / 7.1.3 on Linux 2.2.17 (Debian Potato).

Tonight we were suffering from

FATAL 2:  XLogFlush: request is not satisfied

in the logfile and crashes afterwards:

Server process (pid 26888) exited with status 512 at Wed Jan 30 09:51:37
2002

This was with 7.1.2. As stated in the archives I ran pg_resetxlog on the
data directory (after backup).
After that, the "XLogFlush: request is not satisfied" vanished, but now we
are suffering from several "Server process (pid 5060) exited with status
11".

At first I suspected harddrive or memory problems, but the disks (ICP Vortex
Raid 5) seem to be fine, as well as the memory (I tested with memtester:
http://www.qcc.sk.ca/~charlesc/software/memtester/)

Then I upgraded to 7.1.3, but the problem persists, here are the exact
logfile entries with wal_debug and debug_level set to 2 after upgrade to
7.1.3:

---------------------------------snip---------------------------------------

INSERT @ 30/1818723404: prev 30/1818723368; xprev 30/0; xid 162572613:
Heap - insert: node 1057183/1256672; tid 16173/4
INSERT @ 30/1818725464: prev 30/1818723404; xprev 30/1818723404; xid
162572613: Btree - insert: node 1057183/1256684; tid 7812/421
INSERT @ 30/1818725524: prev 30/1818725464; xprev 30/1818725464; xid
162572613: Heap - insert: node 1057183/1256672; tid 16174/1
INSERT @ 30/1818727500: prev 30/1818725524; xprev 30/1818725524; xid
162572613: Btree - insert: node 1057183/1256684; tid 7812/421
INSERT @ 30/1818727560: prev 30/1818727500; xprev 30/1818727500; xid
162572613: Heap - insert: node 1057183/1256657; tid 435/55
INSERT @ 30/1818727692: prev 30/1818727560; xprev 30/1818727560; xid
162572613: Btree - insert: node 1057183/1256687; tid 3239/462
INSERT @ 30/1818727752: prev 30/1818727692; xprev 30/1818727692; xid
162572613: Btree - insert: node 1057183/1256690; tid 1/2
INSERT @ 30/1818727816: prev 30/1818727752; xprev 30/1818727752; xid
162572613: Btree - insert: node 1057183/1256693; tid 530/8
INSERT @ 30/1818727896: prev 30/1818727816; xprev 30/1818727816; xid
162572613: Btree - insert: node 1057183/1256696; tid 4034/382
2002-01-30 12:41:01 DEBUG:  CommitTransactionCommand
INSERT @ 30/1818727960: prev 30/1818727896; xprev 30/1818727896; xid
162572613: Transaction - commit: 2002-01-30 12:41:01
XLogFlush: rqst 30/1818727996; wrt 30/1818723404; flsh 30/1818723404
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 5060 exited with status 11
Server process (pid 5060) exited with status 11 at Wed Jan 30 12:41:01 2002
Terminating any active server processes...
postmaster: CleanupProc: sending SIGQUIT to process 5186

---------------------------------snip---------------------------------------

INSERT @ 30/1819347080: prev 30/1819347044; xprev 30/0; xid 162573078:
Heap - insert: node 1057183/1256672; tid 16184/3
INSERT @ 30/1819349140: prev 30/1819347080; xprev 30/1819347080; xid
162573078: Btree - insert: node 1057183/1256684; tid 7812/466
INSERT @ 30/1819349200: prev 30/1819349140; xprev 30/1819349140; xid
162573078: Heap - insert: node 1057183/1256672; tid 16184/4
INSERT @ 30/1819350832: prev 30/1819349200; xprev 30/1819349200; xid
162573078: Btree - insert: node 1057183/1256684; tid 7812/466
INSERT @ 30/1819350892: prev 30/1819350832; xprev 30/1819350832; xid
162573078: Heap - insert: node 1057183/1256657; tid 436/10
INSERT @ 30/1819351032: prev 30/1819350892; xprev 30/1819350892; xid
162573078: Btree - insert: node 1057183/1256687; tid 3239/482
INSERT @ 30/1819351092: prev 30/1819351032; xprev 30/1819351032; xid
162573078: Btree - insert: node 1057183/1256690; tid 1/2
INSERT @ 30/1819351156: prev 30/1819351092; xprev 30/1819351092; xid
162573078; bkpb 1: Btree - insert: node 1057183/1256693; tid 75
2/3
INSERT @ 30/1819359428: prev 30/1819351156; xprev 30/1819351156; xid
162573078: Btree - insert: node 1057183/1256696; tid 4034/402
2002-01-30 12:41:44 DEBUG:  CommitTransactionCommand
INSERT @ 30/1819359492: prev 30/1819359428; xprev 30/1819359428; xid
162573078: Transaction - commit: 2002-01-30 12:41:44
XLogFlush: rqst 30/1819359528; wrt 30/1819347080; flsh 30/1819347080
2002-01-30 12:41:45 DEBUG:  StartTransactionCommand
2002-01-30 12:41:45 DEBUG:  query: BEGIN;ROLLBACK;
2002-01-30 12:41:45 DEBUG:  ProcessUtility: BEGIN;ROLLBACK;
2002-01-30 12:41:45 DEBUG:  CommitTransactionCommand
2002-01-30 12:41:45 DEBUG:  StartTransactionCommand
2002-01-30 12:41:45 DEBUG:  ProcessUtility: BEGIN;ROLLBACK;
2002-01-30 12:41:45 DEBUG:  CommitTransactionCommand
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 5203 exited with status 11
Server process (pid 5203) exited with status 11 at Wed Jan 30 12:41:45 2002
Terminating any active server processes...
postmaster: CleanupProc: sending SIGQUIT to process 5211
postmaster: CleanupProc: sending SIGQUIT to process 5210

---------------------------------snip---------------------------------------

INSERT @ 30/1821302728: prev 30/1821302692; xprev 30/0; xid 162575289:
Heap - insert: node 1057183/1256672; tid 16222/1
INSERT @ 30/1821304800: prev 30/1821302728; xprev 30/1821302728; xid
162575289: Btree - insert: node 1057183/1256684; tid 7813/382
INSERT @ 30/1821304860: prev 30/1821304800; xprev 30/1821304800; xid
162575289: Heap - insert: node 1057183/1256672; tid 16222/2
INSERT @ 30/1821306724: prev 30/1821304860; xprev 30/1821304860; xid
162575289: Btree - insert: node 1057183/1256684; tid 7813/382
INSERT @ 30/1821306784: prev 30/1821306724; xprev 30/1821306724; xid
162575289: Heap - insert: node 1057183/1256657; tid 437/5
INSERT @ 30/1821306932: prev 30/1821306784; xprev 30/1821306784; xid
162575289: Btree - insert: node 1057183/1256687; tid 3240/305
INSERT @ 30/1821306992: prev 30/1821306932; xprev 30/1821306932; xid
162575289: Btree - insert: node 1057183/1256690; tid 1/2
INSERT @ 30/1821307056: prev 30/1821306992; xprev 30/1821306992; xid
162575289; bkpb 1: Btree - insert: node 1057183/1256693; tid 13
52/7
INSERT @ 30/1821315328: prev 30/1821307056; xprev 30/1821307056; xid
162575289: Btree - insert: node 1057183/1256696; tid 4035/273
2002-01-30 12:43:15 DEBUG:  CommitTransactionCommand
INSERT @ 30/1821315392: prev 30/1821315328; xprev 30/1821315328; xid
162575289: Transaction - commit: 2002-01-30 12:43:15
XLogFlush: rqst 30/1821315428; wrt 30/1821302728; flsh 30/1821302728
2002-01-30 12:43:16 DEBUG:  StartTransactionCommand
2002-01-30 12:43:16 DEBUG:  query: BEGIN;ROLLBACK;
2002-01-30 12:43:16 DEBUG:  ProcessUtility: BEGIN;ROLLBACK;
2002-01-30 12:43:16 DEBUG:  CommitTransactionCommand
2002-01-30 12:43:16 DEBUG:  StartTransactionCommand
2002-01-30 12:43:16 DEBUG:  ProcessUtility: BEGIN;ROLLBACK;
2002-01-30 12:43:16 DEBUG:  CommitTransactionCommand
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 5220 exited with status 11
Server process (pid 5220) exited with status 11 at Wed Jan 30 12:43:16 2002
Terminating any active server processes...
postmaster: CleanupProc: sending SIGQUIT to process 5279
postmaster: CleanupProc: sending SIGQUIT to process 5278

---------------------------------snip---------------------------------------

2002-01-30 12:45:06 DEBUG:  ProcessQuery
2002-01-30 12:45:06 DEBUG:  CommitTransactionCommand
XLogFlush: rqst 30/1821796188; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821776284; wrt 30/1824031200; flsh 30/1824031200
XLogFlush: rqst 30/1821809412; wrt 30/1823786416; flsh 30/1823786416
2002-01-30 12:45:06 DEBUG:  CommitTransactionCommand
XLogFlush: rqst 30/1821811520; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821822152; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821848796; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821861820; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821884244; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821896940; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821900460; wrt 30/1823786416; flsh 30/1823786416
XLogFlush: rqst 30/1821910400; wrt 30/1823786416; flsh 30/1823786416
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 5375 exited with status 11
Server process (pid 5375) exited with status 11 at Wed Jan 30 12:45:06 2002
Terminating any active server processes...
postmaster: CleanupProc: sending SIGQUIT to process 5398
postmaster: CleanupProc: sending SIGQUIT to process 5397

---------------------------------snip---------------------------------------

Is this due to a corrupted record? If yes, how can I safely delete that one?

Hope you can help me.

Thanks in advance.

greetings,

Bjoern

pgsql-general by date:

Previous
From: "Stefan Brozinski"
Date:
Subject: Solaris/Sparc: Regression test fails
Next
From: Francisco Reyes
Date:
Subject: Shortening time of vacuum analyze