Bug #82301 User friendly CLI message instead of asserting during online buffer pool resize
Submitted: 21 Jul 2016 3:15 Modified: 29 Oct 2018 5:13
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.7.13 OS:Any
Assigned to: CPU Architecture:Any

[21 Jul 2016 3:15] Roel Van de Paar 
Description:
http://bugs.mysql.com/bug.php?id=77564 was fixed, and an appropriate error message is now seen in the error log. 

This request is now to have a user friendly error returned to the CLI instead of just asserting during an online DML by/from the client.

How to repeat:
set global innodb_buffer_pool_size = <too large a number>;
[21 Jul 2016 5:48] Shahriyar Rzayev 
The another thing I want to add is, in addition to "User friendly CLI message", it will be really great, if MySQL will revert back to old buffer pool size after CLI message. "OLD" here maybe default value or the value specified in my.cnf.

So instead of giving assert and aborting, CLI message should be something like:
"Failed to resize innodb buffer pool size online, please check for available memory"

And in error log:
"ERROR: Failed to resize innodb buffer pool size online, please check for available memory.
 NOTE: Reverting back to default value of innodb_buffer_pool_size specified in configuration file"
[21 Jul 2016 5:52] Roel Van de Paar 
Yes, great idea. Much higher user convenience. The way this could be approached programatically is by perhaps by simply checking how much memory is available before actioning, or if that does not work, by allocating a safe space (for example 500MB) before starting the operation, so that there is always plenty of memory to back out, but likely a simple pre-flight check would be sufficient.
[26 Oct 2018 13:05] MySQL Verification Team 
also https://bugs.mysql.com/bug.php?id=92963
[29 Oct 2018 5:13] MySQL Verification Team 
Hello Roel,

Thank you for the feature request!

regards,
Umesh