Reached maximum possible value for auto_increment function set on column
While inserting single record (by both INSERT .. VALUES and INSERT .. SELECT) you will obtain 


  Duplicate entry 'max_value_for_datatype' for key 'PRIMARY'


While inserting multiple records you will obtain (even when only one of them causes overflow)


  Failed to read auto-increment value from storage engine


fiddle




  Will it be handled automatically?


No. You must handle it - and the best way is to solve this issue before it occures.



PS. If you are interested in to know what messages will be produced while inserting record(s) by LOAD DATA/XML you may test it by yourelf.