Bug #17616 | Crash in creation of "mysql" database | ||
---|---|---|---|
Submitted: | 21 Feb 2006 14:48 | Modified: | 21 May 2006 14:24 |
Reporter: | Francesco Riosa | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.1.6_alpha | OS: | Linux (linux (custom)) |
Assigned to: | CPU Architecture: | Any |
[21 Feb 2006 14:48]
Francesco Riosa
[21 Feb 2006 14:51]
Francesco Riosa
mysqld.trace (compressed with bzip2)
Attachment: mysqld.trace.bz2 (application/x-bzip, text), 42.41 KiB.
[21 Feb 2006 14:53]
Francesco Riosa
configure options below: CHOST="i686-pc-linux-gnu" \ CC=gcc \ CFLAGS="-O2 -march=athlon-xp" \ CXX=gcc \ CXXFLAGS="-O2 -march=athlon-xp -felide-constructors \ -fno-exceptions -fno-rtti" \ ./configure --prefix=/mnt/sda6/dest/ \ --with-low-memory --enable-assembler --enable-local-infile \ --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-zlib-dir=/usr \ --without-readline \ --without-docs \ --enable-shared \ --enable-static \ --without-libwrap \ --with-openssl \ --with-debug=full \ --with-bench \ --with-server \ --with-extra-tools \ --with-innodb \ --without-raid \ --with-extra-charsets=all \ --without-berkeley-db \ --with-geometry \ --without-ndbcluster \ --without-big-tables \ --without-ndb-binlog \ --without-embedded-privilege-control \ --without-embedded-server \ --with-archive-storage-engine \ --with-csv-storage-engine \ --with-blackhole-storage-engine \ --with-federated-storage-engine \ --with-partition \ --with-max-indexes=128 \ --with-row-based-replication \ && make && make install
[22 Feb 2006 11:47]
Valeriy Kravchuk
Thank you for a problem report. Can you, please, try to execute standard mysql_install_db once again and send the error log's content for this attempt?
[22 Feb 2006 15:22]
Francesco Riosa
cut and paste from the console, resolved trough "resolve_stack_dump"
Attachment: mysqld.stack.resolved (application/octet-stream, text), 4.75 KiB.
[22 Feb 2006 15:25]
Francesco Riosa
debug trace of the server run by mysql_install_db
Attachment: mysqld.trace.bz2 (application/x-download, text), 8.40 KiB.
[22 Feb 2006 15:34]
Francesco Riosa
the two previous attachments are the output of the following command: ./bin/mysql_install_db \ --no-defaults \ --basedir=/mnt/sda6/dest/ \ --user=mysql \ --skip-name-resolve \ --verbose \ --debug=d:t:i:o,/mnt/sda6/dest/var/mysqld.trace \ --log=/mnt/sda6/dest/var/mysqld.log \ the kernel version has changed and it's now: Linux localhost 2.6.16-rc4-mm1 #1 PREEMPT Tue Feb 21 17:59:59 2006 i686 AMD Athlon(tm) AuthenticAMD GNU/Linux the last function enter this time is "find_type", just a quick test: grep -c find_type mysqld.trace.* mysqld.trace.1:116 mysqld.trace.2:116 mysqld.trace.3:116 show that _probably_ the path to the crash is always the same.
[22 Feb 2006 17:00]
Francesco Riosa
also reproducible with different behaviour (mysqld.trace) on a more stable machine: gcc (GCC) 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8) glibc-2.3.5 Linux francesco-riosa.com 2.6.13-hardened #1 Sat Oct 1 03:49:31 CEST 2005 i686 AMD Duron(tm) Processor AuthenticAMD GNU/Linux
[2 Mar 2006 14:19]
Francesco Riosa
5.1.7 : ./bin/mysql_install_db (same options) trace
Attachment: mysqld.trace.bz2 (application/x-download, text), 11.31 KiB.
[2 Mar 2006 14:21]
Francesco Riosa
diff between traces of 5.1.6 and 5.1.7 (removed first 12 chars of each row)
Attachment: mysqld.trace-5.1.6-5.1.7.diff.bz2 (application/x-download, text), 15.13 KiB.
[2 Mar 2006 18:01]
Valeriy Kravchuk
I had not tried with your exact configure, but in 5.1.8-BK () mysql_install_db works just fine for me on SuSE 9.3: openxs@suse:~/dbs/5.1> bin/mysql_install_db Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /home/openxs/dbs/5.1/bin/mysqladmin -u root password 'new-password' /home/openxs/dbs/5.1/bin/mysqladmin -u root -h suse password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd /home/openxs/dbs/5.1 ; /home/openxs/dbs/5.1/bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the /home/openxs/dbs/5.1/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com openxs@suse:~/dbs/5.1> bin/mysqld_safe & [1] 12237 openxs@suse:~/dbs/5.1> Starting mysqld daemon with databases from /home/openxs/d bs/5.1/var openxs@suse:~/dbs/5.1> bin/mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.1.8-beta-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cluster | | mysql | | test | +--------------------+ 4 rows in set (0.01 sec) mysql> exit Bye openxs@suse:~/dbs/5.1> uname -a Linux suse 2.6.11.4-20a-default #1 Wed Mar 23 21:52:37 UTC 2005 i686 i686 i386 GNU/Linux So, the difference can be in kernel, CPU, glibc version etc. Please, check. Doo you want me to try on a platfrom more similar to yours?
[2 Mar 2006 18:03]
Valeriy Kravchuk
Sorry, missed some information. I had used ChangeSet@1.2205.1.2, 2006-03-02 08:44:11+01:00 and the following (simpler) configure: ./configure --prefix=/home/openxs/dbs/5.1 --with-extra-charsets=all \ --with-readline --with-innodb --with-ndbcluster \ --with-mysqld-ldflags=-all-static --enable-thread-safe-client \ --with-debug=full
[3 Mar 2006 14:51]
Francesco Riosa
I cannot test bitkeeper sources, sorry. Still on 5.1.7 the smallest change needed to make the server work is to remove the following options: --with-max-indexes=128 \ --enable-assembler \ Lowering severity from "Serious" to "Non-critical", may be still lower ? Thanks for the time spent.
[21 Apr 2006 14:24]
Valeriy Kravchuk
Please, try to repeat without --enable-assembler option only and inform about the results. Do you have links in /usr/include to kernel sources?
[21 May 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".