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

Reply via email to