SQL Hi!
Does anybody have any solution? I change time where query run. Each new day where query run first ones in day replication crash. "Slave start" on slave server restore replication. How can it be? I have no any ideas. Both servers have 4.0.16 > SQL > Hi all! > > Nearly very night I have this problem. > This query is done every 3 hours. But problem is happened only at 3:00 > Both master and slave are 4 CPU (2 with HTT) computers. > Both have mysql 4.0.16 > And when I test table analit. There are many records which have the same > conditions as in WHERE statement. > This records are inserted into analit before this UPDATE. > UPDATE finds records on master, I have checked the records on master and > I see the result of UPDATE. > But there is the error on slave server. > If I run any query on analit like "select count(*) from analit where > label=1070931600" and after this SLAVE STOP; SLAVE START > problem is solved. > > Is it a bug in server? > Can mysqld break the order of replication query on multy-CPU > computers? > > Any ideas, please. > > +----------------+-------------+-------------+---------------+ > -----------------+---------------------+------------------+---------------+ > -----------------------+------------------+-------------------+ > -----------------+---------------------+------------+ > ----------------------------------------------------- > ----------------------------------------------------- > ----------------------------------------------------- > ----------------------------------------------------- > ----------------------------------------------------- > --------------------------------+--------------+----- > ----------------+-----------------+ > _ Master_Host _ Master_User _ Master_Port _ Connect_retry _ > Master_Log_File _ Read_Master_Log_Pos _ Relay_Log_File _ Relay_Log_Pos _ > Relay_Master_Log_File _ Slave_IO_Running _ Slave_SQL_Running _ > Replicate_do_db _ Replicate_ignore_db _ Last_errno _ > Last_error > > > > > _ > Skip_counter _ Exec_master_log_pos _ Relay_log_space _ > +----------------+-------------+-------------+---------------+ > -----------------+---------------------+------------------+---------------+ > -----------------------+------------------+-------------------+ > -----------------+---------------------+------------+ > ----------------------------------------------------- > ----------------------------------------------------- > ----------------------------------------------------- > ----------------------------------------------------- > ----------------------------------------------------- > --------------------------------+--------------+---------------------+ > -----------------+ > _ XXXXXXXXXXX _ ZZZZZZZZZ _ DDDD _ 60 _ > a0-bin.029 > _ 2210728 _ a1-relay-bin.001 _ 5880071 _ a0-bin.029 > _ Yes _ No _ atas _ > _ 1032 _ > Error 'Can't find record in 'analit'' on query 'UPDATE analit, price_grp > SET analit.status=price_grp.status, analit.currency=price_grp.currency > WHERE analit.price=price_grp.price AND analit.service=price_grp.service > AND analit.city=price_grp.city AND label=1070931600'. > Default database: 'GGGG' _ 0 _ 2210187 _ > 5880612 _ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > Best regards. _______________________________________ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport тел. +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]