From: Jeetendra Ranjan (jeetendra.ranjansampatti.com)
Date: Thu Dec 24 2009 - 03:00:41 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
'root201.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
'root201.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
'root201.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
'root201.107.236.77:3306': Error: 'Access denied for user
'root''ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno:
1045 retry-time: 60 retries: 86400
091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does not
exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master
'root201.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
'root201.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
'root201.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
'root201.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
'test201.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
'root201.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
'root201.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
'root201.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.shanmugameds.com>
To: "Jeetendra Ranjan" <jeetendra.ranjansampatti.com>; "Parikh, Dilip
Kumar" <dilipkumar.parikheds.com>; <mysqllists.mysql.com>
Sent: Thursday, December 24, 2009 2:15 PM
Subject: RE: Slave is not updated

>
>
> Jeetendra,
>
> Can you paste the error log here.
>
> -D
>
> -----Original Message-----
> From: Jeetendra Ranjan [mailto:jeetendra.ranjansampatti.com]
> Sent: Thursday, December 24, 2009 1:49 PM
> To: Parikh, Dilip Kumar; mysqllists.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.parikheds.com>
> To: "Jeetendra Ranjan" <jeetendra.ranjansampatti.com>;
> <mysqllists.mysql.com>
> Sent: Thursday, December 24, 2009 1:10 PM
> Subject: RE: Slave is not updated
>
>
>> You can see connecting to master means it is not able to establish the
>> connection from slave to master, give the grants as (replication
> client
>> etc..)
>> and then try again.
>>
>> Thanks,
>> Dilipkumar
>> Database Engineering
>> Pager mail:9884430998nma.vodafone.in
>>
>> -----Original Message-----
>> From: Jeetendra Ranjan [mailto:jeetendra.ranjansampatti.com]
>> Sent: Thursday, December 24, 2009 1:05 PM
>> To: mysqllists.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.shanmugameds.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]