beta2: process crash: server process (PID 4872) exited with exit code -1073741819

From: "Thomas H(dot)" <me(at)alternize(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: beta2: process crash: server process (PID 4872) exited with exit code -1073741819
Date: 2006-10-31 00:30:22
Message-ID: 071e01c6fc83$c0f5fe20$0201a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

unfortunately, my problems with 8.2 on win32 become more and more severe. when 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, where that number is strongly related to the amount of data updated. for example i have one table that consists of 8 integers, 3 bools, 2 timestamps, 1 varchar(150) for columns, has 1 foreign key and contains roughly 6600 rows. the table is vacuumed, analyzed, reindexed. when updating any of the integer fields, the backend process crashes after 320 to 450 updates, no matter it 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...

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

if anyone wants (db-)access for debuging or checking stuff, please let me know.

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.history","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") 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: 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; next 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 MultiXactOffset: 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 shut 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/85164D68
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 with 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; reinitializing
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 2006-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") 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("pg_xlog/00000001.history","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") 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: 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 record 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; next 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 MultiXactOffset: 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 shut 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas H. 2006-10-31 06:23:37 Re: xlog lockup patch (was: BUG #2712: could not fsync segment: Permission)
Previous Message Rusty Conover 2006-10-30 17:48:41 Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"