Having heard nothing on the list yet about the reported unsuccessful
parallel regression tests on Cygwin with 7.2b3, I thought I'd have a play
myself having found a spare few minutes.

System: Windows XP Professional, PIII 850MHz, 512Mb RAM, 32Gb disk
uname -a: CYGWIN_NT-5.1 PC20 1.3.3(0.46/3/2) 2001-09-12 23:54 i686 unknown

Sequential regression tests pass repeatedly.

Parallel regression tests appear to fail almost randomly. The best I got so
far was 3 failures (out of 79 tests), the worst was about 15. In particular
the horology & misc tests always seems to fail, whilst the others vary. With
the exception of the misc test, all failures appear to be due to failed
connections eg:

--- 1,3 ----
! psql: could not connect to server: Connection refused
! 	Is the server running on host localhost and accepting
! 	TCP/IP connections on port 65432?

The misc test fails with:

*** ./expected/misc.out	Wed Dec 12 20:34:59 2001
--- ./results/misc.out	Wed Dec 12 21:52:29 2001
***************
*** 567,573 ****
   a_star
   abstime_tbl
   aggtest
-  arrtest
   b
   b_star
   box_tbl
--- 567,572 ----
***************
*** 633,641 ****
   point_tbl
   polygon_tbl
   ramp
-  random_tbl
   real_city
-  reltime_tbl
   road
   serialtest
   serialtest_f2_seq
--- 632,638 ----
***************
*** 652,662 ****
   timestamp_tbl
   timestamptz_tbl
   timetz_tbl
-  tinterval_tbl
   toyemp
   varchar_tbl
   xacttest
! (93 rows)
  
  --SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')))
AS equip_name;
  SELECT hobbies_by_name('basketball');
--- 649,658 ----
   timestamp_tbl
   timestamptz_tbl
   timetz_tbl
   toyemp
   varchar_tbl
   xacttest
! (89 rows)
  
  --SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')))
AS equip_name;
  SELECT hobbies_by_name('basketball');


Though again, this varies with each run - looking at misc.sql I assume that
this is because of the earlier failures?

I have no idea what's causing these connection failures, but if anyone else
has any ideas and would like me to try out anything please let me know -
assuming of course it's not too late for 7.2 yet... 

Regards, Dave.

-- 
Dave Page (dpage@postgresql.org)
http://pgadmin.postgresql.org/ 

Wed, 12 Dec 2001 22:18:57 -0000
Dave Page <dpage@vale-housing.co.uk>
Platform Testing - Cygwin
> Having heard nothing on the list yet about the reported unsuccessful
> parallel regression tests on Cygwin with 7.2b3, I thought I'd have a play
> myself having found a spare few minutes.

Tom Lane has speculated that some optimizations around our locking code
(which had been redone for 7.2) might be the culprit for problems in
Cygwin as it apparently was for AIX. He has since fixed the problems at
least under AIX.

Could you repeat the test with 7.2b4 (out today??)?.

                    - Thomas

> System: Windows XP Professional, PIII 850MHz, 512Mb RAM, 32Gb disk
> uname -a: CYGWIN_NT-5.1 PC20 1.3.3(0.46/3/2) 2001-09-12 23:54 i686 unknown
> Sequential regression tests pass repeatedly.
> Parallel regression tests appear to fail almost randomly...

Thu, 13 Dec 2001 05:57:37 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: [HACKERS] Platform Testing - Cygwin
Dave,

On Wed, Dec 12, 2001 at 10:18:57PM -0000, Dave Page wrote:
> Parallel regression tests appear to fail almost randomly. The best I got so
> far was 3 failures (out of 79 tests), the worst was about 15. In particular
> the horology & misc tests always seems to fail, whilst the others vary. With
> the exception of the misc test, all failures appear to be due to failed
> connections eg:
> 
> --- 1,3 ----
> ! psql: could not connect to server: Connection refused
> ! 	Is the server running on host localhost and accepting
> ! 	TCP/IP connections on port 65432?

The above is a known MS Winsock limitation and is documented in FAQ_MSWIN:

    2.  make check can generate spurious regression test failures due to
        overflowing the listen() backlog queue which causes connection
        refused errors.

> System: Windows XP Professional, PIII 850MHz, 512Mb RAM, 32Gb disk
                     ^^^^^^^^^^^^

Your system has a backlog limit of 5.  Although a little dated, see the
following for details:

    http://support.microsoft.com/support/kb/articles/Q127/1/44.asp

Jason

Thu, 13 Dec 2001 07:32:59 -0500
Jason Tishler <jason@tishler.net>
Re: Platform Testing - Cygwin


Jason Tishler wrote:

>Dave,
>
>On Wed, Dec 12, 2001 at 10:18:57PM -0000, Dave Page wrote:
>
>>Parallel regression tests appear to fail almost randomly. The best I got so
>>far was 3 failures (out of 79 tests), the worst was about 15. In particular
>>the horology & misc tests always seems to fail, whilst the others vary. With
>>the exception of the misc test, all failures appear to be due to failed
>>connections eg:
>>
>>--- 1,3 ----
>>! psql: could not connect to server: Connection refused
>>! 	Is the server running on host localhost and accepting
>>! 	TCP/IP connections on port 65432?
>>
>
>The above is a known MS Winsock limitation and is documented in FAQ_MSWIN:
>
>    2.  make check can generate spurious regression test failures due to
>        overflowing the listen() backlog queue which causes connection
>        refused errors.
>
Could this not be "fixed" in client libs, by having a retry count/timeout.

I guess that having libpq (or any other client) retry the initial 
connection would solve
most of these short queue problems.

>>System: Windows XP Professional, PIII 850MHz, 512Mb RAM, 32Gb disk
>>
>                     ^^^^^^^^^^^^
>
>Your system has a backlog limit of 5.  Although a little dated, see the
>following for details:
>
>    http://support.microsoft.com/support/kb/articles/Q127/1/44.asp
>
>Jason
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>



Fri, 14 Dec 2001 23:24:27 +0500
Hannu Krosing <hannu@tm.ee>
Re: [HACKERS] Platform Testing - Cygwin
Hannu Krosing <hannu@tm.ee> writes:
> I guess that having libpq (or any other client) retry the initial 
> connection would solve most of these short queue problems.

And get us accused of DOS attempts.  Repeated connection attempts
after one has been rejected will be seen as unfriendly behavior by
a lot of people.

Microsoft clearly does not want people running servers on the non-server
versions of Windows, and I don't see why we should go out of our way
to circumvent that.

			regards, tom lane

Fri, 14 Dec 2001 17:38:05 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Platform Testing - Cygwin 
Tom Lane wrote:
> 
> Hannu Krosing <hannu@tm.ee> writes:
> > I guess that having libpq (or any other client) retry the initial
> > connection would solve most of these short queue problems.
> 
> And get us accused of DOS attempts.  Repeated connection attempts
> after one has been rejected will be seen as unfriendly behavior by
> a lot of people.

AFAIK sendmail keeps trying for days :)

> Microsoft clearly does not want people running servers on the non-server
> versions of Windows, and I don't see why we should go out of our way
> to circumvent that.

Ok. Just a thought.

-------------
Hannu

Sat, 15 Dec 2001 13:16:44 +0200
Hannu Krosing <hannu@tm.ee>
Re: [HACKERS] Platform Testing - Cygwin