Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[Solved] Kmail/Akonadi/Mysql problem
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Desktop Environments
View previous topic :: View next topic  
Author Message
leifbk
Guru
Guru


Joined: 05 Jan 2004
Posts: 379
Location: Bærum, Norway

PostPosted: Mon Jul 01, 2019 10:05 am    Post subject: [Solved] Kmail/Akonadi/Mysql problem Reply with quote

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 8O
_________________
Grumpy old man
Back to top
View user's profile Send private message
leifbk
Guru
Guru


Joined: 05 Jan 2004
Posts: 379
Location: Bærum, Norway

PostPosted: Mon Jul 01, 2019 10:37 am    Post subject: Reply with quote

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
View user's profile Send private message
asturm
Developer
Developer


Joined: 05 Apr 2007
Posts: 7428
Location: Austria

PostPosted: Mon Jul 01, 2019 10:39 am    Post subject: Reply with quote

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
View user's profile Send private message
leifbk
Guru
Guru


Joined: 05 Jan 2004
Posts: 379
Location: Bærum, Norway

PostPosted: Mon Jul 01, 2019 10:51 am    Post subject: Reply with quote

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
View user's profile Send private message
asturm
Developer
Developer


Joined: 05 Apr 2007
Posts: 7428
Location: Austria

PostPosted: Mon Jul 01, 2019 10:58 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Desktop Environments All times are GMT
Page 1 of 1

 
Jump to:  
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