Re: Call for platforms - Mailing list pgsql-hackers

> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> >> Tatsuo Ishii <t-ishii@sra.co.jp> 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 ('99999999'); 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      |   99999999      |          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      | 99999999      |        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       |   99999999       |          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       | 99999999       |        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       |   99999999
! (4 rows)  SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234';  three |     f1     
! -------+------------        |       1235
-        | 4294966256        |   99999999
! (3 rows)  DROP TABLE OID_TBL;
--- 56,72 ----  SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234';  four |    f1    
! ------+----------       |     1234       |     1235       | 99999999
! (3 rows)  SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234';  three |    f1    
! -------+----------        |     1235        | 99999999
! (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.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
    |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
!      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081027))
    |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
    |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
--- 445,451 ----
-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
    |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
!      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
    |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
    |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))

======================================================================