[gentoo-commits] proj/kde:master commit in: kde-apps/akonadi/

["Andreas Sturmlechner" <asturm@gentoo.org>]

commit:     b7b95f71ddff77ab067caba16374081b4949f8d0
Author:     Andreas Sturmlechner <asturm <AT> gentoo <DOT> org>
AuthorDate: Tue Jul 23 18:49:27 2019 +0000
Commit:     Andreas Sturmlechner <asturm <AT> gentoo <DOT> org>
CommitDate: Wed Jul 24 11:29:25 2019 +0000
URL:        https://gitweb.gentoo.org/proj/kde.git/commit/?id=b7b95f71

kde-apps/akonadi: Warn users about the trouble with USE mysql

External DBs can't be fixed automatically, and >=mariadb-10.4 still can't
be upgraded automatically, at least add warnings that hopefully will be read.

Bug: https://bugs.gentoo.org/688746
Package-Manager: Portage-2.3.69, Repoman-2.3.16
Signed-off-by: Andreas Sturmlechner <asturm <AT> gentoo.org>

 kde-apps/akonadi/akonadi-19.07.80.ebuild      | 22 ++++++++++++++++++++++
 kde-apps/akonadi/akonadi-19.08.49.9999.ebuild | 22 ++++++++++++++++++++++
 kde-apps/akonadi/akonadi-9999.ebuild          | 22 ++++++++++++++++++++++
 3 files changed, 66 insertions(+)

diff --git a/kde-apps/akonadi/akonadi-19.07.80.ebuild b/kde-apps/akonadi/akonadi-19.07.80.ebuild
index f8fd5fa4cf..18abc722e0 100644
--- a/kde-apps/akonadi/akonadi-19.07.80.ebuild
+++ b/kde-apps/akonadi/akonadi-19.07.80.ebuild
@@ -70,6 +70,28 @@ pkg_setup() {
 	use postgres && DRIVER="QPSQL"
 	use mysql && DRIVER="QMYSQL"
 
+	if use mysql; then
+		ewarn "If using an Akonadi external QMYSQL DB without lower_case_table_names=1,"
+		ewarn "${CATEGORY}/${PN}-19.04.3 and later may fail to start. Running without"
+		ewarn "that option was never supported but not enforced by the setup GUI."
+		ewarn
+		ewarn "Manual steps are required to fix it, see also:"
+		ewarn "  https://bugs.kde.org/show_bug.cgi?id=409753 (comment #4)"
+		ewarn
+	fi
+
+	if use mysql && has_version ">=dev-db/mariadb-10.4"; then
+		ewarn "If an existing Akonadi QMYSQL database is being upgraded using"
+		ewarn ">=dev-db/mariadb-10.4 and KMail stops fetching and sending mail,"
+		ewarn "check ~/.local/share/akonadi/akonadiserver.error for errors like:"
+		ewarn "  \"Cannot add or update a child row: a foreign key constraint fails\""
+		ewarn
+		ewarn "Manual steps are required to fix it, see also:"
+		ewarn "  https://bugs.gentoo.org/688746 (see Whiteboard)"
+		ewarn "  https://bugs.kde.org/show_bug.cgi?id=409224"
+		ewarn
+	fi
+
 	if use sqlite || has_version "<${CATEGORY}/${P}[sqlite]"; then
 		ewarn "We strongly recommend you change your Akonadi database backend to either MySQL"
 		ewarn "or PostgreSQL in your user configuration."

diff --git a/kde-apps/akonadi/akonadi-19.08.49.9999.ebuild b/kde-apps/akonadi/akonadi-19.08.49.9999.ebuild
index 9070a6e386..deb486dea5 100644
--- a/kde-apps/akonadi/akonadi-19.08.49.9999.ebuild
+++ b/kde-apps/akonadi/akonadi-19.08.49.9999.ebuild
@@ -70,6 +70,28 @@ pkg_setup() {
 	use postgres && DRIVER="QPSQL"
 	use mysql && DRIVER="QMYSQL"
 
+	if use mysql; then
+		ewarn "If using an Akonadi external QMYSQL DB without lower_case_table_names=1,"
+		ewarn "${CATEGORY}/${PN}-19.04.3 and later may fail to start. Running without"
+		ewarn "that option was never supported but not enforced by the setup GUI."
+		ewarn
+		ewarn "Manual steps are required to fix it, see also:"
+		ewarn "  https://bugs.kde.org/show_bug.cgi?id=409753 (comment #4)"
+		ewarn
+	fi
+
+	if use mysql && has_version ">=dev-db/mariadb-10.4"; then
+		ewarn "If an existing Akonadi QMYSQL database is being upgraded using"
+		ewarn ">=dev-db/mariadb-10.4 and KMail stops fetching and sending mail,"
+		ewarn "check ~/.local/share/akonadi/akonadiserver.error for errors like:"
+		ewarn "  \"Cannot add or update a child row: a foreign key constraint fails\""
+		ewarn
+		ewarn "Manual steps are required to fix it, see also:"
+		ewarn "  https://bugs.gentoo.org/688746 (see Whiteboard)"
+		ewarn "  https://bugs.kde.org/show_bug.cgi?id=409224"
+		ewarn
+	fi
+
 	if use sqlite || has_version "<${CATEGORY}/${P}[sqlite]"; then
 		ewarn "We strongly recommend you change your Akonadi database backend to either MySQL"
 		ewarn "or PostgreSQL in your user configuration."

diff --git a/kde-apps/akonadi/akonadi-9999.ebuild b/kde-apps/akonadi/akonadi-9999.ebuild
index 9070a6e386..deb486dea5 100644
--- a/kde-apps/akonadi/akonadi-9999.ebuild
+++ b/kde-apps/akonadi/akonadi-9999.ebuild
@@ -70,6 +70,28 @@ pkg_setup() {
 	use postgres && DRIVER="QPSQL"
 	use mysql && DRIVER="QMYSQL"
 
+	if use mysql; then
+		ewarn "If using an Akonadi external QMYSQL DB without lower_case_table_names=1,"
+		ewarn "${CATEGORY}/${PN}-19.04.3 and later may fail to start. Running without"
+		ewarn "that option was never supported but not enforced by the setup GUI."
+		ewarn
+		ewarn "Manual steps are required to fix it, see also:"
+		ewarn "  https://bugs.kde.org/show_bug.cgi?id=409753 (comment #4)"
+		ewarn
+	fi
+
+	if use mysql && has_version ">=dev-db/mariadb-10.4"; then
+		ewarn "If an existing Akonadi QMYSQL database is being upgraded using"
+		ewarn ">=dev-db/mariadb-10.4 and KMail stops fetching and sending mail,"
+		ewarn "check ~/.local/share/akonadi/akonadiserver.error for errors like:"
+		ewarn "  \"Cannot add or update a child row: a foreign key constraint fails\""
+		ewarn
+		ewarn "Manual steps are required to fix it, see also:"
+		ewarn "  https://bugs.gentoo.org/688746 (see Whiteboard)"
+		ewarn "  https://bugs.kde.org/show_bug.cgi?id=409224"
+		ewarn
+	fi
+
 	if use sqlite || has_version "<${CATEGORY}/${P}[sqlite]"; then
 		ewarn "We strongly recommend you change your Akonadi database backend to either MySQL"
 		ewarn "or PostgreSQL in your user configuration."