Re: [HACKERS] Call for platforms
Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's patch should be applied? Cheers, Patrick (just checked, it isn't in today's cvs) On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote: > On Thu, Mar 22, 2001 at 07:58:04PM +, Patrick Welche wrote: > > On Fri, Mar 23, 2001 at 06:25:50AM +1100, Giles Lean wrote: > > > > > > > PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the > > > > above difference is only for i386 + fpu. > > > > > > It doesn't on NetBSD-1.5/alpha -- there geometry-positive-zeros is > > > correct. > > > > Sorry, that should have read: > > > > AFAIK geometry-positive-zeros works for all NetBSD platforms - the > > above difference is only for i386 + fpu. > > Seems that following patch is needed. Now It Works For Me (tm). > Giles, does the regress test now succed for you? > > -- > marko > > > Index: src/test/regress/resultmap > === > RCS file: /home/projects/pgsql/cvsroot/pgsql/src/test/regress/resultmap,v > retrieving revision 1.45 > diff -u -r1.45 resultmap > --- src/test/regress/resultmap2001/03/22 15:13:18 1.45 > +++ src/test/regress/resultmap2001/03/22 17:29:49 > @@ -17,6 +17,7 @@ > geometry/.*-openbsd=geometry-positive-zeros-bsd > geometry/.*-irix6=geometry-irix > geometry/.*-netbsd=geometry-positive-zeros > +geometry/i.86-.*-netbsdelf1.5=geometry-positive-zeros-bsd > geometry/.*-sysv5uw7.*:cc=geometry-uw7-cc > geometry/.*-sysv5uw7.*:gcc=geometry-uw7-gcc > geometry/alpha.*-dec-osf=geometry-alpha-precision > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Call for platforms (Solaris)
Hi I've been running RC3 regression tests, starting with a FreeBSD 4.2-STABLE and a Solaris 7 Sparc box. Both tests ran without any problems. I tried Solaris 8 Sparc next: it still suffered from the same unix socket problems. I had a look at the code and it seems to me that the use of unix sockets in RC3 is still enabled, even though it (appearently) doesn't work reliably on Solaris. Since it was rather strange that RC3 did work correctly on Solaris 7 but not 8, I also ran regression tests on another Solaris 7 and another 8 box, with the same results. Since I still didn't trust it, I also ran RC1 again on both Solaris 7 and 8; same result. And now things start getting weird. A little more than a week ago the RC1 regression tests ran with on average 10-15 tests randomly failing. Now, however, I can run the regression several times without any test failing. But if I run the regression test enough times (4-6 times), I do have tests that fail (about 2-5). The configuration of these servers hasn't changed in the last months and I used the same RC1 source and binaries. Can somebody confirm whether pgsql Solaris does or does not work correctly out-of-the-box? Disabling unix sockets will probably fix all these problems, so I'm naturally wondering whether unix socket will or will not be disabled in pgsql 7.1... Regards, Mathijs Ps. Vince, could you remove test results 46 and 47? I don't trust them anymore. -- "A book is a fragile creature. It suffers the wear of time, it fears rodents, the elements, clumsy hands." Umberto Eco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms (HP-UX)
Giles Lean <[EMAIL PROTECTED]> writes: > I'm not sure how interesting these differences are anymore -- is there > anyone familiar enough with floating point to determine if the results > are acceptable (although currently unexpected :-) or not? Differences in the last couple of decimal places in the geometry test are definitely not a cause for worry. Although we've tried to create exact-match reference files for the most popular platforms, I think that's largely an exercise in time-wasting. Eventually we will figure out a way to make the geometry output round off a few digits, and then the cross-platform differences should mostly vanish. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms (HP-UX)
> Okay, here are my results: > > Box 1: C180 (2.0 PA8000), HPUX 10.20 > > Compile with gcc: all tests pass > Compile with cc: two lines of diffs in geometry (attached) > > Box 2: 715/75 (1.1 PA7100LC), HPUX 10.20 > > Compile with gcc: all tests pass > Compile with cc: all tests pass I haven't had time to look at this further yet, except to build 7.1RC3 a couple of times with the HP ANSI C compiler today: PA-RISC 1.1 code (-Ae +O2 +DAportable): all tests pass PA-RISC 2.0 code (-Ae +O2 +DA2.0 +DS2.0): geometry failures I'm not sure how interesting these differences are anymore -- is there anyone familiar enough with floating point to determine if the results are acceptable (although currently unexpected :-) or not? Regards, Giles ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
Two more for the list (not a single regression test failing, which is a first on Alpha!) Tru64 4.0G Alpha cc-v6.3-129 7.1 2001-03-28 Tru64 4.0G Alpha gcc-2.95.1 7.1 2001-03-28 I updated the regression test database as well. Adriaan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms
On Wed, 21 Mar 2001, Thomas Lockhart wrote: > OK, here is my current platform list taken from the -hackers list and > from Vince's web page. I'm sure I've missed at least a few reports, but > please confirm that platforms are actually running and passing > regression tests with recent betas or the latest release candidate. Updates... > Linux 2.2.x Alpha 7.1 2001-01-23, Ryan Kirkpatrick Tested RC1 with 2.2.17 on my XLT366 Alpha, all regression tests passed. > Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick Tested RC1 with 2.2.18 on my Sparc 20 (SM51), all regression tests passed. Both have been entered into the regression database on the website as well. TTYL. --- | "For to me to live is Christ, and to die is gain."| |--- Philippians 1:21 (KJV) | --- | Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ | --- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[Fwd: Re: [HACKERS] Call for platforms]
Hi all, Vince asked me to forward this here. Regards and best wishes, Justin Clift Original Message Subject: Re: [HACKERS] Call for platforms Date: Sun, 25 Mar 2001 19:45:37 -0500 (EST) From: Vince Vielhaber <[EMAIL PROTECTED]> To: Justin Clift <[EMAIL PROTECTED]> On Mon, 26 Mar 2001, Justin Clift wrote: > Hi Vince, > > I'm wondering if it's worth putting something on the regresssion test > results page asking people to try ALL the options if possible? > > Like, I tested Solaris 8 SPARC with './configure --p=/opt/postgresql71 > --enable-syslog', and that worked perfectly. BUT, when I started adding > in stuff like --with-openssl --with-python, there were nasty > interactions and things didn't work. > > It would be nice to know that on a Supported Platform that ALL of the > options worked (apart from the Perl option which we apparently can't > make 100% work). > > Regards and best wishes, > > Justin Clift > You might want to pass that along to hackers. It'd be interesting to hear their thoughts. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED] http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms
Marko Kreen writes: > OK: Linux 2.4.2 i686 / gcc 2.95.2 / Debian testing/unstable > > no problems. > > OK?: NetBSD 1.5 i586 / egcs 2.91.66 / (netbsd-1-5 from Jan) > > netbsd FAILED the geometry test, diff attached, dunno if its > critical or not. Can you check whether it matches any of the other possible geometry results? See http://www.postgresql.org/devel-corner/docs/postgres/regress-platform.html about the mechanisms. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> The bit test diffs seem to indicate that bit_cmp is messed up. That >> depends on memcmp. I seem to recall something about memcmp not being >> 8-bit-clean on SunOS ... does that ring a bell with anyone? > Sure enough: > - Macro: AC_FUNC_MEMCMP > If the `memcmp' function is not available, or does not work on > 8-bit data (like the one on SunOS 4.1.3), add `memcmp.o' to output > variable `LIBOBJS'. > We could try to mangle this into doing the right thing for us. Not sure if it's worth the trouble. That would be an AC_TRY_RUN test, which you've been trying to move away from, no? It doesn't seem like anyone still cares about SunOS 4.1.*, so ... regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
Tom Lane writes: > The bit test diffs seem to indicate that bit_cmp is messed up. That > depends on memcmp. I seem to recall something about memcmp not being > 8-bit-clean on SunOS ... does that ring a bell with anyone? Sure enough: - Macro: AC_FUNC_MEMCMP If the `memcmp' function is not available, or does not work on 8-bit data (like the one on SunOS 4.1.3), add `memcmp.o' to output variable `LIBOBJS'. We could try to mangle this into doing the right thing for us. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms (HP-UX)
Giles Lean <[EMAIL PROTECTED]> writes: > 2. I saw two different sets of output for geometry.out. These seem to >relate to the processor level: Okay, here are my results: Box 1: C180 (2.0 PA8000), HPUX 10.20 Compile with gcc: all tests pass Compile with cc: two lines of diffs in geometry (attached) Box 2: 715/75 (1.1 PA7100LC), HPUX 10.20 Compile with gcc: all tests pass Compile with cc: all tests pass Box 1 is more up-to-date on HP patches than box 2, so I wouldn't necessarily attribute the difference to the processor. regards, tom lane *** ./expected/geometry-positive-zeros.out Mon Sep 11 23:21:06 2000 --- ./results/geometry.out Sat Mar 24 02:45:35 2001 *** *** 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) --- 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) *** *** 445,451 -+- | ((-3,0),(-2.59807621135076,1.500442),(-1.499116,2.59807621135842),(1.53102359017709e-11,3),(1.501768,2.59807621134311),(2.59807621136607,1.49779),(3,-3.06204718035418e-11),(2.59807621133545,-1.503094),(1.496464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.50442,-2.5980762113278),(-2.59807621138138,-1.495138)) | ((-99,2),(-85.6025403783588,52.01473),(-48.97054,88.602540378614),(1.051034,102),(51.05893,88.6025403781036),(87.6025403788692,51.92634),(101,1.897932),(87.6025403778485,-48.10313),(50.88214,-84.6025403791243),(0.8468976,-98),(-49.14732,-84.6025403775933),(-85.6025403793795,-47.83795)) ! | ((-4,3),(-3.33012701891794,5.500737),(-1.498527,7.3301270189307),(1.002552,8),(3.502946,7.33012701890518),(5.33012701894346,5.496317),(6,2.994897),(5.33012701889242,0.4948437),(3.494107,-1.33012701895622),(0.9923449,-2),(-1.507366,-1.33012701887967),(-3.33012701896897,0.5081028)) | ((-2,2),(-1.59807621135076,3.500442),(-0.4991161,4.59807621135842),(1.001531,5),(2.501768,4.59807621134311),(3.59807621136607,3.49779),(4,1.996938),(3.59807621133545,0.4969062),(2.496464,-0.598076211373729),(0.9954069,-1),(-0.5044197,-0.598076211327799),(-1.59807621138138,0.5048616)) | ((90,200),(91.3397459621641,205.0015),(95.00295,208.660254037861),(100.0051,210),(105.0059,208.66025403781),(108.660254037887,204.9926),(110,199.9898),(108.660254037785,194.9897),(104.9882,191.339745962088),(99.98469,190),(94.98527,191.339745962241),(91.3397459620621,195.0162)) | ((0,0),(13.3974596216412,50.01473),(50.02946,86.602540378614),(100.051,100),(150.0589,86.6025403781036),(186.602540378869,49.92634),(200,-1.02068239345139e-09),(186.602540377848,-50.10313),(149.8821,-86.6025403791243),(99.8469,-100),(49.85268,-86.6025403775933),(13.3974596206205,-49.83795)) --- 445,451 -+-
Re: [HACKERS] Call for platforms (HP-UX)
> Hm, I thought I had updated that before beta6. What it has now is > The parallel regression test script (gmake check) is known to lock up > when run under HP's default Bourne shell, at least in HPUX 10.20. This > appears to be a shell bug, not the fault of the script. If you see that > the tests have stopped making progress and only a shell process is > consuming CPU, kill the shell and start over with > gmake SHELL=/bin/ksh check > to use ksh instead. Interestingly, ksh didn't work for me either, but didn't try it on all the platforms I built on. I'll make a note to check ksh when I'm investigating the problem next week though, and let you know what I find. Regards, Giles ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms (HP-UX)
> >I'll look at this next week. If someone can confirm that > >/usr/bin/sh works for make check on HP-UX 10.20 that would be > >useful. > > It does not work. See FAQ_HPUX. I'm confused: I don't see anything about shells or make check hanging in doc/FAQ_HPUX. There is clear instruction to use GNU make, which I am doing. I'll look into the problem anyway. > >(a) on PA-RISC 1.1 some of the zero values are negative > > Hmm, so does it match any of the existing geometry files? No ... I was hoping for that, but not. Regards, Giles ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms (HP-UX)
Giles Lean <[EMAIL PROTECTED]> writes: >> It does not work. See FAQ_HPUX. > I'm confused: I don't see anything about shells or make check hanging > in doc/FAQ_HPUX. There is clear instruction to use GNU make, which I > am doing. Hm, I thought I had updated that before beta6. What it has now is The parallel regression test script (gmake check) is known to lock up when run under HP's default Bourne shell, at least in HPUX 10.20. This appears to be a shell bug, not the fault of the script. If you see that the tests have stopped making progress and only a shell process is consuming CPU, kill the shell and start over with gmake SHELL=/bin/ksh check to use ksh instead. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms (HP-UX)
Giles Lean <[EMAIL PROTECTED]> writes: >I'll look at this next week. If someone can confirm that >/usr/bin/sh works for make check on HP-UX 10.20 that would be >useful. It does not work. See FAQ_HPUX. > 2. I saw two different sets of output for geometry.out. These seem to >relate to the processor level: I think it depends more on what software you use. The existing HPUX resultmap (geometry-positive-zeros) works on my usual platform (C180, PA8000 chip I think) when using gcc. Compile with cc and you get one different lowest-order digit in two lines, IIRC. I have not tried it lately on a 1.1 chip. >(a) on PA-RISC 1.1 some of the zero values are negative Hmm, so does it match any of the existing geometry files? That would suggest that HPUX 11 has started adhering more closely to the IEEE rules about negative zeroes ... regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] Call for platforms (HP-UX)
Hi all, I've built 7.1beta6 on a number of different HP-UX platforms (11.00 32 bit, 11.00 64 bit, 11i 32 bit). 1. On all these platforms 'make check' hung. Since that's not critical to whether PostgreSQL works or not I worked around it by using a different shell: gmake SHELL=$HOME/bin/pdksh check I'll look at this next week. If someone can confirm that /usr/bin/sh works for make check on HP-UX 10.20 that would be useful. 2. I saw two different sets of output for geometry.out. These seem to relate to the processor level: (a) on PA-RISC 1.1 some of the zero values are negative (b) on PA-RISC 2.0 the negative zeros were produced as on PA-RISC 1.1, plus about three results varied in the least significant digit. The PA-RISC 2.0 values were identical on two platforms: (i) PA8000 running 32 bit 11i (ii) PA8500 running 64 bit 11.00 If these results are OK (I assumed they were for the purposes of Vince's database, so I hope they are :-) then perhaps the attached outputs can be added to the expected results and resultmap updated for HP-UX 11? Regards, Giles -- -- GEOMETRY -- -- -- Points -- SELECT '' AS four, center(f1) AS center FROM BOX_TBL; four | center --+- | (1,1) | (2,2) | (2.5,3) | (3,3) (4 rows) SELECT '' AS four, (@@ f1) AS center FROM BOX_TBL; four | center --+- | (1,1) | (2,2) | (2.5,3) | (3,3) (4 rows) SELECT '' AS six, point(f1) AS center FROM CIRCLE_TBL; six | center -+--- | (0,0) | (1,2) | (1,3) | (1,2) | (100,200) | (100,0) (6 rows) SELECT '' AS six, (@@ f1) AS center FROM CIRCLE_TBL; six | center -+--- | (0,0) | (1,2) | (1,3) | (1,2) | (100,200) | (100,0) (6 rows) SELECT '' AS two, (@@ f1) AS center FROM POLYGON_TBL WHERE (# f1) > 2; two | center -+- | (1.33,1.33) | (2.33,1.33) (2 rows) -- "is horizontal" function SELECT '' AS two, p1.f1 FROM POINT_TBL p1 WHERE ishorizontal(p1.f1, point '(0,0)'); two | f1 -+- | (0,0) | (-10,0) (2 rows) -- "is horizontal" operator SELECT '' AS two, p1.f1 FROM POINT_TBL p1 WHERE p1.f1 ?- point '(0,0)'; two | f1 -+- | (0,0) | (-10,0) (2 rows) -- "is vertical" function SELECT '' AS one, p1.f1 FROM POINT_TBL p1 WHERE isvertical(p1.f1, point '(5.1,34.5)'); one | f1 -+ | (5.1,34.5) (1 row) -- "is vertical" operator SELECT '' AS one, p1.f1 FROM POINT_TBL p1 WHERE p1.f1 ?| point '(5.1,34.5)'; one | f1 -+ | (5.1,34.5) (1 row) -- -- Line segments -- -- intersection SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection FROM LSEG_TBL l, POINT_TBL p; ERROR: Unable to identify an operator '#' for types 'lseg' and 'point' You will have to retype this query using an explicit cast -- closest point SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest FROM LSEG_TBL l, POINT_TBL p; thirty | f1 | s |closest ++---+--- | (0,0) | [(1,2),(3,4)] | (1,2) | (-10,0)| [(1,2),(3,4)] | (1,2) | (-3,4) | [(1,2),(3,4)] | (1,2) | (5.1,34.5) | [(1,2),(3,4)] | (3,4) | (-5,-12) | [(1,2),(3,4)] | (1,2) | (10,10)| [(1,2),(3,4)] | (3,4) | (0,0) | [(0,0),(6,6)] | (-0,0) | (-10,0)| [(0,0),(6,6)] | (0,0) | (-3,4) | [(0,0),(6,6)] | (0.5,0.5) | (5.1,34.5) | [(0,0),(6,6)] | (6,6) | (-5,-12) | [(0,0),(6,6)] | (0,0) | (10,10)| [(0,0),(6,6)] | (6,6) | (0,0) | [(10,-10),(-3,-4)]| (-2.04878048780488,-4.4390243902439) | (-10,0)| [(10,-10),(-3,-4)]| (-3,-4) | (-3,4) | [(10,-10),(-3,-4)]| (-3,-4) | (5.1,34.5) | [(10,-10),(-3,-4)]| (-3,-4) | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.38367449769
Re: [HACKERS] Call for platforms
On 23 Mar 2001, Trond Eivind [iso-8859-1] Glomsrød wrote: > Vince Vielhaber <[EMAIL PROTECTED]> writes: > > > On 22 Mar 2001, Trond Eivind [iso-8859-1] Glomsrød wrote: > > > > > [EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > > > > > > > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > > > > > > > > If a platform you are running on is not listed, make sure it gets > > > > > included! > > > > > > > > Red Hat Linux, Wolverine Beta (and some updates) - glibc 2.2.2, > > > > 2.4.2ish kernel (read: lots of fixes), gcc 2.96RH: All 76 tests passed > > > > with 7.1beta6 (parallel_schedule). > > > > > > Forgot to mention: This is x86. > > > > Forget to enter it into the regresstest database? > > > >http://www.postgresql.org/~vev/regress/ > > I was planning on waiting with that until I test it on an official release. I figured that, it was my just smartass way of reminding EVERYONE to put their data in the database. I saw a few reports of things working yet there was nothing in the database saying so, it was only posted here. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
Vince Vielhaber <[EMAIL PROTECTED]> writes: > On 22 Mar 2001, Trond Eivind [iso-8859-1] Glomsrød wrote: > > > [EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > > > > > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > > > > > > If a platform you are running on is not listed, make sure it gets > > > > included! > > > > > > Red Hat Linux, Wolverine Beta (and some updates) - glibc 2.2.2, > > > 2.4.2ish kernel (read: lots of fixes), gcc 2.96RH: All 76 tests passed > > > with 7.1beta6 (parallel_schedule). > > > > Forgot to mention: This is x86. > > Forget to enter it into the regresstest database? > >http://www.postgresql.org/~vev/regress/ I was planning on waiting with that until I test it on an official release. -- Trond Eivind Glomsrød Red Hat, Inc. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms
On Thu, Mar 22, 2001 at 07:58:04PM +, Patrick Welche wrote: > On Fri, Mar 23, 2001 at 06:25:50AM +1100, Giles Lean wrote: > > > > > PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the > > > above difference is only for i386 + fpu. > > > > It doesn't on NetBSD-1.5/alpha -- there geometry-positive-zeros is > > correct. > > Sorry, that should have read: > > AFAIK geometry-positive-zeros works for all NetBSD platforms - the > above difference is only for i386 + fpu. Seems that following patch is needed. Now It Works For Me (tm). Giles, does the regress test now succed for you? -- marko Index: src/test/regress/resultmap === RCS file: /home/projects/pgsql/cvsroot/pgsql/src/test/regress/resultmap,v retrieving revision 1.45 diff -u -r1.45 resultmap --- src/test/regress/resultmap 2001/03/22 15:13:18 1.45 +++ src/test/regress/resultmap 2001/03/22 17:29:49 @@ -17,6 +17,7 @@ geometry/.*-openbsd=geometry-positive-zeros-bsd geometry/.*-irix6=geometry-irix geometry/.*-netbsd=geometry-positive-zeros +geometry/i.86-.*-netbsdelf1.5=geometry-positive-zeros-bsd geometry/.*-sysv5uw7.*:cc=geometry-uw7-cc geometry/.*-sysv5uw7.*:gcc=geometry-uw7-gcc geometry/alpha.*-dec-osf=geometry-alpha-precision ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for platforms
> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > For the regression test, I got 7 failures, most of them seem harmless, > > the only concern I have is bit test though. > > Most of the diffs derive from what I recall to be a known SunOS problem, > that strtol fails to notice overflow. A value that should be rejected > is getting inserted into int4_tbl (mod 2^32 of course). > > The bit test diffs seem to indicate that bit_cmp is messed up. That > depends on memcmp. I seem to recall something about memcmp not being > 8-bit-clean on SunOS ... does that ring a bell with anyone? Good point. From the man page of memcmp(3) on this machine: BUGS memcmp() uses native character comparison, which is signed on some machines and unsigned on other machines. Thus the sign of the value returned when one of the characters has its high-order bit set is implementation-dependent. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for platforms
> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > >> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > ! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory > > ! pqReadData() -- backend closed the channel unexpectedly. > >> > >> Is it possible you ran out of disk space? > > > Probably not. > > The reason I was speculating that was that it seems pretty unlikely > that a write() call could return ENOENT, as the above appears to > suggest. I think that the errno = ENOENT value was not set by write(), > but is leftover from the expected failure of BasicOpenFile earlier in > XLogFileInit. Probably write() returned some value less than BLCKSZ > but more than zero, and so did not set errno. > > Offhand the only reason I can think of for a write to a disk file > to terminate after a partial transfer is a full disk. What do you > think? Sorry, I was wrong. I accidentaly ran out the disk space. BTW, I got segfault when I first try beta6 on this platform. To investigae it, I recompiled with -g (without -O2) and now the problem has gone. It sems there's something wrong with the compiler (gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease)) or potential bug in 7.1, I don't know. Anyway, the platform is too old now, and I would like to try it another day with newer MkLinux version installed. I don't want to make this as a show stopper for 7.1... -- Tatsuo Ishii *** ./expected/oid.out Tue Nov 21 12:23:20 2000 --- ./results/oid.out Thu Mar 22 15:58:56 2001 *** *** 6,11 --- 6,12 INSERT INTO OID_TBL(f1) VALUES ('1235'); INSERT INTO OID_TBL(f1) VALUES ('987'); INSERT INTO OID_TBL(f1) VALUES ('-1040'); + ERROR: oidin: error in "-1040": can't parse "-1040" INSERT INTO OID_TBL(f1) VALUES (''); INSERT INTO OID_TBL(f1) VALUES (''); -- bad inputs *** *** 15,28 ERROR: oidin: error in "99asdfasd": can't parse "asdfasd" SELECT '' AS six, OID_TBL.*; six | f1 ! -+ | 1234 | 1235 |987 - | 4294966256 | | 0 ! (6 rows) SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; one | f1 --- 16,28 ERROR: oidin: error in "99asdfasd": can't parse "asdfasd" SELECT '' AS six, OID_TBL.*; six |f1 ! -+-- | 1234 | 1235 | 987 | |0 ! (5 rows) SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; one | f1 *** *** 32,44 SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; five | f1 ! --+ | 1235 |987 - | 4294966256 | | 0 ! (5 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; three | f1 --- 32,43 SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; five |f1 ! --+-- | 1235 | 987 | |0 ! (4 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; three | f1 *** *** 57,75 SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; four | f1 ! --+ | 1234 | 1235 - | 4294966256 | ! (4 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234'; three | f1 ! ---+ | 1235 -| 4294966256 | ! (3 rows) DROP TABLE OID_TBL; --- 56,72 SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; four |f1 ! --+-- | 1234 | 1235 | ! (3 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234'; three |f1 ! ---+-- | 1235 | ! (2 rows) DROP TABLE OID_TBL; == *** ./expected/geometry-powerpc-linux-gnulibc1.out Wed Sep 13 06:07:16 2000 --- ./results/geometry.out Thu Mar 22 16:01:20 2001 *** *** 445,451 -+- | ((-3,0),(-2.59807621135076,1.500442),(-1.499116,2.59807621135842),(1.53102359017709e-11,3),(1.501768,2.59807621134311),(2.59807621136607,1.49779),(3,-3.06204718035418e-11),(2.59807621133545,-1.503094),(1.496464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.50442,-2.5980762113278),(-2.59807621138138,-1.495138))
Re: [HACKERS] Call for platforms
Tatsuo Ishii <[EMAIL PROTECTED]> writes: >> The bit test diffs seem to indicate that bit_cmp is messed up. That >> depends on memcmp. I seem to recall something about memcmp not being >> 8-bit-clean on SunOS ... does that ring a bell with anyone? > Good point. From the man page of memcmp(3) on this machine: > BUGS > memcmp() uses native character comparison, which is signed > on some machines and unsigned on other machines. Thus the > sign of the value returned when one of the characters has > its high-order bit set is implementation-dependent. Eeek. The C spec documents I have at hand all agree that memcmp, strcmp, etc shall interpret their arguments as unsigned char. I hope Sun were the only ones who took the above more liberal interpretation... regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > For the regression test, I got 7 failures, most of them seem harmless, > the only concern I have is bit test though. Most of the diffs derive from what I recall to be a known SunOS problem, that strtol fails to notice overflow. A value that should be rejected is getting inserted into int4_tbl (mod 2^32 of course). The bit test diffs seem to indicate that bit_cmp is messed up. That depends on memcmp. I seem to recall something about memcmp not being 8-bit-clean on SunOS ... does that ring a bell with anyone? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms
I have tested today's snap shot on SunOS4. % uname -a SunOS srashd 4.1.4-JL 1 sun4m There's a minor portability problem in src/bin/pg_encoding/Makefile. *** MakefileFri Mar 23 11:53:49 2001 --- Makefile.orig Wed Feb 21 18:05:21 2001 *** *** 16,28 all: submake pg_encoding - ifdef STRTOUL - OBJS+=$(top_builddir)/src/backend/port/strtoul.o - - $(top_builddir)/src/backend/port/strtoul.o: - $(MAKE) -C $(top_builddir)/src/backend/port strtoul.o - endif - pg_encoding: $(OBJS) $(CC) $(CFLAGS) $^ $(libpq) $(LDFLAGS) $(LIBS) -o $@ I'm going to check in this correction soon. For the regression test, I got 7 failures, most of them seem harmless, the only concern I have is bit test though. -- Tatsuo Ishii P.S. I'm going to test Linux/MIPS (Cobalt RaQ2) soon... -- Tatsuo Ishii parallel group (13 tests): text oid varchar int2 float4 boolean name int4 int8 char float8 bit numeric boolean ... ok char ... ok name ... ok varchar ... ok text ... ok int2 ... FAILED int4 ... FAILED int8 ... ok oid ... ok float4 ... ok float8 ... ok bit ... FAILED numeric ... ok test strings ... ok test numerology ... FAILED parallel group (18 tests): comments box lseg time interval abstime path date circle point tinterval reltime polygon inet timestamp type_sanity oidjoins opr_sanity point... ok lseg ... ok box ... ok path ... ok polygon ... ok circle ... ok date ... ok time ... ok timestamp... ok interval ... ok abstime ... ok reltime ... ok tinterval... ok inet ... ok comments ... ok oidjoins ... ok type_sanity ... ok opr_sanity ... ok test geometry ... FAILED test horology ... FAILED test create_function_1... ok test create_type ... ok test create_table ... ok test create_function_2... ok test copy ... ok parallel group (7 tests): create_aggregate create_operator inherit triggers constraints create_misc create_index constraints ... ok triggers ... ok create_misc ... ok create_aggregate ... ok create_operator ... ok create_index ... ok inherit ... ok test create_view ... ok test sanity_check ... ok test errors ... ok test select ... ok parallel group (16 tests): arrays select_having subselect transactions select_distinct_on random union portals select_implicit select_into case join hash_index aggregates select_distinct btree_index select_into ... ok select_distinct ... ok select_distinct_on ... ok select_implicit ... ok select_having... ok subselect... ok union... FAILED case ... ok join ... ok aggregates ... ok transactions ... ok random ... ok portals ... ok arrays ... ok btree_index ... ok hash_index ... ok test misc ... ok parallel group (5 tests): portals_p2 alter_table foreign_key rules select_views select_views ... ok alter_table ... ok portals_p2 ... ok rules... ok foreign_key ... ok parallel group (3 tests): limit temp plpgsql limit... ok plpgsql ... ok temp ... ok regression.diffs.gz ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms
On 22 Mar 2001, Trond Eivind [iso-8859-1] Glomsrød wrote: > [EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > > > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > > > > If a platform you are running on is not listed, make sure it gets > > > included! > > > > Red Hat Linux, Wolverine Beta (and some updates) - glibc 2.2.2, > > 2.4.2ish kernel (read: lots of fixes), gcc 2.96RH: All 76 tests passed > > with 7.1beta6 (parallel_schedule). > > Forgot to mention: This is x86. Forget to enter it into the regresstest database? http://www.postgresql.org/~vev/regress/ Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Call for platforms
[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > > If a platform you are running on is not listed, make sure it gets > > included! > > Red Hat Linux, Wolverine Beta (and some updates) - glibc 2.2.2, > 2.4.2ish kernel (read: lots of fixes), gcc 2.96RH: All 76 tests passed > with 7.1beta6 (parallel_schedule). Forgot to mention: This is x86. -- Trond Eivind Glomsrød Red Hat, Inc. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Call for platforms
> Seems that following patch is needed. Now It Works For Me (tm). > Giles, does the regress test now succed for you? Yes, but I don't like that it is 1.5 specific. I expect that later NetBSD/i386 releases will also have the "new" floating point behaviour by default, subject to /etc/ld.so.conf setting as Patrick Welche discovered. BTW NetBSD just uses "i386" for any x86. It's not necessary to allow for i486, i586 etc. Perhaps the resultmap format could be enhanced to allow wildcarding of the result files, and just accept either match? geometry/.*-netbsd=geometry-positive-zeros* Regards, Giles > Index: src/test/regress/resultmap > === > RCS file: /home/projects/pgsql/cvsroot/pgsql/src/test/regress/resultmap,v > retrieving revision 1.45 > diff -u -r1.45 resultmap > --- src/test/regress/resultmap2001/03/22 15:13:18 1.45 > +++ src/test/regress/resultmap2001/03/22 17:29:49 > @@ -17,6 +17,7 @@ > geometry/.*-openbsd=geometry-positive-zeros-bsd > geometry/.*-irix6=geometry-irix > geometry/.*-netbsd=geometry-positive-zeros > +geometry/i.86-.*-netbsdelf1.5=geometry-positive-zeros-bsd > geometry/.*-sysv5uw7.*:cc=geometry-uw7-cc > geometry/.*-sysv5uw7.*:gcc=geometry-uw7-gcc > geometry/alpha.*-dec-osf=geometry-alpha-precision ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
Thomas Lockhart <[EMAIL PROTECTED]> writes: > If a platform you are running on is not listed, make sure it gets > included! Red Hat Linux, Wolverine Beta (and some updates) - glibc 2.2.2, 2.4.2ish kernel (read: lots of fixes), gcc 2.96RH: All 76 tests passed with 7.1beta6 (parallel_schedule). I'll update this info when we do our next release. -- Trond Eivind Glomsrød Red Hat, Inc. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms
On Fri, Mar 23, 2001 at 06:25:50AM +1100, Giles Lean wrote: > > > PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the > > above difference is only for i386 + fpu. > > It doesn't on NetBSD-1.5/alpha -- there geometry-positive-zeros is > correct. Sorry, that should have read: AFAIK geometry-positive-zeros works for all NetBSD platforms - the above difference is only for i386 + fpu. (-bsd is for bsdi) Thanks for the correction, Patrick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote: > On Thu, Mar 22, 2001 at 07:58:04PM +, Patrick Welche wrote: > > > > AFAIK geometry-positive-zeros works for all NetBSD platforms - the > > above difference is only for i386 + fpu. > > Seems that following patch is needed. Now It Works For Me (tm). > Giles, does the regress test now succed for you? Your patch works for me (i386) - I'd just like to point out that it's because we are both running on peecees with fpus and thus with libm387 loaded (else works without patch) BTW NetBSD 2.8 alpha 7.1 2001-03-22, Giles Lean Shouldn't that be 1.5? Cheers, Patrick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Call for platforms
> PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the > above difference is only for i386 + fpu. It doesn't on NetBSD-1.5/alpha -- there geometry-positive-zeros is correct. Regards, Giles ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Call for platforms
Just a data point on the geometry test under NetBSD/i386 issue: /etc/ld.so.conf by default now contains: libm.so.0 machdep.fpu_present 1:libm387.so.0,libm.so.0 which means that if the sysctl machdep.fpu_present returns 1, load the shared library libm387 to make use of the fpu. If you remove /etc/ld.so.conf, so that ldd `which psql` does not show -lm.0 => /usr/lib/libm387.so.0 -lm.0 => /usr/lib/libm.so.0 but only the libm.so.0 line == All 76 tests passed. == If you replace the /etc/ld.so.conf file and have an fpu, then the geometry test will fail with slightly different rounding. Do we want a specific geometry-netbsd-i386-with-fpu.out where you must also test % sysctl machdep.fpu_present machdep.fpu_present = 1 ? Cheers, Patrick PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the above difference is only for i386 + fpu. On Thu, Mar 22, 2001 at 07:12:39PM +0200, Marko Kreen wrote: > On Thu, Mar 22, 2001 at 05:25:01PM +0100, Peter Eisentraut wrote: > > Marko Kreen writes: > > > > > > OK?: NetBSD 1.5 i586 / egcs 2.91.66 / (netbsd-1-5 from Jan) > > > > > > netbsd FAILED the geometry test, diff attached, dunno if its > > > critical or not. > > > > Can you check whether it matches any of the other possible geometry > > results? See > > Yes, it matches geometry-positive-zeros-bsd.out. There is > another report about NetBSD 1.5/i386 which has comment: > > > one spurious floating point test failure > > (mail sent to postgresql-bugs with details) > > But I could not find it in archive page. (reporter Giles Lean > <[EMAIL PROTECTED]>) Perhaps same thing? > > -- > marko > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Call for platforms
On Thu, Mar 22, 2001 at 05:25:01PM +0100, Peter Eisentraut wrote: > Marko Kreen writes: > > > > OK?: NetBSD 1.5 i586 / egcs 2.91.66 / (netbsd-1-5 from Jan) > > > > netbsd FAILED the geometry test, diff attached, dunno if its > > critical or not. > > Can you check whether it matches any of the other possible geometry > results? See Yes, it matches geometry-positive-zeros-bsd.out. There is another report about NetBSD 1.5/i386 which has comment: > one spurious floating point test failure > (mail sent to postgresql-bugs with details) But I could not find it in archive page. (reporter Giles Lean <[EMAIL PROTECTED]>) Perhaps same thing? -- marko ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms
OK: Linux 2.4.2 i686 / gcc 2.95.2 / Debian testing/unstable no problems. OK?: NetBSD 1.5 i586 / egcs 2.91.66 / (netbsd-1-5 from Jan) netbsd FAILED the geometry test, diff attached, dunno if its critical or not. -- marko *** ./expected/geometry-positive-zeros.out Wed Mar 21 15:07:12 2001 --- ./results/geometry.out Wed Mar 21 20:15:58 2001 *** *** 443,454 FROM CIRCLE_TBL; six | polygon -+- ! | ((-3,0),(-2.59807621135076,1.500442),(-1.499116,2.59807621135842),(1.53102359017709e-11,3),(1.501768,2.59807621134311),(2.59807621136607,1.49779),(3,-3.06204718035418e-11),(2.59807621133545,-1.503094),(1.496464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.50442,-2.5980762113278),(-2.59807621138138,-1.495138)) | ((-99,2),(-85.6025403783588,52.01473),(-48.97054,88.602540378614),(1.051034,102),(51.05893,88.6025403781036),(87.6025403788692,51.92634),(101,1.897932),(87.6025403778485,-48.10313),(50.88214,-84.6025403791243),(0.8468976,-98),(-49.14732,-84.6025403775933),(-85.6025403793795,-47.83795)) | ((-4,3),(-3.33012701891794,5.500737),(-1.498527,7.3301270189307),(1.002552,8),(3.502946,7.33012701890518),(5.33012701894346,5.496317),(6,2.994897),(5.33012701889242,0.4948437),(3.494107,-1.33012701895622),(0.9923449,-2),(-1.507366,-1.33012701887967),(-3.33012701896897,0.5081028)) | ((-2,2),(-1.59807621135076,3.500442),(-0.4991161,4.59807621135842),(1.001531,5),(2.501768,4.59807621134311),(3.59807621136607,3.49779),(4,1.996938),(3.59807621133545,0.4969062),(2.496464,-0.598076211373729),(0.9954069,-1),(-0.5044197,-0.598076211327799),(-1.59807621138138,0.5048616)) | ((90,200),(91.3397459621641,205.0015),(95.00295,208.660254037861),(100.0051,210),(105.0059,208.66025403781),(108.660254037887,204.9926),(110,199.9898),(108.660254037785,194.9897),(104.9882,191.339745962088),(99.98469,190),(94.98527,191.339745962241),(91.3397459620621,195.0162)) ! | ((0,0),(13.3974596216412,50.01473),(50.02946,86.602540378614),(100.051,100),(150.0589,86.6025403781036),(186.602540378869,49.92634),(200,-1.02068239345139e-09),(186.602540377848,-50.10313),(149.8821,-86.6025403791243),(99.8469,-100),(49.85268,-86.6025403775933),(13.3974596206205,-49.83795)) (6 rows) -- convert the circle to an 8-point polygon --- 443,454 FROM CIRCLE_TBL; six | polygon -+- ! | ((-3,0),(-2.59807621135076,1.500442),(-1.499116,2.59807621135842),(1.53102359078377e-11,3),(1.501768,2.59807621134311),(2.59807621136607,1.49779),(3,-3.06204718156754e-11),(2.59807621133545,-1.503094),(1.496464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.50442,-2.5980762113278),(-2.59807621138138,-1.495138)) | ((-99,2),(-85.6025403783588,52.01473),(-48.97054,88.602540378614),(1.051034,102),(51.05893,88.6025403781036),(87.6025403788692,51.92634),(101,1.897932),(87.6025403778485,
[HACKERS] Call for platforms
Results of 'make check': NetBSD-1.5/i386 one spurious floating point test failure (mail sent to postgresql-bugs with details) NetBSD_1.5/alphaall tests passed NetBSD-1.4.2/i386 four tests fail timestamp... FAILED abstime ... FAILED tinterval... FAILED test horology ... FAILED I'll look into the 1.4.2 failures when/if I get time. If anyone wants the test output to examine please ask. Regards, Giles ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for platforms (linux 2.4.x ?)
On Thu, Mar 22, 2001 at 12:31:03PM +1200, Franck Martin wrote: > I see nobody did a test of 7.1 on Linux 2.4.x ? > > Would be nice to certify it is running on kernel 2.4.x as they claim this > is entreprise strength kernel... I've been running the 7.1 betas on 2.4 for weeks without any problems. I replied to the "call for platforms" e-mail, but it looks like it got lost in the avalanche. I'll run the regression tests with the latest CVS snapshot and submit a report to the list. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms
Tatsuo Ishii <[EMAIL PROTECTED]> writes: >> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > ! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory > ! pqReadData() -- backend closed the channel unexpectedly. >> >> Is it possible you ran out of disk space? > Probably not. The reason I was speculating that was that it seems pretty unlikely that a write() call could return ENOENT, as the above appears to suggest. I think that the errno = ENOENT value was not set by write(), but is leftover from the expected failure of BasicOpenFile earlier in XLogFileInit. Probably write() returned some value less than BLCKSZ but more than zero, and so did not set errno. Offhand the only reason I can think of for a write to a disk file to terminate after a partial transfer is a full disk. What do you think? regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
* Tom Lane <[EMAIL PROTECTED]> [010321 21:29]: > Tatsuo Ishii <[EMAIL PROTECTED]> writes: > >> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > ! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory > > ! pqReadData() -- backend closed the channel unexpectedly. > >> > >> Is it possible you ran out of disk space? > > > Probably not. > > The reason I was speculating that was that it seems pretty unlikely > that a write() call could return ENOENT, as the above appears to > suggest. I think that the errno = ENOENT value was not set by write(), > but is leftover from the expected failure of BasicOpenFile earlier in > XLogFileInit. Probably write() returned some value less than BLCKSZ > but more than zero, and so did not set errno. > > Offhand the only reason I can think of for a write to a disk file > to terminate after a partial transfer is a full disk. What do you > think? What about hitting a quota? LER > > regards, tom lane > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms (linux 2.4.x ?)
Franck Martin <[EMAIL PROTECTED]> writes: > Would be nice to certify it is running on kernel 2.4.x as they claim this > is entreprise strength kernel... Lamar, if you send me your SRPM I can do that... -- Trond Eivind Glomsrød Red Hat, Inc. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms (linux 2.4.x ?)
I see nobody did a test of 7.1 on Linux 2.4.x ? Would be nice to certify it is running on kernel 2.4.x as they claim this is entreprise strength kernel... Cheers. Thomas Lockhart wrote: > > > AIX 4.3.2 RS6000 7.0 2000-04-05, Andreas Zeugswetter > Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry > IRIX 6.5.6f MIPS 6.5.3 2000-02-18, Kevin Wheatley > Linux 2.2.x armv4l 7.0 2000-04-17, Mark Knox > Linux 2.0.x MIPS 7.0 2000-04-13, Tatsuo Ishii > mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii > NetBSD 1.4 arm32 7.0 2000-04-08, Patrick Welche > NetBSD 1.4U x867.0 2000-03-26, Patrick Welche > NetBSD m68k7.0 2000-04-10, Henry B. Hotz > NetBSD Sparc 7.0 2000-04-13, Tom I. Helbekkmo > QNX 4.25 x86 7.0 2000-04-01, Dr. Andreas Kardos > SCO OpenServer 5 x86 6.5 1999-05-25, Andrew Merrill > Solaris x867.0 2000-04-12, Marc Fournier > Solaris 2.5.1-2.7 Sparc 7.0 2000-04-12, Peter Eisentraut > SunOS 4.1.4 Sparc 7.0 2000-04-13, Tatsuo Ishii > Windows/Win32 x86 7.0 2000-04-02, Magnus Hagander (clients only) > WinNT/Cygwin x86 7.0 2000-03-30, Daniel Horak > > BeOS 5.0.3 x86 7.1 2000-12-18, Cyril Velter > BSDI 4.01 x86 7.1 2001-03-19, Bruce Momjian > FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber > HPUX 10.20 PA-RISC 7.1 2001-03-19, Tom Lane > IBMS/390 7.1 2000-11-17, Neale Ferguson > Linux 2.2.x Alpha 7.1 2001-01-23, Ryan Kirkpatrick > Linux 2.2.16 x86 7.1 2001-03-19, Thomas Lockhart > Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick > LinuxPPC G37.1 2001-03-19, Tom Lane > SCO UnixWare 7.1.1 x86 7.1 2001-03-19, Larry Rosenman > MacOS-X Darwin PowerPC 7.1 2000-12-11, Peter Bierman > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Call for platforms
Hi, I am currently testing beta6 on AIX 4.3.3 on a RS6000 H80 with 4 cpu and 4 Go RAM I use : ./configure --with-CC=/usr/local/bin/gcc --with-includes=/usr/local/include --with-libraries=/usr/local/lib All seem to be ok, There just the geometry failure in regression test (following the AIX FAQ it's normal ?) But when I configure with --with-perl I have the following error : make[4]: cc : Command not found Any idea ? Gilles DAROLD > Hi, > > I reported Linux RedHat 6.2 - 2.2.14-5.0smp #1 SMP Tue Mar 7 21:01:40 EST > 2000 i686 > 2 cpu - 1Go RAM > > Gilles DAROLD > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
Hi, I reported Linux RedHat 6.2 - 2.2.14-5.0smp #1 SMP Tue Mar 7 21:01:40 EST 2000 i686 2 cpu - 1Go RAM Gilles DAROLD ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Call for platforms
> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > ! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory > > ! pqReadData() -- backend closed the channel unexpectedly. > > Is it possible you ran out of disk space? Probably not. -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > ! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory > ! pqReadData() -- backend closed the channel unexpectedly. Is it possible you ran out of disk space? regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms
> > mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii > > I got core dump while running the parallel regression test of beta6. > Will look at... > -- > Tatsuo Ishii VACUUM; ! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory ! pqReadData() -- backend closed the channel unexpectedly. maybe a bug related to Tom recently fixed? If so, I will try RC1... -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Call for platforms
> Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry We've got 7.0.3 and 7.1b4 running on Compaq Tru64 4.0G Alpha Will do the regression test once RC1 is out. Adriaan ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for platforms
> mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii I got core dump while running the parallel regression test of beta6. Will look at... -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for platforms
* Thomas Lockhart <[EMAIL PROTECTED]> [010320 20:04]: > OK, here is my current platform list taken from the -hackers list and > from Vince's web page. I'm sure I've missed at least a few reports, but > please confirm that platforms are actually running and passing > regression tests with recent betas or the latest release candidate. > > If a platform you are running on is not listed, make sure it gets > included! Platforms with reports for 7.0 risk being demoted to the "used > to be supported list", and platforms with reports for only 6.5 are on a > deathwatch, so be sure to speak up! Also, I've included names below to > remind us who helped last time, but feel free to report even if your > name is not already listed. FreeBSD 4.3-BETA (will be -RELEASE by the time we release) works too. I reported FreeBSD 4.[23]. LER > > I've separated out recent reports and put them at the end of the list. > Thanks in advance. > >- Thomas > > AIX 4.3.2 RS6000 7.0 2000-04-05, Andreas Zeugswetter > Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry > IRIX 6.5.6f MIPS 6.5.3 2000-02-18, Kevin Wheatley > Linux 2.2.x armv4l 7.0 2000-04-17, Mark Knox > Linux 2.0.x MIPS 7.0 2000-04-13, Tatsuo Ishii > mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii > NetBSD 1.4 arm32 7.0 2000-04-08, Patrick Welche > NetBSD 1.4U x867.0 2000-03-26, Patrick Welche > NetBSD m68k7.0 2000-04-10, Henry B. Hotz > NetBSD Sparc 7.0 2000-04-13, Tom I. Helbekkmo > QNX 4.25 x86 7.0 2000-04-01, Dr. Andreas Kardos > SCO OpenServer 5 x86 6.5 1999-05-25, Andrew Merrill > Solaris x867.0 2000-04-12, Marc Fournier > Solaris 2.5.1-2.7 Sparc 7.0 2000-04-12, Peter Eisentraut > SunOS 4.1.4 Sparc 7.0 2000-04-13, Tatsuo Ishii > Windows/Win32 x86 7.0 2000-04-02, Magnus Hagander (clients only) > WinNT/Cygwin x86 7.0 2000-03-30, Daniel Horak > > BeOS 5.0.3 x86 7.1 2000-12-18, Cyril Velter > BSDI 4.01 x86 7.1 2001-03-19, Bruce Momjian > FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber > HPUX 10.20 PA-RISC 7.1 2001-03-19, Tom Lane > IBMS/390 7.1 2000-11-17, Neale Ferguson > Linux 2.2.x Alpha 7.1 2001-01-23, Ryan Kirkpatrick > Linux 2.2.16 x86 7.1 2001-03-19, Thomas Lockhart > Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick > LinuxPPC G37.1 2001-03-19, Tom Lane > SCO UnixWare 7.1.1 x86 7.1 2001-03-19, Larry Rosenman > MacOS-X Darwin PowerPC 7.1 2000-12-11, Peter Bierman > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Call for platforms
OK, here is my current platform list taken from the -hackers list and from Vince's web page. I'm sure I've missed at least a few reports, but please confirm that platforms are actually running and passing regression tests with recent betas or the latest release candidate. If a platform you are running on is not listed, make sure it gets included! Platforms with reports for 7.0 risk being demoted to the "used to be supported list", and platforms with reports for only 6.5 are on a deathwatch, so be sure to speak up! Also, I've included names below to remind us who helped last time, but feel free to report even if your name is not already listed. I've separated out recent reports and put them at the end of the list. Thanks in advance. - Thomas AIX 4.3.2 RS6000 7.0 2000-04-05, Andreas Zeugswetter Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry IRIX 6.5.6f MIPS 6.5.3 2000-02-18, Kevin Wheatley Linux 2.2.x armv4l 7.0 2000-04-17, Mark Knox Linux 2.0.x MIPS 7.0 2000-04-13, Tatsuo Ishii mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii NetBSD 1.4 arm32 7.0 2000-04-08, Patrick Welche NetBSD 1.4U x867.0 2000-03-26, Patrick Welche NetBSD m68k7.0 2000-04-10, Henry B. Hotz NetBSD Sparc 7.0 2000-04-13, Tom I. Helbekkmo QNX 4.25 x86 7.0 2000-04-01, Dr. Andreas Kardos SCO OpenServer 5 x86 6.5 1999-05-25, Andrew Merrill Solaris x867.0 2000-04-12, Marc Fournier Solaris 2.5.1-2.7 Sparc 7.0 2000-04-12, Peter Eisentraut SunOS 4.1.4 Sparc 7.0 2000-04-13, Tatsuo Ishii Windows/Win32 x86 7.0 2000-04-02, Magnus Hagander (clients only) WinNT/Cygwin x86 7.0 2000-03-30, Daniel Horak BeOS 5.0.3 x86 7.1 2000-12-18, Cyril Velter BSDI 4.01 x86 7.1 2001-03-19, Bruce Momjian FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber HPUX 10.20 PA-RISC 7.1 2001-03-19, Tom Lane IBMS/390 7.1 2000-11-17, Neale Ferguson Linux 2.2.x Alpha 7.1 2001-01-23, Ryan Kirkpatrick Linux 2.2.16 x86 7.1 2001-03-19, Thomas Lockhart Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick LinuxPPC G37.1 2001-03-19, Tom Lane SCO UnixWare 7.1.1 x86 7.1 2001-03-19, Larry Rosenman MacOS-X Darwin PowerPC 7.1 2000-12-11, Peter Bierman ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html