Mysqldump (Ver 10.19 Distrib 10.11.4-MariaDB) error on Singlestore Version 8.1.26

Help
1

We are not able to backup with mysqldump Ver 10.19 Distrib 10.11.4-MariaDB, for Linux (x86_64) on singlestore Version 8.1.26
The backups worked previously with mysqldump Ver 10.19 Distrib 10.6.8-MariaDB, for Linux (x86_64)
Error:
Fehlermeldung: mysqldump: Couldn’t execute ‘select column_name, extra, generation_expression, data_type from information_schema.columns where table_schema=database() and table_name=’$projectId$_Rating’': Unknown column ‘generation_expression’ in ‘field list’ (1054)

We know about the workaround using column-statistics=0 but the flag is not available anymore in the new version of mysqldumo we are using right now.
Can somebody explain why this error occurs for mysql dump Ver 10.19 Distrib 10.11.4-MariaDB, but not for Ver 10.19 Distrib 10.6.8-MariaDB
Thank you for your help!

2

The issue seems to be in Mariadb’s version of mysqldump utility. You can refer to the below link of known mariadb mysqldump issue with this specific version - https://jira.mariadb.org/browse/MDEV-31836?jql=labels%20%3D%20MySQL8

Since you are using the mysqldump utility provided by mariadb which is version 10.19. This version of mysqldump utility might not support some of the options.
In Place of Mariadb’s mysqldump utility, you can use the below alternatives -

  • MySQL’s mysqldump utility to take backups. MySQL’s mysqldump utility may offer improved compatibility and mitigate issues related to older versions of MariaDB’s utility.
  • SingleStore’s sdb-admin dump utility is a good alternative if you’re specifically looking to take schema backups.