Regression failures on freebsd

Started by Christopher Kings-Lynnealmost 21 years ago4 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au
2 attachment(s)

I did 'gmake distclean' and rebuild and I still get the attached failures.

Chris

Attachments:

regression.outtext/plain; name=regression.outDownload
regression.diffstext/plain; name=regression.diffsDownload
*** ./expected/triggers.out	Wed Oct 13 09:22:31 2004
--- ./results/triggers.out	Thu Apr 14 09:38:13 2005
***************
*** 307,315 ****
  NOTICE:  trigger_func() called: action = UPDATE, when = AFTER, level = STATEMENT
  -- COPY should fire per-row and per-statement INSERT triggers
  COPY main_table (a, b) FROM stdin;
  NOTICE:  trigger_func() called: action = INSERT, when = BEFORE, level = STATEMENT
  NOTICE:  trigger_func() called: action = INSERT, when = AFTER, level = STATEMENT
- SELECT * FROM main_table ORDER BY a, b;
   a  | b  
  ----+----
    6 | 10
--- 307,315 ----
  NOTICE:  trigger_func() called: action = UPDATE, when = AFTER, level = STATEMENT
  -- COPY should fire per-row and per-statement INSERT triggers
  COPY main_table (a, b) FROM stdin;
+ SELECT * FROM main_table ORDER BY a, b;
  NOTICE:  trigger_func() called: action = INSERT, when = BEFORE, level = STATEMENT
  NOTICE:  trigger_func() called: action = INSERT, when = AFTER, level = STATEMENT
   a  | b  
  ----+----
    6 | 10

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

*** ./expected/copy2.out	Tue Mar 15 10:54:54 2005
--- ./results/copy2.out	Thu Apr 14 09:38:38 2005
***************
*** 34,51 ****
  ERROR:  column "d" specified more than once
  -- missing data: should fail
  COPY x from stdin;
- ERROR:  invalid input syntax for integer: ""
- CONTEXT:  COPY x, line 1, column a: ""
  COPY x from stdin;
- ERROR:  missing data for column "e"
- CONTEXT:  COPY x, line 1: "2000	230	23	23"
  COPY x from stdin;
- ERROR:  missing data for column "e"
- CONTEXT:  COPY x, line 1: "2001	231	\N	\N"
  -- extra data: should fail
  COPY x from stdin;
- ERROR:  extra data after last expected column
- CONTEXT:  COPY x, line 1: "2002	232	40	50	60	70	80"
  -- various COPY options: delimiters, oids, NULL string
  COPY x (b, c, d, e) from stdin with oids delimiter ',' null 'x';
  COPY x from stdin WITH DELIMITER AS ';' NULL AS '';
--- 34,43 ----

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

*** ./expected/domain.out	Tue Mar 15 10:54:54 2005
--- ./results/domain.out	Thu Apr 14 09:38:39 2005
***************
*** 39,46 ****
  INSERT INTO basictest values ('88', 'haha', 'short', '123.1212');    -- Truncate numeric
  -- Test copy
  COPY basictest (testvarchar) FROM stdin; -- fail
- ERROR:  value too long for type character varying(5)
- CONTEXT:  COPY basictest, line 1: "notsoshorttext"
  COPY basictest (testvarchar) FROM stdin;
  select * from basictest;
   testint4 | testtext | testvarchar | testnumeric 
--- 39,44 ----
***************
*** 126,137 ****
  INSERT INTO nulltest values ('a', 'b', 'c', NULL, 'd'); -- Good
  -- Test copy
  COPY nulltest FROM stdin; --fail
- ERROR:  domain dcheck does not allow null values
- CONTEXT:  COPY nulltest, line 1: "a	b	\N	d	\N"
  -- Last row is bad
  COPY nulltest FROM stdin;
- ERROR:  new row for relation "nulltest" violates check constraint "nulltest_col5_check"
- CONTEXT:  COPY nulltest, line 3: "a	b	c	\N	a"
  select * from nulltest;
   col1 | col2 | col3 | col4 | col5 
  ------+------+------+------+------
--- 124,131 ----

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

*** ./expected/alter_table.out	Tue Mar 15 10:54:54 2005
--- ./results/alter_table.out	Thu Apr 14 09:38:42 2005
***************
*** 844,851 ****
  copy test("........pg.dropped.1........") to stdout;
  ERROR:  column "........pg.dropped.1........" of relation "test" does not exist
  copy test from stdin;
- ERROR:  extra data after last expected column
- CONTEXT:  COPY test, line 1: "10	11	12"
  select * from test;
   b | c 
  ---+---
--- 844,849 ----

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

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: Christopher Kings-Lynne (#1)
Re: Regression failures on freebsd

On Thu, Apr 14, 2005 at 09:52:11AM +0800, Christopher Kings-Lynne wrote:

I did 'gmake distclean' and rebuild and I still get the attached failures.

Do you build in a separate directory? I do and I do have problems when
the grammars (main or plpgsql) get updated -- not sure why the derived
files from bison and flex don't get rebuilt. I just delete them by
hand. (The build directory I just rm -fr as a whole).

Yours doesn't seem like a problem in grammars, but who knows.

What I do is

cd $source_dir
for i in `find . -name .cvsignore`; do
pushd `dirname $i`
rm `cat .cvsignore`
popd
done

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Si quieres ser creativo, aprende el arte de perder el tiempo"

#3Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Alvaro Herrera (#2)
Re: Regression failures on freebsd

Do you build in a separate directory? I do and I do have problems when
the grammars (main or plpgsql) get updated -- not sure why the derived
files from bison and flex don't get rebuilt. I just delete them by
hand. (The build directory I just rm -fr as a whole).

Yours doesn't seem like a problem in grammars, but who knows.

No, I do a normal in-place build.

Chris

#4Michael Fuhr
mike@fuhr.org
In reply to: Christopher Kings-Lynne (#1)
Re: Regression failures on freebsd

On Thu, Apr 14, 2005 at 09:52:11AM +0800, Christopher Kings-Lynne wrote:

I did 'gmake distclean' and rebuild and I still get the attached failures.

What versions of PostgreSQL and FreeBSD? The FreeBSD machines in
the buildfarm look good.

http://www.pgbuildfarm.org/cgi-bin/show_status.pl

If you're using CVS, have you tried with a fresh checkout? What
command do you run when you update? If you have a ~/.cvsrc, what's
in it? Do you update into a distclean'ed directory, or into one
that still has an old build in it?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/