MySQL Bugs: #40003: Valgrind error in parts.partition_auto_increment

Bug #40003	Valgrind error in parts.partition_auto_increment_archive
Submitted:	13 Oct 2008 14:23	Modified:	13 Oct 2008 20:43
Reporter:	Mattias Jonsson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Archive storage engine	Severity:	S2 (Serious)
Version:	6.0	OS:	Any
Assigned to:	Mattias Jonsson	CPU Architecture:	Any

Description:
There are valgrind warnings when running parts.partition_auto_increment_archive.

(in mysql-6.0-bugteam, and mysql-6.0-5.1.29-rc).

It does not need partitioning to repeat.

How to repeat:
# non partitioned part of parts.partition_auto_increment_archive
--source include/have_archive.inc
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
c1 INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (c1))
ENGINE='Archive';
SHOW CREATE TABLE t1;
SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test'
AND TABLE_NAME='t1';
INSERT INTO t1 VALUES (2);
INSERT INTO t1 VALUES (4);
INSERT INTO t1 VALUES (NULL);
SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test'
AND TABLE_NAME='t1';
SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test'
AND TABLE_NAME='t1';
INSERT INTO t1 VALUES (0);

Smaller test case:
--source include/have_archive.inc
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
c1 INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (c1))
ENGINE='Archive';
INSERT INTO t1 VALUES (2);
DROP TABLE t1;

One of the valgrind warnings:
==18614== Conditional jump or move depends on uninitialised value(s)==18614==    at 0x4049CA6: (within /usr/lib/libz.so.1.2.3.3)
==18614==    by 0x4048BE6: deflate (in /usr/lib/libz.so.1.2.3.3)==18614==    by 0x84AC38A: do_flush (azio.c:684)
==18614==    by 0x84AC7DA: azflush (azio.c:747)
==18614==    by 0x84A8EC5: ha_archive::info(unsigned) (ha_archive.cc:1366)==18614==    by 0x8392ABC: handler::get_dup_key(int) (handler.cc:2922)
==18614==    by 0x8396D5E: handler::print_error(int, int) (handler.cc:2588)==18614==    by 0x8318791: write_record(THD*, TABLE*, st_copy_info*) (sql_insert.cc:1
632)
==18614==    by 0x831E6FE: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Ite
m> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:829)
==18614==    by 0x829E49F: mysql_execute_command(THD*) (sql_parse.cc:2975)
==18614==    by 0x829F03C: mysql_parse(THD*, char const*, unsigned, char const**) (sq
l_parse.cc:5587)
==18614==    by 0x82A0008: dispatch_command(enum_server_command, THD*, char*, unsigne
d) (sql_parse.cc:1002)
==18614==    by 0x82A12C4: do_command(THD*) (sql_parse.cc:689)
==18614==    by 0x82906AB: handle_one_connection (sql_connect.cc:1153)
==18614==    by 0x40304FA: start_thread (in /lib/tls/i686/cmov/libpthread-2.7.so)
==18614==    by 0x42AAE5D: clone (in /lib/tls/i686/cmov/libc-2.7.so)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/56147

2873 Mattias Jonsson	2008-10-13
      Bug#40003: valgrind warning in
      parts.partition_auto_increment_archive
      
      post fix for bug#38719, fix for valgrind warning

Pushed as a post push fix for bug#38719 (since it was introduced there.)

Pushed into 6.0.8-alpha  (revid:mattias.jonsson@sun.com-20081013192656-kqk69vsh9hraxmo8) (version source revid:mattias.jonsson@sun.com-20081013192656-kqk69vsh9hraxmo8) (pib:5)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/67051

2812 Mattias Jonsson	2009-02-20
      Backport of patch for bug#40003 from 6.0 to 5.1,
      related to the backport of the patch for bug#38719
     @ sql/ha_partition.cc
        bug#40003, archive does not handle dup_key.

Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:azundris@mysql.com-20090224070618-mr7stu6rfcvoj18g) (merge vers: 5.1.33) (pib:6)

Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:azundris@mysql.com-20090223123708-n9rf2to3g15br7za) (merge vers: 6.0.10-alpha) (pib:6)

Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)

Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)

Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)