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: (view raw, whole thread or download thread mbox)
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 ipmeter VACUUM
64202  p8  S      0:00.04 /home/database/v6.5.3/bin/postgres jeff jeff startup
64203  p8  S      0:00.03 /home/database/v6.5.3/bin/postgres hordemgr horde startup
64206  p8  S      0:00.04 /home/database/v6.5.3/bin/postgres jeff jeff startup
64223  p8  S      0:00.02 /home/database/v6.5.3/bin/postgres pgsql banner_ad startup
64235  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres pgsql banner_ad startup
64236  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres hordemgr horde startup
64238  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres pgsql banner_ad startup
64240  p8  S      0:00.01 /home/database/v6.5.3/bin/postgres jeff jeff startup
64255  p8  S      0:00.00 /home/database/v6.5.3/bin/postgres jeff 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 @ 
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-2018 The PostgreSQL Global Development Group