Re: Regression tests of plain 7.0.2 fails
От | 100.179370@germanynet.de (Martin Jacobs) |
---|---|
Тема | Re: Regression tests of plain 7.0.2 fails |
Дата | |
Msg-id | m13j6tb-000QZUC@Schnecke.Windsbach.de обсуждение исходный текст |
Ответ на | Re: Regression tests of plain 7.0.2 fails (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Tom Lane schrieb: > 100.179370@germanynet.de (Martin Jacobs) writes: > > Ignoring the minor floatingpoint errors, the first annoying > > severe was in parallel group2 > > sequential test create_type ... FAILED > > > ERROR: TypeCreate: function 'widget_in(opaque)' does not exist > > Odd. Test create_function_1 did not fail? That's where the > function should get created. No, here is the complete run_check.out: parallel group1 (12 tests) ... boolean char name int2 text varchar float4 oid int4 int8 float8 numeric test boolean ... ok test char ... ok test name ... ok test varchar ... ok test text ... ok test int2 ... ok test int4 ... ok test int8 ... ok test oid ... ok test float4 ... ok test float8 ... ok test numeric ... ok sequential test strings ... ok sequential test numerology ... ok parallel group2 (15 tests) ... point lseg path box polygon reltime circle interval tinterval comments inet timestamp type_sanity opr_sanity oidjoins test point ... ok test lseg ... ok test box ... ok test path ... ok test polygon ... ok test circle ... ok test interval ... ok test timestamp ... ok test reltime ... ok test tinterval ... ok test inet ... ok test comments ... ok test oidjoins ... ok test type_sanity ... ok test opr_sanity ... ok sequential test abstime ... ok sequential test geometry ... FAILED sequential test horology ... ok sequential test create_function_1 ... ok sequential test create_type ... FAILED sequential test create_table ... ok sequential test create_function_2 ... ok sequential test copy ... ok parallel group3 (6 tests) ... constraints create_operator create_aggregate create_misc triggers create_index test constraints ... ok test triggers ... FAILED test create_misc ... ok test create_aggregate ... ok test create_operator ... FAILED test create_index ... FAILED sequential test create_view ... FAILED sequential test sanity_check ... ok sequential test errors ... ok sequential test select ... FAILED parallel group4 (16 tests) ... select_distinct select_distinct_on select_into select_having union aggregates select_implicit subselect case join transactionsrandom portals btree_index arrays hash_index test select_into ... ok test select_distinct ... FAILED test select_distinct_on ... FAILED test select_implicit ... ok test select_having ... ok test subselect ... ok test union ... ok test case ... ok test join ... ok test aggregates ... FAILED test transactions ... FAILED test random ... FAILED test portals ... FAILED test arrays ... ok test btree_index ... FAILED test hash_index ... FAILED sequential test misc ... ok parallel group5 (5 tests) ... select_views portals_p2 alter_table foreign_key rules test select_views ... FAILED test alter_table ... FAILED test portals_p2 ... FAILED test rules ... FAILED test foreign_key ... ok parallel group6 (3 tests) ... limit temp plpgsql test limit ... FAILED test plpgsql ... ok test temp ... ok> > > What platform are you using? It's a linux box, based on SuSE 5.3, kernel 2.0.38, gcc 2.95.2, libc.so.5.4.46, ... > > regards, tom lane > Maybe this is of help: here is src/postgresql-7.0.2/src/test/regress/output/create_function_1.source this file is dated Jan 9 2000: -- -- CREATE_FUNCTION_1 -- CREATE FUNCTION widget_in(opaque) RETURNS widget AS '_OBJWD_/regress_DLSUFFIX_' LANGUAGE 'c'; NOTICE: ProcedureCreate: type 'widget' is not yet defined CREATE FUNCTION widget_out(opaque) RETURNS opaque AS '_OBJWD_/regress_DLSUFFIX_' LANGUAGE 'c'; CREATE FUNCTION check_primary_key () RETURNS opaque AS '_OBJWD_/../../../contrib/spi/refint_DLSUFFIX_' LANGUAGE 'c'; CREATE FUNCTION check_foreign_key () RETURNS opaque AS '_OBJWD_/../../../contrib/spi/refint_DLSUFFIX_' LANGUAGE 'c'; CREATE FUNCTION autoinc () RETURNS opaque AS '_OBJWD_/../../../contrib/spi/autoinc_DLSUFFIX_' LANGUAGE 'c'; CREATE FUNCTION funny_dup17 () RETURNS opaque AS '_OBJWD_/regress_DLSUFFIX_' LANGUAGE 'c'; CREATE FUNCTION ttdummy () RETURNS opaque AS '_OBJWD_/regress_DLSUFFIX_' LANGUAGE 'c'; CREATE FUNCTION set_ttdummy (int4) RETURNS int4 AS '_OBJWD_/regress_DLSUFFIX_' LANGUAGE 'c'; The file src/postgresql-7.0.2/src/test/regress/results/create_type.out: -- -- CREATE_TYPE -- CREATE TYPE widget ( internallength = 24, input = widget_in, output = widget_out, alignment = double ); ERROR: TypeCreate: function 'widget_in(opaque)' does not exist CREATE TYPE city_budget ( internallength = 16, input = int44in, output = int44out, element = int4 ); I did not find a create_functions_1.out file in the results directory. Even doing a grep FUNCTION * fails. Did the create_funcion_1 script run? This is the results directory (output of ls -lt): -rw-r--r-- 1 postgres daemon 64999 Oct 10 21:53 plpgsql.out -rw-r--r-- 1 postgres daemon 773 Oct 10 21:53 temp.out -rw-r--r-- 1 postgres daemon 1867 Oct 10 21:53 limit.out -rw-r--r-- 1 postgres daemon 48851 Oct 10 21:53 rules.out -rw-r--r-- 1 postgres daemon 24796 Oct 10 21:52 foreign_key.out -rw-r--r-- 1 postgres daemon 5840 Oct 10 21:52 alter_table.out -rw-r--r-- 1 postgres daemon 5460 Oct 10 21:52 portals_p2.out -rw-r--r-- 1 postgres daemon 360 Oct 10 21:52 select_views.out -rw-r--r-- 1 postgres daemon 5506 Oct 10 21:52 case.out -rw-r--r-- 1 postgres daemon 8347 Oct 10 21:52 join.out -rw-r--r-- 1 postgres daemon 542 Oct 10 21:52 transactions.out -rw-r--r-- 1 postgres daemon 889 Oct 10 21:52 random.out -rw-r--r-- 1 postgres daemon 16622 Oct 10 21:52 portals.out -rw-r--r-- 1 postgres daemon 2413 Oct 10 21:52 arrays.out -rw-r--r-- 1 postgres daemon 1361 Oct 10 21:52 btree_index.out -rw-r--r-- 1 postgres daemon 3761 Oct 10 21:52 hash_index.out -rw-r--r-- 1 postgres daemon 4690 Oct 10 21:52 subselect.out -rw-r--r-- 1 postgres daemon 7586 Oct 10 21:52 select_implicit.out -rw-r--r-- 1 postgres daemon 1724 Oct 10 21:52 aggregates.out -rw-r--r-- 1 postgres daemon 3473 Oct 10 21:52 union.out -rw-r--r-- 1 postgres daemon 1144 Oct 10 21:52 select_having.out -rw-r--r-- 1 postgres daemon 190 Oct 10 21:52 select_into.out -rw-r--r-- 1 postgres daemon 945 Oct 10 21:52 select_distinct.out -rw-r--r-- 1 postgres daemon 626 Oct 10 21:52 select_distinct_on.out -rw-r--r-- 1 postgres daemon 7410 Oct 10 21:52 errors.out -rw-r--r-- 1 postgres daemon 3252 Oct 10 21:52 select.out -rw-r--r-- 1 postgres daemon 1367 Oct 10 21:52 sanity_check.out -rw-r--r-- 1 postgres daemon 641 Oct 10 21:52 create_view.out -rw-r--r-- 1 postgres daemon 3019 Oct 10 21:52 create_index.out -rw-r--r-- 1 postgres daemon 7841 Oct 10 21:52 triggers.out -rw-r--r-- 1 postgres daemon 6412 Oct 10 21:52 create_misc.out -rw-r--r-- 1 postgres daemon 502 Oct 10 21:52 create_aggregate.out -rw-r--r-- 1 postgres daemon 578 Oct 10 21:52 create_operator.out -rw-r--r-- 1 postgres daemon 3218 Oct 10 21:52 create_table.out -rw-r--r-- 1 postgres daemon 81756 Oct 10 21:52 horology.out -rw-r--r-- 1 postgres daemon 319 Oct 10 21:52 create_type.out -rw-r--r-- 1 postgres daemon 5863 Oct 10 21:52 abstime.out -rw-r--r-- 1 postgres daemon 21855 Oct 10 21:52 geometry.out -rw-r--r-- 1 postgres daemon 10972 Oct 10 21:52 oidjoins.out -rw-r--r-- 1 postgres daemon 22489 Oct 10 21:52 opr_sanity.out -rw-r--r-- 1 postgres daemon 6189 Oct 10 21:52 type_sanity.out -rw-r--r-- 1 postgres daemon 70533 Oct 10 21:52 timestamp.out -rw-r--r-- 1 postgres daemon 6832 Oct 10 21:52 inet.out -rw-r--r-- 1 postgres daemon 2342 Oct 10 21:51 circle.out -rw-r--r-- 1 postgres daemon 5680 Oct 10 21:51 interval.out -rw-r--r-- 1 postgres daemon 2751 Oct 10 21:51 reltime.out -rw-r--r-- 1 postgres daemon 8051 Oct 10 21:51 tinterval.out -rw-r--r-- 1 postgres daemon 660 Oct 10 21:51 comments.out -rw-r--r-- 1 postgres daemon 4715 Oct 10 21:51 box.out -rw-r--r-- 1 postgres daemon 4143 Oct 10 21:51 polygon.out -rw-r--r-- 1 postgres daemon 1245 Oct 10 21:51 lseg.out -rw-r--r-- 1 postgres daemon 2101 Oct 10 21:51 path.out -rw-r--r-- 1 postgres daemon 7841 Oct 10 21:51 point.out -rw-r--r-- 1 postgres daemon 3500 Oct 10 21:51 numerology.out -rw-r--r-- 1 postgres daemon 3116 Oct 10 21:51 strings.out -rw-r--r-- 1 postgres daemon 49002 Oct 10 21:51 numeric.out -rw-r--r-- 1 postgres daemon 6552 Oct 10 21:49 int4.out -rw-r--r-- 1 postgres daemon 11574 Oct 10 21:49 int8.out -rw-r--r-- 1 postgres daemon 8532 Oct 10 21:49 float8.out -rw-r--r-- 1 postgres daemon 1809 Oct 10 21:49 varchar.out -rw-r--r-- 1 postgres daemon 4811 Oct 10 21:49 int2.out -rw-r--r-- 1 postgres daemon 476 Oct 10 21:49 text.out -rw-r--r-- 1 postgres daemon 1314 Oct 10 21:49 oid.out -rw-r--r-- 1 postgres daemon 3980 Oct 10 21:49 float4.out -rw-r--r-- 1 postgres daemon 4884 Oct 10 21:49 boolean.out -rw-r--r-- 1 postgres daemon 3135 Oct 10 21:49 name.out -rw-r--r-- 1 postgres daemon 1966 Oct 10 21:49 char.out -rw-r--r-- 1 postgres daemon 468 Apr 27 1997 Makefile Any ideas? Martin Jacobs
В списке pgsql-general по дате отправления: