You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: