091223 5:55:22 [Note] Slave SQL thread initialized, starting replication in
log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001'
position: 4
091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 6:55:42 [Note] /usr/sbin/mysqld: Normal shutdown
091223 6:55:42 [Note] Slave I/O thread killed while connecting to master
091223 6:55:42 [Note] Slave I/O thread exiting, read up to log 'FIRST',
position 4
091223 6:55:42 [Note] Error reading relay log event: slave SQL thread was
killed
091223 6:55:42 InnoDB: Starting shutdown...
091223 6:55:45 InnoDB: Shutdown completed; log sequence number 0 407843552
091223 6:55:45 [Note] /usr/sbin/mysqld: Shutdown complete
091223 6:58:30 [Warning] No argument was provided to --log-bin,
and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=ip-97-74-85-42-bin' to avoid this problem.
091223 6:58:30 InnoDB: Started; log sequence number 0 407843552
091223 6:58:30 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Edition (GPL)
091223 6:58:30 [Note] Slave SQL thread initialized, starting replication in
log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001'
position: 98
091223 6:58:30 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 7:03:32 [Note] /usr/sbin/mysqld: Normal shutdown
091223 7:03:32 [Note] Slave I/O thread killed while connecting to master
091223 7:03:32 [Note] Slave I/O thread exiting, read up to log 'FIRST',
position 4
091223 7:03:32 [Note] Error reading relay log event: slave SQL thread was
killed
091223 7:03:32 InnoDB: Starting shutdown...
091223 7:03:33 InnoDB: Shutdown completed; log sequence number 0 407843552
091223 7:03:33 [Note] /usr/sbin/mysqld: Shutdown complete
091223 7:03:38 [Warning] No argument was provided to --log-bin,
and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=ip-97-74-85-42-bin' to avoid this problem.
091223 7:03:38 InnoDB: Started; log sequence number 0 407843552
091223 7:03:38 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Edition (GPL)
091223 7:03:38 [Note] Slave SQL thread initialized, starting replication in
log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000002'
position: 98
091223 7:03:38 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 7:03:44 [Note] /usr/sbin/mysqld: Normal shutdown
091223 7:03:44 [Note] Slave I/O thread killed while connecting to master
091223 7:03:44 [Note] Slave I/O thread exiting, read up to log 'FIRST',
position 4
091223 7:03:44 [Note] Error reading relay log event: slave SQL thread was
killed
091223 7:03:52 [Warning] No argument was provided to --log-bin,
and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=ip-97-74-85-42-bin' to avoid this problem.
091223 7:03:52 InnoDB: Started; log sequence number 0 407843552
091223 7:03:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Edition (GPL)
091223 7:03:52 [Note] Slave SQL thread initialized, starting replication in
log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000003'
position: 98
091223 7:03:52 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does not
exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Lost connection to MySQL server at
'reading initial communication packet', system error: 111' errno: 2013
retry-time: 60 retries: 86400
091223 7:31:52 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 7:46:14 [Note] Slave I/O thread killed while connecting to master
091223 7:46:14 [Note] Slave I/O thread exiting, read up to log 'FIRST',
position 4
091223 7:46:14 [Note] Error reading relay log event: slave SQL thread was
killed
091223 7:46:28 [Note] Slave SQL thread initialized, starting replication in
log 'ip-208-109-238-76-bin.000041' at position 17907, relay log
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:46:28 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 7:47:20 [Note] Slave I/O thread killed while connecting to master
091223 7:47:20 [Note] Slave I/O thread exiting, read up to log
'ip-208-109-238-76-bin.000041', position 17907
091223 7:47:20 [Note] Error reading relay log event: slave SQL thread was
killed
091223 7:47:40 [Note] Slave SQL thread initialized, starting replication in
log 'ip-208-109-238-76-bin.000041' at position 17906, relay log
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:47:40 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 8:07:20 [Note] Slave I/O thread killed while connecting to master
091223 8:07:20 [Note] Slave I/O thread exiting, read up to log
'ip-208-109-238-76-bin.000041', position 17906
091223 8:07:20 [Note] Error reading relay log event: slave SQL thread was
killed
091223 8:07:37 [Note] Slave SQL thread initialized, starting replication in
log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001'
position: 4
091223 8:07:37 [ERROR] Slave I/O thread: error connecting to master
't...@201.107.236.77:3306': Error: 'Access denied for user
'test'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 8:12:59 [Note] Slave I/O thread killed while connecting to master
091223 8:12:59 [Note] Slave I/O thread exiting, read up to log 'FIRST',
position 4
091223 8:12:59 [Note] Error reading relay log event: slave SQL thread was
killed
091223 8:13:12 [Note] Slave SQL thread initialized, starting replication in
log 'ip-208-109-238-76-bin.000041' at position 174925, relay log
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 8:13:12 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 8:15:19 [Note] Slave I/O thread killed while connecting to master
091223 8:15:19 [Note] Slave I/O thread exiting, read up to log
'ip-208-109-238-76-bin.000041', position 174925
091223 8:15:19 [Note] Error reading relay log event: slave SQL thread was
killed
091223 23:19:24 [Note] /usr/sbin/mysqld: Normal shutdown
091223 23:19:24 InnoDB: Starting shutdown...
091223 23:19:27 InnoDB: Shutdown completed; log sequence number 0 407845542
091223 23:19:27 [Note] /usr/sbin/mysqld: Shutdown complete
091223 23:20:25 [Warning] No argument was provided to --log-bin,
and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=ip-97-74-85-42-bin' to avoid this problem.
091223 23:20:25 InnoDB: Started; log sequence number 0 407845542
091223 23:20:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Edition (GPL)
091223 23:20:31 [Note] /usr/sbin/mysqld: Normal shutdown
091223 23:20:31 InnoDB: Starting shutdown...
091223 23:20:32 InnoDB: Shutdown completed; log sequence number 0 407845542
091223 23:20:32 [Note] /usr/sbin/mysqld: Shutdown complete
091223 23:20:37 [Warning] No argument was provided to --log-bin,
and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=ip-97-74-85-42-bin' to avoid this problem.
091223 23:20:37 InnoDB: Started; log sequence number 0 407845542
091223 23:20:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Edition (GPL)
091223 23:55:20 [Warning] Neither --relay-log nor --relay-log-index were
used; so replication may break when this MySQL server acts as a slave and
has his hostname changed!! Please use '--relay-log=ip-97-74-85-42-relay-bin'
to avoid this problem.
091224 0:00:16 [Note] Slave SQL thread initialized, starting replication in
log 'ip-208-109-238-76-bin.000042' at position 4436, relay log
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091224 1:04:48 [Note] Slave I/O thread killed while connecting to master
091224 1:04:48 [Note] Slave I/O thread exiting, read up to log
'ip-208-109-238-76-bin.000042', position 4436
091224 1:04:48 [Note] Error reading relay log event: slave SQL thread was
killed
091224 1:07:59 [Note] Slave SQL thread initialized, starting replication in
log 'ip-208-109-238-76-bin.000042' at position 4702, relay log
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 1:07:59 [ERROR] Slave I/O thread: error connecting to master
'r...@201.107.236.77:3306': Error: 'Access denied for user
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
Thanks
Jeetendra Ranjan
----- Original Message -----
From: "Shanmugam, Dhandapani" <dhandapani.shanmu...@eds.com>
To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com>; "Parikh, Dilip
Kumar" <dilipkumar.par...@eds.com>; <mysql@lists.mysql.com>
Sent: Thursday, December 24, 2009 2:15 PM
Subject: RE: Slave is not updated
Jeetendra,
Can you paste the error log here.
-D
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com]
Sent: Thursday, December 24, 2009 1:49 PM
To: Parikh, Dilip Kumar; mysql@lists.mysql.com
Subject: Re: Slave is not updated
Hi Dilip,
Thanks for your response
I already run the below command at master:
grant replication slave on *.* to 'mysqladm'@'95.84.86.41' identified by
'admmysql';
Thanks
Jeetendra Ranjan
----- Original Message -----
From: "Parikh, Dilip Kumar" <dilipkumar.par...@eds.com>
To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com>;
<mysql@lists.mysql.com>
Sent: Thursday, December 24, 2009 1:10 PM
Subject: RE: Slave is not updated
You can see connecting to master means it is not able to establish the
connection from slave to master, give the grants as (replication
client
etc..)
and then try again.
Thanks,
Dilipkumar
Database Engineering
Pager mail:9884430...@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com]
Sent: Thursday, December 24, 2009 1:05 PM
To: mysql@lists.mysql.com
Subject: Slave is not updated
Hi,
I am getting this information from slave
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 201.107.236.77
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: ip-201-107-236-77-bin.000042
Read_Master_Log_Pos: 4702
Relay_Log_File: ip-95-84-86-41-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: ip-201-107-236-77-bin.000042
Slave_IO_Running: No
Slave_IO_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
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: 4702
Relay_Log_Space: 98
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_SSL_Key:
Seconds_Behind_Master: NULL
The Slave_IO_Running is always No even after repeating below steps so
many times
stop slave
CHANGE MASTER TO ....
and
start slave
Please guide why this is always NO and how do i enable it ?
Regards
Jeetendra Ranjan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=dhandapani.shanmu...@eds.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
