postinst is fragile, hanging on error

[Robie Basak]

See bug 1567695. In 5.7.11-0ubuntu4 (and ubuntu5), we're using mysqld --init-file with a SHUTDOWN at the end. But it seems that if a previous command fails, the SHUTDOWN never runs and the postinst hangs.

Is there a better way to do this so that the postinst will correctly fail on an SQL command error, instead of hanging?

[Lars Tangvald (lars-tangvald)]

Will look into this some more.
Some of the more fragile commands (setting the auth_socket plugin is prone to this if installing the plugin fails for some reason) could be run using a normal client instead.

[Lars Tangvald (lars-tangvald)]

One way of solving this is to run the commands inside a created procedure which defines a no-op exception handler. But init-file + procedures are very picky about syntax, so making a general solution is tricky.

[Robie Basak (racb)]

We no longer have a use case where this actually fails, so let's put it in the backlog but not important to users to fix right now.