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]
