Bugs item #2871426, was opened at 2009-10-01 19:58 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2871426&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" Status: Open Resolution: None Priority: 8 Private: No Submitted By: Stefan Manegold (stmane) Assigned to: Niels Nes (nielsnes) Summary: SQL: mclient-lsql-D fails everywhere but on 64-bit Fedora Initial Comment: Most probably since it addition, test sql/src/test/BugTracker-2009/Tests/mclient-lsql-D.SQL.sh fails on all platform except 64-bit Fedora. On all non-Fedora platform, it produces an error like " MAPI = mone...@build-x86-macosx:37561 ACTION= mapi_fetch_line QUERY = SELECT * FROM "sys"."n8" ERROR = Connection terminated MAPI = mone...@build-x86-macosx:37561 ACTION= mapi_query ERROR = Connection lost " cf., e.g., http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.32.32.d.1-Debian4.0/src_test_BugTracker-2009/mclient-lsql-D.err.00.html Additionally, (also on 32-bit Fedora, where no error occurs), it produce output of 12MB to 308MB(!) instead of the expected 3kB output: -rw-r--r-- 1 monet monet 3.0K 2009-10-01 02:07 .GNU.64.64.d.0-Fedora10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 3.0K 2009-10-01 01:46 .Int.64.64.d.1-Fedora10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 3.0K 2009-10-01 01:47 .Int.64.32.d.1-Fedora10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 3.0K 2009-10-01 02:10 .GNU.64.64.d.1-Fedora10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 3.0K 2009-10-01 02:10 .GNU.64.32.d.1-Fedora10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 12M 2009-10-01 04:38 .GNU.64.64.d.1-SunOS5.10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 12M 2009-10-01 04:38 .GNU.64.32.d.1-SunOS5.10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 13M 2009-10-01 04:47 .GNU.32.32.d.1-SunOS5.10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 22M 2009-10-01 02:53 .GNU.64.64.d.1-SunOS5.11..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rwxr-xr-x 1 monet monet 69M 2009-10-01 01:59 .Int.32.32.d.1-Windows5.1..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out* -rw-r--r-- 1 monet monet 82M 2009-10-01 02:18 .GNU.32.32.d.1-Debian4.0..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rwxr-xr-x 1 monet monet 145M 2009-10-01 02:40 .Int.64.32.d.1-Windows5.2..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out* -rw-r--r-- 1 monet monet 151M 2009-10-01 02:45 .GNU.32.32.d.1-Fedora10..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 164M 2009-10-01 02:08 .GNU.64.64.d.1-Gentoo2.0.1..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 267M 2009-10-01 02:12 .GNU.32.32.d.1-Darwin9.8.0..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out -rw-r--r-- 1 monet monet 308M 2009-10-01 05:14 .GNU.64.64.d.1-Darwin9.8.0..2009.10.01/mTests10/src/test/BugTracker-2009/mclient-lsql-D.test.out Instead of simply looking like ' START TRANSACTION; SET SCHEMA "sys"; CREATE TABLE "sys"."table_a" ( "table_a_id" int NOT NULL, "value_a" int NOT NULL, CONSTRAINT "pk_table_a_id" PRIMARY KEY ("table_a_id") ); CREATE TABLE "sys"."table_b" ( "table_b_id" int NOT NULL, "table_a_id" int NOT NULL, CONSTRAINT "pk_table_b_id" PRIMARY KEY ("table_b_id") ); CREATE TABLE "sys"."table_d" ( "table_d_id" int NOT NULL, "table_a_id" int NOT NULL, CONSTRAINT "pk_table_d_id" PRIMARY KEY ("table_d_id") ); CREATE TABLE "sys"."table_c" ( "table_c_id" int NOT NULL, "table_a_id" int NOT NULL, "table_b_id" int NOT NULL, "table_d_id" int NOT NULL, "value_c" int NOT NULL, CONSTRAINT "pk_table_c_id" PRIMARY KEY ("table_c_id") ); SET SCHEMA "sys"; ALTER TABLE "sys"."table_b" ADD CONSTRAINT "fk_table_a_id" FOREIGN KEY ("table_a_id") REFERENCES "sys"."table_a" ("table_a_id"); ALTER TABLE "sys"."table_c" ADD CONSTRAINT "fk_table_c_table_a_id" FOREIGN KEY ("table_a_id") REFERENCES "sys"."table_a" ("table_a_id"); ALTER TABLE "sys"."table_c" ADD CONSTRAINT "fk_table_c_table_d_id" FOREIGN KEY ("table_d_id") REFERENCES "sys"."table_b" ("table_b_id"); ALTER TABLE "sys"."table_d" ADD CONSTRAINT "fk_table_d_table_a_id" FOREIGN KEY ("table_a_id") REFERENCES "sys"."table_a" ("table_a_id"); COMMIT; ' the output starts with (e.g.) ' START TRANSACTION; SET SCHEMA "sys"; CREATE TABLE "sys"."n8" ( "a" decimal(14,2) ); COPY 100000000 RECORDS INTO "sys"."n8" FROM stdin USING DELIMITERS '\t','\n','"'; 1.21 1.21 1.21 [...] ' ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-10-01 22:35 Message: Thanks for the analysis and explanation, Sjoerd! I moved this test and its "companion" 'alter_table_drop_constraint.SF-2803477' to the from of the list to prevent them from being corrupted by remains of other tests in case those do not work / clean-up properly. Tonight's testing will show whether this helps ... ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2009-10-01 21:46 Message: This test depends on what has gone before, and in particular, whether other tests have cleaned up their mess. Unfortunately, other tests don't always clean up their mess, especially not if they fail. I think that is the problem why this test gives incorrect results. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2871426&group_id=56967 ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
