[MDEV-13264] binlog.flashback fails in buildbot on Mac Created: 2017-07-06  Updated: 2017-07-09  Resolved: 2017-07-09

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.7

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/mac-1012-bintar/builds/1641/steps/test/logs/stdio

binlog.flashback 'innodb,mix'            [ fail ]
        Test ended at 2017-07-06 01:19:54
 
CURRENT_TEST: binlog.flashback
--- /Users/buildbot/maria-slave/mac-1012-bintar/build/mysql-test/suite/binlog/r/flashback.result	2017-07-06 11:14:18.000000000 +0800
+++ /Users/buildbot/maria-slave/mac-1012-bintar/build/mysql-test/suite/binlog/r/flashback.reject	2017-07-06 13:19:53.000000000 +0800
@@ -631,7 +631,7 @@
 RESET MASTER;
 CHECKSUM TABLE world.City;
 Table	Checksum
-world.City	563256876
+world.city	563256876
 INSERT INTO test.test VALUES (NULL, 'Good record 1', CURRENT_TIMESTAMP());
 INSERT INTO world.City VALUES (NULL, 'Wrong value 1', '000', 'Wrong', 0);
 INSERT INTO world.City VALUES (NULL, 'Wrong value 2', '000', 'Wrong', 0) , (NULL, 'Wrong value 3', '000', 'Wrong', 0);
@@ -655,9 +655,6 @@
 #
 SELECT * FROM world.City;
 ID	Name	CountryCode	District	Population
-1	Davenport	USA	Iowa	100
-2	Boulder	USA	Colorado	1000
-3	Gweru	ZWE	Midlands	10000
 SELECT * FROM test.test;
 ID	REC	ts
 1	Good record 1	2001-09-09 09:46:40
@@ -670,7 +667,7 @@
 8	Good record 9	2001-09-09 09:46:40
 CHECKSUM TABLE world.City;
 Table	Checksum
-world.City	563256876
+world.city	0
 DROP TABLE test.test;
 DROP TABLE world.City;
 DROP DATABASE world;
 
mysqltest: Result length mismatch



 Comments   
Comment by Lixun Peng [ 2017-07-06 ]

I think this is related with the filesystem of Mac.
elenst Is this case running under lower_case_table_names=1?
Change the table name of City to lower case can fix it.

Comment by Elena Stepanova [ 2017-07-06 ]

Is this case running under lower_case_table_names=1?

There are no custom server settings in buildbot, the test is run with whatever settings it has in MTR.

Comment by Elena Stepanova [ 2017-07-09 ]

Fixed by this commit:
https://github.com/MariaDB/server/commit/51256b603a69882e22222e48d60eaba8151945ed

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