Postgres Pro
Downloads
Home   >   mailing lists

Thread: [7.1b6 on win2k] server crashes with mmap error

[7.1b6 on win2k] server crashes with mmap error

From
Frank Wegmann
Date:
Hi all,

tried to install v 7.1 beta6 on a system with following setup:

- Windows 2000 SP1 (384MB RAM is enough even for Windows)
- Cygwin 1.1.8, gcc-2.95.2-6
- cygipc 1.0.9 (took binary, installed it as a service)

I compiled and installed PostgreSQL as a user with administrator
privileges. I also installed a new user postgres, (both Win and
cygwin), and failed when trying to initialize db as postgres:

$ initdb -D /usr/pgsql/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Fixing permissions on existing directory /usr/pgsql/data
Creating directory /usr/pgsql/data/base
Creating directory /usr/pgsql/data/global
Creating directory /usr/pgsql/data/pg_xlog
Creating template1 database in /usr/pgsql/data/base/1
DEBUG:  database system was shut down at 2001-03-24 13:35:40
DEBUG:  CheckPoint record at (0, 8)
DEBUG:  Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 16384
DEBUG:  database system is in production state
Creating global relations in /usr/pgsql/data/global
DEBUG:  database system was shut down at 2001-03-24 13:35:45
DEBUG:  CheckPoint record at (0, 112)
DEBUG:  Redo record at (0, 112); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 17199
DEBUG:  database system is in production state
Initializing pg_shadow.
Enabling unlimited row width for system tables.
Creating system views.
Loading pg_description.
Setting lastsysoid.
Vacuuming database.
Copying template1 to template0.

Success. You can now start the database server using:

    /usr/pgsql/bin/postmaster -D /usr/pgsql/data
or
    /usr/pgsql/bin/pg_ctl -D /usr/pgsql/data -l logfile start



Well, that's what pgsql said. Tried running it in the background or
foreground to no avail:



postgres@ABSOLUT /usr/pgsql/data
$ nohup /usr/pgsql/bin/postmaster -D /usr/pgsql/data < /dev/null
>>server.log 2
>&1 < /dev/null &
[1] 1048

postgres@ABSOLUT /usr/pgsql/data
$ D:\cygwin\usr\pgsql\bin\postgres.exe: *** recreate_mmaps_after_fork_failed

[1]+  Exit 1                  nohup /usr/pgsql/bin/postmaster -D
/usr/pgsql/data
 </dev/null >>server.log 2>&1 </dev/null

postgres@ABSOLUT /usr/pgsql/data
$ postmaster -D /usr/pgsql/data
D:\cygwin\usr\pgsql\bin\postgres.exe: *** recreate_mmaps_after_fork_failed
postmaster: Startup proc 1144 exited with status 256 - abort


Also tried it as the user who compiled and installed the stuff, but the same
error occurs. What's going wrong here?

And: how can I install a hopefully running postmaster as a service?

Thanks a lot,

Frank Wegmann

Re: [7.1b6 on win2k] server crashes with mmap error

From
"Tim Dunnington"
Date:
Frank,

Don't know if it will help, but on Unix anyway you do:

   postmaster -S

to run the database as a daemon process.  I've not tried running it using
nohup as you did, so I'm not sure if that's your problem or not.

Tim

PS -- if you plan to use ODBC to connect to the database, you'll
need "postmaster -S -i"...also check your pg_hba.conf file in your data
directory, make sure you open it up for use on your network.

Frank Wegmann <wegmann@acm.org> said:

>
> Hi all,
>
> tried to install v 7.1 beta6 on a system with following setup:
>
> - Windows 2000 SP1 (384MB RAM is enough even for Windows)
> - Cygwin 1.1.8, gcc-2.95.2-6
> - cygipc 1.0.9 (took binary, installed it as a service)
>
> I compiled and installed PostgreSQL as a user with administrator
> privileges. I also installed a new user postgres, (both Win and
> cygwin), and failed when trying to initialize db as postgres:
>
> $ initdb -D /usr/pgsql/data
> This database system will be initialized with username "postgres".
> This user will own all the data files and must also own the server process.
>
> Fixing permissions on existing directory /usr/pgsql/data
> Creating directory /usr/pgsql/data/base
> Creating directory /usr/pgsql/data/global
> Creating directory /usr/pgsql/data/pg_xlog
> Creating template1 database in /usr/pgsql/data/base/1
> DEBUG:  database system was shut down at 2001-03-24 13:35:40
> DEBUG:  CheckPoint record at (0, 8)
> DEBUG:  Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
> DEBUG:  NextTransactionId: 514; NextOid: 16384
> DEBUG:  database system is in production state
> Creating global relations in /usr/pgsql/data/global
> DEBUG:  database system was shut down at 2001-03-24 13:35:45
> DEBUG:  CheckPoint record at (0, 112)
> DEBUG:  Redo record at (0, 112); Undo record at (0, 0); Shutdown TRUE
> DEBUG:  NextTransactionId: 514; NextOid: 17199
> DEBUG:  database system is in production state
> Initializing pg_shadow.
> Enabling unlimited row width for system tables.
> Creating system views.
> Loading pg_description.
> Setting lastsysoid.
> Vacuuming database.
> Copying template1 to template0.
>
> Success. You can now start the database server using:
>
>     /usr/pgsql/bin/postmaster -D /usr/pgsql/data
> or
>     /usr/pgsql/bin/pg_ctl -D /usr/pgsql/data -l logfile start
>
>
>
> Well, that's what pgsql said. Tried running it in the background or
> foreground to no avail:
>
>
>
> postgres@ABSOLUT /usr/pgsql/data
> $ nohup /usr/pgsql/bin/postmaster -D /usr/pgsql/data < /dev/null
> >>server.log 2
> >&1 < /dev/null &
> [1] 1048
>
> postgres@ABSOLUT /usr/pgsql/data
> $ D:cygwinusrpgsqlbinpostgres.exe: *** recreate_mmaps_after_fork_failed
>
> [1]+  Exit 1                  nohup /usr/pgsql/bin/postmaster -D
> /usr/pgsql/data
>  </dev/null >>server.log 2>&1 </dev/null
>
> postgres@ABSOLUT /usr/pgsql/data
> $ postmaster -D /usr/pgsql/data
> D:cygwinusrpgsqlbinpostgres.exe: *** recreate_mmaps_after_fork_failed
> postmaster: Startup proc 1144 exited with status 256 - abort
>
>
> Also tried it as the user who compiled and installed the stuff, but the same
> error occurs. What's going wrong here?
>
> And: how can I install a hopefully running postmaster as a service?
>
> Thanks a lot,
>
> Frank Wegmann
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>



--
Tim Dunnington
Sr. Integration Engineer
Healthcare.com

Re: [7.1b6 on win2k] server crashes with mmap error

From
Jason Tishler
Date:
Frank,

On Sat, Mar 24, 2001 at 03:28:08PM +0100, Frank Wegmann wrote:
> postgres@ABSOLUT /usr/pgsql/data
> $ D:\cygwin\usr\pgsql\bin\postgres.exe: *** recreate_mmaps_after_fork_failed
>
> Also tried it as the user who compiled and installed the stuff, but the same
> error occurs. What's going wrong here?

This is a known problem, please see the following for more details:

    http://www.postgresql.org/mhonarc/pgsql-ports/2001-03/msg00096.html

> And: how can I install a hopefully running postmaster as a service?

One cannot run postmaster as a *real* NT service yet.  Occasional work is
being done in this area to rectify this deficiency -- search the archives
for more details.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com