Re: pgsql-cygwin

Richard,

On Mon, Feb 17, 2003 at 04:02:03PM +0200, Richard Wooding wrote:
> We are experiencing the following error:
>
> ---> Start Log file
> DEBUG: recycled transaction log file 0000000400000015
> DEBUG: recycled transaction log file 0000000400000016
> DEBUG: recycled transaction log file 0000000400000017
> ERROR: cannot read block 0 of modem_pkey: Permission denied
> NOTICE: Error occurred while executing PL/pgSQL function ...
^^^^^^^^
********

See below...

> [snip]
> DEBUG: all server processes terminated; reinitializing shared memory and semaphores
> IpcMemoryCreate: shmget(key=5432001, size=2048000, 03600) failed: Not enough core
>
> [snip]
>
> Could this error be related to file permissions and / or NT security?

I don't think so -- I think that it is related to how Windows deals (or
not deals) with open files. See below...

> The reason I am asking is because the error only appears to occur when
> the NT server is on a domain, when it is off a domain the error does
> not occur.

Coincidence?

> Does NTSEC have a bearing on pgsql-cygwin,

Yes.

> should it be turned on/off when running cygwin?

IMO, ntsec should be on.

> Does NTEA have a bearing on pgsql-cygwin,

Only if your filesystem is FAT/FAT32.

> should it be turned on on/off when running cygwin?

IMO, you should never use FAT/FAT32. :,)

I believe that your problem is the same as what I stumbled across trying
to get PL/Tcl working:

http://archives.postgresql.org/pgsql-cygwin/2003-02/msg00003.php

AFAICT (using the Sysinternals handle utility), at least one backend
still has /tmp/cygipc_0 open which causes shmget() to fail with the
above error.

BTW, the plpgsql regression test works, so I (had) hoped that only
PL/Tcl was affected. I guess that I wrong. :,(

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6