Re: parallel regression test failure

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: parallel regression test failure
Date: 2003-07-26 20:40:27
Message-ID: 200307262040.h6QKeRs16329@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-07-26 20:49:27 Re: I might be getting closer?
Previous Message Alvaro Herrera 2003-07-26 18:50:15 Re: granularity of locks in postgresql