Thread: Problems with PostgreSQL 6.5.2 on Irix 6.2

Problems with PostgreSQL 6.5.2 on Irix 6.2

From
Gerald Hanks
Date:
Problems with PostgreSQL 6.5.2 on Irix 6.2

I just finished compiling postgresql for the first time on mu Indy.  I
installed the system and then began to follow the instructions on
testing the backend.  I ran the initdb OK.  I then started the
postmaster.  When I ran the createdb this is what I got:

FATAL: s_lock(004000c0) at spin.c:125, stuck spinlock. Aborting.

FATAL: s_lock(004000c0) at spin.c:125, stuck spinlock. Aborting.
IpcMemoryCreate: shmget failed (Invalid argument) key=5432101,
size=1073152, permission=600
FATAL 1:  ShmemCreate: cannot create region
NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am going to
terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.

Can anyone tell me what this means?

-gerald


Re: [PORTS] Problems with PostgreSQL 6.5.2 on Irix 6.2

From
Bruce Momjian
Date:
Does the Irix faq on the web site say anything?

> Problems with PostgreSQL 6.5.2 on Irix 6.2
>
> I just finished compiling postgresql for the first time on mu Indy.  I
> installed the system and then began to follow the instructions on
> testing the backend.  I ran the initdb OK.  I then started the
> postmaster.  When I ran the createdb this is what I got:
>
> FATAL: s_lock(004000c0) at spin.c:125, stuck spinlock. Aborting.
>
> FATAL: s_lock(004000c0) at spin.c:125, stuck spinlock. Aborting.
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432101,
> size=1073152, permission=600
> FATAL 1:  ShmemCreate: cannot create region
> NOTICE:  Message from PostgreSQL backend:
>         The Postmaster has informed me that some other backend died
> abnormally and possibly corrupted shared memory.
>         I have rolled back the current transaction and am going to
> terminate your database system connection and exit.
>         Please reconnect to the database system and repeat your query.
>
> Can anyone tell me what this means?
>
> -gerald
>
>
> ************
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: [PORTS] Problems with PostgreSQL 6.5.2 on Irix 6.2

From
Gerald Hanks
Date:
I did not see anything in the FAQ's although I noticed as I browsed through
the different mailing lists that others have had the same problem on
different platforms.  I also noticed someone make the comment that they
needed to increase the shared memory space on their system or something like
that.  I am not sure how to do that on my system.  If anyone else out there
has a clue as to whats going on please let me know.

-gerald

Bruce Momjian wrote:

> Does the Irix faq on the web site say anything?
>
> > Problems with PostgreSQL 6.5.2 on Irix 6.2
> >
> > I just finished compiling postgresql for the first time on mu Indy.  I
> > installed the system and then began to follow the instructions on
> > testing the backend.  I ran the initdb OK.  I then started the
> > postmaster.  When I ran the createdb this is what I got:
> >
> > FATAL: s_lock(004000c0) at spin.c:125, stuck spinlock. Aborting.
> >
> > FATAL: s_lock(004000c0) at spin.c:125, stuck spinlock. Aborting.
> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432101,
> > size=1073152, permission=600
> > FATAL 1:  ShmemCreate: cannot create region
> > NOTICE:  Message from PostgreSQL backend:
> >         The Postmaster has informed me that some other backend died
> > abnormally and possibly corrupted shared memory.
> >         I have rolled back the current transaction and am going to
> > terminate your database system connection and exit.
> >         Please reconnect to the database system and repeat your query.
> >
> > Can anyone tell me what this means?
> >
> > -gerald
> >
> >
> > ************
> >
> >
>
> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026