Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
Note: it fails for me every time, but it's still a concurrent non-deterministic test case, run with --repeat if it doesn't fail for you right away.
CREATE TABLE t1 (f INT); |
ALTER TABLE t1 ENGINE=S3; |
|
--connect (con1,localhost,root,,test)
|
--send
|
ALTER TABLE t1 ENGINE=Aria; |
|
--connection default
|
SELECT * FROM t1; |
|
# Cleanup
|
--connection con1
|
--reap
|
--disconnect con1
|
--connection default
|
DROP TABLE t1; |
10.5 ebfe8c4e |
mysqld: /data/src/10.5/storage/maria/ma_pagecache.c:3698: pagecache_read: Assertion `page_st == 1' failed.
|
190523 21:49:27 [ERROR] mysqld got signal 6 ;
|
|
#5 0x00007f1b5b11142a in __GI_abort () at abort.c:89
|
#6 0x00007f1b5b108e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55cea2e07a04 "page_st == 1", file=file@entry=0x55cea2e06118 "/data/src/10.5/storage/maria/ma_pagecache.c", line=line@entry=3698, function=function@entry=0x55cea2e08778 <__PRETTY_FUNCTION__.16148> "pagecache_read") at assert.c:92
|
#7 0x00007f1b5b108f12 in __GI___assert_fail (assertion=0x55cea2e07a04 "page_st == 1", file=0x55cea2e06118 "/data/src/10.5/storage/maria/ma_pagecache.c", line=3698, function=0x55cea2e08778 <__PRETTY_FUNCTION__.16148> "pagecache_read") at assert.c:101
|
#8 0x000055cea281842d in pagecache_read (pagecache=0x55cea3fa1400 <s3_pagecache>, file=0x7f1b3011b1f8, pageno=0, level=0, buff=0x7f1b2c05fe60 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7f1b4d6fa7a0) at /data/src/10.5/storage/maria/ma_pagecache.c:3698
|
#9 0x000055cea285a96e in _ma_scan_block_record (info=0x7f1b2c11ef00, record=0x7f1b2c1abfc0 "\377", record_pos=0, skip_deleted=1 '\001') at /data/src/10.5/storage/maria/ma_blockrec.c:5568
|
#10 0x000055cea2846e8a in maria_scan (info=0x7f1b2c11ef00, record=0x7f1b2c1abfc0 "\377") at /data/src/10.5/storage/maria/ma_scan.c:54
|
#11 0x000055cea27ed47d in ha_maria::rnd_next (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377") at /data/src/10.5/storage/maria/ha_maria.cc:2541
|
#12 0x000055cea21f69d9 in handler::ha_rnd_next (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377") at /data/src/10.5/sql/handler.cc:2803
|
#13 0x000055cea21f8489 in handler::read_first_row (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377", primary_key=64) at /data/src/10.5/sql/handler.cc:3047
|
#14 0x000055cea1f4dcbd in handler::ha_read_first_row (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377", primary_key=64) at /data/src/10.5/sql/sql_class.h:6556
|
#15 0x000055cea1f345b7 in join_read_system (tab=0x7f1b2c0152c0) at /data/src/10.5/sql/sql_select.cc:20568
|
#16 0x000055cea1f3413c in join_read_const_table (thd=0x7f1b2c000b10, tab=0x7f1b2c0152c0, pos=0x7f1b2c015890) at /data/src/10.5/sql/sql_select.cc:20464
|
#17 0x000055cea1f0b77c in make_join_statistics (join=0x7f1b2c014a00, tables_list=..., keyuse_array=0x7f1b2c014cf0) at /data/src/10.5/sql/sql_select.cc:5020
|
#18 0x000055cea1f017fa in JOIN::optimize_inner (this=0x7f1b2c014a00) at /data/src/10.5/sql/sql_select.cc:2191
|
#19 0x000055cea1eff46a in JOIN::optimize (this=0x7f1b2c014a00) at /data/src/10.5/sql/sql_select.cc:1561
|
#20 0x000055cea1f0a260 in mysql_select (thd=0x7f1b2c000b10, tables=0x7f1b2c0139d0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f1b2c0149d8, unit=0x7f1b2c004a38, select_lex=0x7f1b2c013410) at /data/src/10.5/sql/sql_select.cc:4589
|
#21 0x000055cea1efa8f8 in handle_select (thd=0x7f1b2c000b10, lex=0x7f1b2c004970, result=0x7f1b2c0149d8, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:424
|
#22 0x000055cea1ec42f7 in execute_sqlcom_select (thd=0x7f1b2c000b10, all_tables=0x7f1b2c0139d0) at /data/src/10.5/sql/sql_parse.cc:6600
|
#23 0x000055cea1eb9558 in mysql_execute_command (thd=0x7f1b2c000b10) at /data/src/10.5/sql/sql_parse.cc:3887
|
#24 0x000055cea1ec808b in mysql_parse (thd=0x7f1b2c000b10, rawbuf=0x7f1b2c013388 "SELECT * FROM t1", length=16, parser_state=0x7f1b4d6fc180, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8152
|
#25 0x000055cea1eb3715 in dispatch_command (command=COM_QUERY, thd=0x7f1b2c000b10, packet=0x7f1b2c008321 "SELECT * FROM t1", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1829
|
#26 0x000055cea1eb1ed5 in do_command (thd=0x7f1b2c000b10) at /data/src/10.5/sql/sql_parse.cc:1362
|
#27 0x000055cea2029e5b in do_handle_one_connection (connect=0x55cea4ec1e80, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1413
|
#28 0x000055cea2029b9f in handle_one_connection (arg=0x55cea4ec1e80) at /data/src/10.5/sql/sql_connect.cc:1309
|
#29 0x000055cea295d953 in pfs_spawn_thread (arg=0x55cea4ec1ad0) at /data/src/10.5/storage/perfschema/pfs.cc:1862
|
#30 0x00007f1b5d4e44a4 in start_thread (arg=0x7f1b4d6fd700) at pthread_create.c:456
|
#31 0x00007f1b5b1c5d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Attachments
Issue Links
- relates to
-
MDEV-19416 Test S3 Storage engine
- Closed