Re: Fw: Spin lock error - Mailing list pgsql-general

I seem to still be missing what version of PostgreSQL you are running...:(

On Wed, 15 Dec 1999, Differentiated Software Solutions Pvt. Ltd. wrote:

> Hi,
>
> Thanks for responding.
> This is a copy of my message which has all details which I could think of to
> start with.
> I would be glad to receive any suggesstions.
>
> Bye,
>
> Murali
> -----Original Message-----
> From: Differentiated Software Solutions Pvt. Ltd. +ADw-diffs+AEA-vsnl.com+AD4-
> To: pgsql-general+AEA-postgresql.org +ADw-pgsql-general+AEA-postgresql.org+AD4AOw-
> vadim+AEA-krs.ru +ADw-vadim+AEA-krs.ru+AD4AOw- pgsql-interfaces+AEA-postgresql.org
> +ADw-pgsql-interfaces+AEA-postgresql.org+AD4-
> Cc: Kimi +ADw-kimi+AEA-intercept.co.in+AD4-
> Date: 11 December 1999 12:33
> Subject: Spin lock error
>
>
> +AD4-Hi,
> +AD4-
> +AD4-We are getting spinlock errors under the following conditions
> +AD4-
> +AD4-Background :
> +AD4-We have developed a high performance application using postgres database
>  a
> +AD4-3rd party application server).
> +AD4-This application should be scalanble to server 50 requests a second.
> +AD4-Application is written in perl 5.005 using DBI-1.12, DBD-Pg 0.92 and Redhat
> +AD4-linux 6.0
> +AD4-A request consists of one singleton select on a table of 200,000 rows on
> +AD4-it's primary key, a heavy duty cursor which is a 4 table join but which
> +AD4-returns 100 rows from tables containing maximum of 250 rows, a light sql
> +AD4-opening a cursor on a table containing 500 rows, 2 inserts into tables
> which
> +AD4-don't have primary key.
> +AD4-
> +AD4-We are connecting to the database with autoconnect off.
> +AD4-
> +AD4-Problem description :
> +AD4-On a light load there are no problems. As we have increased the load on the
> +AD4-application, the requests get piled up. We keep monitoring the requests
> +AD4-getting piled up using ps ax +AHw- grep post.
> +AD4-Somewhere when the requests crosses 20(ps returns more than 20 rows)....
> +AD4-suddenly postmaster comes down +ACEAIQ- In the server log the following message
> is
> +AD4-written out.
> +AD4-FATAL: s+AF8-lock(4000b011) at spin.c:125, stuck spinlock. Aborting.
> +AD4-
> +AD4-FATAL: s+AF8-lock(4000b011) at spin.c:125, stuck spinlock. Aborting.
> +AD4-
> +AD4-FATAL: s+AF8-lock(4000b011) at spin.c:125, stuck spinlock. Aborting.
> +AD4-
> +AD4-FATAL: s+AF8-lock(4000b011) at spin.c:125, stuck spinlock. Aborting.
> +AD4-
> +AD4-FATAL: s+AF8-lock(40179f44) at bufmgr.c:490, stuck spinlock. Aborting.
> +AD4-After this postmaster shutdown.
> +AD4-
> +AD4-One observation If we try to recreate this in another linux machine...
> +AD4-multiple postmasters run in the linux machine when the number of requests
> +AD4-become more.
> +AD4-I'm also attaching a file containing 'ps' at the instance postmaster
> +AD4-crashed.
> +AD4-
> +AD4-Can anybody please help
> +AD4-
> +AD4-Thanks and regards,
> +AD4-
> +AD4-Murali
> +AD4-
> +AD4-Differentiated Software Solutions Pvt. Ltd.,
> +AD4-176, Gr. Floor, 6th Main
> +AD4-2nd Block RT Nagar
> +AD4-Bangalore - 560 032
> +AD4-India
> +AD4-Ph: 91 80 3431470
> +AD4-
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org