Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.0.6.1
-
None
-
centos 6.5 x86_64
Description
env desc:
same with MCOL-486, but dbroot1 is handled by PM2, dbroot2 is handled by PM1.
reproduce step:
continue from MCOL-486, after restart machine of PM1 and mcs restored(with dbroot1 is handled by PM2, dbroot2 is handled by PM1), I left a.sh running for a whole night, on the next morning I came back only find the mcs can not logged in after swap size threshold(at about 10h) was reached and mcs performed a restartsystem but failed. it was similar with MCOL-486.
question:
1. BUT I failed to restore the system.
2. I found there were nearly 4000 binlog files in the mysql/db directory. every one is tiny, most of them contained 327 bytes, contents pasted below. why are there so many binlog files
[root@s237 db]# ./../bin/mysqlbinlog -vvv mysql-bin.003995
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
|
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
|
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
|
DELIMITER /*!*/;
|
# at 4
|
#161226 21:13:20 server id 1 end_log_pos 249 Start: binlog v 4, server v 10.1.19-MariaDB created 161226 21:13:20 at startup
|
ROLLBACK/*!*/;
|
BINLOG '
|
QM5hWA8BAAAA9QAAAPkAAAAAAAQAMTAuMS4xOS1NYXJpYURCAGxvZwAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAAAAAAAABAzmFYEzgNAAgAEgAEBAQEEgAA3QAEGggAAAAICAgCAAAACgoKAAAAAAAA
|
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAEEwQAAJj+BD8=
|
'/*!*/;
|
# at 249
|
#161226 21:13:20 server id 1 end_log_pos 288 Gtid list [0-1-45]
|
# at 288
|
#161226 21:13:20 server id 1 end_log_pos 327 Binlog checkpoint mysql-bin.003995
|
# at 327
|
#161226 21:16:27 server id 1 end_log_pos 346 Stop
|
DELIMITER ;
|
# End of log file
|
ROLLBACK /* added by mysqlbinlog */;
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|
result file of columnstoreSupport and the log of mysql instance is attached.