Assertion `table->file->stats.records > 0 || error' failed in join_read_const_table on concurrent SELECT and ALTER, constant Aria table
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Michael Widenius |
Bug Description
See also https:/
The reason of both problems might be the same, as they happen with the exact same test case, but since it fails in both threads, sometimes on SELECT with the assertion and sometimes with the crash on ALTER (bug#947487), I will file both.
5.5.21-
mysqld: /home/elenst/
#6 0x00007fd0c2a67235 in __assert_fail () from /lib64/libc.so.6
#7 0x000000000067d8f0 in join_read_
at /home/elenst/
#8 0x000000000065f0fc in make_join_
keyuse_
#9 0x0000000000657c59 in JOIN::optimize (this=0x7fd0a81
at /home/elenst/
#10 0x000000000065e228 in mysql_select (thd=0x7fd0a812
tables=
proc_param=0x0, select_
select_
#11 0x00000000006552c6 in handle_select (thd=0x7fd0a812
setup_
#12 0x000000000062f3d8 in execute_
at /home/elenst/
#13 0x000000000062844f in mysql_execute_
at /home/elenst/
#14 0x0000000000631bec in mysql_parse (thd=0x7fd0a812
parser_
#15 0x0000000000625abd in dispatch_command (command=COM_QUERY, thd=0x7fd0a8128a20,
packet=
at /home/elenst/
#16 0x0000000000624d90 in do_command (thd=0x7fd0a812
#17 0x000000000071f729 in do_handle_
at /home/elenst/
#18 0x000000000071f1ec in handle_
at /home/elenst/
#19 0x00007fd0c3d77a4f in start_thread () from /lib64/
#20 0x00007fd0c2b0c82d in clone () from /lib64/libc.so.6
bzr version-info
revision-id: <email address hidden>
date: 2012-03-03 13:22:49 -0800
build-date: 2012-03-05 22:41:54 +0200
revno: 3311
Could not reproduce on 5.3.
Could not convert into an MTR test, it might require a deeper insight into the root of the problem, and possibly usage of synchronization points.
# RQG grammar (test.yy):
partitions:
ALTER TABLE _table PARTITION BY KEY() PARTITIONS part_num |
ALTER TABLE _table REMOVE PARTITIONING;
query:
SELECT * FROM _table ;
thread1:
partitions ;
part_num:
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 ;
# End of RQG grammar
# Run as
perl runall.pl \
--threads=2 \
--duration=3600 \
--queries=100M \
--grammar=./test.yy \
--engine=Aria \
--rows=
--mtr-build-
--basedir1=<5.5 debug basedir> \
--vardir1=<your vardir>
Related branches
description: | updated |
description: | updated |
description: | updated |
Changed in maria: | |
assignee: | nobody → Michael Widenius (monty) |
Changed in maria: | |
status: | New → In Progress |
Changed in maria: | |
status: | In Progress → Fix Released |
Also filed as JIRA issue MDEV-170