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 |