Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.0.38
-
None
-
OS: CentOS release 6.7 (Final)
Application: Node v0.12.12
Description
I have a nodejs application that build a query to update records on my table.
In the binary logs there is a transaction that occurred but in the storage engine (innodb) it did not update.
for example in the binary log, the transaction is like this. but the id with 2 and 3 are not updated in the storage engine(innodb).
BEGIN
UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 1
UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 2
UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 3
UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 4
UPDATE my_table SET status = 1, updated_at = NOW() WHERE id = 5
COMMIT