[MDEV-20302] Assertion `page_st != 2' failed in read_big_block or server hangs upon concurrent SELECT from partitioned S3 table - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.5
Fix Version/s: 10.5.4
Component/s: Partitioning, Storage Engine - S3
Labels:
None

Description

Note: The test case currently fails every time for me on 10.5 debug builds, but it's a race condition, so run repeatedly if it doesn't fail right away. Remember to use all necessary S3 options and clean the bucket between the tries.

The failure comes in two forms, either as an assertion failure, or as server hang.

--source include/have_partition.inc

CREATE TABLE t1 (

    pk INT AUTO_INCREMENT,

    c CHAR(12),

    PRIMARY KEY(pk),

    KEY(c)

) ENGINE=Aria

  PARTITION BY KEY(pk) PARTITIONS 2;

CREATE VIEW v1 AS SELECT * FROM t1;

INSERT INTO t1 VALUES (NULL,'ill'),(NULL,'loop');

ALTER TABLE t1 ENGINE=S3;

--connect (con1,localhost,root,,test)

--send

    SELECT * FROM t1 WHERE c BETWEEN 'bar' AND 'foo';

--connection default

SELECT pk FROM v1;

--connection con1

--reap

# Cleanup

--disconnect con1

--connection default

DROP VIEW v1;

DROP TABLE t1;

10.5 46553c25
mysqld: /data/src/10.5/storage/maria/ma_pagecache.c:2813: read_big_block: Assertion `page_st != 2' failed.
190809 5:07:44 [ERROR] mysqld got signal 6 ;

#7 0x00007f2036fe5f12 in __GI___assert_fail (assertion=0x5614a79f72e9 "page_st != 2", file=0x5614a79f60f8 "/data/src/10.5/storage/maria/ma_pagecache.c", line=2813, function=0x5614a79f8688 <__PRETTY_FUNCTION__.16070> "read_big_block") at assert.c:101
#8 0x00005614a744d1c0 in read_big_block (pagecache=0x5614a8b7dd60 <s3_pagecache>, block=0x7f202a48d128) at /data/src/10.5/storage/maria/ma_pagecache.c:2813
#9 0x00005614a744f6c8 in pagecache_read (pagecache=0x5614a8b7dd60 <s3_pagecache>, file=0x7f2008283768, pageno=2, level=3, buff=0x7f200c02da38 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7f202958b260) at /data/src/10.5/storage/maria/ma_pagecache.c:3705
#10 0x00005614a7476c06 in _ma_fetch_keypage (page=0x7f202958b350, info=0x7f200c02d2f0, keyinfo=0x7f2008283ed8, pos=16384, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, level=3, buff=0x7f200c02da38 '\245' <repeats 200 times>..., return_buffer=1 '\001') at /data/src/10.5/storage/maria/ma_page.c:109
#11 0x00005614a74ad71d in _ma_search_pos (info=0x7f200c02d2f0, key=0x7f202958b3e0, nextflag=97, pos=16384) at /data/src/10.5/storage/maria/ma_range.c:223
#12 0x00005614a74ad513 in _ma_record_pos (info=0x7f200c02d2f0, key_data=0x7f200c04aae0 "", keypart_map=1, search_flag=HA_READ_KEY_EXACT) at /data/src/10.5/storage/maria/ma_range.c:186
#13 0x00005614a74ad232 in maria_records_in_range (info=0x7f200c02d2f0, inx=1, min_key=0x7f202958b620, max_key=0x7f202958b640) at /data/src/10.5/storage/maria/ma_range.c:99
#14 0x00005614a742661c in ha_maria::records_in_range (this=0x7f200c020f68, inx=1, min_key=0x7f202958b620, max_key=0x7f202958b640) at /data/src/10.5/storage/maria/ha_maria.cc:3265
#15 0x00005614a6c0e483 in handler::multi_range_read_info_const (this=0x7f200c020f68, keyno=1, seq=0x7f200c020ea8, seq_init_param=0x7f200c023448, n_ranges_arg=1, bufsz=0x7f202958b744, flags=0x7f202958b740, cost=0x7f202958b850) at /data/src/10.5/sql/multi_range_read.cc:159
#16 0x00005614a6c11ea4 in DsMrr_impl::dsmrr_info_const (this=0x7f200c0213f8, keyno=1, seq=0x7f200c020ea8, seq_init_param=0x7f200c023448, n_ranges=1, bufsz=0x7f200c023418, flags=0x7f202958b7f8, cost=0x7f202958b850) at /data/src/10.5/sql/multi_range_read.cc:1579
#17 0x00005614a7427bbd in ha_maria::multi_range_read_info_const (this=0x7f200c020f68, keyno=1, seq=0x7f200c020ea8, seq_init_param=0x7f200c023448, n_ranges=1, bufsz=0x7f200c023418, flags=0x7f202958b7f8, cost=0x7f202958b850) at /data/src/10.5/storage/maria/ha_maria.cc:3904
#18 0x00005614a6f9d1ed in ha_partition::multi_range_read_info_const (this=0x7f200c0206f8, keyno=1, seq=0x7f202958b930, seq_init_param=0x7f202958b960, n_ranges=0, bufsz=0x7f202958bef8, mrr_mode=0x7f202958bef4, cost=0x7f202958bfe0) at /data/src/10.5/sql/ha_partition.cc:6315
#19 0x00005614a6ed24fa in check_quick_select (param=0x7f202958c250, idx=0, index_only=false, tree=0x7f200c049b60, update_tbl_stats=true, mrr_flags=0x7f202958bef4, bufsize=0x7f202958bef8, cost=0x7f202958bfe0, is_ror_scan=0x7f202958bef2) at /data/src/10.5/sql/opt_range.cc:11046
#20 0x00005614a6ec8ff0 in get_key_scans_params (param=0x7f202958c250, tree=0x7f200c049970, index_read_must_be_used=false, update_tbl_stats=true, read_time=10.5) at /data/src/10.5/sql/opt_range.cc:7365
#21 0x00005614a6ebdd6d in SQL_SELECT::test_quick_select (this=0x7f200c017268, thd=0x7f200c0026b0, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true, only_single_index_range_scan=false) at /data/src/10.5/sql/opt_range.cc:2895
#22 0x00005614a6a84cb3 in get_quick_record_count (thd=0x7f200c0026b0, select=0x7f200c017268, table=0x7f200c01f890, keys=0x7f200c0161b0, limit=18446744073709551615) at /data/src/10.5/sql/sql_select.cc:4649
#23 0x00005614a6a874a1 in make_join_statistics (join=0x7f200c0155a0, tables_list=..., keyuse_array=0x7f200c015890) at /data/src/10.5/sql/sql_select.cc:5371
#24 0x00005614a6a7bf16 in JOIN::optimize_inner (this=0x7f200c0155a0) at /data/src/10.5/sql/sql_select.cc:2193
#25 0x00005614a6a79b86 in JOIN::optimize (this=0x7f200c0155a0) at /data/src/10.5/sql/sql_select.cc:1563
#26 0x00005614a6a8497c in mysql_select (thd=0x7f200c0026b0, tables=0x7f200c014180, wild_num=1, fields=..., conds=0x7f200c014ab8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f200c015578, unit=0x7f200c0065d8, select_lex=0x7f200c013ba0) at /data/src/10.5/sql/sql_select.cc:4591
#27 0x00005614a6a7500c in handle_select (thd=0x7f200c0026b0, lex=0x7f200c006510, result=0x7f200c015578, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:425
#28 0x00005614a6a3ea36 in execute_sqlcom_select (thd=0x7f200c0026b0, all_tables=0x7f200c014180) at /data/src/10.5/sql/sql_parse.cc:6319
#29 0x00005614a6a34934 in mysql_execute_command (thd=0x7f200c0026b0) at /data/src/10.5/sql/sql_parse.cc:3882
#30 0x00005614a6a4279e in mysql_parse (thd=0x7f200c0026b0, rawbuf=0x7f200c013ad8 "SELECT * FROM t1 WHERE c BETWEEN 'bar' AND 'foo'", length=48, parser_state=0x7f202958e180, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7868
#31 0x00005614a6a2eb2b in dispatch_command (command=COM_QUERY, thd=0x7f200c0026b0, packet=0x7f200c00a0a1 "SELECT * FROM t1 WHERE c BETWEEN 'bar' AND 'foo'", packet_length=48, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1827
#32 0x00005614a6a2d2e9 in do_command (thd=0x7f200c0026b0) at /data/src/10.5/sql/sql_parse.cc:1360
#33 0x00005614a6bb98eb in do_handle_one_connection (connect=0x5614aa17fb50, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1413
#34 0x00005614a6bb962f in handle_one_connection (arg=0x5614aa17fb50) at /data/src/10.5/sql/sql_connect.cc:1309
#35 0x00005614a6fe3c5f in pfs_spawn_thread (arg=0x5614aa0eddb0) at /data/src/10.5/storage/perfschema/pfs.cc:1862
#36 0x00007f20391954a4 in start_thread (arg=0x7f202958f700) at pthread_create.c:456
#37 0x00007f20370a2d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

All threads' stack trace from an alive server when it hangs:

Thread 7 (Thread 0x7fd3529e2700 (LWP 18563)):

#0  0x00007fd3644f78bd in poll () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055b13869d0fc in vio_io_wait (vio=0x7fd330009e30, event=VIO_IO_EVENT_READ, timeout=28800000) at /data/src/10.5/vio/viosocket.c:980

#2  0x000055b13869b718 in vio_socket_io_wait (vio=0x7fd330009e30, event=VIO_IO_EVENT_READ) at /data/src/10.5/vio/viosocket.c:118

#3  0x000055b13869b900 in vio_read (vio=0x7fd330009e30, buf=0x7fd33000a0a0 "\001", size=4) at /data/src/10.5/vio/viosocket.c:199

#4  0x000055b1385f5751 in my_real_read (net=0x7fd3300029a8, complen=0x7fd3529e1950, header=1 '\001') at /data/src/10.5/sql/net_serv.cc:962

#5  0x000055b1385f5fc5 in my_net_read_packet_reallen (net=0x7fd3300029a8, read_from_server=1 '\001', reallen=0x7fd3529e19b8) at /data/src/10.5/sql/net_serv.cc:1243

#6  0x000055b1385f5f79 in my_net_read_packet (net=0x7fd3300029a8, read_from_server=1 '\001') at /data/src/10.5/sql/net_serv.cc:1227

#7  0x000055b13816bc15 in do_command (thd=0x7fd3300026b0) at /data/src/10.5/sql/sql_parse.cc:1233

#8  0x000055b1382f88eb in do_handle_one_connection (connect=0x55b13c0c9b60, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1413

#9  0x000055b1382f862f in handle_one_connection (arg=0x55b13c0c9b60) at /data/src/10.5/sql/sql_connect.cc:1309

#10 0x000055b138722c5f in pfs_spawn_thread (arg=0x55b13c037dc0) at /data/src/10.5/storage/perfschema/pfs.cc:1862

#11 0x00007fd3665f34a4 in start_thread (arg=0x7fd3529e2700) at pthread_create.c:456

#12 0x00007fd364500d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Thread 6 (Thread 0x7fd358055700 (LWP 18550)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x000055b138ccd788 in safe_cond_wait (cond=0x7fd33c0008c8, mp=0x55b13a2bce28 <s3_pagecache+200>, file=0x55b139134fe0 "/data/src/10.5/include/mysql/psi/mysql_thread.h", line=1167) at /data/src/10.5/mysys/thr_mutex.c:492

#2  0x000055b138b85608 in inline_mysql_cond_wait (that=0x7fd33c0008c8, mutex=0x55b13a2bce28 <s3_pagecache+200>, src_file=0x55b1391350f8 "/data/src/10.5/storage/maria/ma_pagecache.c", src_line=3043) at /data/src/10.5/include/mysql/psi/mysql_thread.h:1167

#3  0x000055b138b8cdd5 in read_block (pagecache=0x55b13a2bcd60 <s3_pagecache>, block=0x7fd3580ec128, primary=0 '\000') at /data/src/10.5/storage/maria/ma_pagecache.c:3043

#4  0x000055b138b8e64c in pagecache_read (pagecache=0x55b13a2bcd60 <s3_pagecache>, file=0x7fd330121168, pageno=1, level=3, buff=0x7fd33c090e88 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7fd358052910) at /data/src/10.5/storage/maria/ma_pagecache.c:3696

#5  0x000055b138bb5c06 in _ma_fetch_keypage (page=0x7fd3580529d0, info=0x7fd33c08e740, keyinfo=0x7fd330121818, pos=8192, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, level=3, buff=0x7fd33c090e88 '\245' <repeats 200 times>..., return_buffer=0 '\000') at /data/src/10.5/storage/maria/ma_page.c:109

#6  0x000055b138bb3ff2 in _ma_search_first (info=0x7fd33c08e740, keyinfo=0x7fd330121818, pos=8192) at /data/src/10.5/storage/maria/ma_search.c:1766

#7  0x000055b138baee3d in maria_rnext (info=0x7fd33c08e740, buf=0x7fd33c0c4ce2 '\245' <repeats 23 times>, "\001", inx=0) at /data/src/10.5/storage/maria/ma_rnext.c:63

#8  0x000055b138beaa36 in maria_rfirst (info=0x7fd33c08e740, buf=0x7fd33c0c4ce2 '\245' <repeats 23 times>, "\001", inx=0) at /data/src/10.5/storage/maria/ma_rfirst.c:25

#9  0x000055b138b63311 in ha_maria::index_first (this=0x7fd33c061148, buf=0x7fd33c0c4ce2 '\245' <repeats 23 times>, "\001") at /data/src/10.5/storage/maria/ha_maria.cc:2387

#10 0x000055b138497836 in handler::ha_index_first (this=0x7fd33c061148, buf=0x7fd33c0c4ce2 '\245' <repeats 23 times>, "\001") at /data/src/10.5/sql/handler.cc:2942

#11 0x000055b1386dfcc9 in ha_partition::handle_ordered_index_scan (this=0x7fd33c0608d8, buf=0x7fd33c138988 "\377", reverse_order=false) at /data/src/10.5/sql/ha_partition.cc:7504

#12 0x000055b1386da6ed in ha_partition::common_first_last (this=0x7fd33c0608d8, buf=0x7fd33c138988 "\377") at /data/src/10.5/sql/ha_partition.cc:5736

#13 0x000055b1386da54c in ha_partition::index_first (this=0x7fd33c0608d8, buf=0x7fd33c138988 "\377") at /data/src/10.5/sql/ha_partition.cc:5680

#14 0x000055b1384977f0 in handler::ha_index_first (this=0x7fd33c0608d8, buf=0x7fd33c138988 "\377") at /data/src/10.5/sql/handler.cc:2942

#15 0x000055b1381f07d0 in join_read_first (tab=0x7fd33c1c91b0) at /data/src/10.5/sql/sql_select.cc:21228

#16 0x000055b1381ee04b in sub_select (join=0x7fd33c018300, join_tab=0x7fd33c1c91b0, end_of_records=false) at /data/src/10.5/sql/sql_select.cc:20223

#17 0x000055b1381ed5da in do_select (join=0x7fd33c018300, procedure=0x0) at /data/src/10.5/sql/sql_select.cc:19764

#18 0x000055b1381c31c3 in JOIN::exec_inner (this=0x7fd33c018300) at /data/src/10.5/sql/sql_select.cc:4391

#19 0x000055b1381c2370 in JOIN::exec (this=0x7fd33c018300) at /data/src/10.5/sql/sql_select.cc:4173

#20 0x000055b1381c3a15 in mysql_select (thd=0x7fd33c000b10, tables=0x7fd33c0139f8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fd33c0182d8, unit=0x7fd33c004a38, select_lex=0x7fd33c013410) at /data/src/10.5/sql/sql_select.cc:4605

#21 0x000055b1381b400c in handle_select (thd=0x7fd33c000b10, lex=0x7fd33c004970, result=0x7fd33c0182d8, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:425

#22 0x000055b13817da36 in execute_sqlcom_select (thd=0x7fd33c000b10, all_tables=0x7fd33c0139f8) at /data/src/10.5/sql/sql_parse.cc:6319

#23 0x000055b138173934 in mysql_execute_command (thd=0x7fd33c000b10) at /data/src/10.5/sql/sql_parse.cc:3882

#24 0x000055b13818179e in mysql_parse (thd=0x7fd33c000b10, rawbuf=0x7fd33c013388 "SELECT pk FROM v1", length=17, parser_state=0x7fd358054180, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7868

#25 0x000055b13816db2b in dispatch_command (command=COM_QUERY, thd=0x7fd33c000b10, packet=0x7fd33c008321 "", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1827

#26 0x000055b13816c2e9 in do_command (thd=0x7fd33c000b10) at /data/src/10.5/sql/sql_parse.cc:1360

#27 0x000055b1382f88eb in do_handle_one_connection (connect=0x55b13c0c9b60, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1413

#28 0x000055b1382f862f in handle_one_connection (arg=0x55b13c0c9b60) at /data/src/10.5/sql/sql_connect.cc:1309

#29 0x000055b138722c5f in pfs_spawn_thread (arg=0x55b13c037dc0) at /data/src/10.5/storage/perfschema/pfs.cc:1862

#30 0x00007fd3665f34a4 in start_thread (arg=0x7fd358055700) at pthread_create.c:456

#31 0x00007fd364500d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Thread 5 (Thread 0x7fd3580a0700 (LWP 18547)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x000055b138ccd788 in safe_cond_wait (cond=0x55b139a187e0 <COND_slave_background>, mp=0x55b139a1b9a0 <LOCK_slave_background>, file=0x55b138d7e1b0 "/data/src/10.5/include/mysql/psi/mysql_thread.h", line=1167) at /data/src/10.5/mysys/thr_mutex.c:492

#2  0x000055b138068efe in inline_mysql_cond_wait (that=0x55b139a187e0 <COND_slave_background>, mutex=0x55b139a1b9a0 <LOCK_slave_background>, src_file=0x55b138d7ecad "/data/src/10.5/sql/slave.cc", src_line=519) at /data/src/10.5/include/mysql/psi/mysql_thread.h:1167

#3  0x000055b13806a764 in handle_slave_background (arg=0x0) at /data/src/10.5/sql/slave.cc:519

#4  0x000055b138722c5f in pfs_spawn_thread (arg=0x55b13c118320) at /data/src/10.5/storage/perfschema/pfs.cc:1862

#5  0x00007fd3665f34a4 in start_thread (arg=0x7fd3580a0700) at pthread_create.c:456

#6  0x00007fd364500d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Thread 4 (Thread 0x7fd3580eb700 (LWP 18546)):

#0  0x00007fd36444bf26 in __GI___sigwaitinfo (set=<optimized out>, info=0x7fd3580ead50) at ../sysdeps/unix/sysv/linux/sigwaitinfo.c:56

#1  0x000055b13803884e in my_sigwait (set=0x7fd3580eae30, sig=0x7fd3580eadf4, code=0x7fd3580eadf8) at /data/src/10.5/include/my_pthread.h:198

#2  0x000055b13803ecba in signal_hand (arg=0x0) at /data/src/10.5/sql/mysqld.cc:3155

#3  0x000055b138722c5f in pfs_spawn_thread (arg=0x55b13c02fcf0) at /data/src/10.5/storage/perfschema/pfs.cc:1862

#4  0x00007fd3665f34a4 in start_thread (arg=0x7fd3580eb700) at pthread_create.c:456

#5  0x00007fd364500d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Thread 3 (Thread 0x7fd353fff700 (LWP 18544)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055b138ccda92 in safe_cond_timedwait (cond=0x55b13a2bcb40 <COND_checkpoint>, mp=0x55b13a2bca80 <LOCK_checkpoint>, abstime=0x7fd353ffee00, file=0x55b13913a1e0 "/data/src/10.5/include/mysql/psi/mysql_thread.h", line=1204) at /data/src/10.5/mysys/thr_mutex.c:546

#2  0x000055b138b9f708 in inline_mysql_cond_timedwait (that=0x55b13a2bcb40 <COND_checkpoint>, mutex=0x55b13a2bca80 <LOCK_checkpoint>, abstime=0x7fd353ffee00, src_file=0x55b13913a210 "/data/src/10.5/storage/maria/ma_servicethread.c", src_line=116) at /data/src/10.5/include/mysql/psi/mysql_thread.h:1204

#3  0x000055b138b9fc2d in my_service_thread_sleep (control=0x55b13985c7c0 <checkpoint_control>, sleep_time=30000000000) at /data/src/10.5/storage/maria/ma_servicethread.c:115

#4  0x000055b138b94005 in ma_checkpoint_background (arg=0x1e) at /data/src/10.5/storage/maria/ma_checkpoint.c:707

#5  0x000055b138722c5f in pfs_spawn_thread (arg=0x55b13bf92110) at /data/src/10.5/storage/perfschema/pfs.cc:1862

#6  0x00007fd3665f34a4 in start_thread (arg=0x7fd353fff700) at pthread_create.c:456

#7  0x00007fd364500d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Thread 2 (Thread 0x7fd359a6d700 (LWP 18543)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055b138ccda92 in safe_cond_timedwait (cond=0x55b13a2c5f40 <COND_timer>, mp=0x55b13a2c5e80 <LOCK_timer>, abstime=0x7fd359a6ceb0, file=0x55b1391570d0 "/data/src/10.5/include/mysql/psi/mysql_thread.h", line=1204) at /data/src/10.5/mysys/thr_mutex.c:546

#2  0x000055b138ccea59 in inline_mysql_cond_timedwait (that=0x55b13a2c5f40 <COND_timer>, mutex=0x55b13a2c5e80 <LOCK_timer>, abstime=0x7fd359a6ceb0, src_file=0x55b139157100 "/data/src/10.5/mysys/thr_timer.c", src_line=292) at /data/src/10.5/include/mysql/psi/mysql_thread.h:1204

#3  0x000055b138ccf5be in timer_handler (arg=0x0) at /data/src/10.5/mysys/thr_timer.c:292

#4  0x000055b138722c5f in pfs_spawn_thread (arg=0x55b13bee2000) at /data/src/10.5/storage/perfschema/pfs.cc:1862

#5  0x00007fd3665f34a4 in start_thread (arg=0x7fd359a6d700) at pthread_create.c:456

#6  0x00007fd364500d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Thread 1 (Thread 0x7fd3669fe740 (LWP 18531)):

#0  0x00007fd3644f78bd in poll () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055b138044d7e in handle_connections_sockets () at /data/src/10.5/sql/mysqld.cc:6328

#2  0x000055b1380441a0 in mysqld_main (argc=141, argv=0x55b13bd9cce0) at /data/src/10.5/sql/mysqld.cc:5796

#3  0x000055b1380387d0 in main (argc=12, argv=0x7ffe2e15e628) at /data/src/10.5/sql/main.cc:25

Attachments

Issue Links

relates to

MDEV-17841 S3 Storage engine

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2019-08-09 02:15

Elena Stepanova made changes - 2019-08-09 13:12

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-17841~~ [ ~~MDEV-17841~~ ]

Michael Widenius made changes - 2020-06-08 12:22

Status

Open [ 1 ]

In Progress [ 3 ]

Michael Widenius added a comment - 2020-06-08 12:34

I have tested this with the latest code and the assert seams to be gone.
However, the hang with SELECT pk FROM v1 is still there and seams to happen for me at once in latest 10.5

Michael Widenius added a comment - 2020-06-08 12:34 I have tested this with the latest code and the assert seams to be gone. However, the hang with SELECT pk FROM v1 is still there and seams to happen for me at once in latest 10.5

Michael Widenius made changes - 2020-06-08 12:35

Assignee

Michael Widenius [ monty ]

Oleksandr Byelkin [ sanja ]

Michael Widenius made changes - 2020-06-08 12:46

Priority

Major [ 3 ]

Blocker [ 1 ]

Michael Widenius made changes - 2020-06-10 18:07

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Michael Widenius made changes - 2020-06-10 18:07

Assignee

Oleksandr Byelkin [ sanja ]

Michael Widenius [ monty ]

Michael Widenius made changes - 2020-06-10 18:07

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Michael Widenius added a comment - 2020-06-10 18:16

Worked together with Sanja to fix this.
Fix pushed into bb-10.5-monty to be merged soon with 10.5

Michael Widenius added a comment - 2020-06-10 18:16 Worked together with Sanja to fix this. Fix pushed into bb-10.5-monty to be merged soon with 10.5

Michael Widenius added a comment - 2020-06-15 10:44

Merged Sanja's work into my tree and pushed into 10.5

Michael Widenius added a comment - 2020-06-15 10:44 Merged Sanja's work into my tree and pushed into 10.5

Michael Widenius made changes - 2020-06-15 10:44

Fix Version/s		10.5.4 [ 24264 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Michael Widenius added a comment - 2020-06-18 15:33

Bug was not completely fixed.

Michael Widenius added a comment - 2020-06-18 15:33 Bug was not completely fixed.

Michael Widenius made changes - 2020-06-18 15:33

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2020-06-22 12:30

Fix Version/s		10.5 [ 23123 ]
Fix Version/s	10.5.4 [ 24264 ]

Michael Widenius made changes - 2020-07-17 14:31

Assignee

Michael Widenius [ monty ]

Oleksandr Byelkin [ sanja ]

Elena Stepanova added a comment - 2020-07-21 08:47

I can easily reproduce the failure on a build before 4243785f288149fc1571b168cda1c921cfaf77a5, but not on this commit or on the top of the current 10.5 tree. So, unless there is evidence that the bug wasn't completely fixed, I am fine with closing the issue.

Elena Stepanova added a comment - 2020-07-21 08:47 I can easily reproduce the failure on a build before 4243785f288149fc1571b168cda1c921cfaf77a5, but not on this commit or on the top of the current 10.5 tree. So, unless there is evidence that the bug wasn't completely fixed, I am fine with closing the issue.

Michael Widenius added a comment - 2020-07-21 11:31

Already fixed

Michael Widenius added a comment - 2020-07-21 11:31 Already fixed

Michael Widenius made changes - 2020-07-21 11:31

issue.field.resolutiondate

2020-07-21 11:31:10.0

2020-07-21 11:31:10.754

Michael Widenius made changes - 2020-07-21 11:31

Fix Version/s		10.5.4 [ 24264 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:50

Workflow

MariaDB v3 [ 98835 ]

MariaDB v4 [ 156597 ]

People

Assignee:: Oleksandr Byelkin

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2019-08-09 02:15

Updated:: 2024-06-05 09:53

Resolved:: 2020-07-21 11:31

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration