Bug #99123 Assert on db shutdown if server started with --innodb-checkpoint-disabled=1

• Submitted: 31 Mar 2020 9:15
• Modified: 31 Mar 2020 10:09
• Reporter: Kamil Holubicki (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S6 (Debug Builds)
• Version: 8.0.19
• OS: Any
• CPU Architecture: Any

[31 Mar 2020 9:15] Kamil Holubicki

Description:
Assert on db shutdown if server started with --innodb-checkpoint-disabled=1

How to repeat:
Server built with WITH_DEBUG option
Start server with --innodb-checkpoint-disabled=1

create database test;
use test;
create table t1(a int);
insert into t1 values (1);
shutdown; 

Suggested fix:
Most probably the following 'if' in log0chkp.cc log_make_latest_checkpoint()

  if (!log_request_checkpoint_validate(log)) {
    log_limits_mutex_exit(log);
    ut_error;
  } 

should be:

  if (!log_request_checkpoint_validate(log)) {
    log_limits_mutex_exit(log);
    return;
  }

[31 Mar 2020 10:09] MySQL Verification Team

Hello Kamil,

Thank you for the report.
Verified as described with 8.0.19 debug build.

regards,
Umesh