Public bug reported: Running mariadb in a galera cluster requires state synchronisation with the other cluster members on startup. This takes a couple of minutes in my case but could easily be (much) longer. The systemctl command waits for the process to finish, but the default timeout of 90 seconds is too short and the process gets aborted leading to a corrupted database (at least for that member).
I've remedied this by setting an explicit long timeout in the unit file: systemctl edit --full mariadb and setting the property TimeoutStartSec=900 But this is a bit of a kludge. Maybe systemd should leave the process running and not wait for anything particular to happen... ProblemType: Bug DistroRelease: Ubuntu 18.04 Package: mariadb-server-10.1 1:10.1.34-0ubuntu0.18.04.1 ProcVersionSignature: Ubuntu 4.15.0-42.45-generic 4.15.18 Uname: Linux 4.15.0-42-generic x86_64 ApportVersion: 2.20.9-0ubuntu7.5 Architecture: amd64 Date: Thu Jan 30 15:07:07 2020 Logs.var.log.daemon.log: Logs.var.log.mysql.error.log: MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql] MySQLConf.etc.mysql.conf.d.mysqldump.cnf: [mysqldump] quick quote-names max_allowed_packet = 16M MySQLVarLibDirListing: ['vaars-34.log', 'ib_logfile1', 'neutron', 'nova_exp', 'glance', 'performance_schema', 'tc.log', 'vaars-34.pid', 'nova_api_exp', 'galera.cache', 'multi-master.info', 'cinder', 'nova_api', 'ibdata1', 'keystone_exp', 'grastate.dat', 'neutron_exp', 'aria_log.00000001', 'nova_cell0', 'mysql_upgrade_info', 'keystone', 'cinder_exp', 'glance_exp', 'ib_logfile0', 'mysql', 'debian-10.1.flag', 'gvwstate.dat', 'aria_log_control', 'nova'] SourcePackage: mariadb-10.1 UpgradeStatus: No upgrade log present (probably fresh install) ** Affects: mariadb-10.1 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug bionic -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1861411 Title: systemd unit startup timeout too short To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1861411/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs