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.
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.