MariaDB 10.6.18 release requires action

[nikitasol]

Version

1.22.0

What did you expect to happen?

Seamless sync between production/staging and development

What actually happens?

MariaDB 10.6.18 adds sandbox comman as per release notes and the new line at the top of the db export breaks syncing.

Steps to reproduce

Just re-provision production/staging so the new MariaDB is installed there and then try exporting/importing db either through the amazing sync.sh or manually.

The line which is added is this:

/*!999999\- enable the sandbox mode */

System info

No response

Log output

No response

Please confirm this isn't a support request.

No

[retlehs]

MariaDB breaking database dumps in a patch release is wild 😞

Other relevant discussions/issues:

https://jira.mariadb.org/browse/MDEV-34183
ddev/ddev#6249
wp-cli/db-command#254

[nikitasol]

Just to add a few possible solutions:

• if you use sync.sh (or some other shell script) add tail -n +2 in between db export and db import so that the script may eliminate the first line (tested and works)
• update vm to latest mariadb version (haven't tested yet, but should work)

[nikitasol]

And to confirm that rebuilding vm with updated MariaDB also works too.