I set a master and a slave, master server is a live server, slave server
does't online. but I got 1062 error frenquently, especially when I stop
slave a while and start slave again. following is from my general log:
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',9788534,UNIX_TIMESTAMP(),110252138)
19 Query insert into user_stat
(column_name,user_id,column_value,time,stat_id)
values('visits',8403043,348,NOW(),110252140)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',11839858,UNIX_TIMESTAMP(),110252161)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('comments',11882675,3,110252168)
19 Query delete from user_stat where 1 AND
column_name='last_visit' AND user_id=11839858
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',11839858,UNIX_TIMESTAMP(),110252170)
19 Query delete from user_stat where 1 AND
column_name='last_visit' AND user_id=10731230
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',10731230,UNIX_TIMESTAMP(),110252176)
19 Query insert into user_stat
(column_name,user_id,column_value,time,stat_id)
values('visits',9779846,169,NOW(),110252179)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',8499860,UNIX_TIMESTAMP(),110252181)
19 Query insert into user_stat
(column_name,user_id,column_value,time,stat_id)
values('visits',8314927,19,NOW(),110252185)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',11636653,UNIX_TIMESTAMP(),110252187)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',11865811,UNIX_TIMESTAMP(),110252189)
19 Query delete from user_stat where 1 AND
column_name='last_visit' AND user_id=8499860
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',8499860,UNIX_TIMESTAMP(),110252192)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',10713080,UNIX_TIMESTAMP(),110252193)
19 Query insert into user_stat
(column_name,user_id,column_value,time,stat_id)
values('visits',9477379,490,NOW(),110252194)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',8050753,UNIX_TIMESTAMP(),110252196)
19 Query delete from user_stat where 1 AND
column_name='last_visit' AND user_id=8050753
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',8050753,UNIX_TIMESTAMP(),110252208)
19 Query insert into user_stat
(column_name,user_id,column_value,stat_id)
values('last_visit',10944715,UNIX_TIMESTAMP(),110252209)
in the first line, the slave insert one record with user_id 9788534, the
in last line insert a new record again.
the user_stat's structure is:
CREATE TABLE `user_stat` (
`stat_id` bigint(20) unsigned NOT NULL,
`user_id` mediumint(8) unsigned NOT NULL default '0',
`column_name`
enum('last_visit','profile_photos','albums','photos','journals','friends','comments','visits','mp3s')
NOT NULL default 'last_visit',
`column_value` int(10) unsigned NOT NULL default '0',
`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
PRIMARY KEY (`stat_id`),
UNIQUE KEY `user_column` (`user_id`,`column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
so I got dup error at the last line.
I think something is wrong in the process of binlog replication, like,
the 'delete' sql is discarded. and there are many errors in the error
log like this:
080710 22:41:21 [Warning] Aborted connection 31778 to db: 'data5' user: 'user'
host: '56-1.my.com' (Got an error reading communication packets)
so I want to know: what is happen ? how to resolve it ?
--
Thanks & Regards
Changying Li
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
