pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedspinlock freeze again
6+ messages / 2 participants
[nested] [flat]
* spinlock freeze again
@ 1999-05-18 10:36 Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-07 18:20 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Hiroshi Inoue @ 1999-05-18 10:36 UTC (permalink / raw)
To: pgsql-hackers <pgsql-hackers@postgreSQL.org>
Hi all,
ProcReleaseSpins() does nothing unless MyProc is set.
So both elog(ERROR/FATAL) and proc_exit(0) before
InitProcess() don't release spinlocks.
Comments ?
Hiroshi Inoue
Inoue@tpf.co.jp
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] spinlock freeze again
1999-05-18 10:36 spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
@ 1999-07-07 18:20 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-07 23:50 ` RE: [HACKERS] spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 1999-07-07 18:20 UTC (permalink / raw)
To: Hiroshi Inoue <Inoue@tpf.co.jp>; +Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi all,
>
> ProcReleaseSpins() does nothing unless MyProc is set.
> So both elog(ERROR/FATAL) and proc_exit(0) before
> InitProcess() don't release spinlocks.
Are their any locks acquired before InitProcess()?
--
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [HACKERS] spinlock freeze again
1999-05-18 10:36 spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-07 18:20 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-07-07 23:50 ` Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-08 01:09 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Hiroshi Inoue @ 1999-07-07 23:50 UTC (permalink / raw)
To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
> -----Original Message-----
> From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
> Sent: Thursday, July 08, 1999 3:21 AM
> To: Hiroshi Inoue
> Cc: pgsql-hackers
> Subject: Re: [HACKERS] spinlock freeze again
>
>
> [Charset iso-8859-1 unsupported, filtering to ASCII...]
> > Hi all,
> >
> > ProcReleaseSpins() does nothing unless MyProc is set.
> > So both elog(ERROR/FATAL) and proc_exit(0) before
> > InitProcess() don't release spinlocks.
>
> Are their any locks acquired before InitProcess()?
>
OidGenLockId spinlock is acquired in InitTransactionLog().
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] spinlock freeze again
1999-05-18 10:36 spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-07 18:20 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-07 23:50 ` RE: [HACKERS] spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
@ 1999-07-08 01:09 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-08 02:07 ` RE: [HACKERS] spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 1999-07-08 01:09 UTC (permalink / raw)
To: Hiroshi Inoue <Inoue@tpf.co.jp>; +Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
> > Are their any locks acquired before InitProcess()?
> >
>
> OidGenLockId spinlock is acquired in InitTransactionLog().
>
> Regards.
>
Well, seems we have a Proc queue that holds locks, but for these other
cases, we don't. We could use the on_shmexit queue to add an cleanup
handler once we get the lock, and remove it from the queue once we
release the lock. We don't currently have the ability to remove
specific queue entries, but we could easily do that.
Is the lock failure a problem that happens a lot?
--
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [HACKERS] spinlock freeze again
1999-05-18 10:36 spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-07 18:20 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-07 23:50 ` RE: [HACKERS] spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-08 01:09 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-07-08 02:07 ` Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-08 03:01 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Hiroshi Inoue @ 1999-07-08 02:07 UTC (permalink / raw)
To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
> -----Original Message-----
> From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
> Sent: Thursday, July 08, 1999 10:09 AM
> To: Hiroshi Inoue
> Cc: pgsql-hackers
> Subject: Re: [HACKERS] spinlock freeze again
>
>
> > > Are their any locks acquired before InitProcess()?
> > >
> >
> > OidGenLockId spinlock is acquired in InitTransactionLog().
> >
> > Regards.
> >
>
> Well, seems we have a Proc queue that holds locks, but for these other
> cases, we don't. We could use the on_shmexit queue to add an cleanup
> handler once we get the lock, and remove it from the queue once we
> release the lock. We don't currently have the ability to remove
> specific queue entries, but we could easily do that.
>
> Is the lock failure a problem that happens a lot?
>
It doesn't happen oridinarily.
I don't remember well how it happend.
Probably it was caused by other spinlock(io_in_progress_lock ?)
freeze while testing 6.5-beta.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] spinlock freeze again
1999-05-18 10:36 spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-07 18:20 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-07 23:50 ` RE: [HACKERS] spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-08 01:09 ` Re: [HACKERS] spinlock freeze again Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-08 02:07 ` RE: [HACKERS] spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
@ 1999-07-08 03:01 ` Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 1999-07-08 03:01 UTC (permalink / raw)
To: Hiroshi Inoue <Inoue@tpf.co.jp>; +Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
> It doesn't happen oridinarily.
> I don't remember well how it happend.
> Probably it was caused by other spinlock(io_in_progress_lock ?)
> freeze while testing 6.5-beta.
OK, let's see if it happens again.
--
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~1999-07-08 03:01 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-18 10:36 spinlock freeze again Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-07 18:20 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-07 23:50 ` Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-08 01:09 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-08 02:07 ` Hiroshi Inoue <Inoue@tpf.co.jp>
1999-07-08 03:01 ` Bruce Momjian <maillist@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox