[MDEV-9332] Bug after upgrade to 10.1.10 Created: 2015-12-28  Updated: 2016-01-31  Resolved: 2016-01-27

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 5.3.12, 5.5, 10.0, 10.1
Fix Version/s: 10.1.11

Type: Bug Priority: Major
Reporter: Antonio Fernandes Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: upstream-fixed
Environment:

Centos 7 x86_64

Issue Links:
PartOf
is part of MDEV-9500 Bug after upgrade to 10.1.10 (and 10.... Closed
Sprint: 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. */



 Comments   
Comment by Elena Stepanova [ 2015-12-29 ]

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.

Comment by Antonio Fernandes [ 2016-01-11 ]

Is there any workaround so that I can update MariaDB in my server?

Best regards,
Antonio

Comment by Alexander Barkov [ 2016-01-26 ]

The problem is also repeatable with other engines, e.g. HEAP and INNODB.

Generated at Thu Feb 08 07:33:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.