[MCOL-618] innodb query crash only happens on columnstore server Created: 2017-03-09 Updated: 2017-05-09 Resolved: 2017-05-04 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.0.7 |
| Fix Version/s: | 1.0.8, 1.1.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | David Thompson (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 2017-5, 2017-6, 2017-7, 2017-8, 2017-9 |
| Description |
|
Please be advised the queries that they are failing on are on table running on innodb engine. The Mariadb server runs fine when Columnstore is not there in the Mariadb server, but when Columnstore is added, it is failing on innodb engine "Outer join" queries. 170308 23:36:45 [ERROR] mysqld got signal 11 ; To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.1.21-MariaDB Thread pointer: 0x7f0ce1a1faa8 Trying to get some variables. Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains |
| Comments |
| Comment by David Thompson (Inactive) [ 2017-03-09 ] | |||||||||||||
|
Reference system is a 10.1.21 mariadb server install so it would appear that this is something specific to the columnstore fork of server. | |||||||||||||
| Comment by Andrew Hutchings (Inactive) [ 2017-03-09 ] | |||||||||||||
|
Cause appears to be accessing global_list->table->s when the table doesn't use an engine (derived, etc...). The global_list->table pointer exists but appears to point to unallocated data. | |||||||||||||
| Comment by Andrew Hutchings (Inactive) [ 2017-03-09 ] | |||||||||||||
|
Reproduce by creating a table called 't1' in 'test' (can be anything) and run the following PHP:
| |||||||||||||
| Comment by Andrew Hutchings (Inactive) [ 2017-03-10 ] | |||||||||||||
|
Crash happens with derived tables (likely in the original crash), views and I_S tables. Patch handles all these cases. Pull request for develop and develop-1.0 pending. This may or may not collide with the 10.2 work in develop. | |||||||||||||
| Comment by Daniel Lee (Inactive) [ 2017-05-04 ] | |||||||||||||
|
Build tested: 1.0.9-1 and 1.1.0-1 GitHub source Verified in both 1.0.9-1 and 1.1.0-1 using the php script in the ticket, for both columnstore and innodb tables. It also have been fixed in 1.0.8-1 | |||||||||||||
| Comment by David Thompson (Inactive) [ 2017-05-09 ] | |||||||||||||
|
correcting fix version from 1.0.9 to 1.0.8 |