Bug #75252 | binlog index corruption with closed stdout | ||
---|---|---|---|
Submitted: | 18 Dec 2014 7:18 | Modified: | 19 Dec 2014 11:04 |
Reporter: | Nilnandan Joshi | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 5.6.21, 5.6.22, 5.6.30 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[18 Dec 2014 7:18]
Nilnandan Joshi
[19 Dec 2014 11:04]
MySQL Verification Team
Hello Nilnandan Joshi, Thank you for the report. Observed similar behavior with current Generally Available Release: 5.6.22. Thanks, Umesh
[19 Dec 2014 11:06]
MySQL Verification Team
// Build details [root@cluster-repo ~]# rpm -qa|grep mysql-community mysql-community-libs-compat-5.6.22-2.el6.x86_64 mysql-community-common-5.6.22-2.el6.x86_64 mysql-community-libs-5.6.22-2.el6.x86_64 mysql-community-client-5.6.22-2.el6.x86_64 mysql-community-embedded-5.6.22-2.el6.x86_64 mysql-community-server-5.6.22-2.el6.x86_64 mysql-community-devel-5.6.22-2.el6.x86_64 [root@cluster-repo ~]# [root@cluster-repo ~]# which mysqld /usr/sbin/mysqld // [root@cluster-repo ~]# /usr/sbin/mysqld --log_bin=bug75252 --help --verbose 1>&- 2014-12-21 18:06:18 11793 [Note] Plugin 'FEDERATED' is disabled. 2014-12-21 18:06:18 11793 [Note] Binlog end 2014-12-21 18:06:18 11793 [Note] Shutting down plugin 'CSV' 2014-12-21 18:06:18 11793 [Note] Shutting down plugin 'MyISAM' // Confirmed bug75252.index is created in datadir [root@cluster-repo ~]# [root@cluster-repo ~]# ls -l /var/lib/mysql/bug75252* -rw-rw---- 1 mysql mysql 118784 Dec 21 18:06 /var/lib/mysql/bug75252.index [root@cluster-repo ~]# [root@cluster-repo ~]# more /var/lib/mysql/bug75252.index /usr/sbin/mysqld Ver 5.6.22-log for Linux on x86_64 (MySQL Community Server (GPL)) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Starts the MySQL database server. Usage: /usr/sbin/mysqld [OPTIONS] .. .. sysdate-is-now FALSE table-definition-cache 1400 table-open-cache 2000 table // OS details [root@cluster-repo ~]# cat /etc/*release LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch Oracle Linux Server release 6.6 Red Hat Enterprise Linux Server release 6.6 (Santiago) Oracle Linux Server release 6.6
[1 Dec 2017 13:46]
MySQL Verification Team
can anybody think of any other files that could get trashed by this? What about if server has it's logs flushed or stdout/stderr closed while it's running?