Mysql Error 1186 Binlog Closed
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Slave start to generate relay log files but not master server up vote 0 down vote favorite I am settings up two new servers. One is the master and the other is the slave. Below is the config file for both. Master DB [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 innodb_file_per_table server-id=1 binlog_do_db=data1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Slave DB [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 innodb_file_per_table server-id=2 master-host = 202.*.*.* master-user = replicationUser1 master-password = ******** master-port = 3306 replicate-do-db=data1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid So first in the master I run this reset master command it gave me this error. reset master; ERROR 1186 (HY000): Binlog closed, cannot RESET MASTER. Then on the slave I first ran stop master then reset slave then start slave. THen I notice this files are generated in the slave master.info,mysqld-relay-bin.000001, mysqld-relay-bin.index and relay-log.info. In addit
Jonathan Miller Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical) Version:5.1.6-alpha OS: Assigned to: Magnus Blåudd View Add Comment Files Developer Edit Submission View Progress Log Contributions [17 Jan 2006 14:27] Jonathan Miller Description: mysql> reset master; ERROR 1186 (HY000): Binlog closed, cannot RESET MASTER mysql> exit Bye ~/jmiller> ./builds/bin/perror --ndb 1186 OS error code http://dba.stackexchange.com/questions/18191/slave-start-to-generate-relay-log-files-but-not-master-server 1186: No message slogan found (please report a bug if you get this error code): Unknown: Unknown ~/jmiller> ./builds/bin/perror 1186 Illegal error code: 1186 How to repeat: Use my.cnf [mysqld] server-id=1 #log-bin = /space/var/master1 #max-binlog-size = 20000000 log = /space/var/master1.log log-error = /space/var/master1.err socket = /tmp/mysql.sock port = 3307 https://bugs.mysql.com/bug.php?id=16561 pid-file = /space/var/hostname.pid1 datadir = /space/var/ language = /home/ndbdev/jmiller/builds/share/mysql/english/ start mysqld and try to do mysql>reset master; [26 Jul 2006 12:09] Bugs System A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/9581 [3 Aug 2006 16:42] Magnus Blåudd Pushed to 5.0.25 [4 Aug 2006 4:02] Paul Dubois Noted in 5.0.25 changelog. perror did not properly report NDB error codes. [14 Aug 2006 21:19] Konstantin Osipov Merged into 5.1.12 [15 Aug 2006 3:41] Paul Dubois Noted in 5.1.12 changelog. Legal Policies Your Privacy Rights Terms of Use Contact Us Portions of this website are copyright © 2001, 2002 The PHP Group Page generated in 0.027 sec. using MySQL 5.7.12-enterprise-commercial-advanced-log Content reproduced on this site is the property of the respective copyright holders.It is not
Mail Databases http://blog.itpub.net/23249684/viewspace-1386182/ Samba Screen Version Control Volume Manager SSH Zsh Other PDF files mysql error Hardware CPU Modem Mouse Touchpad Links edit SideBar My SQL Troubleshooting ERROR 1186: Binlog closed, cannot RESET MASTER This is usually mysql error 1186 caused by trying to execute RESET MASTER on a slave server that does not have binary log activated. To fix this, add in my.cnf of the server something like this: log-bin = /var/log/mysql/replication.log Edit Page History Source Attach File Backlinks List Group Page last modified on April 16, 2011, at 09:28 PM skin config ** © 2006-2013 Toshiro Viera Stalker **
成立QQ群、微信群,辅助互动与技术同行交流 首页 | 博文目录 | 关于我 goolen 博客访问: 406721 博文数量: 152 用 户 组: 普通用户 注册时间: 2011-10-20 18:17 个人简介 技术交流群: 241756225 文章分类 全部博文(152) Oracle(83) Mysql(44) Linux(8) Goldengate(3) Mongodb(2) 监控系统(11) Greenplum(1) 未分配的博文(0) 最近访客 royevict xinxin41 糗_蘑菇 wwwlby 静以致远 依然wana heu tom555ca tolilong 微信关注 IT168企业级官微 微信号:IT168qiye 系统架构师大会 微信号:SACC2013 订阅 推荐博文 ·Oracle 12c Data Guard搭建(... ·Oracle Real Time SQL Monito... ·11g升级到Oracle 12c碰到的问... ·Oracle 12c PDB迁移(一)... ·使用Out of Place升级策略进... 热词专题 友情链接 ·老杨 ·老熊 ·惜分飞 ·夜无伤 ·Dave ·Lunar ·MacleanLiu ·落落 ·eygle ·Roger ERROR 1186 (HY000): Binlog closed, cannot RESET MASTER 2014-12-31 15:27:40 分类: MySQL
想把一台mysql slave切换成主库的时候报错: mysql> reset slave; ERROR 1198 (HY000): This operation cannot be performed with a running slave; run STOP SLAVE first mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> reset master; ERROR 1186 (HY000): Binlog closed, cannot RESET MASTER 这是因为slave配置文件中注释了log-bin参数导致的,编辑my.cnf,设置log-bin=参数 重启mysql服务: [root@test11g ]# /etc/init.d/mysqld restart Shutting down MySQL.. [ OK ] Starting MySQL.. [ OK ] mysql> stop slave; Query OK, 0 rows affected (0.09 sec) mysql> reset master; Query OK, 0 rows affected (0.00 sec) 阅读(5478) | 评论(0) | 转发(0) | 0 上一篇:exp导出命令query参数指定的where条件里符号也要转义 下