pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BTP_CHAIN errors fixed?
3+ messages / 2 participants
[nested] [flat]

* BTP_CHAIN errors fixed?
@ 2001-01-27 22:42  Mark Volpe <volpe.mark@epamail.epa.gov>
  0 siblings, 1 reply; 3+ messages in thread

From: Mark Volpe @ 2001-01-27 22:42 UTC (permalink / raw)
  To: pgsql-sql

Hi,
I have been using PostgreSQL-7.0.0 and have had the problem that, when
searching a btree index that contains large numbers of duplicate keys,
Postgres crashes with a BTP_CHAIN error. Now that I have installed 7.1beta3
the problem has seemingly been fixed. Was this problem actually fixed
somewhere between 7.0.0 and 7.1beta3, or am I just getting lucky right now
(just want to know before I put this into production :-))?

Thanks,
Mark



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BTP_CHAIN errors fixed?
@ 2001-01-27 23:00  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Mark Volpe <volpe.mark@epamail.epa.gov>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2001-01-27 23:00 UTC (permalink / raw)
  To: Mark Volpe <volpe.mark@epamail.epa.gov>; +Cc: pgsql-sql

Mark Volpe <volpe.mark@epamail.epa.gov> writes:
> I have been using PostgreSQL-7.0.0 and have had the problem that, when
> searching a btree index that contains large numbers of duplicate keys,
> Postgres crashes with a BTP_CHAIN error. Now that I have installed 7.1beta3
> the problem has seemingly been fixed. Was this problem actually fixed
> somewhere between 7.0.0 and 7.1beta3, or am I just getting lucky right now

Well, it was worked on ;-) ... that whole chunk of code was rewritten.
Whether it has new bugs remains to be seen, but the old bugs are gone...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BTP_CHAIN errors fixed?
@ 2001-01-27 23:11  Mark Volpe <volpe.mark@epamail.epa.gov>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Mark Volpe @ 2001-01-27 23:11 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql

Tom Lane wrote:
> 
> Mark Volpe <volpe.mark@epamail.epa.gov> writes:
> > I have been using PostgreSQL-7.0.0 and have had the problem that, when
> > searching a btree index that contains large numbers of duplicate keys,
> > Postgres crashes with a BTP_CHAIN error. Now that I have installed 7.1beta3
> > the problem has seemingly been fixed. Was this problem actually fixed
> > somewhere between 7.0.0 and 7.1beta3, or am I just getting lucky right now
> 
> Well, it was worked on ;-) ... that whole chunk of code was rewritten.
> Whether it has new bugs remains to be seen, but the old bugs are gone...
> 
>                         regards, tom lane

Thanks for the quick response. The new code will get plenty of testing from
me!



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-01-27 23:11 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-27 22:42 BTP_CHAIN errors fixed? Mark Volpe <volpe.mark@epamail.epa.gov>
2001-01-27 23:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-01-27 23:11   ` Mark Volpe <volpe.mark@epamail.epa.gov>

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