Bug #74017 | Failing assertion: current <= max_value in file ha_innodb.cc line 1473 | ||
---|---|---|---|
Submitted: | 22 Sep 2014 16:33 | Modified: | 23 Sep 2014 5:34 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 5.5.23 | OS: | Linux (CentOS 5) |
Assigned to: | CPU Architecture: | Any | |
Tags: | assert, Failing assertion: current <= max_value |
[22 Sep 2014 16:33]
Simon Mudd
[22 Sep 2014 17:16]
Valeriy Kravchuk
Check http://bugs.mysql.com/bug.php?id=66836. According to Miguel it was repeatable with 5.5.27, but not later versions.
[22 Sep 2014 18:56]
MySQL Verification Team
Version: '5.5.23' socket: '' port: 3307 MySQL Community Server (GPL) InnoDB: Assertion failure in thread 2808 in file ha_innodb.cc line 1473 InnoDB: Failing assertion: current <= max_value mysqld.exe!innobase_next_autoinc()[ha_innodb.cc:1473] mysqld.exe!ha_innobase::get_auto_increment()[ha_innodb.cc:10170] mysqld.exe!handler::update_auto_increment()[handler.cc:2463] mysqld.exe!ha_innobase::write_row()[ha_innodb.cc:5168] mysqld.exe!handler::ha_write_row()[handler.cc:4808] mysqld.exe!write_record()[sql_insert.cc:1734] mysqld.exe!mysql_insert()[sql_insert.cc:931] mysqld.exe!mysql_execute_command()[sql_parse.cc:2909] mysqld.exe!mysql_parse()[sql_parse.cc:5626] mysqld.exe!dispatch_command()[sql_parse.cc:1039] mysqld.exe!do_command()[sql_parse.cc:773] mysqld.exe!do_handle_one_connection()[sql_connect.cc:814] mysqld.exe!handle_one_connection()[sql_connect.cc:735] mysqld.exe!pthread_start()[my_winthread.c:63] mysqld.exe!_callthreadstartex()[threadex.c:348] mysqld.exe!_threadstartex()[threadex.c:326]
[22 Sep 2014 19:07]
MySQL Verification Team
Version: '5.5.27' socket: '' port: 3307 MySQL Community Server (GPL) InnoDB: Assertion failure in thread 7056 in file ha_innodb.cc line 1477 InnoDB: Failing assertion: current <= max_value ...
[22 Sep 2014 19:27]
MySQL Verification Team
Version: '5.5.28' socket: '' port: 3307 MySQL Community Server (GPL) InnoDB: Assertion failure in thread 4344 in file ha_innodb.cc line 1477 InnoDB: Failing assertion: current <= max_value .... I couldn't repeat on 5.5.29 or newer. Looking at the change logs, I see: https://bugs.mysql.com/bug.php?id=20964 https://bugs.mysql.com/bug.php?id=55071 So maybe they fixed it!
[23 Sep 2014 5:31]
Simon Mudd
Thanks very much for checking. This is one of the last 5.5 boxes that's still running and the version is quite old. The cause of filling the auto-increment value to it's maximum was an exception due to a bug in the code which has now been resolved, so I don't think this is worth following up any further. I just wanted to make a record of it. I'll see if I can get this server and its slaves upgraded to 5.6 and trust with that the problem should go away. If not I can open a new ticket and reference this one again.