Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.3, 5.5.32, 5.1.67, 5.2.14, 5.3.12
Description
Test case:
--source include/master-slave.inc
|
--source include/have_binlog_format_row.inc
|
|
|
CREATE TABLE t1 (f1 VARCHAR(128), f2 VARCHAR(128), KEY (f2,f1) USING BTREE) ENGINE=MEMORY; |
INSERT INTO t1 VALUES (NULL,'not'),('one',NULL),('two',NULL),('three',''); |
|
|
UPDATE t1 SET f2 = 'new'; |
|
|
--sync_slave_with_master
|
Last_Error Could not execute Update_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 694
|
It's an upstream bug, but it's not reproducible in MySQL 5.6 (5.6.5, 5.6.12), while still reproducible in MariaDB 10.0.4 candidate.
I filed it at bugs.mysql.com, although I don't have much hope that it will be fixed, given that it's not reproducible in 5.6.
Attachments
Issue Links
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to TODO-60 [ TODO-60 ] |
| Link | This issue relates to TODO-224 [ TODO-224 ] |
| Remote Link | This issue links to "Bug #69831 - Replication fails on updating a MEMORY table with an index using btree (Web Link)" [ 11900 ] |
| Assignee | Kristian Nielsen [ knielsen ] |
This bug is not related to replication:
CREATE TABLE t1 (f1 VARCHAR(128), f2 VARCHAR(128), KEY (f2,f1) USING BTREE) ENGINE=MEMORY; |
INSERT INTO t1 VALUES (NULL,'not'), ('one',NULL),('two',NULL),('three',''); |
SELECT * FROM t1 WHERE f1 = 'one' and f2 IS NULL; |
It was fixed in mysql 5.6 in revision: http://bazaar.launchpad.net/~mysql/mysql-server/5.6/revision/2876.449.1
| Fix Version/s | 5.5.34 [ 13500 ] | |
| Fix Version/s | 5.5.33 [ 13300 ] |
| Fix Version/s | 5.5.34 [ 13700 ] | |
| Fix Version/s | 5.5.33a [ 13500 ] |
| Fix Version/s | 10.0.7 [ 14100 ] | |
| Fix Version/s | 10.0.6 [ 13202 ] |
| Fix Version/s | 5.5.35 [ 14000 ] | |
| Fix Version/s | 5.5.34 [ 13700 ] |
| Fix Version/s | 10.0.8 [ 14200 ] | |
| Fix Version/s | 10.0.7 [ 14100 ] |
| Fix Version/s | 5.5.36 [ 14600 ] | |
| Fix Version/s | 5.5.35 [ 14000 ] |
| Fix Version/s | 10.0.9 [ 14400 ] | |
| Fix Version/s | 10.0.8 [ 14200 ] |
| Fix Version/s | 5.5.37 [ 15000 ] | |
| Fix Version/s | 5.5.36 [ 14600 ] |
| Fix Version/s | 10.0.10 [ 14500 ] | |
| Fix Version/s | 10.0.9 [ 14400 ] |
| Fix Version/s | 10.0.11 [ 15200 ] | |
| Fix Version/s | 10.0.10 [ 14500 ] |
| Fix Version/s | 5.5.38 [ 15400 ] | |
| Fix Version/s | 5.5.37 [ 15000 ] |
| Fix Version/s | 10.0.12 [ 15201 ] | |
| Fix Version/s | 10.0.11 [ 15200 ] |
| Fix Version/s | 5.5.39 [ 15800 ] | |
| Fix Version/s | 5.5.38 [ 15400 ] |
| Workflow | defaullt [ 28209 ] | MariaDB v2 [ 44295 ] |
| Fix Version/s | 10.0.13 [ 16000 ] | |
| Fix Version/s | 10.0.12 [ 15201 ] |
| Assignee | Kristian Nielsen [ knielsen ] |
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Assignee | Sergei Golubchik [ serg ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Component/s | Storage Engine - Memory [ 10300 ] | |
| Fix Version/s | 10.0.15 [ 17300 ] | |
| Fix Version/s | 5.5.40 [ 17100 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 44295 ] | MariaDB v3 [ 64645 ] |
| Workflow | MariaDB v3 [ 64645 ] | MariaDB v4 [ 146882 ] |
Since we aren't planning to merge replication changes from MySQL 5.6, we might want to consider fixing it separately.