Bug #74327 Can't start the server if ib_buffer_pool is deleted
Submitted: 11 Oct 2014 3:12 Modified: 11 Oct 2014 3:17
Reporter: zhai weixiang (OCA) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7.5 OS:Any
Assigned to: CPU Architecture:Any

[11 Oct 2014 3:12] zhai weixiang
Description:
If ib_buffer_pool is deleted , I can not start the mysql instance ,and the error message printed:

2014-10-11 11:08:27 0x2b7165e0d700 InnoDB: Loading buffer pool(s) from /u01/my57/data/ib_buffer_pool
2014-10-11 11:08:27 0x2b7165e0d700 InnoDB: Cannot open '/u01/my57/data/ib_buffer_pool' for reading: No such file or directory
2014-10-11T03:08:27.779165Z 0 [ERROR] Too many arguments (first extra is '-').
2014-10-11T03:08:27.779184Z 0 [ERROR] Aborting

2014-10-11 11:08:27 0x2b7165e0d700 InnoDB: Dumping buffer pool(s) to /u01/my57/data/ib_buffer_pool

So it will generate a new ib_buffer_pool

I then start the server again and still failed to start..

2014-10-11 11:10:35 0x2badd620d700 InnoDB: Loading buffer pool(s) from /u01/my57/data/ib_buffer_pool
2014-10-11T03:10:35.206936Z 0 [ERROR] Too many arguments (first extra is '-').
2014-10-11T03:10:35.210625Z 0 [ERROR] Aborting

2014-10-11 11:10:35 0x2badd620d700 InnoDB: Buffer pool(s) load completed at 141011 11:10:35
2014-10-11 11:10:35 0x2badd620d700 InnoDB: Dumping buffer pool(s) to /u01/my57/data/ib_buffer_pool
2014-10-11 11:10:35 0x2badd620d700 InnoDB: Buffer pool(s) dump completed at 141011 11:10:35

How to repeat:
delete ib_buffer_pool and start the server

Suggested fix:
I don't know...
[11 Oct 2014 3:13] zhai weixiang
both variables enabled:

innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_at_shutdown=1
[11 Oct 2014 3:17] zhai weixiang
make a mistake. close it :(