George,
this is the bug that slipped into the rollback code in .38.
You can download a patch from my website
http://www.innobase.fi/bugfixes.html
You are running out of tablespace when doing the table import.
MyISAM tables take a lot more space when converted to the InnoDB
type. Make your data files bigger. If you encounter more problems,
please write to me.
Regards,
Heikki
Innobase Oy
At 02:25 PM 5/24/01 +0300, you wrote:
>Content-Type: message/rfc822
>Content-Description: forwarded message
>Content-Transfer-Encoding: 7bit
>
>Subject: Bug report
>From: George Mihalcea <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Date: Thu, 24 May 2001 10:49:05 +0300
>Organization: NetBridge Investments SRL
>Sender: [EMAIL PROTECTED]
>MIME-Version: 1.0
>Content-Type: multipart/mixed;
> boundary="------------42287FF6A78805E1B8015642"
>
>Hello!
>I compiled mysql 3.23.38 with support for innodb tables.
>The server is a dual PIII 850, with 1 GB RAM, 1 SCSI disk.
>OS is Slackware current . Kernel version is 2.4.4 , no patches.
>
>I created 4 tablespaces of 1000M each.
>I took a dump from another mysql server (with myisam tables), I changed type
>to innodb in dump files and I tried to create the databases and tables in this
>new server.
>The dump has 2GB.
>First, I tried with the big dump file, then with one file for each database
>(about 2000 databases with the same structure).
>When I tried with the big file, the mysql database crashed after about half of
>the file, he tryed to restart, crashed again, he tried to restart an so on...
>I had to delete all directories and files and restart with the default mysql
>and test databases.
>
>The seconf time, every database had its own dump. Mysql crashed after 1700
>databases.
>If I try to continue with the other databases remaining, it crashes again.
>
>I attached the log mysql error log file and my.cnf config file.
>What should I do? Is any of the parameters in my.cnf wrong ?
>Should I stay to MyISAM tables ?
>
>Thanks,
>George Mihalcea.
>
>Attachment Converted: C:\EUDORA\logerr1.gz
># Example mysql config file for large systems.
>#
># This is for large system with memory = 512M where the system runs mainly
># MySQL.
>#
># You can copy this file to
># /etc/mf.cnf to set global options,
># mysql-data-dir/my.cnf to set server-specific options (in this
># installation this directory is /var/lib/mysql) or
># ~/.my.cnf to set user-specific options.
>#
># One can in this file use all long options that the program supports.
># If you want to know which options a program support, run the program
># with --help option.
>
># The following options will be passed to all MySQL clients
>[client]
>#password = your_password
>port = 3306
>socket = /var/lib/mysql/mysql.sock
>
># Here follows entries for some specific programs
>
># The MySQL server
>[mysqld]
>port = 3306
>socket = /var/lib/mysql/mysql.sock
>skip-locking
>set-variable = key_buffer=256M
>set-variable = max_allowed_packet=1M
>set-variable = table_cache=1
>set-variable = sort_buffer=1M
>set-variable = record_buffer=1M
>set-variable = myisam_sort_buffer_size=64M
>set-variable = thread_cache=4
>set-variable = max_connections=400
># Try number of CPU's*2 for thread_concurrency
>set-variable = thread_concurrency=4
>log-bin
>server-id = 1
>
># Uncomment the following if you are using BDB tables
>#set-variable = bdb_cache_size=64M
>#set-variable = bdb_max_lock=100000
>
># Uncomment the following if you are using Innobase tables
>innodb_data_home_dir = /var/lib/mysql/
>innodb_log_group_home_dir = /var/lib/mysql/
>innodb_log_arch_dir = /var/lib/mysql/
>innodb_data_file_path = ibdata1:1000M;ibdata2:1000M;ibdata3:1000M;ibdata4:1000M
>set-variable = innodb_mirrored_log_groups=1
>set-variable = innodb_log_files_in_group=3
>set-variable = innodb_log_file_size=50M
>set-variable = innodb_log_buffer_size=8M
>innodb_flush_log_at_trx_commit=1
>innodb_log_archive=1
>set-variable = innodb_buffer_pool_size=400M
>set-variable = innodb_additional_mem_pool_size=50M
>set-variable = innodb_file_io_threads=4
>set-variable = innodb_lock_wait_timeout=50
>
># Point the following paths to different dedicated disks
>tmpdir = /tmp/
>#log-update = /path-to-dedicated-directory/hostname
>
>[mysqldump]
>quick
>set-variable = max_allowed_packet=16M
>
>[mysql]
>no-auto-rehash
># Remove the next comment character if you are not familiar with SQL
>#safe-updates
>
>[isamchk]
>set-variable = key_buffer=128M
>set-variable = sort_buffer=128M
>set-variable = read_buffer=2M
>set-variable = write_buffer=2M
>
>[myisamchk]
>set-variable = key_buffer=128M
>set-variable = sort_buffer=128M
>set-variable = read_buffer=2M
>set-variable = write_buffer=2M
>
>[mysqlhotcopy]
>interactive-timeout
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.phpContent-Type: text/plain;
charset=us-ascii
>Content-Description: message body text
>Content-Transfer-Encoding: 7bit
>
>
>
>Something for you !
>
>
>Regards,
>
>Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
