Re: [HACKERS] Current CVS parallel test lock
Do you have a way to revert to the old installation to check whether the checks fail again? It might be useful to track down exactly what happened. It seems wrong that a currently-installed version should have adverse effects on a just-built version's regression tests. No :) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Current CVS parallel test lock
On Wed, Mar 09, 2005 at 03:43:38PM +0800, Christopher Kings-Lynne wrote: Hrm, I just did a gmake install; gmake installcheck - that worked fine. Then I did gmake check again and now that works fine... It must have been picking up something from my previously installed pgsql. Do you have a way to revert to the old installation to check whether the checks fail again? It might be useful to track down exactly what happened. It seems wrong that a currently-installed version should have adverse effects on a just-built version's regression tests. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Current CVS parallel test lock
Michael Fuhr [EMAIL PROTECTED] writes: Do you have a way to revert to the old installation to check whether the checks fail again? It might be useful to track down exactly what happened. It seems wrong that a currently-installed version should have adverse effects on a just-built version's regression tests. We've seen that happen many times with shared library dependencies ... but libpq hasn't changed in the last few days AFAIR. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Current CVS parallel test lock
Do you have a way to revert to the old installation to check whether the checks fail again? It might be useful to track down exactly what happened. It seems wrong that a currently-installed version should have adverse effects on a just-built version's regression tests. We've seen that happen many times with shared library dependencies ... but libpq hasn't changed in the last few days AFAIR. I hadn't done a gmake install for months due to being overseas... Chris ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Current CVS parallel test lock
Running latest cvs on freebsd gives me errors in test strings and test errors, and completely hangs at this point: parallel group (14 tests): limit prepare sequence copy2 truncate rowtypes polymorphism temp domain conversion rangefuncs without_oid alter_table Chris parallel group (13 tests): text name varchar char oid boolean int2 int8 float4 int4 float8 bit numeric boolean ... ok char ... ok name ... ok varchar ... ok text ... ok int2 ... ok int4 ... ok int8 ... ok oid ... ok float4 ... ok float8 ... ok bit ... ok numeric ... ok test strings ... FAILED test numerology ... ok parallel group (20 tests): comments time lseg reltime path timetz abstime circle tinterval box point type_sanity polygon interval inet timestamp timestamptz date oidjoins opr_sanity point... ok lseg ... ok box ... ok path ... ok polygon ... ok circle ... ok date ... ok time ... ok timetz ... ok timestamp... ok timestamptz ... ok interval ... ok abstime ... ok reltime ... ok tinterval... ok inet ... ok comments ... ok oidjoins ... ok type_sanity ... ok opr_sanity ... ok test geometry ... ok test horology ... ok test insert ... ok test create_function_1... FAILED test create_type ... ok test create_table ... ok test create_function_2... ok test copy ... ok parallel group (7 tests): create_operator create_aggregate vacuum triggers constraints inherit create_misc constraints ... FAILED triggers ... ok create_misc ... ok create_aggregate ... ok create_operator ... ok inherit ... ok vacuum ... ok parallel group (2 tests): create_view create_index create_index ... ok create_view ... ok test sanity_check ... ok test errors ... FAILED test select ... ok parallel group (18 tests): select_distinct_on select_into update random namespace select_having select_distinct case select_implicit btree_index aggregates union subselect portals join arrays transactions hash_index select_into ... ok select_distinct ... ok select_distinct_on ... ok select_implicit ... ok select_having... ok subselect... ok union... ok case ... ok join ... ok aggregates ... ok transactions ... ok random ... ok portals ... ok arrays ... ok btree_index ... ok hash_index ... ok update ... ok namespace... ok test privileges ... ok test misc ... ok parallel group (5 tests): select_views portals_p2 cluster foreign_key rules select_views ... ok portals_p2 ... ok rules... ok foreign_key ... ok cluster ... ok parallel group (14 tests): limit prepare sequence copy2 truncate rowtypes polymorphism temp domain conversion rangefuncs without_oid alter_table*** ./expected/strings.out Sun Mar 14 12:25:17 2004 --- ./results/strings.out Wed Mar 9 14:48:33 2005 *** *** 19,26 ' - third line' AS Illegal comment within continuation; ERROR: syntax error at or near ' - third line' at character 75 - LINE 3: ' - third line' - ^ -- -- test conversions between various string types -- E021-10 implicit casting among the character data types --- 19,24 == *** ./expected/create_function_1.outThu Oct 21 11:12:15 2004 --- ./results/create_function_1.out Wed Mar 9 14:48:38 2005 *** *** 56,63 CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'not even SQL'; ERROR: syntax error at or near not at character 62 - LINE 2: AS 'not even SQL'; - ^ CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'SELECT 1, 2, 3;'; ERROR: return type mismatch in function declared to return integer --- 56,61 == *** ./expected/constraints.out Thu Oct 21 11:12:15 2004 ---
Re: [HACKERS] Current CVS parallel test lock
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Running latest cvs on freebsd gives me errors in test strings and test errors, and completely hangs at this point: Time for a clean rebuild? I've not seen any failures, neither has the build farm ... regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Current CVS parallel test lock
Christopher Kings-Lynne [EMAIL PROTECTED] Running latest cvs on freebsd gives me errors in test strings and test errors, and completely hangs at this point: I got a similar problem and system hangs randomly(esp. in test strings) in win32-mingw. The problem I found is in pgunlink(). There is a potential deadloop in while (unlink(path)) { ... } However, if we wait long enough( I waited for 20 mins or so), the system finally go on. I guess that's because of the hot-long-discussed win32's inability of removing file-in-use problem(though FILE_SHARE_DELETE flag is added). Shall we add a time-limit or something to handle this situation? parallel group (14 tests): limit prepare sequence copy2 truncate rowtypes polymorphism temp domain conversion rangefuncs without_oid alter_table Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Current CVS parallel test lock
Time for a clean rebuild? I've not seen any failures, neither has the build farm ... cvs up gmake clean ./configure --prefix=/home/chriskl/local --enable-depend --enable-debug --enable-cassert --with-perl --with-pam --with-openssl gmake check Still hangs. Gets new failure in create function and constraints. Seems to be differences in how it's indicating syntax errors. My src/bin/psql is in the 7_4_STABLE branch, but that shouldn't affect anything. Chris parallel group (13 tests): text name varchar char oid boolean int8 int2 float4 int4 float8 bit numeric boolean ... ok char ... ok name ... ok varchar ... ok text ... ok int2 ... ok int4 ... ok int8 ... ok oid ... ok float4 ... ok float8 ... ok bit ... ok numeric ... ok test strings ... FAILED test numerology ... ok parallel group (20 tests): comments time reltime path timetz circle point lseg box tinterval polygon inet abstime type_sanity interval timestamp date oidjoins timestamptz opr_sanity point... ok lseg ... ok box ... ok path ... ok polygon ... ok circle ... ok date ... ok time ... ok timetz ... ok timestamp... ok timestamptz ... ok interval ... ok abstime ... ok reltime ... ok tinterval... ok inet ... ok comments ... ok oidjoins ... ok type_sanity ... ok opr_sanity ... ok test geometry ... ok test horology ... ok test insert ... ok test create_function_1... FAILED test create_type ... ok test create_table ... ok test create_function_2... ok test copy ... ok parallel group (7 tests): create_operator create_aggregate constraints vacuum triggers inherit create_misc constraints ... FAILED triggers ... ok create_misc ... ok create_aggregate ... ok create_operator ... ok inherit ... ok vacuum ... ok parallel group (2 tests): create_view create_index create_index ... ok create_view ... ok test sanity_check ... ok test errors ... FAILED test select ... ok parallel group (18 tests): select_distinct_on select_into update random namespace select_having select_distinct btree_index case hash_index aggregates union select_implicit portals join arrays transactions subselect select_into ... ok select_distinct ... ok select_distinct_on ... ok select_implicit ... ok select_having... ok subselect... ok union... ok case ... ok join ... ok aggregates ... ok transactions ... ok random ... ok portals ... ok arrays ... ok btree_index ... ok hash_index ... ok update ... ok namespace... ok test privileges ... ok test misc ... ok parallel group (5 tests): portals_p2 select_views cluster foreign_key rules select_views ... ok portals_p2 ... ok rules... ok foreign_key ... ok cluster ... ok parallel group (14 tests): limit prepare sequence copy2 truncate polymorphism rowtypes temp rangefuncs conversion domain without_oid alter_table*** ./expected/strings.out Sun Mar 14 12:25:17 2004 --- ./results/strings.out Wed Mar 9 15:19:16 2005 *** *** 19,26 ' - third line' AS Illegal comment within continuation; ERROR: syntax error at or near ' - third line' at character 75 - LINE 3: ' - third line' - ^ -- -- test conversions between various string types -- E021-10 implicit casting among the character data types --- 19,24 == *** ./expected/create_function_1.outWed Mar 9 15:18:46 2005 --- ./results/create_function_1.out Wed Mar 9 15:19:21 2005 *** *** 56,63 CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'not even SQL'; ERROR: syntax error at or near not at character 62 - LINE 2: AS 'not even SQL'; - ^ CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'SELECT 1, 2, 3;'; ERROR: return type mismatch
Re: [HACKERS] Current CVS parallel test lock
On Wed, Mar 09, 2005 at 03:24:20PM +0800, Christopher Kings-Lynne wrote: gmake clean Have you tried gmake distclean? I just built the latest HEAD on FreeBSD 4.11-STABLE and all tests passed. Configure options were: ./configure --prefix=/usr/local/pgsql81 \ --with-pgport=5481 \ --with-openssl \ --with-perl \ --with-python \ --with-tcl \ --with-tclconfig=/usr/local/lib/tcl8.4 \ --enable-debug \ --enable-cassert -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Current CVS parallel test lock
Have you tried gmake distclean? I just built the latest HEAD on FreeBSD 4.11-STABLE and all tests passed. Configure options were: Hrm, I just did a gmake install; gmake installcheck - that worked fine. Then I did gmake check again and now that works fine... It must have been picking up something from my previously installed pgsql. Chris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly