Postgres Pro
Downloads
Home   >   mailing lists

Thread: shared memory

shared memory

From
"Muhyiddin A.M Hayat"
Date:
What can I do to fix below errors?
 
IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not enough core
 
This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 1499136 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).
 
The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.

Re: shared memory

From
Jason Tishler
Date:
On Wed, Nov 05, 2003 at 02:22:31AM +0800, Muhyiddin A.M Hayat wrote:
> What can I do to fix below errors?
>
> IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not
> enough core

Does the following from the README help?

    2. It is recommended to delete all cygipc temporary files
    (/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under
    a different user account.  Otherwise, postmaster will fail to start
    due to IPC errors.  Note cygipc 2.x automatically removes these
    files during normal shutdown so this issue has been essentially
    obviated.

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

Re: shared memory

From
"Muhyiddin A.M Hayat"
Date:
> Does the following from the README help?
>
>     2. It is recommended to delete all cygipc temporary files
>     (/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under
>     a different user account.  Otherwise, postmaster will fail to start
>     due to IPC errors.  Note cygipc 2.x automatically removes these
>     files during normal shutdown so this issue has been essentially
>     obviated.
>

I have delete that files, so i found other error

$ FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: No space left on
device

[1]+  Exit 1                  postmaster -D /usr/share/postgresql/data

Re: shared memory

From
Jason Tishler
Date:
On Thu, Nov 06, 2003 at 01:57:09AM +0800, Muhyiddin A.M Hayat wrote:
> I have delete that files, so i found other error
>
> $ FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: No space left on
> device

What does the following indicate?

    $ ls -ld /tmp

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

Re: shared memory

From
"Muhyiddin A.M Hayat"
Date:

> > I have delete that files, so i found other error
> >
> > $ FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: No space left
on
> > device
>
> What does the following indicate?
>
>     $ ls -ld /tmp
>

$ ls -ld /tmp
drwxrwxrwx+   3 Administ Users        4096 Nov  7 01:36 /tmp

Re: shared memory

From
Jason Tishler
Date:
On Fri, Nov 07, 2003 at 01:38:11AM +0800, Muhyiddin A.M Hayat wrote:
>
>
> > > I have delete that files, so i found other error
> > >
> > > $ FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: No space
> > > left on device
> >
> > What does the following indicate?
> >
> >     $ ls -ld /tmp
> >
>
> $ ls -ld /tmp
> drwxrwxrwx+   3 Administ Users        4096 Nov  7 01:36 /tmp

Unless you are truly out of disk space, I have no idea.  Let me know
when you figure it out.

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

Re: shared memory

From
"Muhyiddin A.M Hayat"
Date:
> >
> > > > I have delete that files, so i found other error
> > > >
> > > > $ FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: No space
> > > > left on device
> > >
> > > What does the following indicate?
> > >
> > >     $ ls -ld /tmp
> > >
> >
> > $ ls -ld /tmp
> > drwxrwxrwx+   3 Administ Users        4096 Nov  7 01:36 /tmp
>
> Unless you are truly out of disk space, I have no idea.  Let me know
> when you figure it out.
>

i have more than 30 gb free space

Re: shared memory

From
Jason Tishler
Date:
On Sat, Nov 08, 2003 at 08:45:13PM +0800, Muhyiddin A.M Hayat wrote:
> > Unless you are truly out of disk space, I have no idea.  Let me know
> > when you figure it out.
>
> i have more than 30 gb free space

Of course, which is why I said "truly out of disk space" above.

My WAG is you are having a permissions or some other problem that is
manifesting itself as a ENOSPC.  Another WAG, what is your filesystem?

Sorry, but I have never heard of this problem before, so you are on your
own.

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

Re: shared memory

From
"Muhyiddin A.M Hayat"
Date:
> My WAG is you are having a permissions or some other problem that is
> manifesting itself as a ENOSPC.  Another WAG, what is your filesystem?

NTFS

Re: shared memory

From
Jason Tishler
Date:
On Tue, Nov 11, 2003 at 01:27:02AM +0800, Muhyiddin A.M Hayat wrote:
> > My WAG is you are having a permissions or some other problem that is
> > manifesting itself as a ENOSPC.  Another WAG, what is your filesystem?
>
> NTFS

Sorry, I'm out of ideas.  Let the list know when you figure it out.

Thanks,
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

Re: shared memory

From
Frank Seesink
Date:
Muhyiddin A.M Hayat wrote:

>>>I have delete that files, so i found other error
>>>
>>>$ FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: No space left on
>>>device
>>
>>What does the following indicate?
>>
>>    $ ls -ld /tmp
>
> $ ls -ld /tmp
> drwxrwxrwx+   3 Administ Users        4096 Nov  7 01:36 /tmp

Ok, what does the following indicate?

    $ ls -al /tmp