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
