package cacti 0.8.8f+ds1-4ubuntu4 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[gcclinux]

Failed to install on Ubuntu 16.04, this is the message

mysql said: ERROR 1067 (42000) at line 1847: Invalid default value for 'status_fail_date' . Your options are: │
                                                                               │ * abort - Causes the operation to fail; you will need to downgrade, │
                                                                               │ reinstall, reconfigure this package, or otherwise manually intervene │
                                                                               │ to continue using it. This will usually also impact your ability to │
                                                                               │ install other packages until the installation failure is resolved. │
                                                                               │ * retry - Prompts once more with all the configuration questions │
                                                                               │ (including ones you may have missed due to the debconf priority │
                                                                               │ setting) and makes another attempt at performing the operation. │
                                                                               │ * retry (skip questions) - Immediately attempts the operation again, │
                                                                               │ skipping all questions. This is normally useful only if you have │
                                                                               │ solved the underlying problem since the time the error occurred. │
                                                                               │ * ignore - Continues the operation ignoring dbconfig-common errors. │
                                                                               │ This will usually leave this package without a functional database.

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: cacti 0.8.8f+ds1-4ubuntu4
ProcVersionSignature: Ubuntu 4.4.0-22.40-generic 4.4.8
Uname: Linux 4.4.0-22-generic x86_64
NonfreeKernelModules: nvidia_uvm nvidia
ApportVersion: 2.20.1-0ubuntu2
Architecture: amd64
Date: Sun May 22 10:05:47 2016
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2016-04-24 (27 days ago)
InstallationMedia: Ubuntu 16.04 LTS "Xenial Xerus" - Release amd64 (20160420.1)
PackageArchitecture: all
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1
 apt 1.2.10ubuntu1
SourcePackage: cacti
Title: package cacti 0.8.8f+ds1-4ubuntu4 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Paul Gevers (paul-climbing)]

Thanks for the report. The issue is known and the progress is tracked in bug 1578144.