Slave is not updated
am 24.12.2009 08:35:10 von jeetendra.ranjan
------=_NextPart_000_0066_01CA8499.B90A1970
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I am getting this information from slave=20
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:=20
Replicate_Ignore_DB:=20
Replicate_Do_Table:=20
Replicate_Ignore_Table:=20
Replicate_Wild_Do_Table:=20
Replicate_Wild_Ignore_Table:=20
Last_Errno: 0
Last_Error:=20
Skip_Counter: 0
Exec_Master_Log_Pos: 4702
Relay_Log_Space: 98
Until_Condition: None
Until_Log_File:=20
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:=20
Master_SSL_CA_Path:=20
Master_SSL_Cert:=20
Master_SSL_Cipher:=20
Master_SSL_Key:=20
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=20
start slave
Please guide why this is always NO and how do i enable it ?
Regards
Jeetendra Ranjan
------=_NextPart_000_0066_01CA8499.B90A1970--
RE: Slave is not updated
am 24.12.2009 08:40:57 von dilipkumar.parikh
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:9884430998@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]=20
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=20
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:=20
Replicate_Ignore_DB:=20
Replicate_Do_Table:=20
Replicate_Ignore_Table:=20
Replicate_Wild_Do_Table:=20
Replicate_Wild_Ignore_Table:=20
Last_Errno: 0
Last_Error:=20
Skip_Counter: 0
Exec_Master_Log_Pos: 4702
Relay_Log_Space: 98
Until_Condition: None
Until_Log_File:=20
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:=20
Master_SSL_CA_Path:=20
Master_SSL_Cert:=20
Master_SSL_Cipher:=20
Master_SSL_Key:=20
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=20
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=3Dgcdmg-mysql-2@m.gmane.o rg
Re: Slave is not updated
am 24.12.2009 09:19:01 von jeetendra.ranjan
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"
To: "Jeetendra Ranjan" ;
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:9884430998@nma.vodafone.in
>
> -----Original Message-----
> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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=gcdmg-mysql-2@m.gmane.org
RE: Slave is not updated
am 24.12.2009 09:45:36 von dhandapani.shanmugam
=20
Jeetendra,
Can you paste the error log here.
-D
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]=20
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 -----=20
From: "Parikh, Dilip Kumar"
To: "Jeetendra Ranjan" ;=20
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:9884430998@nma.vodafone.in
>
> -----Original Message-----
> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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=20
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Ddhandapani.shanmugam@ed s.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Re: Slave is not updated
am 24.12.2009 10:00:41 von jeetendra.ranjan
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
'root@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
'root@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
'root@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
'root@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-troubleshootin g.html
091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master
'root@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
'root@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
'root@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
'root@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
'test@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
'root@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
'root@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
'root@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"
To: "Jeetendra Ranjan" ; "Parikh, Dilip
Kumar" ;
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.ranjan@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"
> To: "Jeetendra Ranjan" ;
>
> 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:9884430998@nma.vodafone.in
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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.shanmugam@eds. com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
RE: Slave is not updated
am 24.12.2009 10:12:47 von dilipkumar.parikh
You can see in the logs, access denied So give trying for hostname or
with full domain or=20
Grant replication slave on *.* to 'mysqladm'@'95.%' identified by
'xxxxxx';
Grant replication slave on *.* to 'mysqladm'@'hostname identified by
'xxxxxx';
Flush privileges;
it should work.
Thanks,
Dilipkumar
Database Engineering
mailto: dilipkumar.parikh@eds.com=20
Pager mail:9884430998@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]=20
Sent: Thursday, December 24, 2009 2:31 PM
To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
Subject: Re: Slave is not updated
091223 5:55:22 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 4
091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 6:58:30 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 98
091223 6:58:30 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 7:03:38 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000002'=20
position: 98
091223 7:03:38 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 7:03:52 [Warning] No argument was provided to --log-bin,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 7:03:52 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000003'=20
position: 98
091223 7:03:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
1045 retry-time: 60 retries: 86400
091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does
not=20
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-troubleshootin g.html
091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Lost connection to MySQL server at=20
'reading initial communication packet', system error: 111' errno: 2013=20
retry-time: 60 retries: 86400
091223 7:31:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 7:46:28 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 17907, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:46:28 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 17907
091223 7:47:20 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091223 7:47:40 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 17906, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:47:40 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 17906
091223 8:07:20 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091223 8:07:37 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 4
091223 8:07:37 [ERROR] Slave I/O thread: error connecting to master=20
'test@201.107.236.77:3306': Error: 'Access denied for user=20
'test'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 8:13:12 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 174925, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 8:13:12 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 174925
091223 8:15:19 [Note] Error reading relay log event: slave SQL thread
was=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
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=20
has his hostname changed!! Please use
'--relay-log=3Dip-97-74-85-42-relay-bin'=20
to avoid this problem.
091224 0:00:16 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000042' at position 4436, relay log=20
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000042', position 4436
091224 1:04:48 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091224 1:07:59 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000042' at position 4702, relay log=20
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 1:07:59 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
1045 retry-time: 60 retries: 86400
Thanks
Jeetendra Ranjan
----- Original Message -----=20
From: "Shanmugam, Dhandapani"
To: "Jeetendra Ranjan" ; "Parikh, Dilip=20
Kumar" ;
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.ranjan@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 -----=20
> From: "Parikh, Dilip Kumar"
> To: "Jeetendra Ranjan" ;
>
> 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:9884430998@nma.vodafone.in
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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
>
>
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Ddhandapani.shanmugam@ed s.com=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
RE: Slave is not updated
am 24.12.2009 10:17:37 von dhandapani.shanmugam
by the way did you flush the privileges on the master? What is the
output you get, when you log in as root user on the mysql master server
and issue the below command:
select * from mysql.user where user=3D'replication'\G;
-D
-----Original Message-----
From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]=20
Sent: Thursday, December 24, 2009 2:43 PM
To: Jeetendra Ranjan; mysql@lists.mysql.com
Subject: RE: Slave is not updated
You can see in the logs, access denied So give trying for hostname or
with full domain or=20
Grant replication slave on *.* to 'mysqladm'@'95.%' identified by
'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname
identified by 'xxxxxx'; Flush privileges;
it should work.
Thanks,
Dilipkumar
Database Engineering
mailto: dilipkumar.parikh@eds.com
Pager mail:9884430998@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]=20
Sent: Thursday, December 24, 2009 2:31 PM
To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
Subject: Re: Slave is not updated
091223 5:55:22 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 4
091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 6:58:30 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 98
091223 6:58:30 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 7:03:38 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000002'=20
position: 98
091223 7:03:38 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 7:03:52 [Warning] No argument was provided to --log-bin,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 7:03:52 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000003'=20
position: 98
091223 7:03:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
1045 retry-time: 60 retries: 86400
091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does
not=20
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-troubleshootin g.html
091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Lost connection to MySQL server at=20
'reading initial communication packet', system error: 111' errno: 2013=20
retry-time: 60 retries: 86400
091223 7:31:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 7:46:28 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 17907, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:46:28 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 17907
091223 7:47:20 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091223 7:47:40 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 17906, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:47:40 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 17906
091223 8:07:20 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091223 8:07:37 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 4
091223 8:07:37 [ERROR] Slave I/O thread: error connecting to master=20
'test@201.107.236.77:3306': Error: 'Access denied for user=20
'test'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 8:13:12 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 174925, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 8:13:12 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 174925
091223 8:15:19 [Note] Error reading relay log event: slave SQL thread
was=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
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=20
has his hostname changed!! Please use
'--relay-log=3Dip-97-74-85-42-relay-bin'=20
to avoid this problem.
091224 0:00:16 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000042' at position 4436, relay log=20
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000042', position 4436
091224 1:04:48 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091224 1:07:59 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000042' at position 4702, relay log=20
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 1:07:59 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
1045 retry-time: 60 retries: 86400
Thanks
Jeetendra Ranjan
----- Original Message -----=20
From: "Shanmugam, Dhandapani"
To: "Jeetendra Ranjan" ; "Parikh, Dilip=20
Kumar" ;
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.ranjan@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 -----=20
> From: "Parikh, Dilip Kumar"
> To: "Jeetendra Ranjan" ;
>
> 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:9884430998@nma.vodafone.in
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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
>
>
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Ddhandapani.shanmugam@ed s.com=20
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Ddhandapani.shanmugam@ed s.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
RE: Slave is not updated
am 24.12.2009 10:21:51 von dilipkumar.parikh
DQpVc2VyIGlzIG5vdCB0aGUgcmVwbGljYXRpb24gaXQgaXMgJ3Jvb3QnIChv cikgbXlzcWxhZG0N
Cg0KVGhhbmtzLA0KRGlsaXBrdW1hcg0KRGF0YWJhc2UgRW5naW5lZXJpbmcN Cu+AqyBtYWlsdG86
IGRpbGlwa3VtYXIucGFyaWtoQGVkcy5jb20gDQpQYWdlciBtYWlsOjk4ODQ0 MzA5OThAbm1hLnZv
ZGFmb25lLmluDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZy b206IFNoYW5tdWdh
bSwgRGhhbmRhcGFuaSANClNlbnQ6IFRodXJzZGF5LCBEZWNlbWJlciAyNCwg MjAwOSAyOjQ4IFBN
DQpUbzogUGFyaWtoLCBEaWxpcCBLdW1hcjsgSmVldGVuZHJhIFJhbmphbjsg bXlzcWxAbGlzdHMu
bXlzcWwuY29tDQpTdWJqZWN0OiBSRTogU2xhdmUgaXMgbm90IHVwZGF0ZWQN Cg0KDQpieSB0aGUg
d2F5IGRpZCB5b3UgZmx1c2ggdGhlIHByaXZpbGVnZXMgb24gdGhlIG1hc3Rl cj8gV2hhdCBpcyB0
aGUgb3V0cHV0IHlvdSBnZXQsIHdoZW4geW91IGxvZyBpbiBhcyByb290IHVz ZXIgb24gdGhlIG15
c3FsIG1hc3RlciBzZXJ2ZXIgYW5kIGlzc3VlIHRoZSBiZWxvdyBjb21tYW5k Og0KDQpzZWxlY3Qg
KiBmcm9tIG15c3FsLnVzZXIgd2hlcmUgdXNlcj0ncmVwbGljYXRpb24nXEc7 DQoNCi1EDQoNCi0t
LS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBQYXJpa2gsIERpbGlw IEt1bWFyIFttYWls
dG86ZGlsaXBrdW1hci5wYXJpa2hAZWRzLmNvbV0gDQpTZW50OiBUaHVyc2Rh eSwgRGVjZW1iZXIg
MjQsIDIwMDkgMjo0MyBQTQ0KVG86IEplZXRlbmRyYSBSYW5qYW47IG15c3Fs QGxpc3RzLm15c3Fs
LmNvbQ0KU3ViamVjdDogUkU6IFNsYXZlIGlzIG5vdCB1cGRhdGVkDQoNCllv dSBjYW4gc2VlIGlu
IHRoZSBsb2dzLCBhY2Nlc3MgZGVuaWVkIFNvIGdpdmUgdHJ5aW5nIGZvciBo b3N0bmFtZSBvciB3
aXRoIGZ1bGwgZG9tYWluIG9yIA0KDQpHcmFudCByZXBsaWNhdGlvbiBzbGF2 ZSBvbiAqLiogdG8g
J215c3FsYWRtJ0AnOTUuJScgaWRlbnRpZmllZCBieSAneHh4eHh4JzsgR3Jh bnQgcmVwbGljYXRp
b24gc2xhdmUgb24gKi4qIHRvICdteXNxbGFkbSdAJ2hvc3RuYW1lIGlkZW50 aWZpZWQgYnkgJ3h4
eHh4eCc7IEZsdXNoIHByaXZpbGVnZXM7DQoNCml0IHNob3VsZCB3b3JrLg0K DQpUaGFua3MsDQpE
aWxpcGt1bWFyDQpEYXRhYmFzZSBFbmdpbmVlcmluZw0KbWFpbHRvOiBkaWxp cGt1bWFyLnBhcmlr
aEBlZHMuY29tDQpQYWdlciBtYWlsOjk4ODQ0MzA5OThAbm1hLnZvZGFmb25l LmluDQoNCg0KLS0t
LS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IEplZXRlbmRyYSBSYW5q YW4gW21haWx0bzpq
ZWV0ZW5kcmEucmFuamFuQHNhbXBhdHRpLmNvbV0gDQpTZW50OiBUaHVyc2Rh eSwgRGVjZW1iZXIg
MjQsIDIwMDkgMjozMSBQTQ0KVG86IFNoYW5tdWdhbSwgRGhhbmRhcGFuaTsg UGFyaWtoLCBEaWxp
cCBLdW1hcjsgbXlzcWxAbGlzdHMubXlzcWwuY29tDQpTdWJqZWN0OiBSZTog U2xhdmUgaXMgbm90
IHVwZGF0ZWQNCg0KMDkxMjIzICA1OjU1OjIyIFtOb3RlXSBTbGF2ZSBTUUwg dGhyZWFkIGluaXRp
YWxpemVkLCBzdGFydGluZw0KcmVwbGljYXRpb24gaW4gDQpsb2cgJ0ZJUlNU JyBhdCBwb3NpdGlv
biAwLCByZWxheSBsb2cNCicvdmFyL2xpYi9teXNxbC9teXNxbC1yZWxheS1i aW4uMDAwMDAxJyAN
CnBvc2l0aW9uOiA0DQowOTEyMjMgIDU6NTU6MjIgW0VSUk9SXSBTbGF2ZSBJ L08gdGhyZWFkOiBl
cnJvciBjb25uZWN0aW5nIHRvIG1hc3RlciANCidyb290QDIwMS4xMDcuMjM2 Ljc3OjMzMDYnOiBF
cnJvcjogJ0FjY2VzcyBkZW5pZWQgZm9yIHVzZXIgDQoncm9vdCdAJ2lwLTk3 LTc0LTg1LTQyLmlw
LnNlY3VyZXNlcnZlci5uZXQnICh1c2luZyBwYXNzd29yZDogWUVTKScNCmVy cm5vOiANCjEwNDUg
IHJldHJ5LXRpbWU6IDYwICByZXRyaWVzOiA4NjQwMA0KMDkxMjIzICA2OjU1 OjQyIFtOb3RlXSAv
dXNyL3NiaW4vbXlzcWxkOiBOb3JtYWwgc2h1dGRvd24NCg0KMDkxMjIzICA2 OjU1OjQyIFtOb3Rl
XSBTbGF2ZSBJL08gdGhyZWFkIGtpbGxlZCB3aGlsZSBjb25uZWN0aW5nIHRv DQptYXN0ZXINCjA5
MTIyMyAgNjo1NTo0MiBbTm90ZV0gU2xhdmUgSS9PIHRocmVhZCBleGl0aW5n LCByZWFkIHVwIHRv
IGxvZyAnRklSU1QnLA0KDQpwb3NpdGlvbiA0DQowOTEyMjMgIDY6NTU6NDIg W05vdGVdIEVycm9y
IHJlYWRpbmcgcmVsYXkgbG9nIGV2ZW50OiBzbGF2ZSBTUUwgdGhyZWFkDQp3 YXMgDQpraWxsZWQN
CjA5MTIyMyAgNjo1NTo0MiAgSW5ub0RCOiBTdGFydGluZyBzaHV0ZG93bi4u Lg0KMDkxMjIzICA2
OjU1OjQ1ICBJbm5vREI6IFNodXRkb3duIGNvbXBsZXRlZDsgbG9nIHNlcXVl bmNlIG51bWJlciAw
DQo0MDc4NDM1NTINCjA5MTIyMyAgNjo1NTo0NSBbTm90ZV0gL3Vzci9zYmlu L215c3FsZDogU2h1
dGRvd24gY29tcGxldGUNCg0KMDkxMjIzICA2OjU4OjMwIFtXYXJuaW5nXSBO byBhcmd1bWVudCB3
YXMgcHJvdmlkZWQgdG8gLS1sb2ctYmluLCANCmFuZCAtLWxvZy1iaW4taW5k ZXggd2FzIG5vdCB1
c2VkOyBzbyByZXBsaWNhdGlvbiBtYXkgYnJlYWsgd2hlbiB0aGlzDQpNeVNR TCANCnNlcnZlciBh
Y3RzIGFzIGEgbWFzdGVyIGFuZCBoYXMgaGlzIGhvc3RuYW1lIGNoYW5nZWQh ISBQbGVhc2UgdXNl
IA0KJy0tbG9nLWJpbj1pcC05Ny03NC04NS00Mi1iaW4nIHRvIGF2b2lkIHRo aXMgcHJvYmxlbS4N
CjA5MTIyMyAgNjo1ODozMCAgSW5ub0RCOiBTdGFydGVkOyBsb2cgc2VxdWVu Y2UgbnVtYmVyIDAg
NDA3ODQzNTUyDQowOTEyMjMgIDY6NTg6MzAgW05vdGVdIC91c3Ivc2Jpbi9t eXNxbGQ6IHJlYWR5
IGZvciBjb25uZWN0aW9ucy4NClZlcnNpb246ICc1LjAuODUtY29tbXVuaXR5 LWxvZycgIHNvY2tl
dDogJy92YXIvbGliL215c3FsL215c3FsLnNvY2snDQpwb3J0OiANCjMzMDYg IE15U1FMIENvbW11
bml0eSBFZGl0aW9uIChHUEwpDQowOTEyMjMgIDY6NTg6MzAgW05vdGVdIFNs YXZlIFNRTCB0aHJl
YWQgaW5pdGlhbGl6ZWQsIHN0YXJ0aW5nDQpyZXBsaWNhdGlvbiBpbiANCmxv ZyAnRklSU1QnIGF0
IHBvc2l0aW9uIDAsIHJlbGF5IGxvZw0KJy92YXIvbGliL215c3FsL215c3Fs LXJlbGF5LWJpbi4w
MDAwMDEnIA0KcG9zaXRpb246IDk4DQowOTEyMjMgIDY6NTg6MzAgW0VSUk9S XSBTbGF2ZSBJL08g
dGhyZWFkOiBlcnJvciBjb25uZWN0aW5nIHRvIG1hc3RlciANCidyb290QDIw MS4xMDcuMjM2Ljc3
OjMzMDYnOiBFcnJvcjogJ0FjY2VzcyBkZW5pZWQgZm9yIHVzZXIgDQoncm9v dCdAJ2lwLTk3LTc0
LTg1LTQyLmlwLnNlY3VyZXNlcnZlci5uZXQnICh1c2luZyBwYXNzd29yZDog WUVTKScNCmVycm5v
OiANCjEwNDUgIHJldHJ5LXRpbWU6IDYwICByZXRyaWVzOiA4NjQwMA0KMDkx MjIzICA3OjAzOjMy
IFtOb3RlXSAvdXNyL3NiaW4vbXlzcWxkOiBOb3JtYWwgc2h1dGRvd24NCg0K MDkxMjIzICA3OjAz
OjMyIFtOb3RlXSBTbGF2ZSBJL08gdGhyZWFkIGtpbGxlZCB3aGlsZSBjb25u ZWN0aW5nIHRvDQpt
YXN0ZXINCjA5MTIyMyAgNzowMzozMiBbTm90ZV0gU2xhdmUgSS9PIHRocmVh ZCBleGl0aW5nLCBy
ZWFkIHVwIHRvIGxvZyAnRklSU1QnLA0KDQpwb3NpdGlvbiA0DQowOTEyMjMg IDc6MDM6MzIgW05v
dGVdIEVycm9yIHJlYWRpbmcgcmVsYXkgbG9nIGV2ZW50OiBzbGF2ZSBTUUwg dGhyZWFkDQp3YXMg
DQpraWxsZWQNCjA5MTIyMyAgNzowMzozMiAgSW5ub0RCOiBTdGFydGluZyBz aHV0ZG93bi4uLg0K
MDkxMjIzICA3OjAzOjMzICBJbm5vREI6IFNodXRkb3duIGNvbXBsZXRlZDsg bG9nIHNlcXVlbmNl
IG51bWJlciAwDQo0MDc4NDM1NTINCjA5MTIyMyAgNzowMzozMyBbTm90ZV0g L3Vzci9zYmluL215
c3FsZDogU2h1dGRvd24gY29tcGxldGUNCg0KMDkxMjIzICA3OjAzOjM4IFtX YXJuaW5nXSBObyBh
cmd1bWVudCB3YXMgcHJvdmlkZWQgdG8gLS1sb2ctYmluLCANCmFuZCAtLWxv Zy1iaW4taW5kZXgg
d2FzIG5vdCB1c2VkOyBzbyByZXBsaWNhdGlvbiBtYXkgYnJlYWsgd2hlbiB0 aGlzDQpNeVNRTCAN
CnNlcnZlciBhY3RzIGFzIGEgbWFzdGVyIGFuZCBoYXMgaGlzIGhvc3RuYW1l IGNoYW5nZWQhISBQ
bGVhc2UgdXNlIA0KJy0tbG9nLWJpbj1pcC05Ny03NC04NS00Mi1iaW4nIHRv IGF2b2lkIHRoaXMg
cHJvYmxlbS4NCjA5MTIyMyAgNzowMzozOCAgSW5ub0RCOiBTdGFydGVkOyBs b2cgc2VxdWVuY2Ug
bnVtYmVyIDAgNDA3ODQzNTUyDQowOTEyMjMgIDc6MDM6MzggW05vdGVdIC91 c3Ivc2Jpbi9teXNx
bGQ6IHJlYWR5IGZvciBjb25uZWN0aW9ucy4NClZlcnNpb246ICc1LjAuODUt Y29tbXVuaXR5LWxv
ZycgIHNvY2tldDogJy92YXIvbGliL215c3FsL215c3FsLnNvY2snDQpwb3J0 OiANCjMzMDYgIE15
U1FMIENvbW11bml0eSBFZGl0aW9uIChHUEwpDQowOTEyMjMgIDc6MDM6Mzgg W05vdGVdIFNsYXZl
IFNRTCB0aHJlYWQgaW5pdGlhbGl6ZWQsIHN0YXJ0aW5nDQpyZXBsaWNhdGlv biBpbiANCmxvZyAn
RklSU1QnIGF0IHBvc2l0aW9uIDAsIHJlbGF5IGxvZw0KJy92YXIvbGliL215 c3FsL215c3FsLXJl
bGF5LWJpbi4wMDAwMDInIA0KcG9zaXRpb246IDk4DQowOTEyMjMgIDc6MDM6 MzggW0VSUk9SXSBT
bGF2ZSBJL08gdGhyZWFkOiBlcnJvciBjb25uZWN0aW5nIHRvIG1hc3RlciAN Cidyb290QDIwMS4x
MDcuMjM2Ljc3OjMzMDYnOiBFcnJvcjogJ0FjY2VzcyBkZW5pZWQgZm9yIHVz ZXIgDQoncm9vdCdA
J2lwLTk3LTc0LTg1LTQyLmlwLnNlY3VyZXNlcnZlci5uZXQnICh1c2luZyBw YXNzd29yZDogWUVT
KScNCmVycm5vOiANCjEwNDUgIHJldHJ5LXRpbWU6IDYwICByZXRyaWVzOiA4 NjQwMA0KMDkxMjIz
ICA3OjAzOjQ0IFtOb3RlXSAvdXNyL3NiaW4vbXlzcWxkOiBOb3JtYWwgc2h1 dGRvd24NCg0KMDkx
MjIzICA3OjAzOjQ0IFtOb3RlXSBTbGF2ZSBJL08gdGhyZWFkIGtpbGxlZCB3 aGlsZSBjb25uZWN0
aW5nIHRvDQptYXN0ZXINCjA5MTIyMyAgNzowMzo0NCBbTm90ZV0gU2xhdmUg SS9PIHRocmVhZCBl
eGl0aW5nLCByZWFkIHVwIHRvIGxvZyAnRklSU1QnLA0KDQpwb3NpdGlvbiA0 DQowOTEyMjMgIDc6
MDM6NDQgW05vdGVdIEVycm9yIHJlYWRpbmcgcmVsYXkgbG9nIGV2ZW50OiBz bGF2ZSBTUUwgdGhy
ZWFkDQp3YXMgDQpraWxsZWQNCjA5MTIyMyAgNzowMzo1MiBbV2FybmluZ10g Tm8gYXJndW1lbnQg
d2FzIHByb3ZpZGVkIHRvIC0tbG9nLWJpbiwgDQphbmQgLS1sb2ctYmluLWlu ZGV4IHdhcyBub3Qg
dXNlZDsgc28gcmVwbGljYXRpb24gbWF5IGJyZWFrIHdoZW4gdGhpcw0KTXlT UUwgDQpzZXJ2ZXIg
YWN0cyBhcyBhIG1hc3RlciBhbmQgaGFzIGhpcyBob3N0bmFtZSBjaGFuZ2Vk ISEgUGxlYXNlIHVz
ZSANCictLWxvZy1iaW49aXAtOTctNzQtODUtNDItYmluJyB0byBhdm9pZCB0 aGlzIHByb2JsZW0u
DQowOTEyMjMgIDc6MDM6NTIgIElubm9EQjogU3RhcnRlZDsgbG9nIHNlcXVl bmNlIG51bWJlciAw
IDQwNzg0MzU1Mg0KMDkxMjIzICA3OjAzOjUyIFtOb3RlXSAvdXNyL3NiaW4v bXlzcWxkOiByZWFk
eSBmb3IgY29ubmVjdGlvbnMuDQpWZXJzaW9uOiAnNS4wLjg1LWNvbW11bml0 eS1sb2cnICBzb2Nr
ZXQ6ICcvdmFyL2xpYi9teXNxbC9teXNxbC5zb2NrJw0KcG9ydDogDQozMzA2 ICBNeVNRTCBDb21t
dW5pdHkgRWRpdGlvbiAoR1BMKQ0KMDkxMjIzICA3OjAzOjUyIFtOb3RlXSBT bGF2ZSBTUUwgdGhy
ZWFkIGluaXRpYWxpemVkLCBzdGFydGluZw0KcmVwbGljYXRpb24gaW4gDQps b2cgJ0ZJUlNUJyBh
dCBwb3NpdGlvbiAwLCByZWxheSBsb2cNCicvdmFyL2xpYi9teXNxbC9teXNx bC1yZWxheS1iaW4u
MDAwMDAzJyANCnBvc2l0aW9uOiA5OA0KMDkxMjIzICA3OjAzOjUyIFtFUlJP Ul0gU2xhdmUgSS9P
IHRocmVhZDogZXJyb3IgY29ubmVjdGluZyB0byBtYXN0ZXIgDQoncm9vdEAy MDEuMTA3LjIzNi43
NzozMzA2JzogRXJyb3I6ICdBY2Nlc3MgZGVuaWVkIGZvciB1c2VyIA0KJ3Jv b3QnQCdpcC05Ny03
NC04NS00Mi5pcC5zZWN1cmVzZXJ2ZXIubmV0JyAodXNpbmcgcGFzc3dvcmQ6 IFlFUyknDQplcnJu
bzogDQoxMDQ1ICByZXRyeS10aW1lOiA2MCAgcmV0cmllczogODY0MDANCjA5 MTIyMyAgNzowNDow
OSAgSW5ub0RCOiBFcnJvcjogdGFibGUgYGhvcmRlL2hvcmRlX3Nlc3Npb25o YW5kbGVyYCBkb2Vz
DQpub3QgDQpleGlzdCBpbiB0aGUgSW5ub0RCIGludGVybmFsDQpJbm5vREI6 IGRhdGEgZGljdGlv
bmFyeSB0aG91Z2ggTXlTUUwgaXMgdHJ5aW5nIHRvIGRyb3AgaXQuDQpJbm5v REI6IEhhdmUgeW91
IGNvcGllZCB0aGUgLmZybSBmaWxlIG9mIHRoZSB0YWJsZSB0byB0aGUNCklu bm9EQjogTXlTUUwg
ZGF0YWJhc2UgZGlyZWN0b3J5IGZyb20gYW5vdGhlciBkYXRhYmFzZT8NCklu bm9EQjogWW91IGNh
biBsb29rIGZvciBmdXJ0aGVyIGhlbHAgZnJvbQ0KSW5ub0RCOg0KaHR0cDov L2Rldi5teXNxbC5j
b20vZG9jL3JlZm1hbi81LjAvZW4vaW5ub2RiLXRyb3VibGVzaG9vdGluZy5o dG1sDQowOTEyMjMg
IDc6MzA6NTIgW0VSUk9SXSBTbGF2ZSBJL08gdGhyZWFkOiBlcnJvciBjb25u ZWN0aW5nIHRvIG1h
c3RlciANCidyb290QDIwMS4xMDcuMjM2Ljc3OjMzMDYnOiBFcnJvcjogJ0xv c3QgY29ubmVjdGlv
biB0byBNeVNRTCBzZXJ2ZXIgYXQgDQoncmVhZGluZyBpbml0aWFsIGNvbW11 bmljYXRpb24gcGFj
a2V0Jywgc3lzdGVtIGVycm9yOiAxMTEnICBlcnJubzogMjAxMyANCnJldHJ5 LXRpbWU6IDYwICBy
ZXRyaWVzOiA4NjQwMA0KMDkxMjIzICA3OjMxOjUyIFtFUlJPUl0gU2xhdmUg SS9PIHRocmVhZDog
ZXJyb3IgY29ubmVjdGluZyB0byBtYXN0ZXIgDQoncm9vdEAyMDEuMTA3LjIz Ni43NzozMzA2Jzog
RXJyb3I6ICdBY2Nlc3MgZGVuaWVkIGZvciB1c2VyIA0KJ3Jvb3QnQCdpcC05 Ny03NC04NS00Mi5p
cC5zZWN1cmVzZXJ2ZXIubmV0JyAodXNpbmcgcGFzc3dvcmQ6IFlFUyknDQpl cnJubzogDQoxMDQ1
ICByZXRyeS10aW1lOiA2MCAgcmV0cmllczogODY0MDANCjA5MTIyMyAgNzo0 NjoxNCBbTm90ZV0g
U2xhdmUgSS9PIHRocmVhZCBraWxsZWQgd2hpbGUgY29ubmVjdGluZyB0bw0K bWFzdGVyDQowOTEy
MjMgIDc6NDY6MTQgW05vdGVdIFNsYXZlIEkvTyB0aHJlYWQgZXhpdGluZywg cmVhZCB1cCB0byBs
b2cgJ0ZJUlNUJywNCg0KcG9zaXRpb24gNA0KMDkxMjIzICA3OjQ2OjE0IFtO b3RlXSBFcnJvciBy
ZWFkaW5nIHJlbGF5IGxvZyBldmVudDogc2xhdmUgU1FMIHRocmVhZA0Kd2Fz IA0Ka2lsbGVkDQow
OTEyMjMgIDc6NDY6MjggW05vdGVdIFNsYXZlIFNRTCB0aHJlYWQgaW5pdGlh bGl6ZWQsIHN0YXJ0
aW5nDQpyZXBsaWNhdGlvbiBpbiANCmxvZyAnaXAtMjA4LTEwOS0yMzgtNzYt YmluLjAwMDA0MScg
YXQgcG9zaXRpb24gMTc5MDcsIHJlbGF5IGxvZyANCicvdmFyL2xpYi9teXNx bC9teXNxbC1yZWxh
eS1iaW4uMDAwMDAxJyBwb3NpdGlvbjogNA0KMDkxMjIzICA3OjQ2OjI4IFtF UlJPUl0gU2xhdmUg
SS9PIHRocmVhZDogZXJyb3IgY29ubmVjdGluZyB0byBtYXN0ZXIgDQoncm9v dEAyMDEuMTA3LjIz
Ni43NzozMzA2JzogRXJyb3I6ICdBY2Nlc3MgZGVuaWVkIGZvciB1c2VyIA0K J3Jvb3QnQCdpcC05
Ny03NC04NS00Mi5pcC5zZWN1cmVzZXJ2ZXIubmV0JyAodXNpbmcgcGFzc3dv cmQ6IFlFUyknDQpl
cnJubzogDQoxMDQ1ICByZXRyeS10aW1lOiA2MCAgcmV0cmllczogODY0MDAN CjA5MTIyMyAgNzo0
NzoyMCBbTm90ZV0gU2xhdmUgSS9PIHRocmVhZCBraWxsZWQgd2hpbGUgY29u bmVjdGluZyB0bw0K
bWFzdGVyDQowOTEyMjMgIDc6NDc6MjAgW05vdGVdIFNsYXZlIEkvTyB0aHJl YWQgZXhpdGluZywg
cmVhZCB1cCB0byBsb2cgDQonaXAtMjA4LTEwOS0yMzgtNzYtYmluLjAwMDA0 MScsIHBvc2l0aW9u
IDE3OTA3DQowOTEyMjMgIDc6NDc6MjAgW05vdGVdIEVycm9yIHJlYWRpbmcg cmVsYXkgbG9nIGV2
ZW50OiBzbGF2ZSBTUUwgdGhyZWFkDQp3YXMgDQpraWxsZWQNCjA5MTIyMyAg Nzo0Nzo0MCBbTm90
ZV0gU2xhdmUgU1FMIHRocmVhZCBpbml0aWFsaXplZCwgc3RhcnRpbmcNCnJl cGxpY2F0aW9uIGlu
IA0KbG9nICdpcC0yMDgtMTA5LTIzOC03Ni1iaW4uMDAwMDQxJyBhdCBwb3Np dGlvbiAxNzkwNiwg
cmVsYXkgbG9nIA0KJy92YXIvbGliL215c3FsL215c3FsLXJlbGF5LWJpbi4w MDAwMDEnIHBvc2l0
aW9uOiA0DQowOTEyMjMgIDc6NDc6NDAgW0VSUk9SXSBTbGF2ZSBJL08gdGhy ZWFkOiBlcnJvciBj
b25uZWN0aW5nIHRvIG1hc3RlciANCidyb290QDIwMS4xMDcuMjM2Ljc3OjMz MDYnOiBFcnJvcjog
J0FjY2VzcyBkZW5pZWQgZm9yIHVzZXIgDQoncm9vdCdAJ2lwLTk3LTc0LTg1 LTQyLmlwLnNlY3Vy
ZXNlcnZlci5uZXQnICh1c2luZyBwYXNzd29yZDogWUVTKScNCmVycm5vOiAN CjEwNDUgIHJldHJ5
LXRpbWU6IDYwICByZXRyaWVzOiA4NjQwMA0KMDkxMjIzICA4OjA3OjIwIFtO b3RlXSBTbGF2ZSBJ
L08gdGhyZWFkIGtpbGxlZCB3aGlsZSBjb25uZWN0aW5nIHRvDQptYXN0ZXIN CjA5MTIyMyAgODow
NzoyMCBbTm90ZV0gU2xhdmUgSS9PIHRocmVhZCBleGl0aW5nLCByZWFkIHVw IHRvIGxvZyANCidp
cC0yMDgtMTA5LTIzOC03Ni1iaW4uMDAwMDQxJywgcG9zaXRpb24gMTc5MDYN CjA5MTIyMyAgODow
NzoyMCBbTm90ZV0gRXJyb3IgcmVhZGluZyByZWxheSBsb2cgZXZlbnQ6IHNs YXZlIFNRTCB0aHJl
YWQNCndhcyANCmtpbGxlZA0KMDkxMjIzICA4OjA3OjM3IFtOb3RlXSBTbGF2 ZSBTUUwgdGhyZWFk
IGluaXRpYWxpemVkLCBzdGFydGluZw0KcmVwbGljYXRpb24gaW4gDQpsb2cg J0ZJUlNUJyBhdCBw
b3NpdGlvbiAwLCByZWxheSBsb2cNCicvdmFyL2xpYi9teXNxbC9teXNxbC1y ZWxheS1iaW4uMDAw
MDAxJyANCnBvc2l0aW9uOiA0DQowOTEyMjMgIDg6MDc6MzcgW0VSUk9SXSBT bGF2ZSBJL08gdGhy
ZWFkOiBlcnJvciBjb25uZWN0aW5nIHRvIG1hc3RlciANCid0ZXN0QDIwMS4x MDcuMjM2Ljc3OjMz
MDYnOiBFcnJvcjogJ0FjY2VzcyBkZW5pZWQgZm9yIHVzZXIgDQondGVzdCdA J2lwLTk3LTc0LTg1
LTQyLmlwLnNlY3VyZXNlcnZlci5uZXQnICh1c2luZyBwYXNzd29yZDogWUVT KScNCmVycm5vOiAN
CjEwNDUgIHJldHJ5LXRpbWU6IDYwICByZXRyaWVzOiA4NjQwMA0KMDkxMjIz ICA4OjEyOjU5IFtO
b3RlXSBTbGF2ZSBJL08gdGhyZWFkIGtpbGxlZCB3aGlsZSBjb25uZWN0aW5n IHRvDQptYXN0ZXIN
CjA5MTIyMyAgODoxMjo1OSBbTm90ZV0gU2xhdmUgSS9PIHRocmVhZCBleGl0 aW5nLCByZWFkIHVw
IHRvIGxvZyAnRklSU1QnLA0KDQpwb3NpdGlvbiA0DQowOTEyMjMgIDg6MTI6 NTkgW05vdGVdIEVy
cm9yIHJlYWRpbmcgcmVsYXkgbG9nIGV2ZW50OiBzbGF2ZSBTUUwgdGhyZWFk DQp3YXMgDQpraWxs
ZWQNCjA5MTIyMyAgODoxMzoxMiBbTm90ZV0gU2xhdmUgU1FMIHRocmVhZCBp bml0aWFsaXplZCwg
c3RhcnRpbmcNCnJlcGxpY2F0aW9uIGluIA0KbG9nICdpcC0yMDgtMTA5LTIz OC03Ni1iaW4uMDAw
MDQxJyBhdCBwb3NpdGlvbiAxNzQ5MjUsIHJlbGF5IGxvZyANCicvdmFyL2xp Yi9teXNxbC9teXNx
bC1yZWxheS1iaW4uMDAwMDAxJyBwb3NpdGlvbjogNA0KMDkxMjIzICA4OjEz OjEyIFtFUlJPUl0g
U2xhdmUgSS9PIHRocmVhZDogZXJyb3IgY29ubmVjdGluZyB0byBtYXN0ZXIg DQoncm9vdEAyMDEu
MTA3LjIzNi43NzozMzA2JzogRXJyb3I6ICdBY2Nlc3MgZGVuaWVkIGZvciB1 c2VyIA0KJ3Jvb3Qn
QCdpcC05Ny03NC04NS00Mi5pcC5zZWN1cmVzZXJ2ZXIubmV0JyAodXNpbmcg cGFzc3dvcmQ6IFlF
UyknDQplcnJubzogDQoxMDQ1ICByZXRyeS10aW1lOiA2MCAgcmV0cmllczog ODY0MDANCjA5MTIy
MyAgODoxNToxOSBbTm90ZV0gU2xhdmUgSS9PIHRocmVhZCBraWxsZWQgd2hp bGUgY29ubmVjdGlu
ZyB0bw0KbWFzdGVyDQowOTEyMjMgIDg6MTU6MTkgW05vdGVdIFNsYXZlIEkv TyB0aHJlYWQgZXhp
dGluZywgcmVhZCB1cCB0byBsb2cgDQonaXAtMjA4LTEwOS0yMzgtNzYtYmlu LjAwMDA0MScsIHBv
c2l0aW9uIDE3NDkyNQ0KMDkxMjIzICA4OjE1OjE5IFtOb3RlXSBFcnJvciBy ZWFkaW5nIHJlbGF5
IGxvZyBldmVudDogc2xhdmUgU1FMIHRocmVhZA0Kd2FzIA0Ka2lsbGVkDQow OTEyMjMgMjM6MTk6
MjQgW05vdGVdIC91c3Ivc2Jpbi9teXNxbGQ6IE5vcm1hbCBzaHV0ZG93bg0K DQowOTEyMjMgMjM6
MTk6MjQgIElubm9EQjogU3RhcnRpbmcgc2h1dGRvd24uLi4NCjA5MTIyMyAy MzoxOToyNyAgSW5u
b0RCOiBTaHV0ZG93biBjb21wbGV0ZWQ7IGxvZyBzZXF1ZW5jZSBudW1iZXIg MA0KNDA3ODQ1NTQy
DQowOTEyMjMgMjM6MTk6MjcgW05vdGVdIC91c3Ivc2Jpbi9teXNxbGQ6IFNo dXRkb3duIGNvbXBs
ZXRlDQoNCjA5MTIyMyAyMzoyMDoyNSBbV2FybmluZ10gTm8gYXJndW1lbnQg d2FzIHByb3ZpZGVk
IHRvIC0tbG9nLWJpbiwgDQphbmQgLS1sb2ctYmluLWluZGV4IHdhcyBub3Qg dXNlZDsgc28gcmVw
bGljYXRpb24gbWF5IGJyZWFrIHdoZW4gdGhpcw0KTXlTUUwgDQpzZXJ2ZXIg YWN0cyBhcyBhIG1h
c3RlciBhbmQgaGFzIGhpcyBob3N0bmFtZSBjaGFuZ2VkISEgUGxlYXNlIHVz ZSANCictLWxvZy1i
aW49aXAtOTctNzQtODUtNDItYmluJyB0byBhdm9pZCB0aGlzIHByb2JsZW0u DQowOTEyMjMgMjM6
MjA6MjUgIElubm9EQjogU3RhcnRlZDsgbG9nIHNlcXVlbmNlIG51bWJlciAw IDQwNzg0NTU0Mg0K
MDkxMjIzIDIzOjIwOjI1IFtOb3RlXSAvdXNyL3NiaW4vbXlzcWxkOiByZWFk eSBmb3IgY29ubmVj
dGlvbnMuDQpWZXJzaW9uOiAnNS4wLjg1LWNvbW11bml0eS1sb2cnICBzb2Nr ZXQ6ICcvdmFyL2xp
Yi9teXNxbC9teXNxbC5zb2NrJw0KcG9ydDogDQozMzA2ICBNeVNRTCBDb21t dW5pdHkgRWRpdGlv
biAoR1BMKQ0KMDkxMjIzIDIzOjIwOjMxIFtOb3RlXSAvdXNyL3NiaW4vbXlz cWxkOiBOb3JtYWwg
c2h1dGRvd24NCg0KMDkxMjIzIDIzOjIwOjMxICBJbm5vREI6IFN0YXJ0aW5n IHNodXRkb3duLi4u
DQowOTEyMjMgMjM6MjA6MzIgIElubm9EQjogU2h1dGRvd24gY29tcGxldGVk OyBsb2cgc2VxdWVu
Y2UgbnVtYmVyIDANCjQwNzg0NTU0Mg0KMDkxMjIzIDIzOjIwOjMyIFtOb3Rl XSAvdXNyL3NiaW4v
bXlzcWxkOiBTaHV0ZG93biBjb21wbGV0ZQ0KDQowOTEyMjMgMjM6MjA6Mzcg W1dhcm5pbmddIE5v
IGFyZ3VtZW50IHdhcyBwcm92aWRlZCB0byAtLWxvZy1iaW4sIA0KYW5kIC0t bG9nLWJpbi1pbmRl
eCB3YXMgbm90IHVzZWQ7IHNvIHJlcGxpY2F0aW9uIG1heSBicmVhayB3aGVu IHRoaXMNCk15U1FM
IA0Kc2VydmVyIGFjdHMgYXMgYSBtYXN0ZXIgYW5kIGhhcyBoaXMgaG9zdG5h bWUgY2hhbmdlZCEh
IFBsZWFzZSB1c2UgDQonLS1sb2ctYmluPWlwLTk3LTc0LTg1LTQyLWJpbicg dG8gYXZvaWQgdGhp
cyBwcm9ibGVtLg0KMDkxMjIzIDIzOjIwOjM3ICBJbm5vREI6IFN0YXJ0ZWQ7 IGxvZyBzZXF1ZW5j
ZSBudW1iZXIgMCA0MDc4NDU1NDINCjA5MTIyMyAyMzoyMDozNyBbTm90ZV0g L3Vzci9zYmluL215
c3FsZDogcmVhZHkgZm9yIGNvbm5lY3Rpb25zLg0KVmVyc2lvbjogJzUuMC44 NS1jb21tdW5pdHkt
bG9nJyAgc29ja2V0OiAnL3Zhci9saWIvbXlzcWwvbXlzcWwuc29jaycNCnBv cnQ6IA0KMzMwNiAg
TXlTUUwgQ29tbXVuaXR5IEVkaXRpb24gKEdQTCkNCjA5MTIyMyAyMzo1NToy MCBbV2FybmluZ10g
TmVpdGhlciAtLXJlbGF5LWxvZyBub3IgLS1yZWxheS1sb2ctaW5kZXggd2Vy ZQ0KDQp1c2VkOyBz
byByZXBsaWNhdGlvbiBtYXkgYnJlYWsgd2hlbiB0aGlzIE15U1FMIHNlcnZl ciBhY3RzIGFzIGEg
c2xhdmUNCmFuZCANCmhhcyBoaXMgaG9zdG5hbWUgY2hhbmdlZCEhIFBsZWFz ZSB1c2UNCictLXJl
bGF5LWxvZz1pcC05Ny03NC04NS00Mi1yZWxheS1iaW4nIA0KdG8gYXZvaWQg dGhpcyBwcm9ibGVt
Lg0KMDkxMjI0ICAwOjAwOjE2IFtOb3RlXSBTbGF2ZSBTUUwgdGhyZWFkIGlu aXRpYWxpemVkLCBz
dGFydGluZw0KcmVwbGljYXRpb24gaW4gDQpsb2cgJ2lwLTIwOC0xMDktMjM4 LTc2LWJpbi4wMDAw
NDInIGF0IHBvc2l0aW9uIDQ0MzYsIHJlbGF5IGxvZyANCicuL2lwLTk3LTc0 LTg1LTQyLXJlbGF5
LWJpbi4wMDAwMDEnIHBvc2l0aW9uOiA0DQowOTEyMjQgIDA6MDA6MTYgW0VS Uk9SXSBTbGF2ZSBJ
L08gdGhyZWFkOiBlcnJvciBjb25uZWN0aW5nIHRvIG1hc3RlciANCidyb290 QDIwMS4xMDcuMjM2
Ljc3OjMzMDYnOiBFcnJvcjogJ0FjY2VzcyBkZW5pZWQgZm9yIHVzZXIgDQon cm9vdCdAJ2lwLTk3
LTc0LTg1LTQyLmlwLnNlY3VyZXNlcnZlci5uZXQnICh1c2luZyBwYXNzd29y ZDogWUVTKScNCmVy
cm5vOiANCjEwNDUgIHJldHJ5LXRpbWU6IDYwICByZXRyaWVzOiA4NjQwMA0K MDkxMjI0ICAxOjA0
OjQ4IFtOb3RlXSBTbGF2ZSBJL08gdGhyZWFkIGtpbGxlZCB3aGlsZSBjb25u ZWN0aW5nIHRvDQpt
YXN0ZXINCjA5MTIyNCAgMTowNDo0OCBbTm90ZV0gU2xhdmUgSS9PIHRocmVh ZCBleGl0aW5nLCBy
ZWFkIHVwIHRvIGxvZyANCidpcC0yMDgtMTA5LTIzOC03Ni1iaW4uMDAwMDQy JywgcG9zaXRpb24g
NDQzNg0KMDkxMjI0ICAxOjA0OjQ4IFtOb3RlXSBFcnJvciByZWFkaW5nIHJl bGF5IGxvZyBldmVu
dDogc2xhdmUgU1FMIHRocmVhZA0Kd2FzIA0Ka2lsbGVkDQowOTEyMjQgIDE6 MDc6NTkgW05vdGVd
IFNsYXZlIFNRTCB0aHJlYWQgaW5pdGlhbGl6ZWQsIHN0YXJ0aW5nDQpyZXBs aWNhdGlvbiBpbiAN
CmxvZyAnaXAtMjA4LTEwOS0yMzgtNzYtYmluLjAwMDA0MicgYXQgcG9zaXRp b24gNDcwMiwgcmVs
YXkgbG9nIA0KJy4vaXAtOTctNzQtODUtNDItcmVsYXktYmluLjAwMDAwMScg cG9zaXRpb246IDQN
CjA5MTIyNCAgMTowNzo1OSBbRVJST1JdIFNsYXZlIEkvTyB0aHJlYWQ6IGVy cm9yIGNvbm5lY3Rp
bmcgdG8gbWFzdGVyIA0KJ3Jvb3RAMjAxLjEwNy4yMzYuNzc6MzMwNic6IEVy cm9yOiAnQWNjZXNz
IGRlbmllZCBmb3IgdXNlciANCidyb290J0AnaXAtOTctNzQtODUtNDIuaXAu c2VjdXJlc2VydmVy
Lm5ldCcgKHVzaW5nIHBhc3N3b3JkOiBZRVMpJw0KZXJybm86IA0KMTA0NSAg cmV0cnktdGltZTog
NjAgIHJldHJpZXM6IDg2NDAwDQoNCg0KDQpUaGFua3MNCkplZXRlbmRyYSBS YW5qYW4NCg0KLS0t
LS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLSANCkZyb206ICJTaGFubXVnYW0s IERoYW5kYXBhbmki
IDxkaGFuZGFwYW5pLnNoYW5tdWdhbUBlZHMuY29tPg0KVG86ICJKZWV0ZW5k cmEgUmFuamFuIiA8
amVldGVuZHJhLnJhbmphbkBzYW1wYXR0aS5jb20+OyAiUGFyaWtoLCBEaWxp cCANCkt1bWFyIiA8
ZGlsaXBrdW1hci5wYXJpa2hAZWRzLmNvbT47IDxteXNxbEBsaXN0cy5teXNx bC5jb20+DQpTZW50
OiBUaHVyc2RheSwgRGVjZW1iZXIgMjQsIDIwMDkgMjoxNSBQTQ0KU3ViamVj dDogUkU6IFNsYXZl
IGlzIG5vdCB1cGRhdGVkDQoNCg0KPg0KPg0KPiBKZWV0ZW5kcmEsDQo+DQo+ IENhbiB5b3UgcGFz
dGUgdGhlIGVycm9yIGxvZyBoZXJlLg0KPg0KPiAtRA0KPg0KPiAtLS0tLU9y aWdpbmFsIE1lc3Nh
Z2UtLS0tLQ0KPiBGcm9tOiBKZWV0ZW5kcmEgUmFuamFuIFttYWlsdG86amVl dGVuZHJhLnJhbmph
bkBzYW1wYXR0aS5jb21dDQo+IFNlbnQ6IFRodXJzZGF5LCBEZWNlbWJlciAy NCwgMjAwOSAxOjQ5
IFBNDQo+IFRvOiBQYXJpa2gsIERpbGlwIEt1bWFyOyBteXNxbEBsaXN0cy5t eXNxbC5jb20NCj4g
U3ViamVjdDogUmU6IFNsYXZlIGlzIG5vdCB1cGRhdGVkDQo+DQo+IEhpIERp bGlwLA0KPg0KPiBU
aGFua3MgZm9yIHlvdXIgcmVzcG9uc2UNCj4NCj4gSSBhbHJlYWR5IHJ1biB0 aGUgYmVsb3cgY29t
bWFuZCBhdCBtYXN0ZXI6DQo+DQo+IGdyYW50IHJlcGxpY2F0aW9uIHNsYXZl IG9uICouKiB0byAn
bXlzcWxhZG0nQCc5NS44NC44Ni40MScgaWRlbnRpZmllZA0KYnkNCj4gJ2Fk bW15c3FsJzsNCj4N
Cj4NCj4gVGhhbmtzDQo+IEplZXRlbmRyYSBSYW5qYW4NCj4NCj4NCj4gLS0t LS0gT3JpZ2luYWwg
TWVzc2FnZSAtLS0tLSANCj4gRnJvbTogIlBhcmlraCwgRGlsaXAgS3VtYXIi IDxkaWxpcGt1bWFy
LnBhcmlraEBlZHMuY29tPg0KPiBUbzogIkplZXRlbmRyYSBSYW5qYW4iIDxq ZWV0ZW5kcmEucmFu
amFuQHNhbXBhdHRpLmNvbT47DQo+IDxteXNxbEBsaXN0cy5teXNxbC5jb20+ DQo+IFNlbnQ6IFRo
dXJzZGF5LCBEZWNlbWJlciAyNCwgMjAwOSAxOjEwIFBNDQo+IFN1YmplY3Q6 IFJFOiBTbGF2ZSBp
cyBub3QgdXBkYXRlZA0KPg0KPg0KPj4gWW91IGNhbiBzZWUgY29ubmVjdGlu ZyB0byBtYXN0ZXIg
bWVhbnMgaXQgaXMgbm90IGFibGUgdG8gZXN0YWJsaXNoDQp0aGUNCj4+IGNv bm5lY3Rpb24gZnJv
bSBzbGF2ZSB0byBtYXN0ZXIsIGdpdmUgdGhlIGdyYW50cyBhcyAocmVwbGlj YXRpb24NCj4gY2xp
ZW50DQo+PiBldGMuLikNCj4+IGFuZCB0aGVuIHRyeSBhZ2Fpbi4NCj4+DQo+ PiBUaGFua3MsDQo+
PiBEaWxpcGt1bWFyDQo+PiBEYXRhYmFzZSBFbmdpbmVlcmluZw0KPj4gUGFn ZXIgbWFpbDo5ODg0
NDMwOTk4QG5tYS52b2RhZm9uZS5pbg0KPj4NCj4+IC0tLS0tT3JpZ2luYWwg TWVzc2FnZS0tLS0t
DQo+PiBGcm9tOiBKZWV0ZW5kcmEgUmFuamFuIFttYWlsdG86amVldGVuZHJh LnJhbmphbkBzYW1w
YXR0aS5jb21dDQo+PiBTZW50OiBUaHVyc2RheSwgRGVjZW1iZXIgMjQsIDIw MDkgMTowNSBQTQ0K
Pj4gVG86IG15c3FsQGxpc3RzLm15c3FsLmNvbQ0KPj4gU3ViamVjdDogU2xh dmUgaXMgbm90IHVw
ZGF0ZWQNCj4+DQo+PiBIaSwNCj4+DQo+PiBJIGFtIGdldHRpbmcgdGhpcyBp bmZvcm1hdGlvbiBm
cm9tIHNsYXZlDQo+Pg0KPj4gbXlzcWw+IHNob3cgc2xhdmUgc3RhdHVzIFxH Ow0KPj4gKioqKioq
KioqKioqKioqKioqKioqKioqKioqIDEuIHJvdyAqKioqKioqKioqKioqKioq KioqKioqKioqKioN
Cj4+ICAgICAgICAgICAgIFNsYXZlX0lPX1N0YXRlOiBDb25uZWN0aW5nIHRv IG1hc3Rlcg0KPj4g
ICAgICAgICAgICAgICAgTWFzdGVyX0hvc3Q6IDIwMS4xMDcuMjM2Ljc3DQo+ PiAgICAgICAgICAg
ICAgICBNYXN0ZXJfVXNlcjogcm9vdA0KPj4gICAgICAgICAgICAgICAgTWFz dGVyX1BvcnQ6IDMz
MDYNCj4+ICAgICAgICAgICAgICBDb25uZWN0X1JldHJ5OiA2MA0KPj4gICAg ICAgICAgICBNYXN0
ZXJfTG9nX0ZpbGU6IGlwLTIwMS0xMDctMjM2LTc3LWJpbi4wMDAwNDINCj4+ ICAgICAgICBSZWFk
X01hc3Rlcl9Mb2dfUG9zOiA0NzAyDQo+PiAgICAgICAgICAgICBSZWxheV9M b2dfRmlsZTogaXAt
OTUtODQtODYtNDEtcmVsYXktYmluLjAwMDAwMQ0KPj4gICAgICAgICAgICAg IFJlbGF5X0xvZ19Q
b3M6IDk4DQo+PiAgICAgIFJlbGF5X01hc3Rlcl9Mb2dfRmlsZTogaXAtMjAx LTEwNy0yMzYtNzct
YmluLjAwMDA0Mg0KPj4gICAgICAgICAgIFNsYXZlX0lPX1J1bm5pbmc6IE5v DQo+PiAgICAgICAg
ICBTbGF2ZV9JT19SdW5uaW5nOiBZZXMNCj4+ICAgICAgICAgICAgUmVwbGlj YXRlX0RvX0RCOg0K
Pj4gICAgICAgIFJlcGxpY2F0ZV9JZ25vcmVfREI6DQo+PiAgICAgICAgIFJl cGxpY2F0ZV9Eb19U
YWJsZToNCj4+ICAgICBSZXBsaWNhdGVfSWdub3JlX1RhYmxlOg0KPj4gICAg UmVwbGljYXRlX1dp
bGRfRG9fVGFibGU6DQo+PiBSZXBsaWNhdGVfV2lsZF9JZ25vcmVfVGFibGU6 DQo+PiAgICAgICAg
ICAgICAgICAgTGFzdF9FcnJubzogMA0KPj4gICAgICAgICAgICAgICAgIExh c3RfRXJyb3I6DQo+
PiAgICAgICAgICAgICAgIFNraXBfQ291bnRlcjogMA0KPj4gICAgICAgIEV4 ZWNfTWFzdGVyX0xv
Z19Qb3M6IDQ3MDINCj4+ICAgICAgICAgICAgUmVsYXlfTG9nX1NwYWNlOiA5 OA0KPj4gICAgICAg
ICAgICBVbnRpbF9Db25kaXRpb246IE5vbmUNCj4+ICAgICAgICAgICAgIFVu dGlsX0xvZ19GaWxl
Og0KPj4gICAgICAgICAgICAgIFVudGlsX0xvZ19Qb3M6IDANCj4+ICAgICAg ICAgTWFzdGVyX1NT
TF9BbGxvd2VkOiBObw0KPj4gICAgICAgICBNYXN0ZXJfU1NMX0NBX0ZpbGU6 DQo+PiAgICAgICAg
IE1hc3Rlcl9TU0xfQ0FfUGF0aDoNCj4+ICAgICAgICAgICAgTWFzdGVyX1NT TF9DZXJ0Og0KPj4g
ICAgICAgICAgTWFzdGVyX1NTTF9DaXBoZXI6DQo+PiAgICAgICAgICAgICBN YXN0ZXJfU1NMX0tl
eToNCj4+ICAgICAgU2Vjb25kc19CZWhpbmRfTWFzdGVyOiBOVUxMDQo+Pg0K Pj4NCj4+IFRoZSBT
bGF2ZV9JT19SdW5uaW5nIGlzIGFsd2F5cyBObyBldmVuIGFmdGVyIHJlcGVh dGluZyBiZWxvdyBz
dGVwcyBzbw0KPj4gbWFueSB0aW1lcw0KPj4NCj4+IHN0b3Agc2xhdmUNCj4+ DQo+PiBDSEFOR0Ug
TUFTVEVSIFRPIC4uLi4NCj4+DQo+PiBhbmQNCj4+DQo+PiBzdGFydCBzbGF2 ZQ0KPj4NCj4+DQo+
Pg0KPj4gUGxlYXNlIGd1aWRlIHdoeSB0aGlzIGlzIGFsd2F5cyBOTyBhbmQg aG93IGRvIGkgZW5h
YmxlIGl0ID8NCj4+DQo+PiBSZWdhcmRzDQo+PiBKZWV0ZW5kcmEgUmFuamFu DQo+DQo+DQo+IC0t
IA0KPiBNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KPiBGb3IgbGlzdCBh cmNoaXZlczogaHR0
cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbA0KPiBUbyB1bnN1YnNjcmliZToN Cj4gaHR0cDovL2xp
c3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1kaGFuZGFwYW5pLnNoYW5tdWdh bUBlZHMuY29tIA0K
DQoNCi0tIA0KTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExpc3QNCkZvciBsaXN0 IGFyY2hpdmVzOiBo
dHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQpUbyB1bnN1YnNjcmliZTog ICAgaHR0cDovL2xp
c3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1kaGFuZGFwYW5pLnNoYW5tdWdh bUBlZHMuY29tDQoN
Cg==
RE: Slave is not updated
am 24.12.2009 10:27:36 von dhandapani.shanmugam
Jeetendra,
just update the username as root on the below query
select * from mysql.user where user=3D'replication'\G;
=3DD
-----Original Message-----
From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]=20
Sent: Thursday, December 24, 2009 2:52 PM
To: Jeetendra Ranjan; mysql@lists.mysql.com
Subject: RE: Slave is not updated
User is not the replication it is 'root' (or) mysqladm
Thanks,
Dilipkumar
Database Engineering
+ mailto: dilipkumar.parikh@eds.com
Pager mail:9884430998@nma.vodafone.in
-----Original Message-----
From: Shanmugam, Dhandapani=20
Sent: Thursday, December 24, 2009 2:48 PM
To: Parikh, Dilip Kumar; Jeetendra Ranjan; mysql@lists.mysql.com
Subject: RE: Slave is not updated
by the way did you flush the privileges on the master? What is the
output you get, when you log in as root user on the mysql master server
and issue the below command:
select * from mysql.user where user=3D'replication'\G;
-D
-----Original Message-----
From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]=20
Sent: Thursday, December 24, 2009 2:43 PM
To: Jeetendra Ranjan; mysql@lists.mysql.com
Subject: RE: Slave is not updated
You can see in the logs, access denied So give trying for hostname or
with full domain or=20
Grant replication slave on *.* to 'mysqladm'@'95.%' identified by
'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname
identified by 'xxxxxx'; Flush privileges;
it should work.
Thanks,
Dilipkumar
Database Engineering
mailto: dilipkumar.parikh@eds.com
Pager mail:9884430998@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]=20
Sent: Thursday, December 24, 2009 2:31 PM
To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
Subject: Re: Slave is not updated
091223 5:55:22 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 4
091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 6:58:30 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 98
091223 6:58:30 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 7:03:38 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000002'=20
position: 98
091223 7:03:38 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 7:03:52 [Warning] No argument was provided to --log-bin,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
3306 MySQL Community Edition (GPL)
091223 7:03:52 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000003'=20
position: 98
091223 7:03:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
1045 retry-time: 60 retries: 86400
091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does
not=20
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-troubleshootin g.html
091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Lost connection to MySQL server at=20
'reading initial communication packet', system error: 111' errno: 2013=20
retry-time: 60 retries: 86400
091223 7:31:52 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 7:46:28 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 17907, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:46:28 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 17907
091223 7:47:20 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091223 7:47:40 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 17906, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 7:47:40 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 17906
091223 8:07:20 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091223 8:07:37 [Note] Slave SQL thread initialized, starting
replication in=20
log 'FIRST' at position 0, relay log
'/var/lib/mysql/mysql-relay-bin.000001'=20
position: 4
091223 8:07:37 [ERROR] Slave I/O thread: error connecting to master=20
'test@201.107.236.77:3306': Error: 'Access denied for user=20
'test'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
killed
091223 8:13:12 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000041' at position 174925, relay log=20
'/var/lib/mysql/mysql-relay-bin.000001' position: 4
091223 8:13:12 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000041', position 174925
091223 8:15:19 [Note] Error reading relay log event: slave SQL thread
was=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
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,=20
and --log-bin-index was not used; so replication may break when this
MySQL=20
server acts as a master and has his hostname changed!! Please use=20
'--log-bin=3Dip-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:=20
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=20
has his hostname changed!! Please use
'--relay-log=3Dip-97-74-85-42-relay-bin'=20
to avoid this problem.
091224 0:00:16 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000042' at position 4436, relay log=20
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
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=20
'ip-208-109-238-76-bin.000042', position 4436
091224 1:04:48 [Note] Error reading relay log event: slave SQL thread
was=20
killed
091224 1:07:59 [Note] Slave SQL thread initialized, starting
replication in=20
log 'ip-208-109-238-76-bin.000042' at position 4702, relay log=20
'./ip-97-74-85-42-relay-bin.000001' position: 4
091224 1:07:59 [ERROR] Slave I/O thread: error connecting to master=20
'root@201.107.236.77:3306': Error: 'Access denied for user=20
'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)'
errno:=20
1045 retry-time: 60 retries: 86400
Thanks
Jeetendra Ranjan
----- Original Message -----=20
From: "Shanmugam, Dhandapani"
To: "Jeetendra Ranjan" ; "Parikh, Dilip=20
Kumar" ;
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.ranjan@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 -----=20
> From: "Parikh, Dilip Kumar"
> To: "Jeetendra Ranjan" ;
>
> 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:9884430998@nma.vodafone.in
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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
>
>
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Ddhandapani.shanmugam@ed s.com=20
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Ddhandapani.shanmugam@ed s.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Re: Slave is not updated
am 24.12.2009 10:31:49 von jeetendra.ranjan
Here is the action i performed:
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO
'xxxxxx'@'xx.xx.xx.xx' IDENTIFIED BY 'xxxxxxxx';
Query OK, 0 rows affected (0.00 sec)
mysql> Flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from mysql.user where user='adconsent' \G;
*************************** 1. row ***************************
Host: xx.xx.xx.xx
User: xxxxxxx
Password: *02BF3AAD3EDAAD0A1C45A98092B24BDC96172E16
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: Y
Repl_client_priv: Y
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
1 row in set (0.00 sec)
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: xx.xx.xx.xx.
Master_User: xxxxx
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042
Read_Master_Log_Pos: 7220
Relay_Log_File: ip-xx-xx-xx-xx-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042
Slave_IO_Running: No
Slave_SQL_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: 7220
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
Thanks
Jeetendra Ranjan
----- Original Message -----
From: "Shanmugam, Dhandapani"
To: "Parikh, Dilip Kumar" ; "Jeetendra Ranjan"
;
Sent: Thursday, December 24, 2009 2:47 PM
Subject: RE: Slave is not updated
>
> by the way did you flush the privileges on the master? What is the
> output you get, when you log in as root user on the mysql master server
> and issue the below command:
>
> select * from mysql.user where user='replication'\G;
>
> -D
>
> -----Original Message-----
> From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]
> Sent: Thursday, December 24, 2009 2:43 PM
> To: Jeetendra Ranjan; mysql@lists.mysql.com
> Subject: RE: Slave is not updated
>
> You can see in the logs, access denied So give trying for hostname or
> with full domain or
>
> Grant replication slave on *.* to 'mysqladm'@'95.%' identified by
> 'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname
> identified by 'xxxxxx'; Flush privileges;
>
> it should work.
>
> Thanks,
> Dilipkumar
> Database Engineering
> mailto: dilipkumar.parikh@eds.com
> Pager mail:9884430998@nma.vodafone.in
>
>
> -----Original Message-----
> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]
> Sent: Thursday, December 24, 2009 2:31 PM
> To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
> Subject: Re: Slave is not updated
>
> 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
> 'root@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
> 'root@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
> 'root@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
> 'root@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-troubleshootin g.html
> 091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master
> 'root@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
> 'root@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
> 'root@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
> 'root@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
> 'test@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
> 'root@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
> 'root@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
> 'root@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"
> To: "Jeetendra Ranjan" ; "Parikh, Dilip
> Kumar" ;
> 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.ranjan@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"
>> To: "Jeetendra Ranjan" ;
>>
>> 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:9884430998@nma.vodafone.in
>>>
>>> -----Original Message-----
>>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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.shanmugam@eds. com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds. com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: Slave is not updated
am 24.12.2009 10:33:16 von jeetendra.ranjan
Please ignore the user name and ip. i am passing the right information here
----- Original Message -----
From: "Parikh, Dilip Kumar"
To: "Jeetendra Ranjan" ;
Sent: Thursday, December 24, 2009 2:51 PM
Subject: RE: Slave is not updated
>
> User is not the replication it is 'root' (or) mysqladm
>
> Thanks,
> Dilipkumar
> Database Engineering
> ï« mailto: dilipkumar.parikh@eds.com
> Pager mail:9884430998@nma.vodafone.in
>
>
> -----Original Message-----
> From: Shanmugam, Dhandapani
> Sent: Thursday, December 24, 2009 2:48 PM
> To: Parikh, Dilip Kumar; Jeetendra Ranjan; mysql@lists.mysql.com
> Subject: RE: Slave is not updated
>
>
> by the way did you flush the privileges on the master? What is the output
> you get, when you log in as root user on the mysql master server and issue
> the below command:
>
> select * from mysql.user where user='replication'\G;
>
> -D
>
> -----Original Message-----
> From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]
> Sent: Thursday, December 24, 2009 2:43 PM
> To: Jeetendra Ranjan; mysql@lists.mysql.com
> Subject: RE: Slave is not updated
>
> You can see in the logs, access denied So give trying for hostname or with
> full domain or
>
> Grant replication slave on *.* to 'mysqladm'@'95.%' identified by
> 'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname
> identified by 'xxxxxx'; Flush privileges;
>
> it should work.
>
> Thanks,
> Dilipkumar
> Database Engineering
> mailto: dilipkumar.parikh@eds.com
> Pager mail:9884430998@nma.vodafone.in
>
>
> -----Original Message-----
> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]
> Sent: Thursday, December 24, 2009 2:31 PM
> To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
> Subject: Re: Slave is not updated
>
> 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
> 'root@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
> 'root@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
> 'root@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
> 'root@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-troubleshootin g.html
> 091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master
> 'root@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
> 'root@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
> 'root@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
> 'root@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
> 'test@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
> 'root@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
> 'root@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
> 'root@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"
> To: "Jeetendra Ranjan" ; "Parikh, Dilip
> Kumar" ;
> 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.ranjan@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"
>> To: "Jeetendra Ranjan" ;
>>
>> 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:9884430998@nma.vodafone.in
>>>
>>> -----Original Message-----
>>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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.shanmugam@eds. com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds. com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: Slave is not updated
am 24.12.2009 10:34:13 von Nagaraj S
--0016e64692ae671af7047b76245a
Content-Type: text/plain; charset=ISO-8859-1
who is 'adconsent' ??. what is your replication user
-naga
On Thu, Dec 24, 2009 at 3:01 PM, Jeetendra Ranjan <
jeetendra.ranjan@sampatti.com> wrote:
> Here is the action i performed:
>
> mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'xxxxxx'@'xx.xx.xx.xx'
> IDENTIFIED BY 'xxxxxxxx';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> Flush privileges;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> select * from mysql.user where user='adconsent' \G;
> *************************** 1. row ***************************
> Host: xx.xx.xx.xx
> User: xxxxxxx
> Password: *02BF3AAD3EDAAD0A1C45A98092B24BDC96172E16
> Select_priv: N
> Insert_priv: N
> Update_priv: N
> Delete_priv: N
> Create_priv: N
> Drop_priv: N
> Reload_priv: N
> Shutdown_priv: N
> Process_priv: N
> File_priv: N
> Grant_priv: N
> References_priv: N
> Index_priv: N
> Alter_priv: N
> Show_db_priv: N
> Super_priv: N
> Create_tmp_table_priv: N
> Lock_tables_priv: N
> Execute_priv: N
> Repl_slave_priv: Y
> Repl_client_priv: Y
> Create_view_priv: N
> Show_view_priv: N
> Create_routine_priv: N
> Alter_routine_priv: N
> Create_user_priv: N
> Event_priv: N
> Trigger_priv: N
> ssl_type:
> ssl_cipher:
> x509_issuer:
> x509_subject:
> max_questions: 0
> max_updates: 0
> max_connections: 0
> max_user_connections: 0
> 1 row in set (0.00 sec)
>
>
> mysql> show slave status \G;
> *************************** 1. row ***************************
> Slave_IO_State: Connecting to master
> Master_Host: xx.xx.xx.xx.
> Master_User: xxxxx
>
> Master_Port: 3306
> Connect_Retry: 60
> Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042
> Read_Master_Log_Pos: 7220
> Relay_Log_File: ip-xx-xx-xx-xx-relay-bin.000001
> Relay_Log_Pos: 98
> Relay_Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042
> Slave_IO_Running: No
> Slave_SQL_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: 7220
>
> 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
>
>
> Thanks
> Jeetendra Ranjan
> ----- Original Message ----- From: "Shanmugam, Dhandapani" <
> dhandapani.shanmugam@eds.com>
> To: "Parikh, Dilip Kumar" ; "Jeetendra Ranjan"
> ;
> Sent: Thursday, December 24, 2009 2:47 PM
>
> Subject: RE: Slave is not updated
>
>
>
>> by the way did you flush the privileges on the master? What is the
>> output you get, when you log in as root user on the mysql master server
>> and issue the below command:
>>
>> select * from mysql.user where user='replication'\G;
>>
>> -D
>>
>> -----Original Message-----
>> From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]
>> Sent: Thursday, December 24, 2009 2:43 PM
>> To: Jeetendra Ranjan; mysql@lists.mysql.com
>> Subject: RE: Slave is not updated
>>
>> You can see in the logs, access denied So give trying for hostname or
>> with full domain or
>>
>> Grant replication slave on *.* to 'mysqladm'@'95.%' identified by
>> 'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname
>> identified by 'xxxxxx'; Flush privileges;
>>
>> it should work.
>>
>> Thanks,
>> Dilipkumar
>> Database Engineering
>> mailto: dilipkumar.parikh@eds.com
>> Pager mail:9884430998@nma.vodafone.in
>>
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@sampatti.com]
>> Sent: Thursday, December 24, 2009 2:31 PM
>> To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
>> Subject: Re: Slave is not updated
>>
>> 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
>> 'root@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
>> 'root@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
>> 'root@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
>> 'root@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-troubleshootin g.html
>> 091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master
>> 'root@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
>> 'root@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
>> 'root@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
>> 'root@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
>> 'test@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
>> 'root@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
>> 'root@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
>> 'root@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.shanmugam@eds.com>
>> To: "Jeetendra Ranjan" ; "Parikh, Dilip
>> Kumar" ;
>> 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.ranjan@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.parikh@eds.com>
>>> To: "Jeetendra Ranjan" ;
>>>
>>> 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:9884430998@nma.vodafone.in
>>>>
>>>> -----Original Message-----
>>>> From: Jeetendra Ranjan [mailto:jeetendra.ranjan@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.shanmugam@eds. com
>>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds. com
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=nagaraj.chk@gmail.com
>
>
--0016e64692ae671af7047b76245a--