Call for port reports

On 24/10/03 4:37 pm, "Bruce Momjian" <pgman@candle.pha.pa.us> wrote:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

The current list is at:

http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

All beta5 regression tests pass on

[mrc1-003:] adam% uname -a
Darwin mrc1-003.sghms.ac.uk 6.8 Darwin Kernel Version 6.8: Wed Sep 10
15:20:55 PDT 2003; root:xnu/xnu-344.49.obj~2/RELEASE_PPC Power Macintosh
powerpc

[mrc1-003:] adam% sw_vers
ProductName: Mac OS X
ProductVersion: 10.2.8
BuildVersion: 6R73

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Updated:

http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

---------------------------------------------------------------------------

Adam Witney wrote:

On 24/10/03 4:37 pm, "Bruce Momjian" <pgman@candle.pha.pa.us> wrote:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

The current list is at:

http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html

All beta5 regression tests pass on

[mrc1-003:] adam% uname -a
Darwin mrc1-003.sghms.ac.uk 6.8 Darwin Kernel Version 6.8: Wed Sep 10
15:20:55 PDT 2003; root:xnu/xnu-344.49.obj~2/RELEASE_PPC Power Macintosh
powerpc

[mrc1-003:] adam% sw_vers
ProductName: Mac OS X
ProductVersion: 10.2.8
BuildVersion: 6R73

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

Linux bell 2.4.22-1-k7 #5 Sat Oct 4 14:11:12 EST 2003 i686 GNU/Linux

--
Peter Eisentraut peter_e@gmx.net

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

Linux sparc-sid 2.4.22-ctx17a #1 SMP Sam Okt 11 23:39:04 CEST 2003 sparc64 GNU/Linux

(32-bit build)

--
Peter Eisentraut peter_e@gmx.net

Ports list updated:

http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html

---------------------------------------------------------------------------

Peter Eisentraut wrote:

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

Linux bell 2.4.22-1-k7 #5 Sat Oct 4 14:11:12 EST 2003 i686 GNU/Linux

--
Peter Eisentraut peter_e@gmx.net

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Ports list updated:

http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html

---------------------------------------------------------------------------
Peter Eisentraut wrote:

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

Linux sparc-sid 2.4.22-ctx17a #1 SMP Sam Okt 11 23:39:04 CEST 2003 sparc64 GNU/Linux

(32-bit build)

--
Peter Eisentraut peter_e@gmx.net

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

FreeBSD svr1.postgresql.org 4.9-PRERELEASE FreeBSD 4.9-PRERELEASE #4: Sat Sep 20 14:41:58 ADT 2003 i386

--
Peter Eisentraut peter_e@gmx.net

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

CYGWIN_NT-5.1 krusty 1.3.22(0.78/3/2) 2003-03-18 09:20 i686 unknown unknown Cygwin

I suggest that we change the operating system column for this platform
from "Windows" to "Windows with Cygwin" and remove Cygwin from the comment
column.

--
Peter Eisentraut peter_e@gmx.net

On Oct 24, 2003, at 18:37, Bruce Momjian wrote:

It is time for people to report their port testing. Please test
against
current CVS or beta5 and report your 'uname -a'.

This is with beta 5.

Darwin marko.karppinen.fi 7.0.0 Darwin Kernel Version 7.0.0: Wed Sep 24
15:48:39 PDT 2003; root:xnu/xnu-517.obj~1/RELEASE_PPC Power Macintosh
powerpc

ProductName: Mac OS X
ProductVersion: 10.3
BuildVersion: 7B85

6 out of 93 tests failed:
date ... FAILED
timetz ... FAILED
inet ... FAILED
comments ... FAILED
test horology ... FAILED
test misc ... FAILED

The regression.diffs file is at:
http://www.karppinen.fi/pgsql74b4-darwin7-regression.diffs

mk

Looking a bit further into this, it looks like random tests are
failing. Seems like an issue with the test harness on this
platform.

Does someone want a shell account to debug?

mk

I'm just being an idiot, it's obviously a limits problem on the
platform.
It has a default max user processes limit of 100, which I was hitting.
I shut down a bunch of desktop apps, and it's now passing:

92 of 93 tests passed, 1 failed test(s) ignored.
(random was the one failing).

So I guess you can add it to the list.

mk

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

On True64 5.1 (no "thread safety" enabled) with gcc:

In file included from postgresql-7.4beta5/src/port/thread.c:17:
/usr/include/pthread.h:290:3: #error <pthread.h>: unrecognized compiler.
/usr/include/pthread.h:328:4: #error "Please compile the module including pthread.h with -pthread"
make[2]: *** [thread.o] Error 1

and analogously using vendor cc (only the second error).

So this platform is officially broken right now.

--
Peter Eisentraut peter_e@gmx.net

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

This one is OK:

FreeBSD 4.8-RELEASE alpha

BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.

--
Peter Eisentraut peter_e@gmx.net

Linux ns2 2.4.20-xfs #2 Tue Apr 15 10:04:43 EDT 2003 i686 unknown

<-- SNIP -->
stats ... FAILED
============== shutting down postmaster ==============

=======================
1 of 93 tests failed.
=======================

*** ./expected/stats.out        Sat Sep 13 12:44:48 2003
--- ./results/stats.out Fri Oct 24 14:26:56 2003
***************
*** 8,14 ****
  SHOW stats_start_collector;  -- must be on
   stats_start_collector
  -----------------------
!  on
  (1 row)

  -- save counters
--- 8,14 ----
  SHOW stats_start_collector;  -- must be on
   stats_start_collector
  -----------------------
!  off
  (1 row)

-- save counters
***************
*** 62,68 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! t | t | t | t
(1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
--- 62,68 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  f        | f        | f        | f
  (1 row)

SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
***************
*** 71,77 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! t | t
(1 row)

  -- clean up
--- 71,77 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column?
  ----------+----------
!  f        | f
  (1 row)

-- clean up

Ports list updated:

http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html

---------------------------------------------------------------------------

Peter Eisentraut wrote:

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

FreeBSD svr1.postgresql.org 4.9-PRERELEASE FreeBSD 4.9-PRERELEASE #4: Sat Sep 20 14:41:58 ADT 2003 i386

--
Peter Eisentraut peter_e@gmx.net

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Heading updated too.

Ports list updated:

http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html

---------------------------------------------------------------------------

Peter Eisentraut wrote:

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

CYGWIN_NT-5.1 krusty 1.3.22(0.78/3/2) 2003-03-18 09:20 i686 unknown unknown Cygwin

I suggest that we change the operating system column for this platform
from "Windows" to "Windows with Cygwin" and remove Cygwin from the comment
column.

--
Peter Eisentraut peter_e@gmx.net

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Ports list updated:

http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html

I saw in your diff:

! psql: could not fork new process for connection: Resource temporarily
unavailable

so I figured it was something related to resources.

---------------------------------------------------------------------------
Marko Karppinen wrote:

I'm just being an idiot, it's obviously a limits problem on the
platform.
It has a default max user processes limit of 100, which I was hitting.
I shut down a bunch of desktop apps, and it's now passing:

92 of 93 tests passed, 1 failed test(s) ignored.
(random was the one failing).

So I guess you can add it to the list.

mk

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thanks, fixed. Please retest.

---------------------------------------------------------------------------

Peter Eisentraut wrote:

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

On True64 5.1 (no "thread safety" enabled) with gcc:

In file included from postgresql-7.4beta5/src/port/thread.c:17:
/usr/include/pthread.h:290:3: #error <pthread.h>: unrecognized compiler.
/usr/include/pthread.h:328:4: #error "Please compile the module including pthread.h with -pthread"
make[2]: *** [thread.o] Error 1

and analogously using vendor cc (only the second error).

So this platform is officially broken right now.

--
Peter Eisentraut peter_e@gmx.net

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Peter Eisentraut wrote:

Bruce Momjian writes:

It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.

This one is OK:

FreeBSD 4.8-RELEASE alpha

BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.

template/alpha has:

case $host_cpu in
alpha*) CFLAGS="$CFLAGS -O";; # alpha has problems with -O2
esac

Is this not getting invoked?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073