RE: [HACKERS] regressplans failures

2000-11-22 Thread Philip Warner
> >Fixed - fdstate was not properly setted in fd.c:fileNameOpenFile >with WAL enabled, sorry. > >Philip, please try to reproduce crash. > Seems to have fixed the crash for me as well. Thanks. Philip Warner|

RE: [HACKERS] regressplans failures

2000-11-22 Thread Mikheev, Vadim
> >> I'm guessing this is a variant of the problem Philip > >> Warner reported yesterday. Probably WAL-related. Vadim? > > > Probably, though I don't understand how WAL is related to > > execution plans. Ok, it's easy to reproduce - I'll take a look. > > Could just be a question of a differe

Re: [HACKERS] regressplans failures

2000-11-22 Thread Tom Lane
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes: >> I'm guessing this is a variant of the problem Philip Warner reported >> yesterday. Probably WAL-related. Vadim? > Probably, though I don't understand how WAL is related to execution plans. > Ok, it's easy to reproduce - I'll take a look. Could ju

RE: [HACKERS] regressplans failures

2000-11-22 Thread Mikheev, Vadim
> Peter Eisentraut <[EMAIL PROTECTED]> writes: > > #3 0x8149b98 in ExceptionalCondition ( > > conditionName=0x81988a0 "!(((file) > 0 && (file) < > (int) SizeVfdCache > > && VfdCache[file].fileName != ((void *)0)))", exceptionP=0x81b93c8, > > detail=0x0, > > fileName=0x8198787 "fd.c", lin

Re: [HACKERS] regressplans failures

2000-11-22 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > #3 0x8149b98 in ExceptionalCondition ( > conditionName=0x81988a0 "!(((file) > 0 && (file) < (int) SizeVfdCache > && VfdCache[file].fileName != ((void *)0)))", exceptionP=0x81b93c8, > detail=0x0, > fileName=0x8198787 "fd.c", lineNumber=851) at

[HACKERS] regressplans failures

2000-11-22 Thread Peter Eisentraut
I ran the src/test/regressplans.sh script, which runs the regression tests under exclusion of various join and scan types. Without merge joins (-fm) I get an assertion failure in opr_sanity. The query is: SELECT p1.oid, p1.aggname FROM pg_aggregate as p1 WHERE p1.aggfinalfn = 0 AND p1.agg