innodb_track_changed_pages removed as of mysql 8.0.30 breaks bgbackup.sh

[jdanilson]

We are running bgbackup.sh but it's an older copy as we have modifications therein.

We just updated a bunch of servers to percona server 8.0.30 and found that innodb_track_changed_pages is no longer valid. This is tested within bgbackup.sh and results in an error when the value returns nothing. It's around line 419 as:

bitmaps=$(mysql --login-path=root -BNe "select variable_value from performance_schema.global_variables where variable_name = 'innodb_track_changed_pages'")

if [ $bitmaps = "ON" ]; then

As of mysql 8.0.27 innodb_track_changed_pages is deprecated. As of mysql 8.0.30 innodb_track_changed_pages is removed

Our fix is to add this before the check: if [ -z "$bitmaps" ]; then bitmaps='OFF' # as of 8.0.30 innodb_track_changed_pages is removed and no longer available. this tests for no value returned. fi

Sorry I don't know how to pull or push code to this group.