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
Is there any workaround so that I can update MariaDB in my server?
Best regards,
Antonio
The problem is also repeatable with other engines, e.g. HEAP and INNODB.
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.