[MDEV-15198] tokudb.hotindex-update-0 failed in buildbot with timeout Created: 2018-02-03  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - TokuDB, Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-15271 tokudb.hotindex-insert-2 failed in bu... Closed
relates to MDEV-16040 tokudb.hotindex-update-0 failed in bu... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/4222/steps/mtr/logs/stdio

tokudb.hotindex-update-0                 w2 [ fail ]  timeout after 900 seconds
        Test ended at 2018-01-22 18:29:58
 
Test case timeout after 900 seconds
 
== /dev/shm/var/2/log/hotindex-update-0.log == 
insert into s values (15,0),(15,1),(15,2),(15,3),(15,4),(15,5),(15,6),(15,7),(15,8),(15,9);
insert into s values (14,0),(14,1),(14,2),(14,3),(14,4),(14,5),(14,6),(14,7),(14,8),(14,9);
insert into s values (13,0),(13,1),(13,2),(13,3),(13,4),(13,5),(13,6),(13,7),(13,8),(13,9);
insert into s values (12,0),(12,1),(12,2),(12,3),(12,4),(12,5),(12,6),(12,7),(12,8),(12,9);
insert into s values (11,0),(11,1),(11,2),(11,3),(11,4),(11,5),(11,6),(11,7),(11,8),(11,9);
insert into s values (10,0),(10,1),(10,2),(10,3),(10,4),(10,5),(10,6),(10,7),(10,8),(10,9);
insert into s values (9,0),(9,1),(9,2),(9,3),(9,4),(9,5),(9,6),(9,7),(9,8),(9,9);
insert into s values (8,0),(8,1),(8,2),(8,3),(8,4),(8,5),(8,6),(8,7),(8,8),(8,9);
insert into s values (7,0),(7,1),(7,2),(7,3),(7,4),(7,5),(7,6),(7,7),(7,8),(7,9);
insert into s values (6,0),(6,1),(6,2),(6,3),(6,4),(6,5),(6,6),(6,7),(6,8),(6,9);
insert into s values (5,0),(5,1),(5,2),(5,3),(5,4),(5,5),(5,6),(5,7),(5,8),(5,9);
insert into s values (4,0),(4,1),(4,2),(4,3),(4,4),(4,5),(4,6),(4,7),(4,8),(4,9);
insert into s values (3,0),(3,1),(3,2),(3,3),(3,4),(3,5),(3,6),(3,7),(3,8),(3,9);
insert into s values (2,0),(2,1),(2,2),(2,3),(2,4),(2,5),(2,6),(2,7),(2,8),(2,9);
insert into s values (1,0),(1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9);
set tokudb_create_index_online=1;
create index i_a on s(a);
update s set a=20000+10000 where a=10000;
update s set a=20000+9999 where a=9999;
update s set a=20000+9998 where a=9998;
 
 == /dev/shm/var/2/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 '/dev/shm/var/tmp/2/mysqld.1.sock' (111 "Connection refused")



 Comments   
Comment by Elena Stepanova [ 2018-04-26 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/4266/steps/mtr/logs/stdio

10.0 d01dbe66a8bf9cb6031f95159c49100f9299a768

tokudb.hotindex-update-0                 w2 [ fail ]  timeout after 900 seconds
        Test ended at 2018-01-27 16:54:15
 
Test case timeout after 900 seconds
 
== /dev/shm/var/2/log/hotindex-update-0.log == 
insert into s values (13,0),(13,1),(13,2),(13,3),(13,4),(13,5),(13,6),(13,7),(13,8),(13,9);
insert into s values (12,0),(12,1),(12,2),(12,3),(12,4),(12,5),(12,6),(12,7),(12,8),(12,9);
insert into s values (11,0),(11,1),(11,2),(11,3),(11,4),(11,5),(11,6),(11,7),(11,8),(11,9);
insert into s values (10,0),(10,1),(10,2),(10,3),(10,4),(10,5),(10,6),(10,7),(10,8),(10,9);
insert into s values (9,0),(9,1),(9,2),(9,3),(9,4),(9,5),(9,6),(9,7),(9,8),(9,9);
insert into s values (8,0),(8,1),(8,2),(8,3),(8,4),(8,5),(8,6),(8,7),(8,8),(8,9);
insert into s values (7,0),(7,1),(7,2),(7,3),(7,4),(7,5),(7,6),(7,7),(7,8),(7,9);
insert into s values (6,0),(6,1),(6,2),(6,3),(6,4),(6,5),(6,6),(6,7),(6,8),(6,9);
insert into s values (5,0),(5,1),(5,2),(5,3),(5,4),(5,5),(5,6),(5,7),(5,8),(5,9);
insert into s values (4,0),(4,1),(4,2),(4,3),(4,4),(4,5),(4,6),(4,7),(4,8),(4,9);
insert into s values (3,0),(3,1),(3,2),(3,3),(3,4),(3,5),(3,6),(3,7),(3,8),(3,9);
insert into s values (2,0),(2,1),(2,2),(2,3),(2,4),(2,5),(2,6),(2,7),(2,8),(2,9);
insert into s values (1,0),(1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9);
set tokudb_create_index_online=1;
create index i_a on s(a);
update s set a=20000+10000 where a=10000;
update s set a=20000+9999 where a=9999;
update s set a=20000+9998 where a=9998;
update s set a=20000+9997 where a=9997;
update s set a=20000+9996 where a=9996;
 
 == /dev/shm/var/2/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 '/dev/shm/var/tmp/2/mysqld.1.sock' (111 "Connection refused")
 
 
 - saving '/dev/shm/var/2/log/tokudb.hotindex-update-0/' to '/dev/shm/var/log/tokudb.hotindex-update-0/'
 
Retrying test tokudb.hotindex-update-0, attempt(2/3)...
 
worker[2] > Restart  - not started
***Warnings generated in error logs during shutdown after running tests: tokudb.hotindex-insert-2 tokudb.hotindex-del-slow tokudb.hotindex-del-0 tokudb.ext_key_1_tokudb tokudb.hotindex-update-0 tokudb.dir_per_db_rename_to_nonexisting_schema tokudb.ext_key_2_tokudb tokudb.hotindex-insert-0 tokudb.hotindex-del-fast
 
Attempting backtrace. You can use the following information to find out
 
worker[2] Trying to dump core for [mysqltest - pid: 21309, winpid: 21309]
worker[2] Trying to dump core for [mysqld.1 - pid: 21282, winpid: 21282]
tokudb.hotindex-update-0                 w2 [ retry-fail ]  timeout after 900 seconds
        Test ended at 2018-01-27 17:10:06
 
Test case timeout after 900 seconds
 
== /dev/shm/var/2/log/hotindex-update-0.log == 
insert into s values (15,0),(15,1),(15,2),(15,3),(15,4),(15,5),(15,6),(15,7),(15,8),(15,9);
insert into s values (14,0),(14,1),(14,2),(14,3),(14,4),(14,5),(14,6),(14,7),(14,8),(14,9);
insert into s values (13,0),(13,1),(13,2),(13,3),(13,4),(13,5),(13,6),(13,7),(13,8),(13,9);
insert into s values (12,0),(12,1),(12,2),(12,3),(12,4),(12,5),(12,6),(12,7),(12,8),(12,9);
insert into s values (11,0),(11,1),(11,2),(11,3),(11,4),(11,5),(11,6),(11,7),(11,8),(11,9);
insert into s values (10,0),(10,1),(10,2),(10,3),(10,4),(10,5),(10,6),(10,7),(10,8),(10,9);
insert into s values (9,0),(9,1),(9,2),(9,3),(9,4),(9,5),(9,6),(9,7),(9,8),(9,9);
insert into s values (8,0),(8,1),(8,2),(8,3),(8,4),(8,5),(8,6),(8,7),(8,8),(8,9);
insert into s values (7,0),(7,1),(7,2),(7,3),(7,4),(7,5),(7,6),(7,7),(7,8),(7,9);
insert into s values (6,0),(6,1),(6,2),(6,3),(6,4),(6,5),(6,6),(6,7),(6,8),(6,9);
insert into s values (5,0),(5,1),(5,2),(5,3),(5,4),(5,5),(5,6),(5,7),(5,8),(5,9);
insert into s values (4,0),(4,1),(4,2),(4,3),(4,4),(4,5),(4,6),(4,7),(4,8),(4,9);
insert into s values (3,0),(3,1),(3,2),(3,3),(3,4),(3,5),(3,6),(3,7),(3,8),(3,9);
insert into s values (2,0),(2,1),(2,2),(2,3),(2,4),(2,5),(2,6),(2,7),(2,8),(2,9);
insert into s values (1,0),(1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9);
set tokudb_create_index_online=1;
create index i_a on s(a);
update s set a=20000+10000 where a=10000;
update s set a=20000+9999 where a=9999;
update s set a=20000+9998 where a=9998;
 
 == /dev/shm/var/2/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 '/dev/shm/var/tmp/2/mysqld.1.sock' (111 "Connection refused")

Comment by Elena Stepanova [ 2018-09-15 ]

Still happening on current 10.2:
http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/5680/steps/mtr/logs/stdio

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