[MDEV-20136] main.multi_update_debug failed in buildbot with debug sync point wait timed out Created: 2019-07-23  Updated: 2020-04-18  Resolved: 2020-04-18

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1, 10.3, 10.4
Fix Version/s: 10.2.32

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-19491 update query stopped working after ma... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/14916/steps/test/logs/stdio

10.1 10ebdb7f1d7a3f6aa6a91b40a9d90f48

 
main.multi_update_debug                  w1 [ fail ]
 
        Test ended at 2019-07-15 08:39:48
 
 
 
CURRENT_TEST: main.multi_update_debug
 
--- D:/win32-debug/build/src/mysql-test/r/multi_update_debug.result	2019-07-15 08:07:05.143117000 +0000
 
+++ D:\win32-debug\build\src\mysql-test\r\multi_update_debug.reject	2019-07-15 08:39:47.822875200 +0000
 
@@ -9,5 +9,7 @@
 
 update t1 join t2 on (a=c+4) set b=d;
 
 set debug_sync='mdl_acquire_lock_wait SIGNAL cont';
 
 lock table t1 write, t0 write;
 
+Warnings:
 
+Warning	1639	debug sync point wait timed out
 
 drop table t1, t2, t0;
 
 set debug_sync='reset';
 
 
 
mysqltest: Result length mismatch

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/18387

 Comments   
Comment by Aleksey Midenkov [ 2019-08-11 ]

Unstable in bb-10.3-midenok which is based on relatively late 10.3 (e555df648c5c81f):

--- /mnt/buildbot/build/mariadb-10.3.18/mysql-test/main/multi_update_debug.result	2019-08-09 10:01:20.000000000 -0400
 
+++ /mnt/buildbot/build/mariadb-10.3.18/mysql-test/main/multi_update_debug.reject	2019-08-09 13:52:23.774742025 -0400
 
@@ -12,5 +12,7 @@
 
 lock table t1 write, t0 write;
 
 disconnect con1;
 
 connection default;
 
+Warnings:
 
+Warning	1639	debug sync point wait timed out
 
 drop table t1, t2, t0;
 
 set debug_sync='reset';

Comment by Aleksey Midenkov [ 2019-08-11 ]

Not found this issue in 10.3 kvm-fulltest2 (grid width 32) though.

Comment by Marko Mäkelä [ 2019-08-23 ]

This has been failing for me locally for various branches, every now and then. The latest occurrence was on 10.4 today:

10.4 efb8485d85b19a2a729310adc6779ca649198f29

 
CURRENT_TEST: main.multi_update_debug
 
--- /mariadb/10.4/mysql-test/main/multi_update_debug.result	2019-08-12 13:50:58.608699851 +0300
 
+++ /mariadb/10.4/mysql-test/main/multi_update_debug.reject	2019-08-23 08:15:25.171705567 +0300
 
@@ -12,5 +12,7 @@
 
 lock table t1 write, t0 write;
 
 disconnect con1;
 
 connection default;
 
+Warnings:
 
+Warning	1639	debug sync point wait timed out
 
 drop table t1, t2, t0;
 
 set debug_sync='reset';
 
 
 
mysqltest: Result length mismatch

Comment by Michael Widenius [ 2020-01-30 ]

I got this on latest 10.4 code today

Comment by Michael Widenius [ 2020-04-18 ]

Already fixed in 10.5 by svoj. Backported to 10.2

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