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)
• Status: Not a Bug
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.5
• OS: Any
• 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 :(