./test-run --suite=broken 628912.test
Logging: ./test-run --suite=broken 628912.test
Drizzle Version 2010.09.1746
Using MTR_BUILD_THREAD = -69.4
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using MC_PORT = 9316
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
================================================================================
DEFAULT STORAGE ENGINE: innodb
TEST RESULT TIME (ms)
--------------------------------------------------------------------------------
broken.628912 [ fail ]
drizzletest: The specified result file does not exist: '/home/tdavies/hacking/dizzle/drizzle_latest/tests/suite/broken/r/628912.result'
The result from queries just before the failure was:
< snip >
`col_int_not_null` int NOT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `aa` VALUES (1,-1974206464),(2,3),(3,-274595840),(4,295501824),(5,9),(6,2),(7,-1601306624),(8,-1770323968),(9,256311296),(10,4);
CREATE TABLE `bb` (
`pk` int NOT NULL DEFAULT '0',
`col_char_1024_not_null` varchar(1024) NOT NULL,
`col_text` text,
`col_char_10_not_null_key` varchar(10) NOT NULL,
`col_char_1024_not_null_key` varchar(1024) NOT NULL,
`col_int_not_null_key` int NOT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `bb` VALUES (1,'o',NULL,'DCJRX','IHTVZ',1),(2,'a',NULL,'x','a',1),(3,'have',NULL,'ZMHDL','s',-1536425984),(4,'u',NULL,'SJGHS','d',-1443495936),(5,'o',NULL,'his','TTNNK',2),(6,'r',NULL,'m','GKTRR',0),(7,'on',NULL,'i','ZZDWO',8),(8,'IMULJ',NULL,'d','up',476315648),(9,'DXSXG',NULL,'from','would',5),(10,'y',NULL,'h','JNAFV',5);
CREATE TABLE `cc` (
`pk` int NOT NULL DEFAULT '0',
`col_char_10_key` varchar(10) DEFAULT NULL,
`col_bigint_key` bigint DEFAULT NULL,
`col_char_1024_not_null_key` varchar(1024) NOT NULL,
`col_int_key` int DEFAULT NULL,
`col_char_10` varchar(10) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
More results from queries before failure can be found in /home/tdavies/hacking/dizzle/drizzle_latest/tests/var/log/628912.log
Aborting: broken.628912 failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers
// RUN IN CLIENT:
// LAST COMMAND GIVEN...
drizzle> SELECT SQL_SMALL_RESULT table1 . `col_bigint_key` AS field1
-> FROM ( CC AS table1 RIGHT JOIN ( ( BB AS table2 LEFT JOIN BB AS table3
-> ON (table3 . `col_char_10_not_null_key` = table2 . `col_char_1024_not_null` ) ) )
-> ON (table3 . `col_char_10_not_null_key` = table2 . `col_text` ) )
-> WHERE
-> ( EXISTS ( ( SELECT SUBQUERY1_t1 . `col_char_10` AS SUBQUERY1_field1
-> FROM ( CC AS SUBQUERY1_t1 STRAIGHT_JOIN AA AS SUBQUERY1_t2 ON (SUBQUERY1_t2 . `col_int_not_null` = SUBQUERY1_t1 . `pk` ) ) ) ) )
-> AND ( table1 . `col_char_1024_not_null_key` = 'o' AND table1 . `col_char_1024_not_null_key` = table3 . `col_char_10_not_null_key` )
-> AND ( table1 . `col_int_key` != table3 . `col_int_not_null_key`
-> AND table3 . `col_char_1024_not_null_key` > 'h' )
-> ORDER BY table1 . `col_char_10_key` , table2 .`pk` DESC , field1 , table1 . `col_bigint_key` DESC, field1 LIMIT 1 OFFSET 3;
ERROR:
drizzle_state_read:lost connection to server (EOF)
No connection. Trying to reconnect...
ERROR:
drizzle_state_connect:could not connect
ERROR:
Can't connect to the server
drizzle> show tables;
No connection. Trying to reconnect...
ERROR:
drizzle_state_connect:could not connect
ERROR:
Can't connect to the server
CONFIRMED.
// RUN AS TEST CASE
./test-run --suite=broken 628912.test ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= === ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---
Logging: ./test-run --suite=broken 628912.test
Drizzle Version 2010.09.1746
Using MTR_BUILD_THREAD = -69.4
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using MC_PORT = 9316
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
=======
DEFAULT STORAGE ENGINE: innodb
TEST RESULT TIME (ms)
-------
broken.628912 [ fail ] tdavies/ hacking/ dizzle/ drizzle_ latest/ tests/suite/ broken/ r/628912. result'
drizzletest: The specified result file does not exist: '/home/
The result from queries just before the failure was: ,(2,3), (3,-274595840) ,(4,295501824) ,(5,9), (6,2),( 7,-1601306624) ,(8,-1770323968 ),(9,256311296) ,(10,4) ; 1024_not_ null` varchar(1024) NOT NULL, 10_not_ null_key` varchar(10) NOT NULL, 1024_not_ null_key` varchar(1024) NOT NULL, not_null_ key` int NOT NULL NULL,'DCJRX' ,'IHTVZ' ,1),(2, 'a',NULL, 'x','a' ,1),(3, 'have', NULL,'ZMHDL' ,'s',-153642598 4),(4,' u',NULL, 'SJGHS' ,'d',-144349593 6),(5,' o',NULL, 'his',' TTNNK', 2),(6,' r',NULL, 'm','GKTRR' ,0),(7, 'on',NULL, 'i','ZZDWO' ,8),(8, 'IMULJ' ,NULL,' d','up' ,476315648) ,(9,'DXSXG' ,NULL,' from',' would', 5),(10, 'y',NULL, 'h','JNAFV' ,5); 1024_not_ null_key` varchar(1024) NOT NULL,
< snip >
`col_int_not_null` int NOT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `aa` VALUES (1,-1974206464)
CREATE TABLE `bb` (
`pk` int NOT NULL DEFAULT '0',
`col_char_
`col_text` text,
`col_char_
`col_char_
`col_int_
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `bb` VALUES (1,'o',
CREATE TABLE `cc` (
`pk` int NOT NULL DEFAULT '0',
`col_char_10_key` varchar(10) DEFAULT NULL,
`col_bigint_key` bigint DEFAULT NULL,
`col_char_
`col_int_key` int DEFAULT NULL,
`col_char_10` varchar(10) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
More results from queries before failure can be found in /home/tdavies/ hacking/ dizzle/ drizzle_ latest/ tests/var/ log/628912. log
Aborting: broken.628912 failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers
// RUN IN CLIENT:
// LAST COMMAND GIVEN...
drizzle> SELECT SQL_SMALL_RESULT table1 . `col_bigint_key` AS field1 10_not_ null_key` = table2 . `col_char_ 1024_not_ null` ) ) ) 10_not_ null_key` = table2 . `col_text` ) ) 1024_not_ null_key` = 'o' AND table1 . `col_char_ 1024_not_ null_key` = table3 . `col_char_ 10_not_ null_key` ) not_null_ key` 1024_not_ null_key` > 'h' ) state_read: lost connection to server (EOF) state_connect: could not connect
-> FROM ( CC AS table1 RIGHT JOIN ( ( BB AS table2 LEFT JOIN BB AS table3
-> ON (table3 . `col_char_
-> ON (table3 . `col_char_
-> WHERE
-> ( EXISTS ( ( SELECT SUBQUERY1_t1 . `col_char_10` AS SUBQUERY1_field1
-> FROM ( CC AS SUBQUERY1_t1 STRAIGHT_JOIN AA AS SUBQUERY1_t2 ON (SUBQUERY1_t2 . `col_int_not_null` = SUBQUERY1_t1 . `pk` ) ) ) ) )
-> AND ( table1 . `col_char_
-> AND ( table1 . `col_int_key` != table3 . `col_int_
-> AND table3 . `col_char_
-> ORDER BY table1 . `col_char_10_key` , table2 .`pk` DESC , field1 , table1 . `col_bigint_key` DESC, field1 LIMIT 1 OFFSET 3;
ERROR:
drizzle_
No connection. Trying to reconnect...
ERROR:
drizzle_
ERROR:
Can't connect to the server
drizzle> show tables; state_connect: could not connect
No connection. Trying to reconnect...
ERROR:
drizzle_
ERROR:
Can't connect to the server