Bug#843525: kaddressbook: Same issue after upgrading from jessie to stretch
Package: kaddressbook
Version: 4:16.04.3-3
Followup-For: Bug #843525
Dear Maxy,
I think I hit the same issue on my system after upgrading from jessie
to stretch, before following the procedure above I give you a chance
to review, maybe it helps to find out what needs to be done to help
other jessie users who have not yet upgraded:
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
akonadiprivate_log: search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
Using mysqld: "/usr/sbin/mysqld-akonadi"
mysqld reports version 5.5.54 (Oracle MySQL)
Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/home/test/.local/share/akonadi/mysql.conf --datadir=/home/test/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-test.7MgEGb/mysql.socket"
akonadicore_log: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
akonadicore_log: Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
Executing: "/usr/bin/mysqlcheck" "--defaults-file=/home/test/.local/share/akonadi/mysql.conf --check-upgrade --auto-repair --socket=/tmp/akonadi-test.7MgEGb/mysql.socket akonadi"
akonadi.collectiontable OK
akonadi.mimetypetable OK
akonadi.resourcetable OK
akonadi.schemaversiontable OK
MySQL version OK (required "5.1" , available "5.5" )
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
"CREATE TABLE PimItemTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, rev INTEGER NOT NULL DEFAULT 0, remoteId VARBINARY(255), remoteRevision VARBINARY(255), gid VARBINARY(255), collectionId BIGINT, mimeTypeId BIGINT, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, dirty BOOL, size BIGINT NOT NULL DEFAULT 0, FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8"
"\nSql error: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause QMYSQL: Unable to execute query\nQuery: CREATE TABLE PimItemTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, rev INTEGER NOT NULL DEFAULT 0, remoteId VARBINARY(255), remoteRevision VARBINARY(255), gid VARBINARY(255), collectionId BIGINT, mimeTypeId BIGINT, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, dirty BOOL, size BIGINT NOT NULL DEFAULT 0, FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8"
Unable to initialize database.
terminating service threads
terminating connection threads
stopping db process
Application 'akonadiserver' exited normally...
akonadicore_log: "Unknown error."
akonadicore_log: Job error: "Unknown error." for collection: QVector()
State of akonadi-backend-mysql:
blackbox:~# apt-cache policy akonadi-backend-mysql
akonadi-backend-mysql:
Installiert: 4:16.04.3-4
Installationskandidat: 4:16.04.3-4
Versionstabelle:
*** 4:16.04.3-4 500
500 http://ftp-stud.fht-esslingen.de/debian stretch/main i386 Packages
500 http://ftp-stud.fht-esslingen.de/debian stretch/main amd64 Packages
300 http://ftp-stud.fht-esslingen.de/debian sid/main i386 Packages
300 http://ftp-stud.fht-esslingen.de/debian sid/main amd64 Packages
100 /var/lib/dpkg/status
1.13.0-2+deb8u2 500
500 http://ftp-stud.fht-esslingen.de/debian jessie/main i386 Packages
500 http://ftp-stud.fht-esslingen.de/debian jessie/main amd64 Packages
1.13.0-2+deb8u1 500
500 http://snapshot.debian.org/archive/debian/20160901T042215Z jessie/main i386 Packages
500 http://snapshot.debian.org/archive/debian/20160901T042215Z jessie/main amd64 Packages
blackbox:~#
One reason could be that mysql was not updated properly
blackbox:~# apt-cache policy mysql-server-core-5.5
mysql-server-core-5.5:
Installiert: 5.5.54-0+deb8u1
Installationskandidat: 5.5.54-0+deb8u1
Versionstabelle:
*** 5.5.54-0+deb8u1 450
450 http://ftp-stud.fht-esslingen.de/debian jessie-proposed-updates/main i386 Packages
100 /var/lib/dpkg/status
5.5.53-0+deb8u1 500
500 http://ftp-stud.fht-esslingen.de/debian jessie/main i386 Packages
5.5.49-0+deb8u1 500
500 http://snapshot.debian.org/archive/debian/20160901T042215Z jessie/main i386 Packages
blackbox:~# apt-cache policy mariadb-server-core-10.1
mariadb-server-core-10.1:
Installiert: (keine)
Installationskandidat: 10.1.22-3
Versionstabelle:
10.1.22-3 500
500 http://ftp-stud.fht-esslingen.de/debian stretch/main i386 Packages
300 http://ftp-stud.fht-esslingen.de/debian sid/main i386 Packages
blackbox:~#
-- System Information:
Debian Release: 9.0
APT prefers testing
APT policy: (500, 'testing'), (500, 'stable'), (450, 'proposed-updates'), (300, 'unstable'), (250, 'experimental')
Architecture: i386 (i686)
Foreign Architectures: amd64
Kernel: Linux 4.9.0-2-686-pae (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages kaddressbook depends on:
ii kio 5.28.0-2
ii libc6 2.24-9
ii libgcc1 1:6.3.0-12
ii libkf5akonadicontact5 4:16.04.2-2
ii libkf5akonadicore5 4:16.04.3-4
ii libkf5akonadisearchdebug5 16.04.3-1+b2
ii libkf5akonadiwidgets5 4:16.04.3-4
ii libkf5completion5 5.28.0-1
ii libkf5configcore5 5.28.0-2
ii libkf5configgui5 5.28.0-2
ii libkf5configwidgets5 5.28.0-2
ii libkf5contacts5 16.04.2-1
ii libkf5coreaddons5 5.28.0-2
ii libkf5gpgmepp-pthread5 16.04.3-2+b2
ii libkf5grantleetheme-plugins 16.04.3-1
ii libkf5grantleetheme5 16.04.3-1
ii libkf5i18n5 5.28.0-2
ii libkf5iconthemes5 5.28.0-2
ii libkf5itemmodels5 5.28.0-2
ii libkf5jobwidgets5 5.28.0-2
ii libkf5kaddressbookgrantlee5 4:16.04.2-2
ii libkf5kcmutils5 5.28.0-2
ii libkf5kdelibs4support5 5.28.0-1
ii libkf5kiocore5 5.28.0-2
ii libkf5kiowidgets5 5.28.0-2
ii libkf5kontactinterface5 16.04.2-1
ii libkf5libkdepim-plugins 4:16.04.2-3
ii libkf5libkdepim5 4:16.04.2-3
ii libkf5parts5 5.28.0-1
ii libkf5pimcommon-plugins 4:16.04.2-2
ii libkf5pimcommon5 4:16.04.2-2
ii libkf5qgpgme5 16.04.3-2+b2
ii libkf5widgetsaddons5 5.28.0-2
ii libkf5xmlgui5 5.28.0-1
ii libqt5core5a 5.7.1+dfsg-3+b1
ii libqt5dbus5 5.7.1+dfsg-3+b1
ii libqt5gui5 5.7.1+dfsg-3+b1
ii libqt5printsupport5 5.7.1+dfsg-3+b1
ii libqt5widgets5 5.7.1+dfsg-3+b1
ii libstdc++6 6.3.0-12
kaddressbook recommends no packages.
kaddressbook suggests no packages.
-- no debconf information
Reply to: