Drizzle

Crash / segfault in add_found_match_trig_cond (tab=0x0, cond=0x1c778c8, root_tab=0x1c82c80) at drizzled/sql_select.cc:1209

Bug #628397 reported by Patrick Crews on 2010-09-01

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Drizzle	Fix Released	High	Andrew Hutchings	Drizzle 2011-01-03
	7.0	Fix Released	High	Andrew Hutchings	Drizzle 2011-01-03

Bug Description

Crashing bug / segfault. Similar to https://bugs.launchpad.net/drizzle/+bug/586578, but this is a segfault rather than a failed assertion.

Query (test case attached):
SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1
FROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOIN c AS table4 ON table3 . `pk` = table4 . `pk` ON table1 . `pk` = table3 . `pk` LEFT OUTER JOIN e AS table5 LEFT JOIN b AS table6 ON table5 . `col_varchar_10_key` = table6 . `col_varchar_10` ON table2 . `col_varchar_10_key` = table5 . `col_varchar_1024_key` RIGHT OUTER JOIN g AS table7 ON table2 . `col_varchar_10_key` = table7 . `col_varchar_1024_key` WHERE ( ( ( table6 . `pk` = table3 . `col_int` OR table1 . `pk` < table2 . `pk` ) OR table3 . `col_int_key` > 7 ) OR table2 . `col_int_key` = 5 ) GROUP BY field1 ORDER BY field1 ;

Backtrace:
Program terminated with signal 11, Segmentation fault.
#0 add_found_match_trig_cond (tab=0x0, cond=0x1c778c8, root_tab=0x1c82c80) at drizzled/sql_select.cc:1209
1209 if ((tmp= add_found_match_trig_cond(tab->first_upper, cond, root_tab)))
(gdb) backtrace
#0 add_found_match_trig_cond (tab=0x0, cond=0x1c778c8, root_tab=0x1c82c80) at drizzled/sql_select.cc:1209
#1 0x00000000005a660d in make_join_select (join=0x1c78dd0, select=<value optimized out>, cond=<value optimized out>) at drizzled/join.cc:4839
#2 0x00000000005a99a8 in drizzled::Join::optimize (this=0x1c78dd0) at drizzled/join.cc:647
#3 0x000000000062a625 in drizzled::mysql_select (session=0x1c351b0, rref_pointer_array=<value optimized out>, tables=0x1c3adb8, wild_num=0, fields=..., conds=0x0,
    og_num=2, order=0x1c78ce8, group=0x1c78b50, having=0x0, select_options=2147500034, result=0x1c78db0, unit=0x1c35c28, select_lex=0x1c35e28)
    at drizzled/sql_select.cc:412
#4 0x000000000062afa0 in drizzled::handle_select (session=0x1c351b0, lex=0x1c35c08, result=0x1c78db0, setup_tables_done_option=0) at drizzled/sql_select.cc:146
#5 0x0000000000624e23 in drizzled::execute_sqlcom_select (session=0x1c351b0, all_tables=0x1c3adb8) at drizzled/sql_parse.cc:544
#6 0x0000000000624a3e in mysql_execute_command (session=0x1c351b0, inBuf=<value optimized out>, length=<value optimized out>) at drizzled/sql_parse.cc:479
#7 drizzled::mysql_parse (session=0x1c351b0, inBuf=<value optimized out>, length=<value optimized out>) at drizzled/sql_parse.cc:750
#8 0x0000000000626e12 in drizzled::dispatch_command (command=drizzled::COM_QUERY, session=0x1c351b0,
    packet=0x1c311a1 "SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1 \nFROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOI"..., packet_length=<value optimized out>) at drizzled/sql_parse.cc:224
#9 0x00000000005f508a in drizzled::Session::executeStatement (this=0x1c351b0) at drizzled/session.cc:666
#10 0x00000000005f8132 in drizzled::Session::run (this=0x1c351b0) at drizzled/session.cc:522
#11 0x00007f73f7193344 in MultiThreadScheduler::runSession (arg=<value optimized out>) at ./plugin/multi_thread/multi_thread.h:67
#12 session_thread (arg=<value optimized out>) at plugin/multi_thread/multi_thread.cc:52
#13 0x00007f73fad7b9ca in start_thread (arg=<value optimized out>) at pthread_create.c:300
#14 0x00007f73faad86fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#15 0x0000000000000000 in ?? ()

Tags:

Related branches

lp://staging/~linuxjedi/drizzle/trunk-bug-628397

Merged into lp://staging/drizzle/7.0 at revision 2047

Drizzle Developers: Pending requested 2011-01-01

Revision history for this message

Patrick Crews (patrick-crews) wrote on 2010-09-01:

Download full text (7.8 KiB)

test-suite testcase:
try to record via ./test-run --record <test_case_name>

--disable_warnings
DROP TABLE IF EXISTS `o`;
DROP TABLE IF EXISTS `b`;
DROP TABLE IF EXISTS `f`;
DROP TABLE IF EXISTS `c`;
DROP TABLE IF EXISTS `e`;
DROP TABLE IF EXISTS `g`;
--enable_warnings

CREATE TABLE `o` (
`pk` int NOT NULL DEFAULT '0',
`col_int_key` int DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `o` VALUES (1,4);
INSERT INTO `o` VALUES (2,-867368960);
INSERT INTO `o` VALUES (3,655032320);
INSERT INTO `o` VALUES (4,1);
INSERT INTO `o` VALUES (5,NULL);
INSERT INTO `o` VALUES (6,-118751232);
INSERT INTO `o` VALUES (7,7);
INSERT INTO `o` VALUES (8,1);
INSERT INTO `o` VALUES (9,3);
INSERT INTO `o` VALUES (10,-518324224);
INSERT INTO `o` VALUES (11,7);
INSERT INTO `o` VALUES (12,1129709568);
INSERT INTO `o` VALUES (13,-2081357824);
INSERT INTO `o` VALUES (14,6);
INSERT INTO `o` VALUES (15,NULL);
INSERT INTO `o` VALUES (16,NULL);
INSERT INTO `o` VALUES (17,NULL);
INSERT INTO `o` VALUES (18,NULL);
INSERT INTO `o` VALUES (19,4);
INSERT INTO `o` VALUES (20,1049690112);
INSERT INTO `o` VALUES (21,NULL);
INSERT INTO `o` VALUES (22,5);
INSERT INTO `o` VALUES (23,431292416);
INSERT INTO `o` VALUES (24,2);
INSERT INTO `o` VALUES (25,6);

CREATE TABLE `b` (
  `pk` int NOT NULL DEFAULT '0',
  `col_int_key` int DEFAULT NULL,
  `col_varchar_1024_key` varchar(1024) DEFAULT NULL,
  `col_varchar_10_key` varchar(10) DEFAULT NULL,
  `col_varchar_10` varchar(10) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `b` VALUES (1,NULL,'she','okay','we');

CREATE TABLE `f` (
  `pk` int NOT NULL DEFAULT '0',
  `col_int` int DEFAULT NULL,
  `col_int_key` int DEFAULT NULL,
  `col_varchar_1024_key` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `f` VALUES (1,1230307328,-180486144,'can\'t');
INSERT INTO `f` VALUES (2,NULL,NULL,'gbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjit');
INSERT INTO `f` VALUES (3,NULL,NULL,'think');
INSERT INTO `f` VALUES (4,0,NULL,'jqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdm');
INSERT INTO `f` VALUES (5,2,0,'u');
INSERT INTO `f` VALUES (6,1,NULL,'your');
INSERT INTO `f` VALUES (7,NULL,9,'at');

CREATE TABLE `c` (
`pk` int NOT NULL DEF...

test-suite testcase:
try to record via ./test-run --record <test_case_name>

--disable_warnings
DROP TABLE IF EXISTS `o`;
DROP TABLE IF EXISTS `b`;
DROP TABLE IF EXISTS `f`;
DROP TABLE IF EXISTS `c`;
DROP TABLE IF EXISTS `e`;
DROP TABLE IF EXISTS `g`;
--enable_warnings

CREATE TABLE `o` (
  `pk` int NOT NULL DEFAULT '0',
  `col_int_key` int DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `o` VALUES (1,4);
INSERT INTO `o` VALUES (2,-867368960);
INSERT INTO `o` VALUES (3,655032320);
INSERT INTO `o` VALUES (4,1);
INSERT INTO `o` VALUES (5,NULL);
INSERT INTO `o` VALUES (6,-118751232);
INSERT INTO `o` VALUES (7,7);
INSERT INTO `o` VALUES (8,1);
INSERT INTO `o` VALUES (9,3);
INSERT INTO `o` VALUES (10,-518324224);
INSERT INTO `o` VALUES (11,7);
INSERT INTO `o` VALUES (12,1129709568);
INSERT INTO `o` VALUES (13,-2081357824);
INSERT INTO `o` VALUES (14,6);
INSERT INTO `o` VALUES (15,NULL);
INSERT INTO `o` VALUES (16,NULL);
INSERT INTO `o` VALUES (17,NULL);
INSERT INTO `o` VALUES (18,NULL);
INSERT INTO `o` VALUES (19,4);
INSERT INTO `o` VALUES (20,1049690112);
INSERT INTO `o` VALUES (21,NULL);
INSERT INTO `o` VALUES (22,5);
INSERT INTO `o` VALUES (23,431292416);
INSERT INTO `o` VALUES (24,2);
INSERT INTO `o` VALUES (25,6);

CREATE TABLE `c` (
  `pk` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `c` VALUES (1);
INSERT INTO `c` VALUES (2);

CREATE TABLE `e` (
  `pk` int NOT NULL DEFAULT '0',
  `col_varchar_10_key` varchar(10) DEFAULT NULL,
  `col_varchar_1024_key` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `e` VALUES (1,'were','poyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfep');
INSERT INTO `e` VALUES (2,'ok','kpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjitmaijfpfbpdwickgvibccphunilmnxvdsykirhgxvyehxyhixejfktoptnpveambxrovrpulkkjqccekfbfamsuiwhofodwrlsvwmxtvaoazfufeehwftkaugjsnebabzsscqhnafqodwrvohesokjrzhnkjhqowroirjsmo');
INSERT INTO `e` VALUES (3,'yes','w');
INSERT INTO `e` VALUES (4,'adfszkpoyx','will');
INSERT INTO `e` VALUES (5,'m','wadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtb');
INSERT INTO `e` VALUES (6,'k','all');

CREATE TABLE `g` (
  `pk` int NOT NULL DEFAULT '0',
  `col_varchar_1024_key` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;

INSERT INTO `g` VALUES (1,'pkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpn');
INSERT INTO `g` VALUES (2,'sydpkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjitmaijfpfbpdwickgvibccphunilmnxvdsykirhgxvyehxyhixejfktoptnpveambxrovrpulkkjqccekfbfamsuiwhofodwrlsvwmxtvaoazfufeehwftkaugjsnebabzsscqhnafqodwrvohesokjrzhnkjhqowroirjsmofgfvfuomwlcdytimiwybmtuheejeitapnjnestutftmutidlvdubbjdznrxsrrmahxsxurpk');
INSERT INTO `g` VALUES (3,'bmsydpkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngd');
INSERT INTO `g` VALUES (4,'are');
INSERT INTO `g` VALUES (5,'p');
INSERT INTO `g` VALUES (6,'now');
INSERT INTO `g` VALUES (7,'k');
INSERT INTO `g` VALUES (8,'h');

SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1 
FROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOIN c AS table4 ON table3 . `pk` = table4 . `pk` ON table1 . `pk` = table3 . `pk` LEFT OUTER JOIN e AS table5 LEFT JOIN b AS table6 ON table5 . `col_varchar_10_key` = table6 . `col_varchar_10` ON table2 . `col_varchar_10_key` = table5 . `col_varchar_1024_key` RIGHT OUTER JOIN g AS table7 ON table2 . `col_varchar_10_key` = table7 . `col_varchar_1024_key` WHERE ( ( ( table6 . `pk` = table3 . `col_int` OR table1 . `pk` < table2 . `pk` ) OR table3 . `col_int_key` > 7 ) OR table2 . `col_int_key` = 5 ) GROUP BY field1 ORDER BY field1 ;

DROP TABLE `o`;
DROP TABLE `b`;
DROP TABLE `f`;
DROP TABLE `c`;
DROP TABLE `e`;
DROP TABLE `g`;

Revision history for this message

Travis Davies (travisdaveez) wrote on 2010-09-05:

Attempting to confirm this bug.
After running the test-case, I am seeing the failure, but I want to see the backtrace, like the
one posted. How do I get this backtrace?

Cheers!
Travis

Revision history for this message

Travis Davies (travisdaveez) wrote on 2010-09-06:

Download full text (18.8 KiB)

Bug Confirmation
revision 1746 of branch

// TEST CASE
./test-run --suite=broken test_case.test
Logging: ./test-run --suite=broken test_case.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.test_case [ fail ]
drizzletest: At line 95: query 'SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1
FROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOIN c AS table4 ON table3 . `pk` = table4 . `pk` ON table1 . `pk` = table3 . `pk` LEFT OUTER JOIN e AS table5 LEFT JOIN b AS table6 ON table5 . `col_varchar_10_key` = table6 . `col_varchar_10` ON table2 . `col_varchar_10_key` = table5 . `col_varchar_1024_key` RIGHT OUTER JOIN g AS table7 ON table2 . `col_varchar_10_key` = table7 . `col_varchar_1024_key` WHERE ( ( ( table6 . `pk` = table3 . `col_int` OR table1 . `pk` < table2 . `pk` ) OR table3 . `col_int_key` > 7 ) OR table2 . `col_int_key` = 5 ) GROUP BY field1 ORDER BY field1 ' failed: 20: drizzle_state_read:lost connection to server (EOF)

Bug Confirmation
revision 1746 of branch

// TEST CASE
./test-run --suite=broken test_case.test
Logging: ./test-run --suite=broken test_case.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.test_case                                             [ fail ]
drizzletest: At line 95: query 'SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1
FROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOIN c AS table4 ON table3 . `pk` = table4 . `pk` ON table1 . `pk` = table3 . `pk` LEFT OUTER JOIN e AS table5 LEFT JOIN b AS table6 ON table5 . `col_varchar_10_key` = table6 . `col_varchar_10` ON table2 . `col_varchar_10_key` = table5 . `col_varchar_1024_key` RIGHT OUTER JOIN g AS table7 ON table2 . `col_varchar_10_key` = table7 . `col_varchar_1024_key` WHERE ( ( ( table6 . `pk` = table3 . `col_int` OR table1 . `pk` < table2 . `pk` ) OR table3 . `col_int_key` > 7 ) OR table2 . `col_int_key` = 5 ) GROUP BY field1 ORDER BY field1 ' failed: 20: drizzle_state_read:lost connection to server (EOF)

The result from queries just before the failure was:
< snip >
INSERT INTO `e` VALUES (1,'were','poyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfep');
INSERT INTO `e` VALUES (2,'ok','kpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjitmaijfpfbpdwickgvibccphunilmnxvdsykirhgxvyehxyhixejfktoptnpveambxrovrpulkkjqccekfbfamsuiwhofodwrlsvwmxtvaoazfufeehwftkaugjsnebabzsscqhnafqodwrvohesokjrzhnkjhqowroirjsmo');
INSERT INTO `e` VALUES (3,'yes','w');
INSERT INTO `e` VALUES (4,'adfszkpoyx','will');
INSERT INTO `e` VALUES (5,'m','wadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtb');
INSERT INTO `e` VALUES (6,'k','all');
CREATE TABLE `g` (
`pk` int NOT NULL DEFAULT '0',
`col_varchar_1024_key` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `g` VALUES (1,'pkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpn');
INSERT INTO `g` VALUES (2,'sydpkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjitmaijfpfbpdwickgvibccphunilmnxvdsykirhgxvyehxyhixejfktoptnpveambxrovrpulkkjqccekfbfamsuiwhofodwrlsvwmxtvaoazfufeehwftkaugjsnebabzsscqhnafqodwrvohesokjrzhnkjhqowroirjsmofgfvfuomwlcdytimiwybmtuheejeitapnjnestutftmutidlvdubbjdznrxsrrmahxsxurpk');
INSERT INTO `g` VALUES (3,'bmsydpkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngd');
INSERT INTO `g` VALUES (4,'are');
INSERT INTO `g` VALUES (5,'p');
INSERT INTO `g` VALUES (6,'now');
INSERT INTO `g` VALUES (7,'k');
INSERT INTO `g` VALUES (8,'h');
SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1
FROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOIN c AS table4 ON table3 . `pk` = table4 . `pk` ON table1 . `pk` = table3 . `pk` LEFT OUTER JOIN e AS table5 LEFT JOIN b AS table6 ON table5 . `col_varchar_10_key` = table6 . `col_varchar_10` ON table2 . `col_varchar_10_key` = table5 . `col_varchar_1024_key` RIGHT OUTER JOIN g AS table7 ON table2 . `col_varchar_10_key` = table7 . `col_varchar_1024_key` WHERE ( ( ( table6 . `pk` = table3 . `col_int` OR table1 . `pk` < table2 . `pk` ) OR table3 . `col_int_key` > 7 ) OR table2 . `col_int_key` = 5 ) GROUP BY field1 ORDER BY field1 ;

More results from queries before failure can be found in /home/tdavies/hacking/dzzRepo/drizzle-628397/drizzle/tests/var/log/test_case.log

Aborting: broken.test_case failed in default mode. 
To continue, re-run with '--force'.
Stopping All Servers

// OUTPUT FROM CLIENT AT CONSOLE

drizzle> use test;
Database changed
drizzle> DROP TABLE IF EXISTS `o`;
Query OK, 0 rows affected, 1 warning (0 sec)

drizzle> DROP TABLE IF EXISTS `b`;
Query OK, 0 rows affected, 1 warning (0 sec)

drizzle> DROP TABLE IF EXISTS `f`;
Query OK, 0 rows affected, 1 warning (0 sec)

drizzle> DROP TABLE IF EXISTS `c`;
Query OK, 0 rows affected, 1 warning (0 sec)

drizzle> DROP TABLE IF EXISTS `e`;
Query OK, 0 rows affected, 1 warning (0 sec)

drizzle> DROP TABLE IF EXISTS `g`;
Query OK, 0 rows affected, 1 warning (0 sec)

drizzle> CREATE TABLE `o` (
    ->   `pk` int NOT NULL DEFAULT '0',
    ->   `col_int_key` int DEFAULT NULL
    -> ) ENGINE=InnoDB COLLATE = utf8_general_ci;
Query OK, 0 rows affected (0.06 sec)

drizzle> INSERT INTO `o` VALUES (1,4);
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `o` VALUES (2,-867368960);
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `o` VALUES (3,655032320);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (4,1);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (5,NULL);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (6,-118751232);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (7,7);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (8,1);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (9,3);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (10,-518324224);
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `o` VALUES (11,7);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (12,1129709568);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (13,-2081357824);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (14,6);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (15,NULL);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (16,NULL);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (17,NULL);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (18,NULL);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (19,4);
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `o` VALUES (20,1049690112);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (21,NULL);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (22,5);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (23,431292416);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (24,2);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `o` VALUES (25,6);
Query OK, 1 row affected (0.04 sec)

drizzle> CREATE TABLE `b` (
    ->   `pk` int NOT NULL DEFAULT '0',
    ->   `col_int_key` int DEFAULT NULL,
    ->   `col_varchar_1024_key` varchar(1024) DEFAULT NULL,
    ->   `col_varchar_10_key` varchar(10) DEFAULT NULL,
    ->   `col_varchar_10` varchar(10) DEFAULT NULL
    -> ) ENGINE=InnoDB COLLATE = utf8_general_ci;
Query OK, 0 rows affected (0.03 sec)

drizzle> INSERT INTO `b` VALUES (1,NULL,'she','okay','we');
Query OK, 1 row affected (0.04 sec)

drizzle> CREATE TABLE `f` (
    ->   `pk` int NOT NULL DEFAULT '0',
    ->   `col_int` int DEFAULT NULL,
    ->   `col_int_key` int DEFAULT NULL,
    ->   `col_varchar_1024_key` varchar(1024) DEFAULT NULL
    -> ) ENGINE=InnoDB COLLATE = utf8_general_ci;
Query OK, 0 rows affected (0.04 sec)

drizzle> INSERT INTO `f` VALUES (1,1230307328,-180486144,'can\'t');
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `f` VALUES (2,NULL,NULL,'gbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjit');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `f` VALUES (3,NULL,NULL,'think');
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `f` VALUES (4,0,NULL,'jqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdm');
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `f` VALUES (5,2,0,'u');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `f` VALUES (6,1,NULL,'your');
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `f` VALUES (7,NULL,9,'at');
Query OK, 1 row affected (0.05 sec)

drizzle> 
drizzle> CREATE TABLE `c` (
    ->   `pk` int NOT NULL DEFAULT '0'
    -> ) ENGINE=InnoDB COLLATE = utf8_general_ci;
Query OK, 0 rows affected (0.05 sec)

drizzle> INSERT INTO `c` VALUES (1);
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `c` VALUES (2);
Query OK, 1 row affected (0.03 sec)

drizzle> CREATE TABLE `e` (
    ->   `pk` int NOT NULL DEFAULT '0',
    ->   `col_varchar_10_key` varchar(10) DEFAULT NULL,
    ->   `col_varchar_1024_key` varchar(1024) DEFAULT NULL
    -> ) ENGINE=InnoDB COLLATE = utf8_general_ci;
Query OK, 0 rows affected (0.05 sec)

drizzle> INSERT INTO `e` VALUES (1,'were','poyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfep');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `e` VALUES (2,'ok','kpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjitmaijfpfbpdwickgvibccphunilmnxvdsykirhgxvyehxyhixejfktoptnpveambxrovrpulkkjqccekfbfamsuiwhofodwrlsvwmxtvaoazfufeehwftkaugjsnebabzsscqhnafqodwrvohesokjrzhnkjhqowroirjsmo');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `e` VALUES (3,'yes','w');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `e` VALUES (4,'adfszkpoyx','will');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `e` VALUES (5,'m','wadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtb');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `e` VALUES (6,'k','all');
Query OK, 1 row affected (0.04 sec)

drizzle> CREATE TABLE `g` (
    ->   `pk` int NOT NULL DEFAULT '0',
    ->   `col_varchar_1024_key` varchar(1024) DEFAULT NULL
    -> ) ENGINE=InnoDB COLLATE = utf8_general_ci;
Query OK, 0 rows affected (0.05 sec)

drizzle> INSERT INTO `g` VALUES (1,'pkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpn');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `g` VALUES (2,'sydpkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngdjiawsiarcbkgoudqpkecymujxlwfzdeqnrumctcfmndgknecfzkndoohlpkgksukysorfgkvvkreijhlyhznczsxfdezymeqjpdeydhvhrxolrlxmxxdmajqwizwmyvustnzbrbopxmspxnazyxzmuysgonfckdeurqnroljslhdnjmdetcftzsrkjzmhimfmsbhnsgriqkaejakxzbldvftdcaugaahtcwtnujxmwqvkfepcswvrvqhibmuutnuhmvcnctfzmswcmtsrpmyedqxpoluufzbhwbrmcdiwytofotjitmaijfpfbpdwickgvibccphunilmnxvdsykirhgxvyehxyhixejfktoptnpveambxrovrpulkkjqccekfbfamsuiwhofodwrlsvwmxtvaoazfufeehwftkaugjsnebabzsscqhnafqodwrvohesokjrzhnkjhqowroirjsmofgfvfuomwlcdytimiwybmtuheejeitapnjnestutftmutidlvdubbjdznrxsrrmahxsxurpk');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `g` VALUES (3,'bmsydpkmxffjqgbawadfszkpoyxyczdvoleqxermmjkovqnoqhpubzfjxwqacdiwyekwemegyaluzytnccflbvqnqnmfvvlhitckzgppyilihmleccmmxqxcilxqvfikqseftdkgtlqzbwpucapktdeqxndcqytizhxaaiyashfuwbyynvenjcsmasklnxxtbzrqxmoupppjcctptgoksleizxkrbednzzwgvlnnghjvvtlpajyalhsygtjrhjxreywihgnxlevtsvfzsztftgvgzkqhwpnbztbcpoqdmhgjffokjvoaejwgqpnhemopbmrkfnkwngd');
Query OK, 1 row affected (0.03 sec)

drizzle> INSERT INTO `g` VALUES (4,'are');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `g` VALUES (5,'p');
Query OK, 1 row affected (0.05 sec)

drizzle> INSERT INTO `g` VALUES (6,'now');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `g` VALUES (7,'k');
Query OK, 1 row affected (0.04 sec)

drizzle> INSERT INTO `g` VALUES (8,'h');
Query OK, 1 row affected (0.04 sec)

drizzle> SELECT STRAIGHT_JOIN table1 . `col_int_key` AS field1
    -> FROM o AS table1 RIGHT OUTER JOIN b AS table2 LEFT JOIN f AS table3 ON table2 . `col_varchar_1024_key` = table3 . `col_varchar_1024_key` LEFT JOIN c AS table4 ON table3 . `pk` = table4 . `pk` ON table1 . `pk` = table3 . `pk` LEFT OUTER JOIN e AS table5 LEFT JOIN b AS table6 ON table5 . `col_varchar_10_key` = table6 . `col_varchar_10` ON table2 . `col_varchar_10_key` = table5 . `col_varchar_1024_key` RIGHT OUTER JOIN g AS table7 ON table2 . `col_varchar_10_key` = table7 . `col_varchar_1024_key` WHERE ( ( ( table6 . `pk` = table3 . `col_int` OR table1 . `pk` < table2 . `pk` ) OR table3 . `col_int_key` > 7 ) OR table2 . `col_int_key` = 5 ) GROUP BY field1 ORDER BY field1 ;
100905 19:55:53 - drizzled got signal 11;
This could be because you hit a bug. It is also possible that this binary
 or one of the libraries it was linked against is corrupt, improperly built,
 or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

read_buffer_size=131072
max_used_connections=1
connection_count=1
It is possible that drizzled could use up to 
(read_buffer_size + sort_buffer_size)*thread_count
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Number of stack frames obtained: 18
[0xfb7400]
drizzled::add_found_match_trig_cond(drizzled::JoinTable*, drizzled::Item*, drizzled::JoinTable*)
./drizzled() [0x83199fb]
drizzled::Join::optimize()
drizzled::mysql_select(drizzled::Session*, drizzled::Item***, drizzled::TableList*, unsigned int, drizzled::List<drizzled::Item>&, drizzled::Item*, unsigned int, drizzled::order_st*, drizzled::order_st*, drizzled::Item*, unsigned long long, drizzled::select_result*, drizzled::Select_Lex_Unit*, drizzled::Select_Lex*)
drizzled::handle_select(drizzled::Session*, drizzled::LEX*, drizzled::select_result*, unsigned long long)
drizzled::execute_sqlcom_select(drizzled::Session*, drizzled::TableList*)
drizzled::statement::Select::execute()
./drizzled() [0x83be11f]
drizzled::mysql_parse(drizzled::Session*, char const*, unsigned int)
drizzled::dispatch_command(drizzled::enum_server_command, drizzled::Session*, char*, unsigned int)
drizzled::Session::executeStatement()
drizzled::Session::run()
MultiThreadScheduler::runSession(drizzled::Session*)
session_thread()
/lib/libpthread.so.0() [0x87f919]
clone()
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

Changed in drizzle:
status:	New → Confirmed

Lee Bieber (kalebral-deactivatedaccount) on 2010-10-04

tags:

added: crash

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2011-01-01:

Duplicate of MySQL bug #52005

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.