Mysqldump: Couldn't execute 'show events'

Support
#1

NethServer Version: 7.9
Module: Automysqlbackup

Since a few days, I receive error mails.

Subject: ERRORS REPORTED: MySQL Backup error Log for MY-NethServer - 2022-02-22_03h01m

Content:
mysqldump: Couldn't execute 'show events': Cannot proceed, because event scheduler is disabled (1577)

Parallel to this comes another mail.
Subject: MySQL Backup Log for MY-NethServer - 2022-02-22_03h01m
Content: normal status messages about the successful execution of automysql

What has happened here?

Best regards, Marko

Automysqlbackup stopped working (partial)
#2

I think it’s just a warning. Which mariadb versions do you use?

Here are instructions how to enable the event scheduler:

https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html

1 Like
#3

I use…

[root@MDOL-NethServer rh]# pwd
/opt/rh
[root@MDOL-NethServer rh]# ll
total 0
dr-xr-xr-x 3 root root  59 Jan 15 20:16 rh-mariadb103
dr-xr-xr-x 3 root root  59 Jan 16 15:35 rh-mariadb105
dr-xr-xr-x 6 root root 128 Jan 15 18:48 rh-php73
#4

strangely enough I can log in with mysql and mysql103 but not with mysql105

# mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 219
Server version: 5.5.68-MariaDB MariaDB Server

# mysql103

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9351
Server version: 10.3.28-MariaDB MariaDB Server

# mysql105

-bash: mysql105: command not found

#5

That’s not an issue. AFAIK nethserver-mariadb105 doesn’t provide the mysql105 alias like previous mariadb10 packages.

1 Like