Is this bug a known one? I can reliably crash 4.1.1 with this query every
time right now, which is a bit of a bummer.
From the error log:
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x86644a0 = SELECT profileid, profile_name, domain_name,
domainid FROM profiles, domain_profile, domains WHERE profileid=ref_profileid
AND domainid=ref_domainid AND ref_domainid in (SELECT domainid FROM domains
LEFT JOIN domain_profile ON ref_domainid=domainid GROUP BY domain_name HAVING
count(ref_profileid) > 1) ORDER BY domain_name
thd->thread_id=2
~/crash> resolve_stack_dump -s mysqld.sym -n m.stack
0x8089167 handle_segfault + 423
0x82da818 pthread_sighandler + 184
0x80baa71 get_best_combination__FP4JOIN + 145
0x80b899e
make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dynamic_array + 4158
0x80b5271 optimize__4JOIN + 369
0x80b780f
mysql_select__FP3THDPPP4ItemP13st_table_listUiRt4List1Z4ItemP4ItemUiP8st_orderT7T5T7UlP13select_resultP18st_select_lex_unitP13s
+ 767
0x80b487e handle_select__FP3THDP6st_lexP13select_result + 174
0x8096b1a mysql_execute_command__FP3THD + 1354
0x809b3f1 mysql_parse__FP3THDPcUi + 177
0x80957ff dispatch_command__F19enum_server_commandP3THDPcUi + 1631
0x8095192 do_command__FP3THD + 162
0x8094907 handle_one_connection + 551
0x82d7fcc pthread_start_thread + 220
0x830b8fa thread_start + 4
CREATE TABLE `domain_profile` (
`ref_domainid` int(10) unsigned NOT NULL default '0',
`ref_profileid` int(10) unsigned NOT NULL default '0',
`modified` timestamp NOT NULL,
`created` timestamp NOT NULL,
KEY `idx_domainid` (`ref_domainid`),
KEY `idx_profileid` (`ref_profileid`),
CONSTRAINT `0_1700` FOREIGN KEY (`ref_profileid`) REFERENCES `profiles`
(`profileid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `0_1701` FOREIGN KEY (`ref_domainid`) REFERENCES `domains`
(`domainid`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Domain::profile mapping';
CREATE TABLE `domains` (
`domainid` int(10) unsigned NOT NULL auto_increment,
`domain_name` char(200) NOT NULL default 'INVALID',
`domain_active` char(1) NOT NULL default 'N',
`modified` timestamp NOT NULL,
`created` timestamp NOT NULL,
PRIMARY KEY (`domainid`),
KEY `idx_active` (`domain_active`)
) TYPE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Master list of domains for
customer';
CREATE TABLE `profiles` (
`profileid` int(10) unsigned NOT NULL auto_increment,
`profile_name` varchar(100) NOT NULL default 'Default Profile',
`modified` timestamp NOT NULL,
`created` timestamp NOT NULL,
PRIMARY KEY (`profileid`)
) TYPE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of profiles';
mysql> select * from profiles;
+-----------+------------------+---------------------+---------------------+
| profileid | profile_name | modified | created |
+-----------+------------------+---------------------+---------------------+
| 1 | Built-in Profile | 2004-06-28 10:00:42 | 0000-00-00 00:00:00 |
| 2 | Test Profile | 2004-07-01 10:32:04 | 2004-07-01 10:32:04 |
+-----------+------------------+---------------------+---------------------+
mysql> select * from domain_profile;
+--------------+---------------+---------------------+---------------------+
| ref_domainid | ref_profileid | modified | created |
+--------------+---------------+---------------------+---------------------+
| 1 | 1 | 2004-06-29 17:12:41 | 2004-06-29 17:12:41 |
| 2 | 1 | 2004-07-01 09:29:57 | 2004-07-01 09:29:57 |
| 2 | 2 | 2004-07-01 11:37:19 | 2004-07-01 11:37:19 |
| 1 | 2 | 2004-07-01 11:45:28 | 2004-07-01 11:45:28 |
+--------------+---------------+---------------------+---------------------+
mysql> select * from domains;
+----------+-------------+---------------+---------------------+---------------------+
| domainid | domain_name | domain_active | modified | created
|
+----------+-------------+---------------+---------------------+---------------------+
| 1 | test.domain | Y | 2004-06-29 17:12:15 | 2004-06-29
17:12:10 |
| 2 | foo.domain | Y | 2004-06-30 10:52:34 | 2004-06-30
10:52:34 |
| 3 | jack.domain | Y | 2004-06-30 15:34:04 | 2004-06-30
15:34:04 |
+----------+-------------+---------------+---------------------+---------------------+
*************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: profiles
type: ALL
possible_keys: PRIMARY
key: NULL
key_len: NULL
ref: NULL
rows: 2
Extra: Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: PRIMARY
table: domain_profile
type: ref
possible_keys: idx_domainid,idx_profileid
key: idx_profileid
key_len: 4
ref: cust_116.profiles.profileid
rows: 1
Extra: Using where
*************************** 3. row ***************************
id: 1
select_type: PRIMARY
table: domains
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: cust_116.domain_profile.ref_domainid
rows: 1
Extra:
*************************** 4. row ***************************
id: 2
select_type: DEPENDENT SUBQUERY
table: domains
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 3
Extra: Using temporary; Using filesort
*************************** 5. row ***************************
id: 2
select_type: DEPENDENT SUBQUERY
table: domain_profile
type: ref
possible_keys: idx_domainid
key: idx_domainid
key_len: 4
ref: cust_116.domains.domainid
rows: 1
Extra:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
