Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
Note: The test case is similar to MDEV-14844, only here with system_time partitioning we are getting a crash, not the assertion failure.
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
|
CREATE OR REPLACE TABLE t1 (pk int) ENGINE=InnoDB WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 4 HOUR (PARTITION p1 HISTORY, PARTITION pn CURRENT); |
LOCK TABLE t1 WRITE; |
SET system_versioning_alter_history=KEEP; |
--error ER_SAME_NAME_PARTITION
|
ALTER TABLE t1 ADD PARTITION (PARTITION p1 HISTORY); |
SELECT * FROM t1; |
|
# Cleanup
|
DROP TABLE t1; |
bb-10.3-temporal a3a15126f260e26b7 |
#3 <signal handler called>
|
#4 0x000055d50cbfecb0 in base_list_iterator::next (this=0x7f3ba42f6580) at /data/src/bb-10.3-temporal/sql/sql_list.h:412
|
#5 0x000055d50cd42c39 in List_iterator<p_elem_val>::operator++ (this=0x7f3ba42f6580) at /data/src/bb-10.3-temporal/sql/sql_list.h:519
|
#6 0x000055d50cdcab0c in partition_info::check_range_constants (this=0x7f3b5809d068, thd=0x7f3b58000b00, alloc=false) at /data/src/bb-10.3-temporal/sql/partition_info.cc:1552
|
#7 0x000055d50d0eaf52 in partition_info::vers_update_range_constants (this=0x7f3b5809d068, thd=0x7f3b58000b00) at /data/src/bb-10.3-temporal/sql/partition_info.h:565
|
#8 0x000055d50d0ceaf7 in prune_partitions (thd=0x7f3b58000b00, table=0x7f3b58072020, pprune_cond=0x7f3b580160c0) at /data/src/bb-10.3-temporal/sql/opt_range.cc:3460
|
#9 0x000055d50ccd1275 in JOIN::optimize_inner (this=0x7f3b58015528) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1868
|
#10 0x000055d50ccd00b8 in JOIN::optimize (this=0x7f3b58015528) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1556
|
#11 0x000055d50ccd9814 in mysql_select (thd=0x7f3b58000b00, tables=0x7f3b58014e30, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2149845760, result=0x7f3b58015508, unit=0x7f3b58004898, select_lex=0x7f3b58004ff0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:4244
|
#12 0x000055d50cccb93e in handle_select (thd=0x7f3b58000b00, lex=0x7f3b580047d0, result=0x7f3b58015508, setup_tables_done_option=0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:382
|
#13 0x000055d50cc96aa1 in execute_sqlcom_select (thd=0x7f3b58000b00, all_tables=0x7f3b58014e30) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6535
|
#14 0x000055d50cc8d0e5 in mysql_execute_command (thd=0x7f3b58000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3749
|
#15 0x000055d50cc9a3f6 in mysql_parse (thd=0x7f3b58000b00, rawbuf=0x7f3b58014c48 "SELECT * FROM t1", length=16, parser_state=0x7f3ba42f85f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7991
|
#16 0x000055d50cc87b97 in dispatch_command (command=COM_QUERY, thd=0x7f3b58000b00, packet=0x7f3b58120201 "SELECT * FROM t1", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1825
|
#17 0x000055d50cc865cb in do_command (thd=0x7f3b58000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370
|
#18 0x000055d50cdee354 in do_handle_one_connection (connect=0x55d50f8cf590) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
|
#19 0x000055d50cdee0e1 in handle_one_connection (arg=0x55d50f8cf590) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
|
#20 0x000055d50d288c5a in pfs_spawn_thread (arg=0x55d50f915dd0) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
|
#21 0x00007f3bae3c9494 in start_thread (arg=0x7f3ba42f9700) at pthread_create.c:333
|
#22 0x00007f3bac7af93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Also reproducible on tempesta-tech/mariadb 52f9f635a5fa6.
Attachments
Issue Links
- is duplicated by
-
MDEV-14826 Server crashes in String_list::append_str / make_used_partitions_str
-
- Closed
-
-
MDEV-14844 Assertion `bit < (map)->n_bits' failed in bitmap_is_set
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Component/s | System versioning [ 14303 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Affects Version/s | N/A [ 14700 ] | |
Description |
https://api.travis-ci.org/v3/job/322917771/log.txt
{noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8} # 2017-12-29T19:42:11 [25543] #3 <signal handler called> # 2017-12-29T19:42:11 [25543] #4 0x000000000071df04 in base_list_iterator::next (this=0x7f08e5135340) at /home/travis/src/sql/sql_list.h:410 # 2017-12-29T19:42:11 [25543] #5 0x00000000008604f5 in List_iterator<p_elem_val>::operator++ (this=0x7f08e5135340) at /home/travis/src/sql/sql_list.h:519 # 2017-12-29T19:42:11 [25543] #6 0x00000000008e71a7 in partition_info::check_range_constants (this=0x7f08a00ae188, thd=0x7f08a000b3c0, alloc=false) at /home/travis/src/sql/partition_info.cc:1552 # 2017-12-29T19:42:11 [25543] #7 0x0000000000c0dc1d in partition_info::vers_update_range_constants (this=0x7f08a00ae188, thd=0x7f08a000b3c0) at /home/travis/src/sql/partition_info.h:565 # 2017-12-29T19:42:11 [25543] #8 0x0000000000bf222a in prune_partitions (thd=0x7f08a000b3c0, table=0x7f08a01775d0, pprune_cond=0x7f08a001f850) at /home/travis/src/sql/opt_range.cc:3460 # 2017-12-29T19:42:11 [25543] #9 0x00000000007f034e in JOIN::optimize_inner (this=0x7f08a001eec0) at /home/travis/src/sql/sql_select.cc:1868 # 2017-12-29T19:42:11 [25543] #10 0x00000000007ef1e2 in JOIN::optimize (this=0x7f08a001eec0) at /home/travis/src/sql/sql_select.cc:1556 # 2017-12-29T19:42:11 [25543] #11 0x00000000007f87fe in mysql_select (thd=0x7f08a000b3c0, tables=0x7f08a001e450, wild_num=1, fields=..., conds=0x7f08a001eca8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551906183680, result=0x7f08a001eea0, unit=0x7f08a000f158, select_lex=0x7f08a000f8b0) at /home/travis/src/sql/sql_select.cc:4244 # 2017-12-29T19:42:11 [25543] #12 0x00000000007eaa4a in handle_select (thd=0x7f08a000b3c0, lex=0x7f08a000f090, result=0x7f08a001eea0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382 # 2017-12-29T19:42:11 [25543] #13 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7f08a000b3c0, all_tables=0x7f08a001e450) at /home/travis/src/sql/sql_parse.cc:6535 # 2017-12-29T19:42:11 [25543] #14 0x00000000007ac1ef in mysql_execute_command (thd=0x7f08a000b3c0) at /home/travis/src/sql/sql_parse.cc:3749 # 2017-12-29T19:42:11 [25543] #15 0x00000000007b9737 in mysql_parse (thd=0x7f08a000b3c0, rawbuf=0x7f08a001e188 "SELECT * from `table0_myisam_int` WHERE sys_trx_start = @trx /* QNO 53152 CON_ID 17 */", length=86, parser_state=0x7f08e5137470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991 # 2017-12-29T19:42:11 [25543] #16 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7f08a000b3c0, packet=0x7f08a00159c1 "SELECT * from `table0_myisam_int` WHERE sys_trx_start = @trx /* QNO 53152 CON_ID 17 */ ", packet_length=87, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 # 2017-12-29T19:42:11 [25543] #17 0x00000000007a565d in do_command (thd=0x7f08a000b3c0) at /home/travis/src/sql/sql_parse.cc:1370 # 2017-12-29T19:42:11 [25543] #18 0x000000000090b7cf in do_handle_one_connection (connect=0x399f530) at /home/travis/src/sql/sql_connect.cc:1420 # 2017-12-29T19:42:11 [25543] #19 0x000000000090b551 in handle_one_connection (arg=0x399f530) at /home/travis/src/sql/sql_connect.cc:1326 # 2017-12-29T19:42:11 [25543] #20 0x00007f08e8844e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 # 2017-12-29T19:42:11 [25543] #21 0x00007f08e7d602ed in clone () from /lib/x86_64-linux-gnu/libc.so.6 # 2017-12-29T19:42:11 [25543] #22 0x0000000000000000 in ?? () Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f08a001e188): SELECT * from `table0_myisam_int` WHERE sys_trx_start = @trx /* QNO 53152 CON_ID 17 */ Connection ID (thread ID): 17 Status: NOT_KILLED {noformat} {noformat:title=experimental 12ad3991f47e76979fbf8ac828844ede0c7b5acc} perl /home/travis/rqg/runall-new.pl --duration=400 --threads=6 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableIndexes,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3 {noformat} |
_Note: The test case is similar to {code:sql} --source include/have_innodb.inc --source include/have_partition.inc CREATE OR REPLACE TABLE t1 (pk int) ENGINE=InnoDB WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 4 HOUR (PARTITION p1 HISTORY, PARTITION pn CURRENT); LOCK TABLE t1 WRITE; SET system_versioning_alter_history=KEEP; --error ER_SAME_NAME_PARTITION ALTER TABLE t1 ADD PARTITION (PARTITION p1 HISTORY); SELECT * FROM t1; # Cleanup DROP TABLE t1; {code} {noformat:title=bb-10.3-temporal a3a15126f260e26b7} #3 <signal handler called> #4 0x000055d50cbfecb0 in base_list_iterator::next (this=0x7f3ba42f6580) at /data/src/bb-10.3-temporal/sql/sql_list.h:412 #5 0x000055d50cd42c39 in List_iterator<p_elem_val>::operator++ (this=0x7f3ba42f6580) at /data/src/bb-10.3-temporal/sql/sql_list.h:519 #6 0x000055d50cdcab0c in partition_info::check_range_constants (this=0x7f3b5809d068, thd=0x7f3b58000b00, alloc=false) at /data/src/bb-10.3-temporal/sql/partition_info.cc:1552 #7 0x000055d50d0eaf52 in partition_info::vers_update_range_constants (this=0x7f3b5809d068, thd=0x7f3b58000b00) at /data/src/bb-10.3-temporal/sql/partition_info.h:565 #8 0x000055d50d0ceaf7 in prune_partitions (thd=0x7f3b58000b00, table=0x7f3b58072020, pprune_cond=0x7f3b580160c0) at /data/src/bb-10.3-temporal/sql/opt_range.cc:3460 #9 0x000055d50ccd1275 in JOIN::optimize_inner (this=0x7f3b58015528) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1868 #10 0x000055d50ccd00b8 in JOIN::optimize (this=0x7f3b58015528) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1556 #11 0x000055d50ccd9814 in mysql_select (thd=0x7f3b58000b00, tables=0x7f3b58014e30, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2149845760, result=0x7f3b58015508, unit=0x7f3b58004898, select_lex=0x7f3b58004ff0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:4244 #12 0x000055d50cccb93e in handle_select (thd=0x7f3b58000b00, lex=0x7f3b580047d0, result=0x7f3b58015508, setup_tables_done_option=0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:382 #13 0x000055d50cc96aa1 in execute_sqlcom_select (thd=0x7f3b58000b00, all_tables=0x7f3b58014e30) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6535 #14 0x000055d50cc8d0e5 in mysql_execute_command (thd=0x7f3b58000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3749 #15 0x000055d50cc9a3f6 in mysql_parse (thd=0x7f3b58000b00, rawbuf=0x7f3b58014c48 "SELECT * FROM t1", length=16, parser_state=0x7f3ba42f85f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7991 #16 0x000055d50cc87b97 in dispatch_command (command=COM_QUERY, thd=0x7f3b58000b00, packet=0x7f3b58120201 "SELECT * FROM t1", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1825 #17 0x000055d50cc865cb in do_command (thd=0x7f3b58000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370 #18 0x000055d50cdee354 in do_handle_one_connection (connect=0x55d50f8cf590) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420 #19 0x000055d50cdee0e1 in handle_one_connection (arg=0x55d50f8cf590) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326 #20 0x000055d50d288c5a in pfs_spawn_thread (arg=0x55d50f915dd0) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863 #21 0x00007f3bae3c9494 in start_thread (arg=0x7f3ba42f9700) at pthread_create.c:333 #22 0x00007f3bac7af93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Also reproducible on tempesta-tech/mariadb 52f9f635a5fa6. |
Summary | [Draft] Server crashes in in base_list_iterator::next | Server crashes in in base_list_iterator::next / partition_info::check_range_constants |
Assignee | Elena Stepanova [ elenst ] | Alexander Krizhanovsky [ krizhanovsky ] |
Comment |
[ https://api.travis-ci.org/v3/job/323555922/log.txt
Can be the same or different {noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8} #3 <signal handler called> #4 0x00000000008e71af in partition_info::check_range_constants (this=0x7f04b8180900, thd=0x7f04b8000c00, alloc=false) at /home/travis/src/sql/partition_info.cc:1553 #5 0x0000000000c0dc1d in partition_info::vers_update_range_constants (this=0x7f04b8180900, thd=0x7f04b8000c00) at /home/travis/src/sql/partition_info.h:565 #6 0x0000000000bf222a in prune_partitions (thd=0x7f04b8000c00, table=0x7f04b814c7b0, pprune_cond=0x7f04b8015138) at /home/travis/src/sql/opt_range.cc:3460 #7 0x00000000007f034e in JOIN::optimize_inner (this=0x7f04b8014588) at /home/travis/src/sql/sql_select.cc:1868 #8 0x00000000007ef1e2 in JOIN::optimize (this=0x7f04b8014588) at /home/travis/src/sql/sql_select.cc:1556 #9 0x00000000007f87fe in mysql_select (thd=0x7f04b8000c00, tables=0x7f04b8013cf8, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7f04b8014418, group=0x0, having=0x0, proc_param=0x0, select_options=551906183680, result=0x7f04b8014508, unit=0x7f04b8004998, select_lex=0x7f04b80050f0) at /home/travis/src/sql/sql_select.cc:4244 #10 0x00000000007eaa4a in handle_select (thd=0x7f04b8000c00, lex=0x7f04b80048d0, result=0x7f04b8014508, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382 #11 0x00000000007b5dd3 in execute_sqlcom_select (thd=0x7f04b8000c00, all_tables=0x7f04b8013cf8) at /home/travis/src/sql/sql_parse.cc:6535 #12 0x00000000007ac1ef in mysql_execute_command (thd=0x7f04b8000c00) at /home/travis/src/sql/sql_parse.cc:3749 #13 0x00000000007b9737 in mysql_parse (thd=0x7f04b8000c00, rawbuf=0x7f04b8013a18 "SELECT sys_trx_start FROM `table0_aria_int` ORDER BY RAND() LIMIT 1 INTO @trx /* QNO 36847 CON_ID 16 */", length=103, parser_state=0x7f0501871470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991 #14 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7f04b8000c00, packet=0x7f04b800b251 "SELECT sys_trx_start FROM `table0_aria_int` ORDER BY RAND() LIMIT 1 INTO @trx /* QNO 36847 CON_ID 16 */ ", packet_length=104, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 #15 0x00000000007a565d in do_command (thd=0x7f04b8000c00) at /home/travis/src/sql/sql_parse.cc:1370 #16 0x000000000090b7cf in do_handle_one_connection (connect=0x38ce530) at /home/travis/src/sql/sql_connect.cc:1420 #17 0x000000000090b551 in handle_one_connection (arg=0x38ce530) at /home/travis/src/sql/sql_connect.cc:1326 #18 0x00007f0504f34e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #19 0x00007f05044502ed in clone () from /lib/x86_64-linux-gnu/libc.so.6 #20 0x0000000000000000 in ?? () {noformat} {noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514738181 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4 {noformat} ] |
Assignee | Alexander Krizhanovsky [ krizhanovsky ] | Aleksey Midenkov [ midenok ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Link |
This issue is duplicated by |
Link |
This issue is duplicated by |
Summary | Server crashes in in base_list_iterator::next / partition_info::check_range_constants | Server crashes in prep_alter_part_table() after table lock and multiple add partition |
Component/s | System versioning [ 14303 ] |
Component/s | Data Definition - Alter Table [ 10114 ] | |
Component/s | Optimizer [ 10200 ] |
Status | In Progress [ 3 ] | Stalled [ 10000 ] |
Assignee | Aleksey Midenkov [ midenok ] | Sergei Golubchik [ serg ] |
Status | Stalled [ 10000 ] | In Review [ 10002 ] |
Assignee | Sergei Golubchik [ serg ] | Aleksey Midenkov [ midenok ] |
Fix Version/s | 10.3.4 [ 22904 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Review [ 10002 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 84667 ] | MariaDB v4 [ 153470 ] |