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 started
This 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