Skip site navigation (1) Skip section navigation (2)

[6.5.3] first spinlock problem I've ever noticed ...

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [6.5.3] first spinlock problem I've ever noticed ...
Date: 2000-04-01 01:43:54
Message-ID: Pine.BSF.4.21.0003312141380.859-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Jsut doing a vacuum of my database, and foundsomething that I consider to
be "odd" ... while vacuuming one of the tables, doign a ps shows:

64185  p8  S      0:00.10 /home/database/v6.5.3/bin/postgres pgsql 216.126.84.1 ipmeter VACUUM
64202  p8  S      0:00.04 /home/database/v6.5.3/bin/postgres jeff 216.126.84.1 jeff startup
64203  p8  S      0:00.03 /home/database/v6.5.3/bin/postgres hordemgr 216.126.84.1 horde startup
64206  p8  S      0:00.04 /home/database/v6.5.3/bin/postgres jeff 216.126.84.1 jeff startup
64223  p8  S      0:00.02 /home/database/v6.5.3/bin/postgres pgsql 216.126.84.1 banner_ad startup
64235  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres pgsql 216.126.84.1 banner_ad startup
64236  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres hordemgr 216.126.84.1 horde startup
64238  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres pgsql 216.126.84.1 banner_ad startup
64240  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres jeff 216.126.84.1 jeff startup
64255  p8  S      0:00.00 /home/database/v6.5.3/bin/postgres jeff 216.126.84.1 jeff startup

ipmeter was being vacuum'd, but the rest were "hanging"?

Eventually, I got a:

FATAL: s_lock(5004c3d4) at bufmgr.c:665, stuck spinlock. Aborting.

message on the vacuum and then everthing went back to normal ...

I'm tempted to upgrade to v7.0 and see how she goes, but am wondering if
there is something that I should be looking at *beforE* I do that?


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


pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-04-01 01:47:38
Subject: [6.5.3] further investigation ...
Previous:From: Don BaccusDate: 2000-03-31 23:13:22
Subject: Re: Regression tests

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group