mysql timeoutsec results in killing mysql process

Bug #1882527 reported by Warwick Bruce Chapman on 2020-06-08
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-8.0 (Ubuntu)
High
Unassigned
Bionic
Medium
Unassigned
Eoan
Medium
Unassigned
Focal
Medium
Unassigned

Bug Description

MySQL on 20.04 has TimeoutSec set to 600 (IIRC) in the systemd script. This has the effect of killing the MySQL process if this timeout is reached.

IMHO this is a Very Bad Idea. A database server process should only be force killed by a user action.

I would prefer that the server had unlimited time to cleanly shutdown and startup (eg if recovering).

Our DB is about 500GB with some very large tables (for us at least) eg. 250GB and we've had more than a few unfortunate delays as a result of delayed startup caused by recoveries because MySQL was killed prematurely.

Because MySQL 8.0 has reduced the default logging level, it was not clear to me that the process was being force killed.

I believe the MySQL team are of the same view as me per https://bugs.mysql.com/bug.php?id=91423:

```
[12 Jul 2019 15:57] Paul Dubois
Posted by developer:

Fixed in 8.0.18.

On Debian, long InnoDB recovery times at startup could cause systemd
service startup failure. The default systemd service timeout is now
disabled (consistent with RHEL) to prevent this from happening.
```

I see I have created this bug report in xorg instead of MySQL. Please accept my apology and either move or delete. I am happy to recreate, just tell me which.

affects: xorg-server (Ubuntu) → mysql-8.0 (Ubuntu)
tags: added: focal

Thanks Daniel.

Balint Harmath (bharmath) wrote :

The vendor is working on it - we can assist to that.

Changed in mysql-8.0 (Ubuntu):
status: New → Confirmed
no longer affects: mysql-8.0 (Ubuntu Groovy)
Changed in mysql-8.0 (Ubuntu Focal):
status: New → Triaged
Changed in mysql-8.0 (Ubuntu Eoan):
status: New → Triaged
Changed in mysql-8.0 (Ubuntu Bionic):
status: New → Triaged
importance: Undecided → Medium
Changed in mysql-8.0 (Ubuntu Eoan):
importance: Undecided → Medium
Changed in mysql-8.0 (Ubuntu Focal):
importance: Undecided → Medium
Changed in mysql-8.0 (Ubuntu):
importance: Undecided → High
tags: added: server-next
Robie Basak (racb) on 2020-06-15
tags: added: bitesize
Brian Murray (brian-murray) wrote :

The Eoan Ermine has reached end of life, so this bug will not be fixed for that release

Changed in mysql-8.0 (Ubuntu Eoan):
status: Triaged → Won't Fix
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers