Hello community, here is the log from the commit of package akonadi-server for openSUSE:Factory checked in at 2016-03-26 15:12:39 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/akonadi-server (Old) and /work/SRC/openSUSE:Factory/.akonadi-server.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "akonadi-server" Changes: -------- --- /work/SRC/openSUSE:Factory/akonadi-server/akonadi-server.changes 2016-02-22 10:14:09.000000000 +0100 +++ /work/SRC/openSUSE:Factory/.akonadi-server.new/akonadi-server.changes 2016-03-26 15:12:41.000000000 +0100 @@ -1,0 +2,9 @@ +Sun Mar 13 15:32:26 UTC 2016 - [email protected] + +- Update to KDE Applications 15.12.3 + * KDE Applications 15.12.3 + * https://www.kde.org/announcements/announce-applications-15.12.3.php + * boo#970855 + + +------------------------------------------------------------------- Old: ---- akonadi-15.12.2.tar.xz New: ---- akonadi-15.12.3.tar.xz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ akonadi-server.spec ++++++ --- /var/tmp/diff_new_pack.lwjj1P/_old 2016-03-26 15:12:42.000000000 +0100 +++ /var/tmp/diff_new_pack.lwjj1P/_new 2016-03-26 15:12:42.000000000 +0100 @@ -17,7 +17,7 @@ Name: akonadi-server -Version: 15.12.2 +Version: 15.12.3 Release: 0 %define rname akonadi Summary: PIM Storage Service ++++++ akonadi-15.12.2.tar.xz -> akonadi-15.12.3.tar.xz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/akonadi-15.12.2/src/server/storage/dbupdate.xml new/akonadi-15.12.3/src/server/storage/dbupdate.xml --- old/akonadi-15.12.2/src/server/storage/dbupdate.xml 2016-01-28 13:00:07.000000000 +0100 +++ new/akonadi-15.12.3/src/server/storage/dbupdate.xml 2016-03-11 01:10:30.000000000 +0100 @@ -256,4 +256,64 @@ WHERE PimItemTable.id IS NULL) </raw-sql> </update> + <!-- + Update 31 fixes missing constraints on relation tables in MySQL. + We cannot just let DbInitializer create the foreign keys there, because data + in the relation tables might reference rows from other tables that no longer + exist. + --> + <update version="31" abortOnFailure="false"> + <!-- PimItemFlagRelation --> + <raw-sql backends="mysql">DELETE FROM PimItemFlagRelation WHERE pimItem_id IN ( + SELECT id FROM ( + SELECT pimItem_id AS id FROM PimItemFlagRelation + LEFT JOIN PimItemTable ON PimItemFlagRelation.pimItem_id = PimItemTable.id + WHERE PimItemTable.id IS NULL) x) + </raw-sql> + <raw-sql backends="mysql">DELETE FROM PimItemFlagRelation WHERE flag_id IN ( + SELECT id FROM ( + SELECT flag_id AS id FROM PimItemFlagRelation + LEFT JOIN FlagTable ON PimItemFlagRelation.flag_id = FlagTable.id + WHERE FlagTable.id IS NULL) x) + </raw-sql> + <!-- PimItemTagRelation --> + <raw-sql backends="mysql">DELETE FROM PimItemTagRelation WHERE pimItem_id IN ( + SELECT id FROM ( + SELECT pimItem_id AS id FROM PimItemTagRelation + LEFT JOIN PimItemTable ON PimItemTagRelation.pimItem_id = PimItemTable.id + WHERE PimItemTable.id IS NULL) x) + </raw-sql> + <raw-sql backends="mysql">DELETE FROM PimItemTagRelation WHERE tag_id IN ( + SELECT id FROM ( + SELECT tag_id AS id FROM PimItemTagRelation + LEFT JOIN TagTable ON PimItemTagRelation.tag_id = TagTable.id + WHERE TagTable.id IS NULL) x) + </raw-sql> + <!-- CollectionMimeTypeRelation --> + <raw-sql backends="mysql">DELETE FROM CollectionMimeTypeRelation WHERE collection_id IN ( + SELECT id FROM ( + SELECT collection_id AS id FROM CollectionMimeTypeRelation + LEFT JOIN CollectionTable ON CollectionMimeTypeRelation.collection_id = CollectionTable.id + WHERE CollectionTable.id IS NULL) x) + </raw-sql> + <raw-sql backends="mysql">DELETE FROM CollectionMimeTypeRelation WHERE mimeType_id IN ( + SELECT id FROM ( + SELECT mimeType_id AS id FROM CollectionMimeTypeRelation + LEFT JOIN MimeTypeTable ON CollectionMimeTypeRelation.mimeType_id = MimeTypeTable.id + WHERE MimeTypeTable.id IS NULL) x) + </raw-sql> + <!-- CollectionPimItemRelation --> + <raw-sql backends="mysql">DELETE FROM CollectionPimItemRelation WHERE collection_id IN ( + SELECT id FROM ( + SELECT collection_id AS id FROM CollectionPimItemRelation + LEFT JOIN CollectionTable ON CollectionPimItemRelation.collection_id = CollectionTable.id + WHERE CollectionTable.id IS NULL) x) + </raw-sql> + <raw-sql backends="mysql">DELETE FROM CollectionPimItemRelation WHERE pimItem_id IN ( + SELECT id FROM ( + SELECT pimItem_id AS id FROM CollectionPimItemRelation + LEFT JOIN PimItemTable ON CollectionPimItemRelation.pimItem_id = PimItemTable.id + WHERE PimItemTable.id IS NULL) x) + </raw-sql> + </update> </updates> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/akonadi-15.12.2/src/server/storage/mysql-global.conf new/akonadi-15.12.3/src/server/storage/mysql-global.conf --- old/akonadi-15.12.2/src/server/storage/mysql-global.conf 2016-01-28 13:00:07.000000000 +0100 +++ new/akonadi-15.12.3/src/server/storage/mysql-global.conf 2016-03-11 01:10:30.000000000 +0100 @@ -37,9 +37,9 @@ # use InnoDB for transactions and better crash recovery default_storage_engine=innodb -# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M) -# Deprecated in MySQL >= 5.6.3 -innodb_additional_mem_pool_size=1M +# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:8M) +# Deprecated in MySQL >= 5.6.3, removed in 5.7 (works in MariaDB) +# innodb_additional_mem_pool_size=8M # memory buffer InnoDB uses to cache data and indexes of its tables (default:128M) # Larger values means less I/O
