Description:
The platform is an Intel Xeon 3.000GHz with 2 CPUs and 4 cores each with 8 GBytes of memory
The OS is Linux kernel 2.6.18-5 running with Debian 4.0
The MySQL version running is 5.1.20 compiled for 64 bits on Debian with The options used for building MySQL are:
./configure CC=gcc CFLAGS="-DBIG_JOINS=1 -O2" CXX=g++ CXXFLAGS="-DBIG_JOINS=1 -felide-constructors -fno-rtti -O2" --prefix=/....../app/mysql-5.1.20 --localstatedir=/..../app/mysql-5.1.20/data --libexecdir=/...../app/mysql-5.1.20/bin --datadir=/....../app/mysql-5.1.20/data -with-comment="Debian x86_64" --with-server-suffix="Debian x86_64" --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-big-tables --with-raid --with-mysqld-user=mysql --with-libwrap --with-mysqld-ldflags=-all-static --with-vio --with-bench --with-readline --with-extra-charsets=all --with-innodb --with-isam --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-embedded-privilege-control --with-zlib-dir=bundled --with-ssl=bundled --with-partition
The MySQL software and database data are on a reiserfs filesystem
MySQL has been setup with 16 Innodb table spaces
ibdata1:1024M;ibdata2:1024M;ibdata3:1024M;ibdata4:1024M;ibdata5:1024M;ibdata6:1024M;ibdata7:1024M;ibdata8:1024M;ibdata9:1024M;ibdata10:1024M;ibdata11:1024M;ibdata12:1024M;ibdata13:1024M;ibdata14:1024M;ibdata15:1024M;ibdata16:50M:autoextend
It had only one database created
The database contains 3 tables (with 1000 partitions each) with approximately 6 millions rows each, + a few tables (with 5 partitions each) with approximately 2 millions rows each and apprimately newly created 143,920 tables (each table is partitioned by LIST on an integer with a total of 5 partitions) with no data inside.
There were 8 jobs running trying to create more tables o fthe same type of the latter described.
The jobs were supposed to create in total 1,000,000 tables.
When approximately 143,920 tables were created mysql died
This is the message stored in the error log file:
InnoDB: Error: trying to declare trx to enter InnoDB, but
InnoDB: it already is declared.
How to repeat:
I think the way to repeat the bug is to create over 100,000 tables with InnoDb, Linux and reiserfs.
I will re-run the jobs and see whether I run into the same error.
