Bug #28799 | Using InnoDB, this will stop MySQL from starting at all, Signal 11 | ||
---|---|---|---|
Submitted: | 31 May 2007 8:31 | Modified: | 4 Jul 2007 11:04 |
Reporter: | Niklas Saers | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
Version: | 5.1.14 - 5.1.18 | OS: | MacOS (10.4.9) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | ALTER TABLE, innodb, Signal 11 |
[31 May 2007 8:31]
Niklas Saers
[31 May 2007 9:05]
Sveta Smirnova
Thank you for the report. Please provide output of SHOW CREATE TABLE and SHOW TABLE STATUS for table you alter.
[31 May 2007 17:19]
Niklas Saers
mysql> show create table url; +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | url | CREATE TABLE `url` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(900) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idxUrl` (`url`(100)) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1739182 DEFAULT CHARSET=latin1 | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.02 sec) From table status: | url | InnoDB | 10 | Compact | 154035 | 133 | 20496384 | 0 | 23691264 | 0 | 1739182 | 2007-05-31 11:02:42 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 3304448 kB | Cheers Nik
[1 Jun 2007 11:11]
Sveta Smirnova
Thank you for the report. I can not repeat described behaviour with test data. Please provide your configuration file and indicate how much physical RAM do you have.
[1 Jun 2007 22:40]
Niklas Saers
It's a Mac Mini with 2GB RAM. Below follows the config file [mysql] max_allowed_packet=512M [mysqld] server-id=1 replicate-same-server-id = 0 auto-increment-increment = 10 auto-increment-offset = 1 log-slave-updates log-bin=/usr/local/mysql/log/bin.log log-bin-index = /usr/local/mysql/log/log-bin.index log-error = /usr/local/mysql/log/error.log binlog-do-db=timeattask binlog-do-db=mysql relay-log=/usr/local/mysql/log/datacentre-relay-bin relay-log-info-file=/usr/local/mysql/log/datacentre-relay-log.info relay-log-index=/usr/local/mysql/log/datacentre-relay-log.index relay-log-space-limit=2G lower_case_table_names=1 slave_compressed_protocol=1 log-warnings key_buffer_size=512M slave-net-timeout = 5 master-connect-retry = 5 log-slow-queries log-queries-not-using-indexes long_query_time=5 set-variable=innodb_buffer_pool_size=256M set-variable = sort_buffer_size=2000M set-variable = read_buffer_size=640M set-variable = max_allowed_packet=1M set-variable = max_connections=400
[4 Jun 2007 11:04]
Sveta Smirnova
Thank you for the feeback. I still can not repeat the issue with development sources. Please download current 5.1.19-beta version, try with it and say us result.
[4 Jul 2007 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".