- 论坛徽章:
- 6
|
我现在有4台机器，有一台是master 其它三台为slave,而其中有一台slave机器上有时间数据不能与master同步，而其它的两台slave是没有问题的！在有问题的那台slave上的部分日志如下：051023 0:00:04 Aborted connection 24799710 to db: 'message' user: 'www' host: `10.0.153.92' (Got an error reading communication packets)
ERROR: 1062 Duplicate entry 'message_11_6_22-22168' for key 1
051023 11:21:47 Slave: Error 'Duplicate entry 'message_11_6_22-22168' for key 1' on query. Default database: 'new_message'. Query: 'insert into viewcount(tbname,thread_seq,viewcount) values('message_11_6_22',22168,1)', Error_code: 1062
051023 11:21:47 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '4a-d02-a6-bin.060' position 78400980
051023 11:48:12 Slave I/O thread killed while reading event
051023 11:48:12 Slave I/O thread exiting, read up to log '4a-d02-a6-bin.060', position 89606383
051023 11:49:30 Slave SQL thread initialized, starting replication in log '4a-d02-a6-bin.061' at position 434, relay log './4a-d02-a8-relay-bin.001' position: 4
051023 11:49:30 Slave I/O thread: connected to master 'slaver@10.0.153.120:3306', replication started in log '4a-d02-a6-bin.061' at position 434
051023 19:55:52 Aborted connection 24898955 to db: 'test' user: 'root' host: `localhost' (Got timeout reading communication packets)
ERROR: 1146 Table 'new_message.message_12_2_448' doesn't exist
051024 11:38:41 Slave: Error 'Table 'new_message.message_12_2_448' doesn't exist' on query. Default database: 'new_message'. Query: 'insert into message_12_2_448 (reply_id,thread_seq,head_reply_seq,u1_flg,show_flg,ip_addr,livedoor_id,livedoor_id_dummy,title,inputdate,body) values ('','2','','5','1','218.224.27.31','rie_kan1','rie_kan1','セクシーヒップ 綺麗なお姉さんは好きですか？','2005-10-24 11:38:41','綺麗なお姉さんは好きですか？rnrn■ エッチなプログ！ 痴女???rn貴方の趣味に合わせた大人の出逢いを??? rnrn【ＵＲＬ】http://www.fry.to/aijinnrn【ＵＲＬ】http://www.fry.to/aijinnrnrnアダルト、エッチな??セックスフレンド募集！rnrnrnrnrnrn99rn')', Error_code: 1146
051024 11:38:41 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '4a-d02-a6-bin.061' position 816165734
051024 11:52:43 Slave I/O thread killed while reading event
051024 11:52:43 Slave I/O thread exiting, read up to log '4a-d02-a6-bin.061', position 827296105
051024 11:59:46 Slave SQL thread initialized, starting replication in log '4a-d02-a6-bin.062' at position 6357, relay log './4a-d02-a8-relay-bin.001' position: 4
051024 11:59:46 Slave I/O thread: connected to master 'slaver@10.0.153.120:3306', replication started in log '4a-d02-a6-bin.062' at position 6357
ERROR: 1146 Table 'new_message.message_1_7_375' doesn't exist
051024 23:09:30 Slave: Error 'Table 'new_message.message_1_7_375' doesn't exist' on query. Default database: 'new_message'. Query: 'insert into message_1_7_375 (reply_id,thread_seq,head_reply_seq,u1_flg,show_flg,ip_addr,livedoor_id,livedoor_id_dummy,title,inputdate,body) values ('','3','','0','1','221.185.42.13','kai102351','kai102351','最高!!','2005-10-24 23:09:28','なDVD販売サイトを紹介します！！rn高画質＆激安なナイスなサイトです！！rnおすすめですので、是非一度ご覧ください！！！rnhttp://www.geocities.jp/katou784159')', Error_code: 1146
051024 23:09:30 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '4a-d02-a6-bin.062' position 377413766
051024 23:16:26 Slave I/O thread killed while reading event
051024 23:16:26 Slave I/O thread exiting, read up to log '4a-d02-a6-bin.062', position 382956271
051024 23:19:01 Slave SQL thread initialized, starting replication in log '4a-d02-a6-bin.063' at position 1710, relay log './4a-d02-a8-relay-bin.001' position: 4
051024 23:19:01 Slave I/O thread: connected to master 'slaver@10.0.153.120:3306', replication started in log '4a-d02-a6-bin.063' at position 1710
051026 0:00:03 Aborted connection 25985650 to db: 'kawase' user: 'www' host: `10.0.153.55' (Got an error reading communication packets)
051026 0:00:06 Aborted connection 25985680 to db: 'message' user: 'www' host: `10.0.153.92' (Got an error reading communication packets)
051027 0:00:00 Aborted connection 26312514 to db: 'kawase' user: 'www' host: `10.0.153.88' (Got an error reading communication packets)
051029 12:01:07 Aborted connection 26951037 to db: 'message' user: 'www' host: `10.0.153.43' (Got an error reading communication packets)
ERROR: 1146 Table 'new_message.message_12_2_448' doesn't exist
051029 13:41:45 Slave: Error 'Table 'new_message.message_12_2_448' doesn't exist' on query. Default database: 'new_message'. Query: 'insert into message_12_2_448 (reply_id,thread_seq,head_reply_seq,u1_flg,show_flg,ip_addr,livedoor_id,livedoor_id_dummy,title,inputdate,body) values ('','3','','0','1','210.146.167.2','cutie_pie55','cutie_pie55','大人の出会い','2005-10-29 13:41:45','素敵な出会いを提供いたします。rn有料？ No！完全無料です！→安心rnサクラ？ No！一切おりません！→確実rn携帯情報？ No!入力の必要ありません！→安全rnフリーアドレス？ Yes！使えます！→さらに安心rn安心?安全?完全無料！！rnあなたの好みの女性に必ず出会えます。rnhttp://sefurex.h.fc2.com/s/rn※美女率No.1です。rnrn')', Error_code: 1146
051029 13:41:45 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '4a-d02-a6-bin.066' position 478567319
051029 14:04:05 Slave I/O thread killed while reading event
051029 14:04:05 Slave I/O thread exiting, read up to log '4a-d02-a6-bin.066', position 489549584
051029 14:16:58 Slave SQL thread initialized, starting replication in log '4a-d02-a6-bin.068' at position 16258, relay log './4a-d02-a8-relay-bin.001' position: 4
051029 14:16:58 Slave I/O thread: connected to master 'slaver@10.0.153.120:3306', replication started in log '4a-d02-a6-bin.068' at position 16258
051030 0:00:03 Aborted connection 27081060 to db: 'new_message' user: 'www' host: `10.0.153.92' (Got an error reading communication packets)
051030 0:00:09 Aborted connection 27081080 to db: 'new_message' user: 'www' host: `10.0.153.92' (Got an error reading communication packets)
ERROR: 1146 Table 'new_message.message_12_2_448' doesn't exist
051101 20:15:16 Slave: Error 'Table 'new_message.message_12_2_448' doesn't exist' on query. Default database: 'new_message'. Query: 'update message_12_2_448 set show_flg=0', Error_code: 1146
051101 20:15:16 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '4a-d02-a6-bin.070' position 453207748
051101 20:33:30 Slave I/O thread killed while reading event
051101 20:33:30 Slave I/O thread exiting, read up to log '4a-d02-a6-bin.070', position 464376613
051101 20:38:24 Slave SQL thread initialized, starting replication in log '4a-d02-a6-bin.071' at position 25357, relay log './4a-d02-a8-relay-bin.001' position: 4
051101 20:38:24 Slave I/O thread: connected to master 'slaver@10.0.153.120:3306', replication started in log '4a-d02-a6-bin.071' at position 25357
请大家帮忙分析是什么原因所造成的？谢谢了！ |
|
免费注册
发表于 2005-11-02 12:50
发表于 2005-11-02 21:38