Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
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();
|
Attachments
Activity
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 )
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/'
|
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
|
It looks like the timeout appeared in 10.3 between 7a5eb0032 (still OK) and 77c41fa72 (timeout).