Mysql Show Slave Status Error No Query Specified
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any mysql replication error no query specified questions you might have Meta Discuss the workings and policies of slave sql running no this site About Us Learn more about Stack Overflow the company Business Learn more about hiring slave_sql_running: no 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
Seconds_behind_master Null
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 MySQL replication working, but data slave_io_running no is out of date up vote 0 down vote favorite I'm trying to figure out why even though SHOW SLAVE STATUS isn't reporting any errors, nothing is replicating (see below): both nodes are running: mysql> SELECT VERSION(); +------------+ | VERSION() | +------------+ | 5.1.73-log | +------------+ 1 row in set (0.00 sec) mysql> on # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago) # master: mysql> SHOW MASTER STATUS\G; *************************** 1. row *************************** File: mysql-bin.000107 Position: 228679653 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00 sec) ERROR: No query specified mysql> slave: mysql> SHOW SLAVE STATUS\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: MASTER_HOST Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000107 Read_Master_Log_Pos: 228681259 Relay_Log_File: mysql:PR_DB-relay-bin.000150 Relay_Log_Pos: 228398599 Relay_Master_Log_File: mysql-bin.000107 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: DB1,DB2,DB3,DB4 Replicate_Ignore_DB: information_schema,mysql Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 228681259 Relay_Log_Space: 228681667 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_S
Gonna go flush my head down the toilet now. Thanks guys. From: William Newton [mailto:wclarknewton@stripped] Sent: Thursday, December 06, 2007 1:29 PM To: Jeff Mckeon; MySql Subject: Re: Error: No query specified I'm guessing you are adding a semi-colon (;) to the end of the statement. Its unnecessary with the \G ----- Original Message ---- From: Jeff Mckeon
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Replication :: Urgent a master/slave replication not running New Topic Advanced http://forums.mysql.com/read.php?26,148922 Search Urgent a master/slave replication not running Posted by: GASMI Amine () Date: April 16, 2007 10:33AM Hi, I am student on training period. I have to http://www.pc-freak.net/blog/how-to-check-master-slave-mysql-nodes-status-check-mysql-replication-status/ do mastre/slave replication but it not running!!! I have a mysql 5.0.22-debian_0ubuntu6.06.3- log running. On my master I did mysql> grant replication slave on *.* to 'replication'@XX.XX.XX.1 error no identified by 'password'; A part of my my.cnf (On the master) is like this [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # server-id = 1 log-bin = /var/log/mysql/mysql-bin.log expire-logs-days error no query = 20 max_binlog_size = 104857600 binlog-do-db = radius #binlog-ignore-db = include_database_name # The show master status shows mysql> show master status\G; *************************** 1. row *************************** File: mysql-bin.000001 Position: 98 Binlog_Do_DB: radius,radius Binlog_Ignore_DB: 1 row in set (0.21 sec) ERROR: No query specified On slave I did mysql> change master to master_host = 'XX.XX.XX.2' , master_user = 'replication', master_password = 'password', master_log_file = 'mysql-bin.000001', master_log_pos = 98; A part of my my.cnf (On the slave) is like this [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # server-id = 2 log-bin = /var/log/mysql/mysql-bin.log expire-logs-days = 20 max_binlog_size = 104857600 binlog-do-db = radius #binlog-ignore-db = include_database_name After mysql restart, the show slave status shows mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: XX.XX.XX.2 Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 98 Relay_Log_Fi
I'm doing replication for one server. Its not the first time I do configure replication between two MySQL database nodes, however since I haven't done it for a few years, my "know how" has mostly vanished so I had some troubles in setting it up. Once I followed some steps to configure replication I had to check if the two MASTER / Slave MySQL db nodes communicate properly. Hence I decided to drop a short post on that just in case if someone has to do the same or if I myself forget how I did it so I can check later on: 1. Check if MASTER MySQL server node is configured properly The standard way to check a MySQL master node status info is with: mysql> show master status; +------------+-------+--------------------------------------+------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------+-------+--------------------------------------+------------+ | mysql-bin.000007 | 106 | database1,database2,database3 | | +------------+-------+--------------------------------------+------------+ 1 row in set (0.00 sec) By putting \G some extra status info is provided: mysql> show master status\G; *************************** 1. row *************************** File: mysql-bin.000007 Position: 106 Binlog_Do_DB: database1,database2,database3 Binlog_Ignore_DB: 1 row in set (0.00 sec) ERROR: No query specified 2. Check if Slave MySQL node is configured properly To check status of the slave the cmd is: mysql> show slave status; The command returns an output like: mysql> show slave status;+-----------------------+---------+---------+---------+----------+------------+--------------+-----------------+----------+---------------+------------+-------------+-------------------------------------+--------------+-------------+----------------+-----------------+-------------------+--------+--------+---------+--------------+-----------+-----------+-----------+----------+-------------+-------------+-------------+-----------+-------------+-----------+---------------+---------------------+----------+----------+-----------+-----------+| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_P