pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBTP_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>
2001-01-27 23:00 ` Re: BTP_CHAIN errors fixed? Tom Lane <tgl@sss.pgh.pa.us>
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 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 ` Re: BTP_CHAIN errors fixed? 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 22:42 BTP_CHAIN errors fixed? Mark Volpe <volpe.mark@epamail.epa.gov>
2001-01-27 23:00 ` Re: BTP_CHAIN errors fixed? Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-01-27 23:11 ` Mark Volpe <volpe.mark@epamail.epa.gov>
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