MySQL Forums
Forum List  »  InnoDB

Caonot change innodb_data_file_path
Posted by: Jean Vieille
Date: November 24, 2012 08:35AM

I just enabled innodb on a mysql server, and I am struggling with this variable that I cannot set without crashing the server.

All work well with the default value
innodb_data_file_path = ibdata1:10M:autoextend

If I change the size to say 100M, innodb dies and I get this kind of log :
(note that this one succeded at staeting, but momst of the time, Mysql dies definitely)

Nov 24 15:01:16 ns mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov 24 15:01:19 ns mysqld_safe: Starting mysqld daemon with databases from /home/mysql
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [Note] Plugin 'FEDERATED' is disabled.
Nov 24 15:01:19 ns mysqld: InnoDB: The InnoDB memory heap is disabled
Nov 24 15:01:19 ns mysqld: InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 24 15:01:19 ns mysqld: InnoDB: Compressed tables use zlib 1.2.3.3
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 InnoDB: Initializing buffer pool, size = 6.0G
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 InnoDB: Completed initialization of buffer pool
Nov 24 15:01:19 ns mysqld: InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
Nov 24 15:01:19 ns mysqld: InnoDB: 640 pages (rounded down to MB) than specified in the .cnf file:
Nov 24 15:01:19 ns mysqld: InnoDB: initial 6400 pages, max 0 (relevant if non-zero) pages!
Nov 24 15:01:19 ns mysqld: InnoDB: Could not open or create data files.
Nov 24 15:01:19 ns mysqld: InnoDB: If you tried to add new data files, and it failed here,
Nov 24 15:01:19 ns mysqld: InnoDB: you should now edit innodb_data_file_path in my.cnf back
Nov 24 15:01:19 ns mysqld: InnoDB: to what it was, and remove the new ibdata files InnoDB created
Nov 24 15:01:19 ns mysqld: InnoDB: in this failed attempt. InnoDB only wrote those files full of
Nov 24 15:01:19 ns mysqld: InnoDB: zeros, but did not yet use them in any way. But be careful: do not
Nov 24 15:01:19 ns mysqld: InnoDB: remove old data files which contain your precious data!
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [ERROR] Plugin 'InnoDB' init function returned error.
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [Warning] Found an entry in the 'db' table with empty database name; Skipped
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [Warning] Found an entry in the 'db' table with empty database name; Skipped
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [Note] Event Scheduler: Loaded 0 events
Nov 24 15:01:19 ns mysqld: 121124 15:01:19 [Note] /usr/sbin/mysqld: ready for connections.
Nov 24 15:01:19 ns mysqld: Version: '5.1.58-1~dotdeb.0-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Nov 24 15:01:20 ns /etc/mysql/debian-start[17941]: Upgrading MySQL tables if necessary.
Nov 24 15:01:20 ns /etc/mysql/debian-start[17944]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Nov 24 15:01:20 ns /etc/mysql/debian-start[17944]: Looking for 'mysql' as: /usr/bin/mysql
Nov 24 15:01:20 ns /etc/mysql/debian-start[17944]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov 24 15:01:20 ns /etc/mysql/debian-start[17944]: This installation of MySQL is already upgraded to 5.1.58, use --force if you still need to run mysql_upgrade
Nov 24 15:01:20 ns /etc/mysql/debian-start[17951]: Checking for insecure root accounts.
Nov 24 15:01:20 ns /etc/mysql/debian-start[17955]: Triggering myisam-recover for all MyISAM tables


I tried to delete all ib_log_file and ibdata files, but it did not help - the only working setting is the default one.

Thanks for help

Options: ReplyQuote


Subject
Views
Written By
Posted
Caonot change innodb_data_file_path
6064
November 24, 2012 08:35AM
2067
November 25, 2012 02:28PM
1710
November 27, 2012 05:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.