[MDEV-15373] engine gtid_slave_pos table name disobeys lower-case-table-names Created: 2018-02-21  Updated: 2018-08-24  Resolved: 2018-05-25

Status: Closed
Project: MariaDB Server
Component/s: Replication, Storage Engine - InnoDB, Tests
Affects Version/s: 10.3
Fix Version/s: 10.3.7

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Andrei Elkin
Resolution: Fixed Votes: 0
Labels: None


 Description   

rpl.rpl_mdev12179 'innodb,row'           [ fail ]
        Test ended at 2018-02-21 12:15:17
 
CURRENT_TEST: rpl.rpl_mdev12179
--- D:/wlad/bb-10.3-wlad/mysql-test/suite/rpl/r/rpl_mdev12179.result    2018-02-
21 08:31:42.591085500 +0000
+++ D:\wlad\bb-10.3-wlad\mysql-test\suite\rpl\r\rpl_mdev12179.reject    2018-02-
21 12:15:17.275461200 +0000
@@ -157,7 +157,7 @@
  ORDER BY table_name;
 table_name     engine
 gtid_slave_pos MyISAM
-gtid_slave_pos_InnoDB  InnoDB
+gtid_slave_pos_innodb  InnoDB
 include/stop_slave.inc
 SET sql_log_bin=0;
 INSERT INTO mysql.gtid_slave_pos SELECT * FROM mysql.gtid_slave_pos_InnoDB;
@@ -250,7 +250,7 @@
  ORDER BY table_name;
 table_name     engine
 gtid_slave_pos MyISAM
-gtid_slave_pos_InnoDB  InnoDB
+gtid_slave_pos_innodb  InnoDB
 SELECT domain_id, max(seq_no) FROM mysql.gtid_slave_pos GROUP BY domain_id;
 domain_id      max(seq_no)
 0      13
 
mysqltest: Result content mismatch
 
 - saving 'D:/wlad/bb-10.3-wlad/xxx/mysql-test/var/log/rpl.rpl_mdev12179-innodb,
row/' to 'D:/wlad/bb-10.3-wlad/xxx/mysql-test/var/log/rpl.rpl_mdev12179-innodb,r
ow/'
***Warnings generated in error logs during shutdown after running tests: rpl.rpl
_mdev12179

2018-02-21 12:10:47 12 [Warning] InnoDB: Waited 30 seconds for ref-count on tabl
e: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:11:17 12 [Warning] InnoDB: Waited 60 seconds for ref-count on tabl
e: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:11:47 12 [Warning] InnoDB: Waited 90 seconds for ref-count on tabl
e: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:12:17 12 [Warning] InnoDB: Waited 120 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:12:47 12 [Warning] InnoDB: Waited 150 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:13:17 12 [Warning] InnoDB: Waited 180 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:13:47 12 [Warning] InnoDB: Waited 210 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:14:17 12 [Warning] InnoDB: Waited 240 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:14:19 0 [Warning] InnoDB: A long semaphore wait:
2018-02-21 12:14:47 12 [Warning] InnoDB: Waited 270 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:14:50 0 [Warning] InnoDB: A long semaphore wait:
2018-02-21 12:15:17 12 [Warning] InnoDB: Waited 300 seconds for ref-count on tab
le: `mysql`.`gtid_slave_pos_innodb` space: 8
2018-02-21 12:15:17 12 [Warning] InnoDB: After 300 seconds, gave up waiting for
ref-count on table: `mysql`.`gtid_slave_pos_innodb` space: 8



 Comments   
Comment by Andrei Elkin [ 2018-05-09 ]

Hello, Alexander!

Although the case is largely about replication its fixes demand table name lowercase rule
understanding. That's why I am asking you to take a look.

Thanks!

Andrei

Comment by Alexander Barkov [ 2018-05-17 ]

The patch 463331a263e433e70bad47b33bafd2ac5fd83407 is OK to push

Comment by Teodor Mircea Ionita (Inactive) [ 2018-05-24 ]

bar Printing a warning will still result in a failed test case. Should the test also be updated to reflect that?
https://github.com/mariadb/server/commit/463331a263e433e70bad47b33bafd2ac5fd83407#diff-dbd2540d5c16257ffb1af5ea27c80001R349

Comment by Andrei Elkin [ 2018-05-25 ]

9df656db65e98 was pushed to 10.3.7.

Comment by Teodor Mircea Ionita (Inactive) [ 2018-05-25 ]

Elkin The call mtr.add_suppression does it, you can ignore my previous statement.

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