Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> I got a regression test result from Hiroshi Saito on
> UNIX_System_V ews4800 4.2MP 4.2 R4000 r4000.
> Seems INT64_IS_BUSTED, old PST ... etc and
> *** ./expected/create_index.out Tue Aug 28 08:23:34 JST 2001
> --- ./results/create_index.out Fri Nov 30 00:28:22 JST 2001
> ***************
> *** 35,44 ****
> --- 35,47 ----
> --
> CREATE INDEX onek2_u1_prtl ON onek2 USING btree(unique1 int4_ops)
> where unique1 < 20 or unique1 > 980;
> + ERROR: AllocSetFree: cannot find block containing chunk 4f64f0
> CREATE INDEX onek2_u2_prtl ON onek2 USING btree(unique2 int4_ops)
> where stringu1 < 'B';
> + ERROR: AllocSetFree: cannot find block containing chunk 4f6390
> CREATE INDEX onek2_stu1_prtl ON onek2 USING btree(stringu1 name_ops)
> where onek2.stringu1 >= 'J' and onek2.stringu1 < 'K';
> + ERROR: AllocSetFree: cannot find block containing chunk 4f6740
Interesting. Something nonportable in the partial index support,
perhaps?
Would you ask him to compile with debug support, set a breakpoint at
elog(), and get a backtrace from the point of the error? It'll probably
work to execute any one of those commands by hand in the regression
database, so he doesn't need to try to attach to a regression testing
backend on the fly. Just start psql, attach gdb to its backend, set the
breakpoint, and then run the create index command.
regards, tom lane