I do not know why it seems off now in mariadb103, probably an upstream change
What does this event ?
I do not know why it seems off now in mariadb103, probably an upstream change
What does this event ?
I tried to set the variable
event_scheduler=ON
MariaDB [(none)]> SET GLOBAL event_scheduler = ON;
ERROR 1146 (42S02): Table 'mysql.event' doesn't exist
MariaDB [(none)]> SHOW PROCESSLIST;
+------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 1329 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 |
+------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
6 rows in set (0.000 sec)
Unsurprisingly the deamon does not run.
So it is a dead end
maybe it is inside automysqlbackup I need to disable it, it is an old project, need to check
Thank you very (!) much
vim /etc/opt/rh/rh-mariadb103/my.cnf.d/mariadb-server.cnf
add in the [server]
event_scheduler = ON
then restart the process
systemctl restart rh-mariadb103-mariadb.service
you can check by
[root@ns7loc9 ~]# mysql103
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.3.28-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> SHOW PROCESSLIST;
+----+-----------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+-----------------+-----------+------+---------+------+--------------------------+------------------+----------+
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 6 | event_scheduler | localhost | NULL | Daemon | 227 | Waiting on empty queue | NULL | 0.000 |
| 10 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 |
+----+-----------------+-----------+------+---------+------+--------------------------+------------------+----------+
7 rows in set (0.000 sec)
MariaDB [(none)]>
then testt with automysqlbackup please
Thank you, I did it.
But I noticed:
================= DO NOT MODIFY THIS FILE =================
Manual changes will be lost when this file is regenerated.
also: event_schedule
is not shown in process list
MariaDB [(none)]> SHOW PROCESSLIST;
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 8 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 |
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
6 rows in set (0.000 sec)
I also tried event_scheduler=ON
in difference to event_scheduler = ON
also:
automysql
and /sbin/e-smith/runmysqlbackup-rh-mariadb103
work as before.
Once modified (yes the change won’t persist a template expand) think to restart the service as I pointed
It works
I did it before and did it again.
It does not work.
MariaDB [(none)]> SHOW PROCESSLIST;
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 8 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 |
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
6 rows in set (0.000 sec)
[root@MDOL-NethServer ~]# cat /etc/opt/rh/rh-mariadb103/my.cnf.d/mariadb-server.cnf
# ================= DO NOT MODIFY THIS FILE =================
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at NethServer official site: https://www.nethserver.org
#
#
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld/mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
#
datadir=/var/opt/rh/rh-mariadb103/lib/mysql
socket=/var/lib/rh-mariadb103/mariadb.sock
log-error=/var/log/rh-mariadb103/mariadb.log
pid-file=/var/run/rh-mariadb103-mariadb/mariadb.pid
event_scheduler = ON
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port=3313
max_allowed_packet=64M
# networking is enabled
#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.3 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.3]