View previous topic :: View next topic |
Author |
Message |
leifbk Guru


Joined: 05 Jan 2004 Posts: 379 Location: Bærum, Norway
|
Posted: Mon Jul 01, 2019 10:05 am Post subject: [Solved] Kmail/Akonadi/Mysql problem |
|
|
Does anybody have any idea about what's going on here:
Code: | leif@balapapa ~ $ akonadictl restart
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
leif@balapapa ~ $ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
akonadi.collectionattributetable OK
akonadi.collectionmimetyperelation OK
akonadi.collectionpimitemrelation OK
akonadi.collectiontable OK
akonadi.flagtable OK
akonadi.mimetypetable OK
akonadi.parttable OK
akonadi.parttypetable OK
akonadi.pimitemflagrelation OK
akonadi.pimitemtable OK
akonadi.pimitemtagrelation OK
akonadi.relationtable OK
akonadi.relationtypetable OK
akonadi.resourcetable OK
akonadi.schemaversiontable OK
akonadi.tagattributetable OK
akonadi.tagremoteidresourcerelationtable OK
akonadi.tagtable OK
akonadi.tagtypetable OK
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: DB initializer done
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8003a00) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8003220) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a801c360) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8025b30) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a802f120) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8038780) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8041980) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8003220) identified as "ETMCalendarMonitor - 94017444490016"
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8053bc0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a805d780) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a806ebb0) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a801c360) identified as "SpecialCollectionsMonitor - 94217929201360"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8003a00) identified as "KMail Kernel ETM - 94217928959600"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8025b30) identified as "MessageListTagMonitor - 94217930360880"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a802f120) identified as "MessageViewerMonitor - 94217931105904"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8038780) identified as "TagActionManagerMonitor - 94217930605616"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8041980) identified as "FilterManagerTagMonitor - 94217976313808"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8053bc0) identified as "MessageListTagCacheMonitor - 140696015105856"
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80ab1b0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8002d10) )
QDBusConnection: name 'org.freedesktop.Akonadi.Control' had owner '' but we thought it was ':1.142'
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80c6c00) )
org.kde.pim.akonadiserver: Subscriber "" disconnected
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80cfa10) )
org.kde.pim.akonadiserver: Subscriber "" disconnected
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a806ebb0) identified as "SpecialCollectionsMonitor - 94309656547664"
QDBusConnection: name 'org.freedesktop.Akonadi.Control' had owner '' but we thought it was ':1.142'
QDBusConnection: name 'org.freedesktop.Akonadi.Control' had owner '' but we thought it was ':1.142'
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a806ebb0) identified as "SpecialCollectionsMonitor - 94309656547664"
org.kde.pim.akonadiserver: Cannot connect to agent instance with identifier 'akonadi_akonotes_resource_0', error message: ''
org.kde.pim.akonadiserver: Cannot connect to agent instance with identifier 'akonadi_akonotes_resource_0', error message: ''
org.kde.pim.akonadiserver: NotificationSubscriber for "SpecialCollectionsMonitor - 94309656547664" : timeout writing into stream
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a806ebb0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80d1630) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80d0de0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80d2150) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80d2fb0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80d3e40) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a80fd440) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8106530) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a810f620) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8118710) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8121800) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a812a8f0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a81339e0) )
org.kde.pim.akonadiserver: Subscriber "" disconnected
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a813cad0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8152be0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a814ec30) )
org.kde.pim.akonadiserver: Subscriber "" disconnected
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a814f820) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a81514c0) )
org.kde.pim.akonadiserver: Subscriber "" disconnected
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8151c70) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a816fc30) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a816bc80) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a816c7d0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a816d9a0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a816c670) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7ff3a8188320) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80ab1b0) identified as "AgentBaseChangeRecorder - 94903261499760"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8002d10) identified as "AgentBaseChangeRecorder - 94088249849088"
org.kde.pim.akonadiserver: Subscriber "AgentBaseChangeRecorder - 94088249849088" disconnected
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80cfa10) identified as "akonadi_maildispatcher_agent - 94309656434480"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80cfa10) identified as "akonadi_maildispatcher_agent - 94309656434480"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80c6c00) identified as "AgentBaseChangeRecorder - 94309656467408"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80d1630) identified as "AgentBaseChangeRecorder - 94665172362272"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80d0de0) identified as "AgentBaseChangeRecorder - 93899329045728"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80d2150) identified as "AgentBaseChangeRecorder - 94349594759776"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80d2fb0) identified as "AgentBaseChangeRecorder - 94532316562400"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80d3e40) identified as "AgentBaseChangeRecorder - 94064443085712"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a80fd440) identified as "AgentBaseChangeRecorder - 93988508996176"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8106530) identified as "AgentBaseChangeRecorder - 94512029493216"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a810f620) identified as "AgentBaseChangeRecorder - 94621078480032"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8118710) identified as "AgentBaseChangeRecorder - 94059238311376"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8121800) identified as "AgentBaseChangeRecorder - 94088249849088"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a812a8f0) identified as "AgentBaseChangeRecorder - 93948970690672"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a81339e0) identified as "AgentBaseChangeRecorder - 94123424555760"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8152be0) identified as "Archive Mail Kernel ETM - 94665172476880"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a814ec30) identified as "ArchiveMailCollectionMonitor - 94665172538896"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a81514c0) identified as "KNotes Session - 94532316631712"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a816fc30) identified as "MailFilter Kernel ETM - 94064443214672"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a816bc80) identified as "FilterManagerTagMonitor - 94064439894832"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a816c7d0) identified as "MailFilterCollectionMonitor - 94064443773408"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a816d9a0) identified as "MailFilterItemMonitor - 140608572397376"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a816c670) identified as "UnifiedMailboxChangeRecorder - 94512029499728"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7ff3a8188320) identified as "SpecialCollectionsMonitor - 94064444000912"
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver: Error code: "1452"
org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 78883))(":1", QVariant(qlonglong, 11))(":2", QVariant(QByteArray, ""))(":3", QVariant(qlonglong, 7107))(":4", QVariant(int, 1))(":5", QVariant(int, 1)))
org.kde.pim.akonadiserver: Query: "INSERT INTO PartTable (pimItemId, partTypeId, data, datasize, version, storage) VALUES (:0, :1, :2, :3, :4, :5)"
org.kde.pim.akonadiserver: Error during insertion into table "PartTable" "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver: Error while handling command CreateItem on connection akonadi_pop3_resource_21 (0x56520f70f660)
org.kde.pim.pop3resource: ============== ERROR DURING POP3 SYNC ==========================
org.kde.pim.pop3resource: "Klarer ikke lagre meldinger som er lasted ned.\nFailed to insert new part fo PimItem 78883 into database." |
Seems like I'm unable to receive new email  _________________ Grumpy old man |
|
Back to top |
|
 |
leifbk Guru


Joined: 05 Jan 2004 Posts: 379 Location: Bærum, Norway
|
Posted: Mon Jul 01, 2019 10:37 am Post subject: |
|
|
I read the other Akonadi related post here and did:
Code: | balapapa ~ # echo ">=dev-db/mariadb-10.4" >> /etc/portage/package.mask
balapapa ~ # emerge -av mariadb
balapapa ~ # /etc/init.d/mysql restart |
and then
Code: | leif@balapapa ~ $ akonadictl restart |
And the email came back.
While I'm using PostgreSQL and SQLite all the time, I have tried to forget everything I knew about Mysql/Mariadb, and don't even know how to log into it as admin on my system.. I hope that Kmail 3 will feature an option to get rid of the blasted Mysql database storage. _________________ Grumpy old man |
|
Back to top |
|
 |
asturm Developer


Joined: 05 Apr 2007 Posts: 8053 Location: Austria
|
Posted: Mon Jul 01, 2019 10:39 am Post subject: |
|
|
But kmail/akonadi works very well with postgresql backend
Since your solution is really only a workaround, here is the bug with a fix to make it work after 10.4 upgrade: https://bugs.gentoo.org/688746 _________________ backend.cpp:92:2: warning: #warning TODO - this error message is about as useful as a cooling unit in the arctic |
|
Back to top |
|
 |
leifbk Guru


Joined: 05 Jan 2004 Posts: 379 Location: Bærum, Norway
|
Posted: Mon Jul 01, 2019 10:51 am Post subject: |
|
|
asturm wrote: | But kmail/akonadi works very well with postgresql backend  |
Oh, I didn't know. Is there an easy way to migrate my settings and messages to the PostgreSQL backend? I've got lots of old mail all the way back to 2004.
asturm wrote: | Since your solution is really only a workaround, here is the bug with a fix to make it work after 10.4 upgrade: https://bugs.gentoo.org/688746 |
I may be a little dense, but is this what you mean?
Code: | Whiteboard: workaround: mysql_upgrade --socket=/tmp/akonadi-${USER}.XXXXX/mysql.socket |
I have no idea how it should be run. Please explain for a plain random user. _________________ Grumpy old man |
|
Back to top |
|
 |
asturm Developer


Joined: 05 Apr 2007 Posts: 8053 Location: Austria
|
Posted: Mon Jul 01, 2019 10:58 am Post subject: |
|
|
leifbk wrote: | Oh, I didn't know. Is there an easy way to migrate my settings and messages to the PostgreSQL backend? I've got lots of old mail all the way back to 2004. |
I have never done it, but it would probably involve backing up all data using Tools -> Import/Export KMail data, then after switching to QPSQL backend importing it back. But you may want to search the web for confirmatory reports, and you definitely want to keep a backup of your data.
leifbk wrote: | Code: | Whiteboard: workaround: mysql_upgrade --socket=/tmp/akonadi-${USER}.XXXXX/mysql.socket |
I have no idea how it should be run. Please explain for a plain random user. |
You run the command in your favorite terminal emulator, ${USER} would be your current login username, XXXXX would be some incomprehensible alphanumerical string. You would easily find the complete path just using tab completion in the terminal, there should only exist exactly one for your user. _________________ backend.cpp:92:2: warning: #warning TODO - this error message is about as useful as a cooling unit in the arctic |
|
Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|