Обсуждение: 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.
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/
> 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...
> -----Original Message----- > From: Thomas Lockhart [mailto:lockhart@fourpalms.org] > Sent: 13 December 2001 05:58 > To: Dave Page > Cc: 'pgsql-hackers@postgresql.org'; 'pgsql-cygwin@postgresql.org' > Subject: Re: [HACKERS] 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??)?. > Still the same problem :-(. BTW: I have also updated my Cygwin installation to CYGWIN_NT-5.1 PC20 1.3.6(0.47/3/2) 2001-12-08 17:02 i686 unknown Regards, Dave
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
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 >
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
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