Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 336027 - dev-db/mysql-5.1 - fails to create database when using option max-idx-128
Summary: dev-db/mysql-5.1 - fails to create database when using option max-idx-128
Status: RESOLVED UPSTREAM
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High critical with 1 vote (vote)
Assignee: Gentoo Linux MySQL bugs team
URL: http://bugs.mysql.com/bug.php?id=36751
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-09-04 21:09 UTC by J.O. Aho
Modified: 2010-10-28 20:48 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 Gentoo Infrastructure gentoo-dev Security 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.