Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12, 5.5(EOL), 10.0(EOL), 10.1(EOL)
-
Centos 7 x86_64
-
10.1.11
Description
After I've updated my replication slave to 10.1.10 i've begun having replication problems with a query I've narrow down to a MySQL bug (https://bugs.mysql.com/bug.php?id=58081). Is this a bug?
set names latin1;
|
drop table if exists t1;
|
create table t1(a int) engine=myisam;
|
insert into t1 values (0),(0),(1),(0),(0);
|
select count(*) from t1, t1 t2 group by insert('', t2.a, t1.a,(@@global.max_binlog_size));
|
/* SQL Error (1062): Duplicate entry '107374182410737418241' for key 'group_key' */
|
/* Affected rows: 5 Found rows: 0 Warnings: 1 Duration for 4 of 5 queries: 0,188 sec. */
|
Attachments
Issue Links
- is part of
-
-
- Closed
-
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
After I've updated my replication slave to 10.1.10 i've begun having replication problems with a query I've narrow down to a MySQL bug (https://bugs.mysql.com/bug.php?id=58081). Is this a bug? {{ set names latin1; drop table if exists t1; create table t1(a int) engine=myisam; insert into t1 values (0),(0),(1),(0),(0); select count(*) from t1, t1 t2 group by insert('', t2.a, t1.a,(@@global.max_binlog_size)); /* SQL Error (1062): Duplicate entry '107374182410737418241' for key 'group_key' */ /* Affected rows: 5 Found rows: 0 Warnings: 1 Duration for 4 of 5 queries: 0,188 sec. */ }} |
After I've updated my replication slave to 10.1.10 i've begun having replication problems with a query I've narrow down to a MySQL bug (https://bugs.mysql.com/bug.php?id=58081). Is this a bug? {noformat} set names latin1; drop table if exists t1; create table t1(a int) engine=myisam; insert into t1 values (0),(0),(1),(0),(0); select count(*) from t1, t1 t2 group by insert('', t2.a, t1.a,(@@global.max_binlog_size)); /* SQL Error (1062): Duplicate entry '107374182410737418241' for key 'group_key' */ /* Affected rows: 5 Found rows: 0 Warnings: 1 Duration for 4 of 5 queries: 0,188 sec. */ {noformat} |
| Component/s | Optimizer [ 10200 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 5.3.12 [ 12000 ] | |
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.1.10 [ 20402 ] | |
| Assignee | Alexander Barkov [ bar ] | |
| Labels | upstream-fixed |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Remote Link | This issue links to "Bug #58081 Duplicate entry error when doing GROUP BY (Web Link)" [ 26406 ] |
Is there any workaround so that I can update MariaDB in my server?
Best regards,
Antonio
| Sprint | 10.1.11 [ 30 ] |
| Rank | Ranked lower |
The problem is also repeatable with other engines, e.g. HEAP and INNODB.
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Alexander Barkov [ bar ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Alexander Barkov [ bar ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.1.11 [ 21202 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 73330 ] | MariaDB v4 [ 149943 ] |
ampf,
It's a bug, but it's strange that you only started hitting it after upgrade, apparently it's been there for a long, long time. Possibly some defaults have changed which made it surface.
bar, you filed it back then at MySQL, do you want to pick it up?
It's said to have been fixed in 5.7.5.