| Bug #26117 | index_merge sort-union over partitioned table crashes | ||
|---|---|---|---|
| Submitted: | 6 Feb 2007 16:19 | Modified: | 1 Mar 2007 5:51 |
| Reporter: | Jake Chung | ||
| Status: | Closed | ||
| Category: | Server: Partition | Severity: | S1 (Critical) |
| Version: | 5.1.14-Beta/5.1bk | OS: | Microsoft Windows (Windows/Linux) |
| Assigned to: | Bugs System | Target Version: | |
| Tags: | partition, index merge, crash | ||
[6 Feb 2007 16:21]
Jake Chung
Table definition and records to reproduce the bug.
Attachment: mysqlbug.sql (text/plain), 7.23 KiB.
[6 Feb 2007 17:43]
Miguel Solorzano
Call Stack for Windows server source 5.1.16
Attachment: call-stack-bug26117.txt (text/plain), 3.52 KiB.
[6 Feb 2007 17:56]
Miguel Solorzano
Back Trace on Linux
Attachment: bt-bug26117.txt (text/plain), 7.93 KiB.
[6 Feb 2007 17:58]
Miguel Solorzano
Thank you for the bug report. Verified on Windows and Linux with source servers (both back trace files attached).
[26 Feb 2007 22:44]
Sergey Petrunya
Changed synopsis to reflect bug's nature
[26 Feb 2007 22:55]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/20616 ChangeSet@1.2436, 2007-02-27 00:54:47+03:00, sergefp@mysql.com +4 -0 BUG#26117 "index_merge sort-union over partitioned table crashes" - Add ha_partition::clone() and adjust ha_partition::close() so that m_part_info!=NULL for the clone but is "owned" by the primary instance of ha_partition.
[27 Feb 2007 20:02]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/20681 ChangeSet@1.2436, 2007-02-27 22:01:03+03:00, sergefp@mysql.com +4 -0 BUG#26117 "index_merge sort-union over partitioned table crashes" Before the fix: ha_partition objects had ha_partition::m_part_info==NULL and that caused crash After: - The new ha_partition::clone() function makes the clones use parent's m_part_info value. - The parent ha_partition object remains responsible for deallocation of m_part_info.
[28 Feb 2007 18:48]
Sergey Gluhov
Fixed in 5.1.17-beta
[1 Mar 2007 5:51]
Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.
If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at
http://dev.mysql.com/doc/en/installing-source.html
Documented bugfix in 5.1.17 changelog.
Description: Performing a query that uses an index merge on a partitioned table will crash mysqld-nt.exe. I have tried the same index merge query on a non-partitioned table, and mysqld-nt.exe did not crash. I am running on a Windows XP Pro machine with 3Ghz Xeon processor and 2 GB of RAM. my.ini contents: [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 default-character-set=latin1 default-storage-engine=INNODB max_connections=100 query_cache_size=0M table_cache=100 thread_cache_size=8 innodb_additional_mem_pool_size=5M innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=50M innodb_log_file_size=100M innodb_thread_concurrency=8 datadir=c:\mysql\data basedir=c:\mysql innodb_buffer_pool_size=750M How to repeat: 1. Create the table defined in the attachment and insert the records that are provided also in the attachment. 2. EXPLAIN a select query that OR's two indexes from the table (i.e. EXPLAIN SELECT * FROM transaction WHERE first_name='Andy' OR last_name='Jake';). Make sure that the query is of type 'index_merge' +----+-------------+-------------+-------------+------------------------+------------------------ | id | select_type | table | type | possible_keys | ... | +----+-------------+-------------+-------------+------------------------+------------------------+ | 1 | SIMPLE | transaction | index_merge | first_index,last_index | ... | +----+-------------+-------------+-------------+------------------------+------------------------+ If the query does not use an index merge, insert more random entries until the indexes are big enough that the query will use an index merge. 3. Perform the select query (SELECT * FROM transaction WHERE first_name='Jake' OR last_name='Chung';). An error message will pop up indicating that mysqld-nt.exe has crashed.