I have just installed Postgresql Beta 1 on a new Windows 7 64-bit system
(without a previously installed PostgreSQL).
When using pgAdmin III (included in the installer package) to create a
user (Login Role) postgresql crashes.
This does not occur when I also set an expiration date on that user.
OS: Windows 7 64-bit
PostgreSQL version: PostgreSQL 9.1beta1, compiled by Visual C++ build
Steps to reproduce:
- Download PostgreSQL via Download 9.1 Beta 1 installers
link) on the PostgreSQL website
- install PostgreSQL (not upgrade)
- start pgAdmin
- connect to the server
- right-click on Login Roles
- select New login role...
- fill in
- OK can now be clicked - click OK
You now see an error dialog (server closed the connection unexpectedly)
This is because the server has crashed.
Even though it's probably pgAdmin sending an illegal statement to the
server I think the major problem
here is that it causes the server to crash.
2011-05-05 21:07:33 CEST LOG: 00000: database system was shut down at
2011-05-05 21:06:15 CEST
2011-05-05 21:07:33 CEST LOCATION: StartupXLOG,
2011-05-05 21:07:33 CEST LOG: 00000: database system is ready to accept
2011-05-05 21:07:33 CEST LOCATION: reaper,
2011-05-05 21:07:33 CEST LOG: 00000: autovacuum launcher started
2011-05-05 21:07:33 CEST LOCATION: AutoVacLauncherMain,
2011-05-05 21:08:29 CEST LOG: 00000: server process (PID 2700) was
terminated by exception 0xC0000005
2011-05-05 21:08:29 CEST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2011-05-05 21:08:29 CEST LOCATION: LogChildExit,
2011-05-05 21:08:29 CEST LOG: 00000: terminating any other active
2011-05-05 21:08:29 CEST LOCATION: HandleChildCrash,
2011-05-05 21:08:29 CEST WARNING: 57P02: terminating connection because
of crash of another server process
2011-05-05 21:08:29 CEST 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
2011-05-05 21:08:29 CEST HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2011-05-05 21:08:29 CEST LOCATION: quickdie,
2011-05-05 21:08:29 CEST LOG: 00000: all server processes terminated;
2011-05-05 21:08:29 CEST LOCATION: PostmasterStateMachine,
2011-05-05 21:08:39 CEST FATAL: XX000: pre-existing shared memory block
is still in use
2011-05-05 21:08:39 CEST HINT: Check if there are any old server
processes still running, and terminate them.
2011-05-05 21:08:39 CEST LOCATION: PGSharedMemoryCreate,