Bug #13383 | Server will not start with InnoDB lines uncommented | ||
---|---|---|---|
Submitted: | 21 Sep 2005 16:31 | Modified: | 21 Sep 2005 21:16 |
Reporter: | Doug Hunting | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.12-beta-max-log | OS: | Linux (Linux 2.6.10) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[21 Sep 2005 16:31]
Doug Hunting
[21 Sep 2005 16:44]
MySQL Verification Team
Could you please show us the lines printed on the log-error file and how you uncommented these lines. Thanks in advance.
[21 Sep 2005 19:32]
Doug Hunting
These are the lines that I uncommented : #innodb_data_home_dir = /usr/local/mysql/data/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql/data/ #innodb_buffer_pool_size = 256M #innodb_additional_mem_pool_size = 20M #innodb_log_file_size = 64M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 Here are the results of the [server].err file: 050921 02:20:43 mysqld started 050921 2:20:43 InnoDB: Error: cannot allocate 268451840 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 25922024 bytes. Operating system errno: 12 InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: Note that in most 32-bit computers the process InnoDB: memory space is limited to 2 GB or 4 GB. InnoDB: We keep retrying the allocation for 60 seconds... InnoDB: Fatal error: cannot allocate the memory for the buffer pool 050921 2:21:43 [ERROR] Can't init databases 050921 2:21:43 [ERROR] Aborting 050921 2:21:43 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050921 02:21:43 mysqld ended
[21 Sep 2005 20:14]
MySQL Verification Team
According the log-error you are out of the resources and InnoDB engines has aborted. If actually that is the reason, could you please change the values of the buffer for more adequate ones for your hardware.
[21 Sep 2005 21:16]
MySQL Verification Team
Thank you for the feedback.