View Single Post
  #3  
Old 9th September 2010, 16:30
jithinkcs jithinkcs is offline
Junior Member
 
Join Date: Sep 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Mark,

Thanks for responding to my post. I just followed your suggestion and my
DB 1 replicates fine , but DB2 replication failed.

Please help me to solve the issue ?

My Slaves MY SQL log


100909 18:40:43 InnoDB: Started; log sequence number 0 46469
100909 18:40:43 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100909 18:40:43 [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=wins_pc_c33_1-relay-bin' to avoid this problem.
100909 18:40:43 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000002' at position 18598, relay log '.\wins_pc_c33_1-relay-bin.000003' position: 2115
100909 18:40:43 [Note] Slave I/O thread: connected to master 'jith@192.168.0.97:3306',replication started in log 'mysql-bin.000002' at position 18598
100909 18:40:43 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES ','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY',' NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTG RESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTI ONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3 23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_B ACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_AL L_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALI D_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL ','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES ','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY',' NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTG RESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTI ONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3 23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_B ACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_AL L_TABLES','NO_Z
100909 18:40:43 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
100909 18:40:43 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
100909 18:49:50 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
100909 18:49:50 [Note] Slave I/O thread killed while reading event
100909 18:49:50 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000002', position 22095
100909 18:49:50 [Note] Error reading relay log event: slave SQL thread was killed
100909 18:49:55 [Note] wampmysqld: Normal shutdown

100909 18:49:57 [Warning] wampmysqld: Forcing close of thread 3 user: 'root'

100909 18:49:57 InnoDB: Starting shutdown...
100909 18:49:58 InnoDB: Shutdown completed; log sequence number 0 46469
100909 18:49:58 [Note] wampmysqld: Shutdown complete

100909 18:50:01 InnoDB: Started; log sequence number 0 46469
100909 18:50:01 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100909 18:50:01 [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=wins_pc_c33_1-relay-bin' to avoid this problem.
100909 18:50:01 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000002' at position 22095, relay log '.\wins_pc_c33_1-relay-bin.000005' position: 3748
100909 18:50:01 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES ','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY',' NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTG RESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTI ONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3 23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_B ACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_AL L_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALI D_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL ','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES ','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY',' NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTG RESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTI ONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3 23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_B ACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_AL L_TABLES','NO_Z
100909 18:50:01 [Note] Slave I/O thread: connected to master 'jith@192.168.0.97:3306',replication started in log 'mysql-bin.000002' at position 22095
100909 18:50:01 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
100909 18:50:01 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
Reply With Quote