[MDEV-13183] main.set_statement failed with PS protocol, result mismatch Created: 2017-06-26  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/8429/steps/test_5/logs/stdio

main.set_statement                       w3 [ fail ]
        Test ended at 2017-06-08 19:07:20
 
CURRENT_TEST: main.set_statement
Warning: /mnt/buildbot/build/mariadb-10.1.25/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.1.25/mysql-test/std_data/cacert.pem'
Warning: /mnt/buildbot/build/mariadb-10.1.25/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.1.25/mysql-test/std_data/client-cert.pem'
Warning: /mnt/buildbot/build/mariadb-10.1.25/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.1.25/mysql-test/std_data/client-key.pem'
Warning: /mnt/buildbot/build/mariadb-10.1.25/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
--- /mnt/buildbot/build/mariadb-10.1.25/mysql-test/r/set_statement.result	2017-06-08 12:01:00.000000000 +0300
+++ /mnt/buildbot/build/mariadb-10.1.25/mysql-test/r/set_statement.reject	2017-06-08 19:07:20.000000000 +0300
@@ -1066,6 +1066,7 @@
 set @@long_query_time=@save_long_query_time;
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Prepare
 select sleep(0.1)
 #---
 #should be written
@@ -1074,6 +1075,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Prepare
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1085,6 +1087,7 @@
 set @@long_query_time=@save_long_query_time;
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Prepare
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1094,6 +1097,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Prepare
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1103,6 +1107,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Prepare
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1112,6 +1117,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Prepare
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2018-02-11 ]

New variation on 10.2:
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/11336/steps/mtr_ps/logs/stdio

main.set_statement                       w1 [ fail ]
        Test ended at 2018-01-25 17:02:21
 
CURRENT_TEST: main.set_statement
--- /mnt/buildbot/build/mariadb-10.2.13/mysql-test/r/set_statement.result	2018-01-25 11:38:01.000000000 +0200
+++ /mnt/buildbot/build/mariadb-10.2.13/mysql-test/r/set_statement.reject	2018-01-25 17:02:20.000000000 +0200
@@ -1070,6 +1070,7 @@
 set @@long_query_time=@save_long_query_time;
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Close stmt
 select sleep(0.1)
 #---
 #should be written
@@ -1078,6 +1079,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Close stmt
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1089,6 +1091,7 @@
 set @@long_query_time=@save_long_query_time;
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Close stmt
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1098,6 +1101,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Close stmt
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1107,6 +1111,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Close stmt
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
@@ -1116,6 +1121,7 @@
 0
 select sql_text from mysql.slow_log where sql_text not like 'set @@long_query_time%';
 sql_text
+Close stmt
 select sleep(0.1)
 set statement long_query_time=0.01 for select sleep(0.1)
 #---
 
mysqltest: Result length mismatch

Comment by Elena Stepanova [ 2022-08-21 ]

Still fails, although very rarely, in CI tests.

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