Re: parallel regression test failure - Mailing list pgsql-hackers

That is a very good guess.  All the errors seem related to the parser.

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

Robert Creager wrote:
-- Start of PGP signed section.
> 
> Could the failures have something to do with bison level?  2003-02-01
> would not compile with 1.875, but compiles with 1.5.  Which is running
> now...
> 
> Later,
> Rob
> 
> On Sat, 26 Jul 2003 14:12:35 -0400 (EDT)
> Bruce Momjian <pgman@candle.pha.pa.us> said something like:
> 
> > 
> > I just reproduced the same failure for the same date.  Let me try
> > another date here.
> > 
> > ---------------------------------------------------------------------
> > ------
> > 
> > Robert Creager wrote:
> > -- Start of PGP signed section.
> > > On Sat, 26 Jul 2003 11:09:54 -0400 (EDT)
> > > Bruce Momjian <pgman@candle.pha.pa.us> said something like:
> > > 
> > > > 
> > > > I think you just take a CVS checkout and to:
> > > > 
> > > >     cvs update -D '2003-05-01 00:00:00 GMT' pgsql
> > > > 
> > > > and keep changing the dates to find the date it started breaking.
> > > > 
> > > 
> > > I just want to make sure I'm not chasing my tail.
> > > 
> > > I just went to 2002-12-01 in an empty directory, and had the
> > > following failures:
> > > 
> > > *** ./expected/strings.out    Sun Sep 22 11:27:25 2002
> > > --- ./results/strings.out    Sat Jul 26 11:20:22 2003
> > > ***************
> > > *** 18,24 ****
> > >   ' - next line' /* this comment is not allowed here */
> > >   ' - third line'
> > >       AS "Illegal comment within continuation";
> > > ! ERROR:  parser: parse error at or near "' - third line'" at
> > > character 75
> > >   --
> > >   -- test conversions between various string types
> > >   -- E021-10 implicit casting among the character data types
> > > --- 18,24 ----
> > >   ' - next line' /* this comment is not allowed here */
> > >   ' - third line'
> > >       AS "Illegal comment within continuation";
> > > ! ERROR:  parser: syntax error at or near "' - third line'" at
> > > character 75
> > >   --
> > >   -- test conversions between various string types
> > >   -- E021-10 implicit casting among the character data types
> > > 
> > > ===================================================================
> > > ===
> > > 
> > > *** ./expected/geometry.out    Fri Nov  8 13:09:55 2002
> > > --- ./results/geometry.out    Sat Jul 26 11:20:23 2003
> > > ***************
> > > *** 258,281 ****
> > >    twenty |                               rotation                  
> > >                
> > >   --------+--------------------------------------------------------
> > >   --------------
> > >           | (0,-0),(-0.2,-0.2)
> > > -         | (-0.1,-0.1),(-0.3,-0.3)
> > > -         | (-0.25,-0.25),(-0.25,-0.35)
> > > -         | (-0.3,-0.3),(-0.3,-0.3)
> > >           | (0.08,-0),(0,-0.56)
> > > -         | (0.12,-0.28),(0.04,-0.84)
> > > -         | (0.26,-0.7),(0.1,-0.82)
> > > -         | (0.12,-0.84),(0.12,-0.84)
> > >           | (0.0651176557644,0),(0,-0.0483449262493)
> > > -         |
> > > (0.0976764836466,-0.0241724631247),(0.0325588278822,-0.072517389374
> > > )-         |
> > > (0.109762715209,-0.0562379754329),(0.0813970697055,-0.0604311578117
> > > )-         |
> > > (0.0976764836466,-0.072517389374),(0.0976764836466,-0.072517389374)
> > >           | (-0,0.0828402366864),(-0.201183431953,0)
> > > -         |
> > > (-0.100591715976,0.12426035503),(-0.301775147929,0.0414201183432)-  
> > >       |
> > >       (-0.251479289941,0.103550295858),(-0.322485207101,0.073964497
> > >       0414)
> > > -         |
> > > (-0.301775147929,0.12426035503),(-0.301775147929,0.12426035503)
> > >           | (0.2,0),(0,0)
> > >           | (0.3,0),(0.1,0)
> > >           | (0.3,0.05),(0.25,0)
> > >           | (0.3,0),(0.3,0)
> > >   (20 rows)
> > >   
> > > --- 258,281 ----
> > >    twenty |                               rotation                  
> > >                
> > >   --------+--------------------------------------------------------
> > >   --------------
> > >           | (0,-0),(-0.2,-0.2)
> > >           | (0.08,-0),(0,-0.56)
> > >           | (0.0651176557644,0),(0,-0.0483449262493)
> > >           | (-0,0.0828402366864),(-0.201183431953,0)
> > >           | (0.2,0),(0,0)
> > > +         | (-0.1,-0.1),(-0.3,-0.3)
> > > +         | (0.12,-0.28),(0.04,-0.84)
> > > +         |
> > > (0.0976764836466,-0.0241724631247),(0.0325588278822,-0.072517389374
> > > )+         |
> > > (-0.100591715976,0.12426035503),(-0.301775147929,0.0414201183432)
> > >           | (0.3,0),(0.1,0)
> > > +         | (-0.25,-0.25),(-0.25,-0.35)
> > > +         | (0.26,-0.7),(0.1,-0.82)
> > > +         |
> > > (0.109762715209,-0.0562379754329),(0.0813970697055,-0.0604311578117
> > > )+         |
> > > (-0.251479289941,0.103550295858),(-0.322485207101,0.0739644970414)
> > >           | (0.3,0.05),(0.25,0)
> > > +         | (-0.3,-0.3),(-0.3,-0.3)
> > > +         | (0.12,-0.84),(0.12,-0.84)
> > > +         |
> > > (0.0976764836466,-0.072517389374),(0.0976764836466,-0.072517389374)+
> > >         |
> > >         (-0.301775147929,0.12426035503),(-0.301775147929,0.12426035
> > >         503)
> > >           | (0.3,0),(0.3,0)
> > >   (20 rows)
> > >   
> > > 
> > > ===================================================================
> > > ===
> > > 
> > > *** ./expected/create_function_1.out    Sat Jul 26 11:19:18 2003
> > > --- ./results/create_function_1.out    Sat Jul 26 11:20:24 2003
> > > ***************
> > > *** 51,57 ****
> > >   ERROR:  return type mismatch in function: declared to return
> > >   integer, returns "unknown" CREATE FUNCTION test1 (int) RETURNS int
> > >   LANGUAGE sql
> > >       AS 'not even SQL';
> > > ! ERROR:  parser: parse error at or near "not" at character 1
> > >   CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
> > >       AS 'SELECT 1, 2, 3;';
> > >   ERROR:  function declared to return integer returns multiple
> > >   columns in final SELECT
> > > --- 51,57 ----
> > >   ERROR:  return type mismatch in function: declared to return
> > >   integer, returns "unknown" CREATE FUNCTION test1 (int) RETURNS int
> > >   LANGUAGE sql
> > >       AS 'not even SQL';
> > > ! ERROR:  parser: syntax error at or near "not" at character 1
> > >   CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
> > >       AS 'SELECT 1, 2, 3;';
> > >   ERROR:  function declared to return integer returns multiple
> > >   columns in final SELECT
> > > 
> > > ===================================================================
> > > ===
> > > 
> > > *** ./expected/constraints.out    Sat Jul 26 11:19:18 2003
> > > --- ./results/constraints.out    Sat Jul 26 11:20:26 2003
> > > ***************
> > > *** 45,56 ****
> > >   -- syntax errors
> > >   --  test for extraneous comma
> > >   CREATE TABLE error_tbl (i int DEFAULT (100, ));
> > > ! ERROR:  parser: parse error at or near "," at character 43
> > >   --  this will fail because gram.y uses b_expr not a_expr for
> > >   defaults,--  to avoid a shift/reduce conflict that arises from NOT
> > >   NULL being--  part of the column definition syntax:
> > >   CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
> > > ! ERROR:  parser: parse error at or near "IN" at character 43
> > >   --  this should work, however:
> > >   CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
> > >   DROP TABLE error_tbl;
> > > --- 45,56 ----
> > >   -- syntax errors
> > >   --  test for extraneous comma
> > >   CREATE TABLE error_tbl (i int DEFAULT (100, ));
> > > ! ERROR:  parser: syntax error at or near "," at character 43
> > >   --  this will fail because gram.y uses b_expr not a_expr for
> > >   defaults,--  to avoid a shift/reduce conflict that arises from NOT
> > >   NULL being--  part of the column definition syntax:
> > >   CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
> > > ! ERROR:  parser: syntax error at or near "IN" at character 43
> > >   --  this should work, however:
> > >   CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
> > >   DROP TABLE error_tbl;
> > > 
> > > ===================================================================
> > > ===
> > > 
> > > *** ./expected/errors.out    Mon Sep  2 00:05:16 2002
> > > --- ./results/errors.out    Sat Jul 26 11:20:28 2003
> > > ***************
> > > *** 22,34 ****
> > >    
> > >   -- missing relation name 
> > >   select;
> > > ! ERROR:  parser: parse error at or near ";" at character 7
> > >   -- no such relation 
> > >   select * from nonesuch;
> > >   ERROR:  Relation "nonesuch" does not exist
> > >   -- missing target list
> > >   select from pg_database;
> > > ! ERROR:  parser: parse error at or near "from" at character 8
> > >   -- bad name in target list
> > >   select nonesuch from pg_database;
> > >   ERROR:  Attribute "nonesuch" not found
> > > --- 22,34 ----
> > >    
> > >   -- missing relation name 
> > >   select;
> > > ! ERROR:  parser: syntax error at or near ";" at character 7
> > >   -- no such relation 
> > >   select * from nonesuch;
> > >   ERROR:  Relation "nonesuch" does not exist
> > >   -- missing target list
> > >   select from pg_database;
> > > ! ERROR:  parser: syntax error at or near "from" at character 8
> > >   -- bad name in target list
> > >   select nonesuch from pg_database;
> > >   ERROR:  Attribute "nonesuch" not found
> > > ***************
> > > *** 40,46 ****
> > >   ERROR:  Attribute "nonesuch" not found
> > >   -- bad select distinct on syntax, distinct attribute missing
> > >   select distinct on (foobar) from pg_database;
> > > ! ERROR:  parser: parse error at or near "from" at character 29
> > >   -- bad select distinct on syntax, distinct attribute not in target
> > >   list select distinct on (foobar) * from pg_database;
> > >   ERROR:  Attribute "foobar" not found
> > > --- 40,46 ----
> > >   ERROR:  Attribute "nonesuch" not found
> > >   -- bad select distinct on syntax, distinct attribute missing
> > >   select distinct on (foobar) from pg_database;
> > > ! ERROR:  parser: syntax error at or near "from" at character 29
> > >   -- bad select distinct on syntax, distinct attribute not in target
> > >   list select distinct on (foobar) * from pg_database;
> > >   ERROR:  Attribute "foobar" not found
> > > ***************
> > > *** 49,55 ****
> > >    
> > >   -- missing relation name (this had better not wildcard!) 
> > >   delete from;
> > > ! ERROR:  parser: parse error at or near ";" at character 12
> > >   -- no such relation 
> > >   delete from nonesuch;
> > >   ERROR:  Relation "nonesuch" does not exist
> > > --- 49,55 ----
> > >    
> > >   -- missing relation name (this had better not wildcard!) 
> > >   delete from;
> > > ! ERROR:  parser: syntax error at or near ";" at character 12
> > >   -- no such relation 
> > >   delete from nonesuch;
> > >   ERROR:  Relation "nonesuch" does not exist
> > > ***************
> > > *** 58,64 ****
> > >    
> > >   -- missing relation name (this had better not wildcard!) 
> > >   drop table;
> > > ! ERROR:  parser: parse error at or near ";" at character 11
> > >   -- no such relation 
> > >   drop table nonesuch;
> > >   ERROR:  table "nonesuch" does not exist
> > > --- 58,64 ----
> > >    
> > >   -- missing relation name (this had better not wildcard!) 
> > >   drop table;
> > > ! ERROR:  parser: syntax error at or near ";" at character 11
> > >   -- no such relation 
> > >   drop table nonesuch;
> > >   ERROR:  table "nonesuch" does not exist
> > > ***************
> > > *** 68,74 ****
> > >   -- relation renaming 
> > >   -- missing relation name 
> > >   alter table rename;
> > > ! ERROR:  parser: parse error at or near ";" at character 19
> > >   -- no such relation 
> > >   alter table nonesuch rename to newnonesuch;
> > >   ERROR:  Relation "nonesuch" does not exist
> > > --- 68,74 ----
> > >   -- relation renaming 
> > >   -- missing relation name 
> > >   alter table rename;
> > > ! ERROR:  parser: syntax error at or near ";" at character 19
> > >   -- no such relation 
> > >   alter table nonesuch rename to newnonesuch;
> > >   ERROR:  Relation "nonesuch" does not exist
> > > ***************
> > > *** 122,131 ****
> > >    
> > >   -- missing index name 
> > >   drop index;
> > > ! ERROR:  parser: parse error at or near ";" at character 11
> > >   -- bad index name 
> > >   drop index 314159;
> > > ! ERROR:  parser: parse error at or near "314159" at character 12
> > >   -- no such index 
> > >   drop index nonesuch;
> > >   ERROR:  index "nonesuch" does not exist
> > > --- 122,131 ----
> > >    
> > >   -- missing index name 
> > >   drop index;
> > > ! ERROR:  parser: syntax error at or near ";" at character 11
> > >   -- bad index name 
> > >   drop index 314159;
> > > ! ERROR:  parser: syntax error at or near "314159" at character 12
> > >   -- no such index 
> > >   drop index nonesuch;
> > >   ERROR:  index "nonesuch" does not exist
> > > ***************
> > > *** 134,146 ****
> > >    
> > >   -- missing aggregate name 
> > >   drop aggregate;
> > > ! ERROR:  parser: parse error at or near ";" at character 15
> > >   -- missing aggregate type
> > >   drop aggregate newcnt1;
> > > ! ERROR:  parser: parse error at or near ";" at character 23
> > >   -- bad aggregate name 
> > >   drop aggregate 314159 (int);
> > > ! ERROR:  parser: parse error at or near "314159" at character 16
> > >   -- bad aggregate type
> > >   drop aggregate newcnt (nonesuch);
> > >   ERROR:  Type "nonesuch" does not exist
> > > --- 134,146 ----
> > >    
> > >   -- missing aggregate name 
> > >   drop aggregate;
> > > ! ERROR:  parser: syntax error at or near ";" at character 15
> > >   -- missing aggregate type
> > >   drop aggregate newcnt1;
> > > ! ERROR:  parser: syntax error at or near ";" at character 23
> > >   -- bad aggregate name 
> > >   drop aggregate 314159 (int);
> > > ! ERROR:  parser: syntax error at or near "314159" at character 16
> > >   -- bad aggregate type
> > >   drop aggregate newcnt (nonesuch);
> > >   ERROR:  Type "nonesuch" does not exist
> > > ***************
> > > *** 155,164 ****
> > >    
> > >   -- missing function name 
> > >   drop function ();
> > > ! ERROR:  parser: parse error at or near "(" at character 15
> > >   -- bad function name 
> > >   drop function 314159();
> > > ! ERROR:  parser: parse error at or near "314159" at character 15
> > >   -- no such function 
> > >   drop function nonesuch();
> > >   ERROR:  RemoveFunction: function nonesuch() does not exist
> > > --- 155,164 ----
> > >    
> > >   -- missing function name 
> > >   drop function ();
> > > ! ERROR:  parser: syntax error at or near "(" at character 15
> > >   -- bad function name 
> > >   drop function 314159();
> > > ! ERROR:  parser: syntax error at or near "314159" at character 15
> > >   -- no such function 
> > >   drop function nonesuch();
> > >   ERROR:  RemoveFunction: function nonesuch() does not exist
> > > ***************
> > > *** 167,176 ****
> > >    
> > >   -- missing type name 
> > >   drop type;
> > > ! ERROR:  parser: parse error at or near ";" at character 10
> > >   -- bad type name 
> > >   drop type 314159;
> > > ! ERROR:  parser: parse error at or near "314159" at character 11
> > >   -- no such type 
> > >   drop type nonesuch;
> > >   ERROR:  Type "nonesuch" does not exist
> > > --- 167,176 ----
> > >    
> > >   -- missing type name 
> > >   drop type;
> > > ! ERROR:  parser: syntax error at or near ";" at character 10
> > >   -- bad type name 
> > >   drop type 314159;
> > > ! ERROR:  parser: syntax error at or near "314159" at character 11
> > >   -- no such type 
> > >   drop type nonesuch;
> > >   ERROR:  Type "nonesuch" does not exist
> > > ***************
> > > *** 179,200 ****
> > >    
> > >   -- missing everything 
> > >   drop operator;
> > > ! ERROR:  parser: parse error at or near ";" at character 14
> > >   -- bad operator name 
> > >   drop operator equals;
> > > ! ERROR:  parser: parse error at or near ";" at character 21
> > >   -- missing type list 
> > >   drop operator ===;
> > > ! ERROR:  parser: parse error at or near ";" at character 18
> > >   -- missing parentheses 
> > >   drop operator int4, int4;
> > > ! ERROR:  parser: parse error at or near "," at character 19
> > >   -- missing operator name 
> > >   drop operator (int4, int4);
> > > ! ERROR:  parser: parse error at or near "(" at character 15
> > >   -- missing type list contents 
> > >   drop operator === ();
> > > ! ERROR:  parser: parse error at or near ")" at character 20
> > >   -- no such operator 
> > >   drop operator === (int4);
> > >   ERROR:  parser: argument type missing (use NONE for unary
> > >   operators)
> > > --- 179,200 ----
> > >    
> > >   -- missing everything 
> > >   drop operator;
> > > ! ERROR:  parser: syntax error at or near ";" at character 14
> > >   -- bad operator name 
> > >   drop operator equals;
> > > ! ERROR:  parser: syntax error at or near ";" at character 21
> > >   -- missing type list 
> > >   drop operator ===;
> > > ! ERROR:  parser: syntax error at or near ";" at character 18
> > >   -- missing parentheses 
> > >   drop operator int4, int4;
> > > ! ERROR:  parser: syntax error at or near "," at character 19
> > >   -- missing operator name 
> > >   drop operator (int4, int4);
> > > ! ERROR:  parser: syntax error at or near "(" at character 15
> > >   -- missing type list contents 
> > >   drop operator === ();
> > > ! ERROR:  parser: syntax error at or near ")" at character 20
> > >   -- no such operator 
> > >   drop operator === (int4);
> > >   ERROR:  parser: argument type missing (use NONE for unary
> > >   operators)
> > > ***************
> > > *** 206,212 ****
> > >   ERROR:  parser: argument type missing (use NONE for unary
> > >   operators)-- no such type1 
> > >   drop operator = ( , int4);
> > > ! ERROR:  parser: parse error at or near "," at character 19
> > >   -- no such type1 
> > >   drop operator = (nonesuch, int4);
> > >   ERROR:  Type "nonesuch" does not exist
> > > --- 206,212 ----
> > >   ERROR:  parser: argument type missing (use NONE for unary
> > >   operators)-- no such type1 
> > >   drop operator = ( , int4);
> > > ! ERROR:  parser: syntax error at or near "," at character 19
> > >   -- no such type1 
> > >   drop operator = (nonesuch, int4);
> > >   ERROR:  Type "nonesuch" does not exist
> > > ***************
> > > *** 215,239 ****
> > >   ERROR:  Type "nonesuch" does not exist
> > >   -- no such type2 
> > >   drop operator = (int4, );
> > > ! ERROR:  parser: parse error at or near ")" at character 24
> > >   --
> > >   -- DROP RULE
> > >    
> > >   -- missing rule name 
> > >   drop rule;
> > > ! ERROR:  parser: parse error at or near ";" at character 10
> > >   -- bad rule name 
> > >   drop rule 314159;
> > > ! ERROR:  parser: parse error at or near "314159" at character 11
> > >   -- no such rule 
> > >   drop rule nonesuch on noplace;
> > >   ERROR:  Relation "noplace" does not exist
> > >   -- bad keyword 
> > >   drop tuple rule nonesuch;
> > > ! ERROR:  parser: parse error at or near "tuple" at character 6
> > >   -- no such rule 
> > >   drop instance rule nonesuch on noplace;
> > > ! ERROR:  parser: parse error at or near "instance" at character 6
> > >   -- no such rule 
> > >   drop rewrite rule nonesuch;
> > > ! ERROR:  parser: parse error at or near "rewrite" at character 6
> > > --- 215,239 ----
> > >   ERROR:  Type "nonesuch" does not exist
> > >   -- no such type2 
> > >   drop operator = (int4, );
> > > ! ERROR:  parser: syntax error at or near ")" at character 24
> > >   --
> > >   -- DROP RULE
> > >    
> > >   -- missing rule name 
> > >   drop rule;
> > > ! ERROR:  parser: syntax error at or near ";" at character 10
> > >   -- bad rule name 
> > >   drop rule 314159;
> > > ! ERROR:  parser: syntax error at or near "314159" at character 11
> > >   -- no such rule 
> > >   drop rule nonesuch on noplace;
> > >   ERROR:  Relation "noplace" does not exist
> > >   -- bad keyword 
> > >   drop tuple rule nonesuch;
> > > ! ERROR:  parser: syntax error at or near "tuple" at character 6
> > >   -- no such rule 
> > >   drop instance rule nonesuch on noplace;
> > > ! ERROR:  parser: syntax error at or near "instance" at character 6
> > >   -- no such rule 
> > >   drop rewrite rule nonesuch;
> > > ! ERROR:  parser: syntax error at or near "rewrite" at character 6
> > > 
> > > ===================================================================
> > > ===
> > > 
> > > 
> > > 
> > > -- 
> > >  11:22:06 up 8 days, 15:22,  2 users,  load average: 0.30, 0.51,
> > >  0.53
> > -- End of PGP section, PGP failed!
> > 
> > -- 
> >   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
> > 
> > 
> 
> 
> -- 
>  12:41:22 up 8 days, 16:42,  2 users,  load average: 2.58, 1.05, 0.97
-- End of PGP section, PGP failed!

--  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,
Pennsylvania19073