Thread: 8.3 beta 4 crash on windows 2003 64-bit
Hi, I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to restore a database into it (about 30GB,5schemas and about 2000 tables) but whenever I try to open the tables in pgadmin3, the database crashes (i've tried with both the default postgresql.conf file and with some more tuned ones (based on 8.2.5 running on the same box before holding the same db): 2007-12-03 16:38:01 GMT LOG: database system is ready to accept connections 2007-12-03 16:38:01 GMT LOG: autovacuum launcher startedThis application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. 2007-12-03 16:38:22 GMT LOG: server process (PID 3716) exited with exit code 3 2007-12-03 16:38:22 GMT LOG: terminating any other active server processes 2007-12-03 16:38:22 GMT WARNING: terminating connection because of crash of another server process 2007-12-03 16:38:22 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2007-12-03 16:38:22 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command. 2007-12-03 16:38:22 GMT LOG: all server processes terminated; reinitializing 2007-12-03 16:38:23 GMT FATAL: pre-existing shared memory block is still in use 2007-12-03 16:38:23 GMT HINT: Check if there are any old server processes still running, and terminate them. ~ filip
Filip Wuytack wrote: > Hi, > > I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to > restore a database into it (about 30GB,5schemas and about 2000 tables) > but whenever I try to open the tables in pgadmin3, the database crashes > (i've tried with both the default postgresql.conf file and with some > more tuned ones (based on 8.2.5 running on the same box before holding > the same db): > > > Where did you get the binary from? How was it built? cheers andrew
From the postgresql ftp server. I initially wanted to download beta3, but spotted beta4 so I gave that a go ftp.postgresql.org /pub/binary/v8.3beta4/win32/ ~ Filip -----Original Message----- From: Andrew Dunstan [mailto:andrew@dunslane.net] Sent: 03 December 2007 17:09 To: Filip Wuytack Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] 8.3 beta 4 crash on windows 2003 64-bit Filip Wuytack wrote: > Hi, > > I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to > restore a database into it (about 30GB,5schemas and about 2000 tables) > but whenever I try to open the tables in pgadmin3, the database > crashes (i've tried with both the default postgresql.conf file and > with some more tuned ones (based on 8.2.5 running on the same box > before holding the same db): > > > Where did you get the binary from? How was it built? cheers andrew
Andrew, As to how it was built: I was under the impression that the 8.3 release is build using MSVSC? I was keen to give it a try to see if this version would work more optimally on windows as the pg instance (8.2.5) I run normally suffers from serious high pages/sec (by looking at perfmon on windows) slowing the whole thing down (it's connected to a SAN on a 4Gb card and holds > 80 disks...so file I/O should not be the bottleneck). Now a quick restore back to 8.2.5... ~ Filip -----Original Message----- From: Filip Wuytack Sent: 03 December 2007 17:12 To: 'Andrew Dunstan' Cc: 'pgsql-hackers@postgresql.org' Subject: RE: [HACKERS] 8.3 beta 4 crash on windows 2003 64-bit From the postgresql ftp server. I initially wanted to download beta3, but spotted beta4 so I gave that a go ftp.postgresql.org /pub/binary/v8.3beta4/win32/ ~ Filip -----Original Message----- From: Andrew Dunstan [mailto:andrew@dunslane.net] Sent: 03 December 2007 17:09 To: Filip Wuytack Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] 8.3 beta 4 crash on windows 2003 64-bit Filip Wuytack wrote: > Hi, > > I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to > restore a database into it (about 30GB,5schemas and about 2000 tables) > but whenever I try to open the tables in pgadmin3, the database > crashes (i've tried with both the default postgresql.conf file and > with some more tuned ones (based on 8.2.5 running on the same box > before holding the same db): > > > Where did you get the binary from? How was it built? cheers andrew