Postgres Pro
Downloads
Home   >   mailing lists

beta2: process crash: server process (PID 4872) exited with exit code -1073741819 - Mailing list pgsql-bugs

From Thomas H.
Subject beta2: process crash: server process (PID 4872) exited with exit code -1073741819
Date
Msg-id 071e01c6fc83$c0f5fe20$0201a8c0@iwing
Whole thread Raw
List pgsql-bugs
Tree view 
unfortunately, my problems with 8.2 on win32 become more and more severe. w=
hen i wanted to test magnus compiled patch for the xlog transaction rename =
lockup, i run into more problems (with the original beta2 files):

it seems that processes regurarly crash after a number of transactions, whe=
re that number is strongly related to the amount of data updated. for examp=
le i have one table that consists of 8 integers, 3 bools, 2 timestamps, 1 v=
archar(150) for columns, has 1 foreign key and contains roughly 6600 rows. =
the table is vacuumed, analyzed, reindexed. when updating any of the intege=
r fields, the backend process crashes after 320 to 450 updates, no matter i=
t the updates are in 1 transaction for all or 1 update per transaction).

there are no log entries (beside the ones from the startup sequence) prior =
to the process error...=20

i first logged the problem as tsearch2 problem (http://archives.postgresql.=
org/pgsql-bugs/2006-10/msg00123.php). but it seems it is a more general pro=
blem.

if anyone wants (db-)access for debuging or checking stuff, please let me k=
now.=20

best regards,
thomas



2006-10-31 01:04:29 [3304] LOG:  00000: database system was interrupted at =
2006-10-31 01:04:27 W. Europe Standard Time
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4660
2006-10-31 01:04:29 [3304] LOG:  00000: Windows fopen("recovery.conf","r") =
failed: code 2, errno 2
2006-10-31 01:04:29 [3304] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:04:29 [3304] LOG:  00000: Windows fopen("pg_xlog/00000001.his=
tory","r") failed: code 2, errno 2
2006-10-31 01:04:29 [3304] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:04:29 [3304] LOG:  00000: Windows fopen("backup_label","r") f=
ailed: code 2, errno 2
2006-10-31 01:04:29 [3304] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:04:29 [3304] LOG:  00000: checkpoint record is at C/84D20810
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4730
2006-10-31 01:04:29 [3304] LOG:  00000: redo record is at C/84D20810; undo =
record is at 0/0; shutdown TRUE
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4757
2006-10-31 01:04:29 [3304] LOG:  00000: next transaction ID: 0/16121161; ne=
xt OID: 6660908
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4761
2006-10-31 01:04:29 [3304] LOG:  00000: next MultiXactId: 1; next MultiXact=
Offset: 0
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4764
2006-10-31 01:04:29 [3304] LOG:  00000: database system was not properly sh=
ut down; automatic recovery in progress
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4831
2006-10-31 01:04:29 [3304] LOG:  00000: redo starts at C/84D20860
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4893
2006-10-31 01:04:29 [3304] LOG:  00000: record with zero length at C/85164D=
68
2006-10-31 01:04:29 [3304] LOCATION:  ReadRecord, xlog.c:2997
2006-10-31 01:04:29 [3304] LOG:  00000: redo done at C/85164D38
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:4963
2006-10-31 01:04:29 [3304] LOG:  00000: database system is ready
2006-10-31 01:04:29 [3304] LOCATION:  StartupXLOG, xlog.c:5156
2006-10-31 01:04:29 [3304] LOG:  00000: Windows fopen("global/pg_fsm.cache"=
,"rb") failed: code 2, errno 2
2006-10-31 01:04:29 [3304] LOCATION:  AllocateFile, fd.c:1289

2006-10-31 01:04:54 [3272] LOG:  00000: server process (PID 4872) exited wi=
th exit code -1073741819
2006-10-31 01:04:54 [3272] LOCATION:  LogChildExit, postmaster.c:2385

2006-10-31 01:04:54 [3272] LOG:  00000: terminating any other active server=
 processes
2006-10-31 01:04:54 [3272] LOCATION:  HandleChildCrash, postmaster.c:2277
2006-10-31 01:04:54 [3272] LOG:  00000: all server processes terminated; re=
initializing
2006-10-31 01:04:54 [3272] LOCATION:  reaper, postmaster.c:2179
2006-10-31 01:04:54 [580] LOG:  00000: database system was interrupted at 2=
006-10-31 01:04:29 W. Europe Standard Time
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4660
2006-10-31 01:04:54 [580] LOG:  00000: Windows fopen("recovery.conf","r") f=
ailed: code 2, errno 2
2006-10-31 01:04:54 [580] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:04:54 [580] LOG:  00000: Windows fopen("pg_xlog/00000001.hist=
ory","r") failed: code 2, errno 2
2006-10-31 01:04:54 [580] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:04:54 [580] LOG:  00000: Windows fopen("backup_label","r") fa=
iled: code 2, errno 2
2006-10-31 01:04:54 [580] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:04:54 [580] LOG:  00000: checkpoint record is at C/85164D68
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4730
2006-10-31 01:04:54 [580] LOG:  00000: redo record is at C/85164D68; undo r=
ecord is at 0/0; shutdown TRUE
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4757
2006-10-31 01:04:54 [580] LOG:  00000: next transaction ID: 0/16122460; nex=
t OID: 6669100
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4761
2006-10-31 01:04:54 [580] LOG:  00000: next MultiXactId: 1; next MultiXactO=
ffset: 0
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4764
2006-10-31 01:04:54 [580] LOG:  00000: database system was not properly shu=
t down; automatic recovery in progress
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4831
2006-10-31 01:04:54 [580] LOG:  00000: redo starts at C/85164DB8
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4893
2006-10-31 01:04:54 [580] LOG:  00000: record with zero length at C/8592C648
2006-10-31 01:04:54 [580] LOCATION:  ReadRecord, xlog.c:2997
2006-10-31 01:04:54 [580] LOG:  00000: redo done at C/8592C618
2006-10-31 01:04:54 [580] LOCATION:  StartupXLOG, xlog.c:4963
2006-10-31 01:04:55 [580] LOG:  00000: database system is ready
2006-10-31 01:04:55 [580] LOCATION:  StartupXLOG, xlog.c:5156
2006-10-31 01:04:55 [580] LOG:  00000: Windows fopen("global/pg_fsm.cache",=
"rb") failed: code 2, errno 2
2006-10-31 01:04:55 [580] LOCATION:  AllocateFile, fd.c:1289
2006-10-31 01:05:02 [1112] LOG:  00000: Windows fopen("global/pgstat.stat",=
"rb") failed: code 2, errno 2
2006-10-31 01:05:02 [1112] LOCATION:  AllocateFile, fd.c:1289

pgsql-bugs by date:

Previous
From: Rusty Conover
Date:
Subject: Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Next
From: "Thomas H."
Date:
Subject: Re: xlog lockup patch (was: BUG #2712: could not fsync segment: Permission)