RE: PostgreSQL 7.1 beta3 on Windows 2k

Tom,

I have downloaded PostgreSQL 7.1 beta4 and I have tried the regression
tests with "make check", they run until 13 parallel tests or so ( with 13
does with 16 does not ) when it stops you can make it continue killing some
processes with the task manager, but I think this would be the same if
something inherently bad were happenning within the process.
I have tried "make installcheck" and in the end I get this:

############################################################################
############################
ok

======================
All 76 tests passed.
======================

make[2]: Leaving directory `/usr/src/postgresql-7.1beta4/src/test/regress'
make[1]: Leaving directory `/usr/src/postgresql-7.1beta4/src/test'
############################################################################
############################

but I have seen the word ERROR before this, so I am wondering why. An
example of this:

############################################################################
############################
============== running regression test queries ==============
test boolean ... ERROR: Bad boolean external representation
'XXX'
ok
test char ... ok
test name ... ok
test varchar ... ok
test text ... ok
test int2 ... ERROR: pg_atoi: error in "34.5": can't parse
".5"

ERROR: pg_atoi: error reading "100000": Math result out of range
ERROR: pg_atoi: error in "asdf": can't parse "asdf"
ok
test int4 ... ERROR: pg_atoi: error in "34.5": can't parse
".5"

ERROR: pg_atoi: error reading "1000000000000": Math result out of range
ERROR: pg_atoi: error in "asdf": can't parse "asdf"
ok
test int8 ... ok
test oid ... ERROR: oidin: error in "asdfasd": can't parse
"as
dfasd"
ERROR: oidin: error in "99asdfasd": can't parse "asdfasd"
ok
test float4 ... ERROR: Bad float4 input format -- overflow
ERROR: Bad float4 input format -- overflow
ERROR: Bad float4 input format -- underflow
ERROR: Bad float4 input format -- underflow
ERROR: float4div: divide by zero error
ok
test float8 ... ERROR: Bad float8 input format -- overflow
ERROR: pow() result is out of range
ERROR: can't take log of zero
ERROR: can't take log of a negative number
ERROR: exp() result is out of range
ERROR: float8div: divide by zero error
ERROR: Input '10e400' is out of range for float8
ERROR: Input '-10e400' is out of range for float8
############################################################################
############################

Could you tell me if this is wrong or not please.
Thank you for your time.

//Juan

-----Mensaje original-----
De: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Enviado el: martes, 06 de febrero de 2001 2:14
Para: JJAR
CC: Jason Tishler; pgsql-ports(at)postgresql(dot)org
Asunto: Re: [PORTS] PostgreSQL 7.1 beta3 on Windows 2k

"JJAR" <jjarcore(at)eresmas(dot)com> writes:
> [ parallel regression tests hang up in second parallel group ]
> I come to this point and nothing happens. The CPU doesn't work at all (
only
> 5% CPU power consumption ) and the hard disk is quiet so the process is
> dead.

Hmm. You might be looking at a shell bug. There are shells out there
that lose track of how many children they have when asked to spawn more
than a dozen or so parallel children. For example, I see extremely
similar behavior when I try to run 'make check' using the standard
/bin/sh shell on HPUX 10.20: it locks up partway through the second set
of parallel tests. I have to select SHELL=/bin/ksh instead to get
the tests to complete. I'm not sure it's quite the same issue, because
HPUX's sh goes to 100% CPU usage after getting confused in this way,
but it still seems like a likely explanation.

Can you run the non-parallel test (make installcheck) successfully?
Also, try splitting the parallel groups in the parallel_schedule file
into smaller numbers of tests.

regards, tom lane