[MDEV-20533] perfschema.pfs_upgrade_proc failed in buildbot, Upgrade file was not properly created Created: 2019-09-08  Updated: 2020-01-26

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.4
Fix Version/s: 10.4

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


 Description   

http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/15243

10.4 efb8485d85b19a2a729310adc6779ca6

perfschema.pfs_upgrade_proc 'innodb'     w3 [ fail ]
        Test ended at 2019-08-23 06:32:32
 
CURRENT_TEST: perfschema.pfs_upgrade_proc
--- D:/winx64-debug/build/src/mysql-test/suite/perfschema/r/pfs_upgrade_proc.result	2019-08-23 05:30:46.261394900 +0000
+++ D:\winx64-debug\build\src\mysql-test\suite\perfschema\r\pfs_upgrade_proc.reject	2019-08-23 06:32:32.505511000 +0000
@@ -2,6 +2,7 @@
 create procedure test.user_proc()
 select "Not supposed to be here";
 update mysql.proc set db='performance_schema' where name='user_proc';
+Upgrade file 'D:\\winx64-debug\\build\\mysql-test\\var\\3\\mysqld.1\\data\\mysql_upgrade_info' was not properly created. Got error errno while checking file content: 0
 select name from mysql.proc where db='performance_schema';
 name
 user_proc
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2019-09-08 ]

http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/15468

bb-10.4-release 437b7f54ae6c78f30e50f1e9636f9bdc

perfschema.pfs_upgrade_view 'innodb'     w4 [ fail ]
        Test ended at 2019-09-06 09:35:25
 
CURRENT_TEST: perfschema.pfs_upgrade_view
--- D:/winx64-debug/build/src/mysql-test/suite/perfschema/r/pfs_upgrade_view.result	2019-09-06 08:30:48.877235600 +0000
+++ D:\winx64-debug\build\src\mysql-test\suite\perfschema\r\pfs_upgrade_view.reject	2019-09-06 09:35:25.146610300 +0000
@@ -4,6 +4,7 @@
 show tables like "user_view";
 Tables_in_performance_schema (user_view)
 user_view
+Upgrade file 'D:\\winx64-debug\\build\\mysql-test\\var\\4\\mysqld.1\\data\\mysql_upgrade_info' was not properly created. Got error errno while checking file content: 0
 show tables like "user_view";
 Tables_in_performance_schema (user_view)
 user_view
 
mysqltest: Result length mismatch

Comment by Elena Stepanova [ 2020-01-26 ]

I wonder if it's the same failure or a different one.
http://buildbot.askmonty.org/buildbot/builders/winx64-packages/builds/16490

10.4 088de81d965f1b5ae2f50b1ed6e7cfcc

perfschema.pfs_upgrade_table 'innodb'    w3 [ fail ]
        Test ended at 2019-12-18 12:38:56
 
CURRENT_TEST: perfschema.pfs_upgrade_table
mysqltest: In included file "./suite/perfschema/include/upgrade_check.inc": 
included from D:/winx64-packages/build/src/mysql-test/suite/perfschema/t/pfs_upgrade_table.test at line 23:
At line 6: exec of 'D:\winx64-packages\build\client\RelWithDebInfo\mysql_upgrade.exe --defaults-file=D:/winx64-packages/build/mysql-test/var/3/my.cnf --skip-verbose --force > D:/winx64-packages/build/mysql-test/var/3/tmp/out_file 2> D:/winx64-packages/build/mysql-test/var/3/tmp/err_file' failed, error: 1, status: 1, errno: 0
Output from before failure:
Tables_in_performance_schema (user_table)
user_table
 
 
 
The result from queries just before the failure was:
"Testing mysql_upgrade with TABLE performance_schema.user_table"
create table test.user_table(a int);
use performance_schema;
show tables like "user_table";
Tables_in_performance_schema (user_table)
user_table
 
 - saving 'D:/winx64-packages/build/mysql-test/var/3/log/perfschema.pfs_upgrade_table-innodb/' to 'D:/winx64-packages/build/mysql-test/var/log/perfschema.pfs_upgrade_table-innodb/'

Generated at Thu Feb 08 09:00:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.