[MDEV-13661] main.sum_distinct-big failed in buildbot, timeout after 7200 seconds Created: 2017-08-28  Updated: 2023-12-01

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2-big/builds/1135/steps/test/logs/stdio

main.sum_distinct-big 'innodb'           w2 [ fail ]  timeout after 7200 seconds
 
        Test ended at 2017-08-27 20:22:39
 
 
 
Test case timeout after 7200 seconds
 
 
 
== /mnt/buildbot/build/mariadb-10.3.1/mysql-test/var/2/log/sum_distinct-big.log == 
INSERT INTO t1 (id) SELECT id FROM t1;
 
INSERT INTO t1 (id) SELECT id FROM t1;
 
INSERT INTO t1 (id) SELECT id FROM t1;
 
INSERT INTO t1 (id) SELECT id FROM t1;
 
INSERT INTO t1 (id) SELECT id FROM t1;
 
INSERT INTO t1 SELECT id+1 FROM t1;
 
INSERT INTO t1 SELECT id+2 FROM t1;
 
INSERT INTO t1 SELECT id+4 FROM t1;
 
INSERT INTO t1 SELECT id+8 FROM t1;
 
INSERT INTO t1 SELECT id+16 FROM t1;
 
INSERT INTO t1 SELECT id+32 FROM t1;
 
INSERT INTO t1 SELECT id+64 FROM t1;
 
INSERT INTO t1 SELECT id+128 FROM t1;
 
INSERT INTO t1 SELECT id+256 FROM t1;
 
INSERT INTO t1 SELECT id+512 FROM t1;
 
INSERT INTO t1 SELECT id+1024 FROM t1;
 
INSERT INTO t1 SELECT id+2048 FROM t1;
 
INSERT INTO t1 SELECT id+4096 FROM t1;
 
INSERT INTO t1 SELECT id+8192 FROM t1;
 
INSERT INTO t2 SELECT id FROM t1 ORDER BY id*rand();



 Comments   
Comment by Elena Stepanova [ 2017-09-15 ]

It looks like the timeout appeared in 10.3 between 7a5eb0032 (still OK) and 77c41fa72 (timeout).

Comment by Alice Sherepa [ 2018-04-06 ]

on 10.3 the last failure with timeout was 29-08-2017, then it failed with ASAN til 08-11, now test is skipped ( needs --big-test)
on 10.1 it fails with ASAN http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/1686/steps/mtr_emb/logs/stdio (2018-04-04 )

Comment by Alice Sherepa [ 2022-03-10 ]

https://buildbot.mariadb.org/#/builders/195/builds/4649

10.5

 
[Revision hash: a112a80b4762dbb80b25ae0e8bcd93893eacec5f]
 
 
 
main.sum_distinct-big 'innodb'           w1 [ fail ]  timeout after 900 seconds
 
        Test ended at 2022-02-22 13:06:27
 
 
 
Test case timeout after 900 seconds
 
 
 
== /buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/1/log/sum_distinct-big.log == 
sm
 
536887296
 
SET max_heap_table_size=16384;
 
SELECT SUM(DISTINCT id) sm FROM t2;
 
sm
 
536887296
 
DROP TABLE t1;
 
DROP TABLE t2;
 
SET @@tmp_table_size=@save_tmp_table_size;
 
SET @@max_heap_table_size=@save_max_heap_table_size;
 
#
 
# MDEV-4311: COUNT(DISTINCT...) requiring a file for UNIQUE (bug #68749)
 
#
 
CREATE TABLE t2 (id INTEGER) ENGINE=InnoDB;
 
BEGIN;
 
INSERT INTO t2 SELECT b.seq FROM seq_1_to_128 a, seq_1_to_16384 b
 
ORDER BY b.seq*rand();
 
INSERT INTO t2 VALUE(NULL);
 
# With default tmp_table_size / max_heap_table_size
 
SELECT SQL_NO_CACHE count(DISTINCT id) sm FROM t2;
 
 
 
 == /buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err ==
 
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/tmp/1/mysq' (111)
 
 
 
 
 
 - found 'core' (0/5)
 
 
 
Trying 'dbx' to get a backtrace
 
 
 
Trying 'gdb' to get a backtrace from coredump /buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/1/log/main.sum_distinct-big-innodb/mysqld.1/data/core
 
Core generated by '/buildbot/amd64-ubuntu-1804-msan/build/sql/mariadbd'
 
Output from gdb follows. The first stack trace is from the failing thread.
 
The following stack traces are from all threads (so the failing one is
 
duplicated).
 
--------------------------
 
[New LWP 3104]
 
[New LWP 3109]
 
[New LWP 3132]
 
[New LWP 3110]
 
[New LWP 3134]
 
[New LWP 12478]
 
[New LWP 3108]
 
[New LWP 3133]
 
[Thread debugging using libthread_db enabled]
 
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
 
Core was generated by `/buildbot/amd64-ubuntu-1804-msan/build/sql/mariadbd --defaults-group-suffix=.1'.
 
Program terminated with signal SIGABRT, Aborted.
 
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
 
57	../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
 
[Current thread is 1 (Thread 0x7f13dcd40840 (LWP 3104))]
 
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
 
#1  0x000055721b638876 in handle_fatal_signal (sig=<optimized out>) at signal_handler.cc:344
 
#2  0x000055721a4044b9 in SignalHandler(int) () at sql_basic_types.h:151
 
#3  <signal handler called>
 
#4  0x00007f13dafc5cb9 in __GI___poll (fds=0x7fff22015ce0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
 
#5  0x000055721a3d8ed2 in poll () at sql_basic_types.h:151
 
#6  0x000055721a45ad45 in handle_connections_sockets () at mysqld.cc:6210
 
#7  0x000055721a4479b6 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at mysqld.cc:5659
 
#8  0x000055721a4329f4 in main (argc=570514656, argv=0x2) at main.cc:25
 
 
 
Thread 8 (Thread 0x7f13d2a76700 (LWP 3133)):
 
#0  0x00007f13dbeb4ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x5572212728a0 <COND_manager+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88
 
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x5572212727f0 <LOCK_manager+40>, cond=0x557221272878 <COND_manager>) at pthread_cond_wait.c:502
 
#2  __pthread_cond_wait (cond=0x557221272878 <COND_manager>, mutex=0x5572212727f0 <LOCK_manager+40>) at pthread_cond_wait.c:655
 
#3  0x000055721db25042 in safe_cond_wait (cond=0x557221272878 <COND_manager>, mp=0x5572212727c8 <LOCK_manager>, file=0x55721e2bdd71 "/buildbot/amd64-ubuntu-1804-msan/build/include/mysql/psi/mysql_thread.h", line=1222) at thr_mutex.c:492
 
#4  0x000055721a9110f5 in inline_mysql_cond_wait (that=<optimized out>, mutex=<optimized out>, src_file=<optimized out>, src_line=103) at /buildbot/amd64-ubuntu-1804-msan/build/include/mysql/psi/mysql_thread.h:1222
 
#5  handle_manager (arg=<optimized out>) at sql_manager.cc:103
 
#6  0x000055721c4d04f1 in pfs_spawn_thread (arg=0x714000003818) at pfs.cc:2201
 
#7  0x00007f13dbeae6db in start_thread (arg=0x7f13d2a76700) at pthread_create.c:463
 
#8  0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 7 (Thread 0x7f13d518f840 (LWP 3108)):
 
#0  0x00007f13dbeb5065 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f13d518de20, expected=0, futex_word=0x557221b51898 <COND_timer+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205
 
#1  __pthread_cond_wait_common (abstime=0x7f13d518de20, mutex=0x557221b517e8 <LOCK_timer+40>, cond=0x557221b51870 <COND_timer>) at pthread_cond_wait.c:539
 
#2  __pthread_cond_timedwait (cond=0x557221b51870 <COND_timer>, mutex=0x557221b517e8 <LOCK_timer+40>, abstime=0x7f13d518de20) at pthread_cond_wait.c:667
 
#3  0x000055721db26039 in safe_cond_timedwait (cond=0x557221b51870 <COND_timer>, mp=0x557221b517c0 <LOCK_timer>, abstime=0x7f13d518de20, file=0x55721e2bdd71 "/buildbot/amd64-ubuntu-1804-msan/build/include/mysql/psi/mysql_thread.h", line=<optimized out>) at thr_mutex.c:546
 
#4  0x000055721db291a2 in inline_mysql_cond_timedwait (that=<optimized out>, mutex=<optimized out>, abstime=0x7f13d518de20, src_file=<optimized out>, src_line=321) at /buildbot/amd64-ubuntu-1804-msan/build/include/mysql/psi/mysql_thread.h:1259
 
#5  timer_handler (arg=<optimized out>) at thr_timer.c:321
 
#6  0x000055721c4d04f1 in pfs_spawn_thread (arg=0x714000000018) at pfs.cc:2201
 
#7  0x00007f13dbeae6db in start_thread (arg=0x7f13d518f840) at pthread_create.c:463
 
#8  0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 6 (Thread 0x7f13c51e0700 (LWP 12478)):
 
#0  0x00007f13dbeb5065 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f13c51deb80, expected=0, futex_word=0x73000002f228) at ../sysdeps/unix/sysv/linux/futex-internal.h:205
 
#1  __pthread_cond_wait_common (abstime=0x7f13c51deb80, mutex=0x717000000490, cond=0x73000002f200) at pthread_cond_wait.c:539
 
#2  __pthread_cond_timedwait (cond=0x73000002f200, mutex=0x717000000490, abstime=0x7f13c51deb80) at pthread_cond_wait.c:667
 
#3  0x00007f13db94d1a6 in __libcpp_condvar_timedwait () at /mariadb/llvm-toolchain-10-10.0.1/libcxx/include/__threading_support:359
 
#4  __do_timed_wait () at /mariadb/llvm-toolchain-10-10.0.1/libcxx/src/condition_variable.cpp:74
 
#5  0x000055721d848dea in std::__1::condition_variable::wait_for<long long, std::__1::ratio<1l, 1000l> > (this=0x73000002f200, __lk=..., __d=...) at /usr/lib/llvm-10/bin/../include/c++/v1/__mutex_base:465
 
#6  tpool::thread_pool_generic::wait_for_tasks (this=<optimized out>, lk=..., thread_data=0x73000002f200) at tpool_generic.cc:446
 
#7  0x000055721d8497f2 in tpool::thread_pool_generic::get_task (this=0x717000000380, thread_var=0x73000002f200, t=0x7f13c51ded58) at tpool_generic.cc:499
 
#8  0x000055721d84a4d8 in tpool::thread_pool_generic::worker_main (this=<optimized out>, thread_var=0x73000002f200) at tpool_generic.cc:544
 
#9  0x000055721d8544cd in std::__1::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*, void> (__f=<optimized out>, __a0=<optimized out>, __args=<optimized out>) at /usr/lib/llvm-10/bin/../include/c++/v1/type_traits:3480
 
#10 std::__1::__thread_execute<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*, 2ul, 3ul> (__t=...) at /usr/lib/llvm-10/bin/../include/c++/v1/thread:273
 
#11 std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > (__vp=<optimized out>) at /usr/lib/llvm-10/bin/../include/c++/v1/thread:284
 
#12 0x00007f13dbeae6db in start_thread (arg=0x7f13c51e0700) at pthread_create.c:463
 
#13 0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 5 (Thread 0x7f13d2a2b700 (LWP 3134)):
 
#0  0x00007f13dbeb1014 in __GI___pthread_mutex_lock (mutex=0x557221b45ea0 <rw_lock_debug_mutex+112>) at ../nptl/pthread_mutex_lock.c:80
 
#1  0x000055721a3da73c in pthread_mutex_lock () at mysqld.cc:4326
 
#2  0x000055721d07fcc4 in OSMutex::enter (this=0x557221b45e98 <rw_lock_debug_mutex+104>) at include/sync0types.h:397
 
#3  MutexDebug<OSTrackMutex<GenericPolicy> >::set (this=0x557221b45e68 <rw_lock_debug_mutex+56>, mutex=0x0, filename=0x0, line=0, thread_id=18446744073709551615) at include/sync0policy.h:54
 
#4  0x000055721d0b6603 in MutexDebug<OSTrackMutex<GenericPolicy> >::release (this=0x557221b45e68 <rw_lock_debug_mutex+56>, mutex=...) at include/sync0policy.h:152
 
#5  0x000055721d09d9fc in PolicyMutex<OSTrackMutex<GenericPolicy> >::exit (this=<optimized out>) at include/ib0mutex.h:562
 
#6  rw_lock_debug_mutex_exit () at sync/sync0debug.cc:1195
 
#7  0x000055721d0872a9 in rw_lock_own (lock=<optimized out>, lock_type=4) at sync/sync0rw.cc:1019
 
#8  0x000055721d343328 in buf_block_get_modify_clock (block=0x7f13d2c08f38) at include/buf0buf.inl:248
 
#9  0x000055721d33d4a3 in btr_pcur_store_position (cursor=<optimized out>, mtr=0x2f13d2c08f40) at btr/btr0pcur.cc:210
 
#10 0x000055721cf93eaf in row_search_mvcc (buf=<optimized out>, mode=<optimized out>, prebuilt=<optimized out>, match_mode=<optimized out>, direction=<optimized out>) at row/row0sel.cc:5609
 
#11 0x000055721c7fd6e9 in ha_innobase::general_fetch (this=0x71c000072830, buf=0x1 <error: Cannot access memory at address 0x1>, direction=565468832, match_mode=0) at handler/ha_innodb.cc:9152
 
#12 0x000055721c7fe842 in ha_innobase::rnd_next (this=0x1, buf=0x0) at handler/ha_innodb.cc:9356
 
#13 0x000055721b65c7b0 in handler::ha_rnd_next (this=<optimized out>, buf=0x704000013ff0 "\375H5") at handler.cc:3080
 
#14 0x000055721bde9117 in rr_sequential (info=0x71c0000720f8) at records.cc:519
 
#15 0x000055721ab70f15 in READ_RECORD::read_record (this=0x71c0000720f8) at records.h:80
 
#16 sub_select (join=<optimized out>, join_tab=<optimized out>, end_of_records=<optimized out>) at sql_select.cc:20932
 
#17 0x000055721aadc698 in do_select (join=0x71b000011f30, procedure=<optimized out>) at sql_select.cc:20445
 
#18 JOIN::exec_inner (this=<optimized out>) at sql_select.cc:4538
 
#19 0x000055721aad84ef in JOIN::exec (this=0x71b000011f30) at sql_select.cc:4318
 
#20 0x000055721aa38e5e in mysql_select (thd=<optimized out>, tables=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=<optimized out>, having=<optimized out>, proc_param=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at sql_select.cc:4795
 
#21 0x000055721aa37935 in handle_select (thd=0x72b00004d018, lex=<optimized out>, result=<optimized out>, setup_tables_done_option=<optimized out>) at sql_select.cc:444
 
#22 0x000055721a96875e in execute_sqlcom_select (thd=<optimized out>, all_tables=0x71c000026830) at sql_parse.cc:6314
 
#23 0x000055721a940da4 in mysql_execute_command (thd=<optimized out>) at sql_parse.cc:4005
 
#24 0x000055721a927b5f in mysql_parse (thd=0x72b00004d018, rawbuf=<optimized out>, length=<optimized out>, parser_state=0x7f13d2a29470, is_com_multi=false, is_next_command=false) at sql_parse.cc:8100
 
#25 0x000055721a9193dc in dispatch_command (command=<optimized out>, thd=0x72b00004d018, packet=0x0, packet_length=49, is_com_multi=false, is_next_command=false) at sql_parse.cc:1891
 
#26 0x000055721a929b1b in do_command (thd=<optimized out>) at sql_parse.cc:1370
 
#27 0x000055721af77779 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at sql_connect.cc:1418
 
#28 0x000055721af76a7b in handle_one_connection (arg=0x1) at sql_connect.cc:1312
 
#29 0x000055721c4d04f1 in pfs_spawn_thread (arg=0x714000003a18) at pfs.cc:2201
 
#30 0x00007f13dbeae6db in start_thread (arg=0x7f13d2a2b700) at pthread_create.c:463
 
#31 0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 4 (Thread 0x7f13d25f0700 (LWP 3110)):
 
#0  0x00007f13dbeb4ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55721f05126c <buf_pool+1132>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88
 
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x55721f051168 <buf_pool+872>, cond=0x55721f051240 <buf_pool+1088>) at pthread_cond_wait.c:502
 
#2  __pthread_cond_wait (cond=0x55721f051240 <buf_pool+1088>, mutex=0x55721f051168 <buf_pool+872>) at pthread_cond_wait.c:655
 
#3  0x000055721db25042 in safe_cond_wait (cond=0x55721f051240 <buf_pool+1088>, mp=0x55721f051140 <buf_pool+832>, file=0x55721e587320 "/buildbot/amd64-ubuntu-1804-msan/build/storage/innobase/buf/buf0flu.cc", line=2243) at thr_mutex.c:492
 
#4  0x000055721d447495 in buf_flush_page_cleaner () at buf/buf0flu.cc:2243
 
#5  0x00007f13dbeae6db in start_thread (arg=0x7f13d25f0700) at pthread_create.c:463
 
#6  0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 3 (Thread 0x7f13d43f9700 (LWP 3132)):
 
#0  0x00007f13daef138c in __GI___sigtimedwait (set=<optimized out>, info=0x7f13d43f7c78, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:42
 
#1  0x000055721a3d9980 in sigwaitinfo () at mysqld.cc:4326
 
#2  0x000055721a43c8ad in my_sigwait (set=0x7f13d43f7cf8, sig=0x7f13d43f7c38, code=<optimized out>) at /buildbot/amd64-ubuntu-1804-msan/build/include/my_pthread.h:196
 
#3  signal_hand (arg=<optimized out>) at mysqld.cc:2963
 
#4  0x000055721c4d04f1 in pfs_spawn_thread (arg=0x714000002c18) at pfs.cc:2201
 
#5  0x00007f13dbeae6db in start_thread (arg=0x7f13d43f9700) at pthread_create.c:463
 
#6  0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 2 (Thread 0x7f13d3ff7700 (LWP 3109)):
 
#0  0x00007f13dbeb5065 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f13d3ff5c30, expected=0, futex_word=0x557221aa9198 <COND_checkpoint+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205
 
#1  __pthread_cond_wait_common (abstime=0x7f13d3ff5c30, mutex=0x557221aa90e0 <LOCK_checkpoint+40>, cond=0x557221aa9170 <COND_checkpoint>) at pthread_cond_wait.c:539
 
#2  __pthread_cond_timedwait (cond=0x557221aa9170 <COND_checkpoint>, mutex=0x557221aa90e0 <LOCK_checkpoint+40>, abstime=0x7f13d3ff5c30) at pthread_cond_wait.c:667
 
#3  0x000055721db26039 in safe_cond_timedwait (cond=0x557221aa9170 <COND_checkpoint>, mp=0x557221aa90b8 <LOCK_checkpoint>, abstime=0x7f13d3ff5c30, file=0x55721e2bdd71 "/buildbot/amd64-ubuntu-1804-msan/build/include/mysql/psi/mysql_thread.h", line=<optimized out>) at thr_mutex.c:546
 
#4  0x000055721c241a99 in inline_mysql_cond_timedwait (that=0x557221aa9198 <COND_checkpoint+40>, mutex=<optimized out>, abstime=0x7f13d3ff5c30, src_file=<optimized out>, src_line=116) at /buildbot/amd64-ubuntu-1804-msan/build/include/mysql/psi/mysql_thread.h:1259
 
#5  my_service_thread_sleep (control=<optimized out>, sleep_time=25769803776) at ma_servicethread.c:115
 
#6  0x000055721c216e13 in ma_checkpoint_background (arg=0x1e) at ma_checkpoint.c:725
 
#7  0x000055721c4d04f1 in pfs_spawn_thread (arg=0x714000001018) at pfs.cc:2201
 
#8  0x00007f13dbeae6db in start_thread (arg=0x7f13d3ff7700) at pthread_create.c:463
 
#9  0x00007f13dafd271f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
Thread 1 (Thread 0x7f13dcd40840 (LWP 3104)):
 
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
 
#1  0x000055721b638876 in handle_fatal_signal (sig=<optimized out>) at signal_handler.cc:344
 
#2  0x000055721a4044b9 in SignalHandler(int) () at mysqld.cc:4326
 
#3  <signal handler called>
 
#4  0x00007f13dafc5cb9 in __GI___poll (fds=0x7fff22015ce0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
 
#5  0x000055721a3d8ed2 in poll () at mysqld.cc:4326
 
#6  0x000055721a45ad45 in handle_connections_sockets () at mysqld.cc:6210
 
#7  0x000055721a4479b6 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at mysqld.cc:5659
 
#8  0x000055721a4329f4 in main (argc=570514656, argv=0x2) at main.cc:25
 
Compressed file /buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/1/log/main.sum_distinct-big-innodb/mysqld.1/data/core
 
 - saving '/buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/1/log/main.sum_distinct-big-innodb/' to '/buildbot/amd64-ubuntu-1804-msan/build/mysql-test/var/log/main.sum_distinct-big-innodb/'

Comment by Alice Sherepa [ 2023-12-01 ] 

MariaDB Version 11.4.0-MariaDB-debug
 
main.sum_distinct-big 'innodb'           w2 [ fail ]  timeout after 900 seconds
 
        Test ended at 2023-12-01 15:28:09
 
 
 
Test case timeout after 900 seconds
 
 
 
== /11.4/mysql-test/var/2/log/sum_distinct-big.log == 
536887296
 
DROP TABLE t1;
 
DROP TABLE t2;
 
SET @@tmp_table_size=@save_tmp_table_size;
 
SET @@max_heap_table_size=@save_max_heap_table_size;
 
#
 
# MDEV-4311: COUNT(DISTINCT...) requiring a file for UNIQUE (bug #68749)
 
#
 
CREATE TABLE t2 (id INTEGER) ENGINE=InnoDB;
 
BEGIN;
 
INSERT INTO t2 SELECT b.seq FROM seq_1_to_128 a, seq_1_to_16384 b
 
ORDER BY b.seq*rand();
 
INSERT INTO t2 VALUE(NULL);
 
# With default tmp_table_size / max_heap_table_size
 
SELECT SQL_NO_CACHE count(DISTINCT id) sm FROM t2;
 
sm
 
16384
 
set @@tmp_table_size=1024*256;
 
# With reduced tmp_table_size
 
SELECT SQL_NO_CACHE count(DISTINCT id) sm FROM t2;
 
 
 
 == /11.4/mysql-test/var/2/tmp/analyze-timeout-mysqld.1.err ==
 
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local server through socket '/11.4/mysql-test/var/tmp/2/mysqld.1.sock' (111)
 
 
 
 
 
 - saving '/11.4/mysql-test/var/2/log/main.sum_distinct-big-innodb/' to '/11.4/mysql-test/var/log/main.sum_distinct-big-innodb/'
 
***Warnings generated in error logs during shutdown after running tests: innodb_gis.rtree_split main.sum_distinct-big main.delete_use_source

Generated at Thu Feb 08 08:07:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.