Bug 336027

Summary:	dev-db/mysql-5.1 - fails to create database when using option max-idx-128
Product:	Gentoo Linux	Reporter:	J.O. Aho <bugs-gentoo>
Component:	Current packages	Assignee:	Gentoo Linux MySQL bugs team <mysql-bugs>
Status:	RESOLVED UPSTREAM
Severity:	critical
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	http://bugs.mysql.com/bug.php?id=36751
Whiteboard:
Package list:		Runtime testing required:	---

Description J.O. Aho 2010-09-04 21:09:05 UTC

When enabling max-idx-128 MySQL files to create the initial database when running "emerge --config =dev-db/mysql-5.1.50-r1", it dies in the middle of the creation of the tables and leaves the installation unusable.
The problem affects also mysql_upgrade, which will render a broken database whcih may not work with older versions of MySQL (as 5.0).

Reproducible: Always

Steps to Reproduce:
1. USE="max-idx-128" emerge mysql
2. emerge --config =dev-db/mysql-5.1.50-r1

Actual Results:  
mysql_install_db fails to create the complete mysql database.

Expected Results:  
A completly working mysql database is created.

There is at least one bug about the max-idx-128 in the mysql bugzilla (see http://bugs.mysql.com/bug.php?id=36751).
I do suggest that the USE option max-idx-128 would be disabled for MySQL 5.1 until this bug has been fixed in the upstream 5.1/5.5 tree.

Comment 1 J.O. Aho 2010-09-04 21:12:39 UTC

When building mysql 5.1 with debug and max-idx-128 USE options and in my.cnf enable

log                                            = /tmp/mysqld.sql
gdb
debug                                          = d:t:i:o,/tmp/mysqld.trace
one-thread

you will find in your /var/log/mysql/mysqld.log

mysqld: my_bitmap.c:366: bitmap_intersect: Assertion `map->bitmap && map2->bitmap' failed.

Comment 2 Robin Johnson archtester

2010-10-28 20:48:53 UTC

Explicitly blocked in the eclass for now.

We can't just disable it by default, as that would make existing idx-128 data inaccessible.

Please reopen upstream.