Results 1 to 8 of 8

Thread: Akonadi laat KMail crashen na update.

  1. #1
    Join Date
    Nov 2018
    Location
    Somwhere in the lowlands
    Posts
    85

    Default Akonadi laat KMail crashen na update.

    Tumbleweed + KDE

    Beste mede forumleden, wellicht dat iemand mij uit de brand kan helpen met dit probleem.

    KMail start niet meer door Akonadi crash.
    Dit gebeurde tijdens een Yast2 update bij terugkomst in onze timezone waarbij tijdens de update de systeemklok automatisch werd reset.


    Akonadi melde eerst met een kolom pop-ups voor iedere mailaccount:

    Hulpbron ...accountnaam... is gebroken.
    Unable to start.

    Vervolgens krijg ik de mogelijkheid de Akonadie persoonlijke informatiebeheerder te starten (die start niet).

    Starten dat biedt geen soelaas.

    Dit gebeurde gisteren.

    Vandaag bij opstarten duurde het minuten voordat KMail opende.
    Uiteindelijk verschijnen de 12 e-mailboxen en het lijkt er ook op dat KMail de mail ophaalt (IMAP)

    Dan verschijnt vrijwel gelijktijdig met de lijst e-mailboxen een pop-up met de mededeling:

    Het emailprogramma kwam een fatale fout tegen en zal nu worden afgesloten.
    De fout was:
    Unable to retreive collection of listing.


    Please HELP?

    Hieronder het crash report, de backtrace:

    -- Backtrace:
    Application: Akonadi Server (akonadiserver), signal: Aborted

    [KCrash Handler]
    #4 0x00007f0b9363a4b1 in raise () from /lib64/libc.so.6
    #5 0x00007f0b93623539 in abort () from /lib64/libc.so.6
    #6 0x00007f0b93881876 in ?? () from /usr/lib64/libstdc++.so.6
    #7 0x00007f0b9388d0fc in ?? () from /usr/lib64/libstdc++.so.6
    #8 0x00007f0b9388d167 in std::terminate() () from /usr/lib64/libstdc++.so.6
    #9 0x00007f0b9388d419 in __cxa_throw () from /usr/lib64/libstdc++.so.6
    #10 0x0000561c08794a3f in Akonadi::Server::DbIntrospector::hasIndex (this=<optimized out>, tableName=..., indexName=...) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/server/storage/dbintrospector.cpp:56
    #11 0x0000561c0883ab35 in Akonadi::Server::DbInitializer::checkIndexes (this=0x561c0929e050, tableDescription=...) at /usr/include/qt5/QtCore/qsharedpointer_impl.h:306
    #12 0x0000561c08815ce6 in Akonadi::Server::DbInitializer::updateIndexesAndConstraints (this=0x561c0929e050) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/server/storage/dbinitializer.cpp:220
    #13 Akonadi::Server:;DataStore::init (this=<optimized out>) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/server/storage/datastore.cpp:195
    #14 0x0000561c087a57e4 in Akonadi::Server::AkonadiServer::setupDatabase (this=<optimized out>) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/server/akonadi.cpp:264
    #15 0x0000561c087a7478 in Akonadi::Server::AkonadiServer::init (this=0x7fff4be92dc0) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/server/akonadi.cpp:107
    #16 0x00007f0b93c9eb41 in QObject::event (this=0x7fff4be92dc0, e=0x561c09290920) at kernel/qobject.cpp:1314
    #17 0x00007f0b93c72bef in doNotify (event=0x561c09290920, receiver=0x7fff4be92dc0) at ../../include/QtCore/../../src/corelib/tools/qscopedpointer.h:116
    #18 QCoreApplication::notify (event=<optimized out>, receiver=<optimized out>, this=<optimized out>) at kernel/qcoreapplication.cpp:1137
    #19 QCoreApplication::notifyInternal2 (receiver=0x7fff4be92dc0, event=0x561c09290920) at kernel/qcoreapplication.cpp:1061
    #20 0x00007f0b93c75641 in QCoreApplicationPrivate::sendPostedEvents (receiver=0x0, event_type=0, data=0x561c09282e10) at kernel/qcoreapplication.cpp:1815
    #21 0x00007f0b93cca9d3 in postEventSourceDispatch (s=0x561c0928a9d0) at kernel/qeventdispatcher_glib.cpp:277
    #22 0x00007f0b920072b7 in g_main_context_dispatch () from /usr/lib64/libglib-2.0.so.0
    #23 0x00007f0b92007638 in ?? () from /usr/lib64/libglib-2.0.so.0
    #24 0x00007f0b920076ef in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0
    #25 0x00007f0b93cca05f in QEventDispatcherGlib::processEvents (this=0x561c09287e60, flags=...) at kernel/qeventdispatcher_glib.cpp:423
    #26 0x00007f0b93c715db in QEventLoop::exec (this=this@entry=0x7fff4be92c20, flags=..., flags@entry=...) at ../../include/QtCore/../../src/corelib/global/qflags.h:141
    #27 0x00007f0b93c79840 in QCoreApplication::exec () at ../../include/QtCore/../../src/corelib/global/qflags.h:121
    #28 0x0000561c087a0c06 in AkApplicationBase::exec (this=0x7fff4be92d90) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/shared/akapplication.cpp:109
    #29 main (argc=<optimized out>, argv=<optimized out>) at /usr/src/debug/akonadi-server-20.08.0-1.1.x86_64/src/server/main.cpp:66
    [Inferior 1 (process 4406) detached]

    Reported using DrKonqi
    Last edited by Amadeus1965; 28-Aug-2020 at 00:06. Reason: Tekstcorrecties
    Lenovo T480 i5 32GB DDR4 RAM (project) on Tumbleweed
    Lenovo X1 Yoga i5 8GB DDR3L RAM (my travel horse) on Tumbleweed
    Lenovo T460s i7 20GB DDR4 RAM (my work horse) on Tumbleweed
    Lenovo X220 i5 16GB DDR3L RAM on Linux Subgraph (best keyboard ever!).

  2. #2
    Join Date
    Nov 2018
    Location
    Somwhere in the lowlands
    Posts
    85

    Default Re: Akonadi laat KMail crashen na update.

    Misschien dat de code na startpoging in Konsole ook nog helpt (voor mij is het leesbaarder dan het voorgaande).

    Code:
    xxxxx@xxxxxLinuxX1:~> akonadictl start
    org.kde.pim.akonadictl: Starting Akonadi Server...
    org.kde.pim.akonadictl:    done.
    Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
    roland@AmadeusLinuxX1:~> 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
    org.kde.pim.akonadiserver: DATABASE ERROR:
    org.kde.pim.akonadiserver:   Error code: "2013"
    org.kde.pim.akonadiserver:   DB error:  "Lost connection to MySQL server during query"
    org.kde.pim.akonadiserver:   Error text: "Lost connection to MySQL server during query QMYSQL3: Unable to execute statement"
    org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "akonadi"))(":1", QVariant(QString, "SchemaVersionTable")))
    org.kde.pim.akonadiserver:   Query: "SELECT information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME, information_schema.KEY_COLUMN_USAGE.COLUMN_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME, information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE, information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN information_schema.KEY_COLUMN_USAGE ON ( information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME = information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE ( information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = :0 AND information_schema.KEY_COLUMN_USAGE.TABLE_NAME = :1 )"
    org.kde.pim.akonadiserver: DATABASE ERROR:
    org.kde.pim.akonadiserver:   Error code: "2006"
    org.kde.pim.akonadiserver:   DB error:  "MySQL server has gone away"
    org.kde.pim.akonadiserver:   Error text: "MySQL server has gone away QMYSQL3: Unable to execute statement"
    org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "akonadi"))(":1", QVariant(QString, "ResourceTable")))
    org.kde.pim.akonadiserver:   Query: "SELECT information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME, information_schema.KEY_COLUMN_USAGE.COLUMN_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME, information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE, information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN information_schema.KEY_COLUMN_USAGE ON ( information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME = information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE ( information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = :0 AND information_schema.KEY_COLUMN_USAGE.TABLE_NAME = :1 )"
    org.kde.pim.akonadiserver: DATABASE ERROR:
    org.kde.pim.akonadiserver:   Error code: "2006"
    org.kde.pim.akonadiserver:   DB error:  "MySQL server has gone away"
    org.kde.pim.akonadiserver:   Error text: "MySQL server has gone away QMYSQL3: Unable to execute statement"
    org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "akonadi"))(":1", QVariant(QString, "CollectionTable")))
    org.kde.pim.akonadiserver:   Query: "SELECT information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME, information_schema.KEY_COLUMN_USAGE.COLUMN_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME, information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE, information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN information_schema.KEY_COLUMN_USAGE ON ( information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME = information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE ( information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = :0 AND information_schema.KEY_COLUMN_USAGE.TABLE_NAME = :1 )"
    terminate called after throwing an instance of 'Akonadi::Server::DbException'
      what():  Failed to query index
    Sql error: MySQL server has gone away QMYSQL: Unable to execute query
    Query: SHOW INDEXES FROM CollectionTable WHERE `Key_name` = 'CollectionTable_parentAndNameIndex'
    KCrash: Application 'akonadiserver' crashing...
    KCrash: Attempting to start /usr/lib64/libexec/drkonqi
    Lenovo T480 i5 32GB DDR4 RAM (project) on Tumbleweed
    Lenovo X1 Yoga i5 8GB DDR3L RAM (my travel horse) on Tumbleweed
    Lenovo T460s i7 20GB DDR4 RAM (my work horse) on Tumbleweed
    Lenovo X220 i5 16GB DDR3L RAM on Linux Subgraph (best keyboard ever!).

  3. #3
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,872
    Blog Entries
    14

    Default Re: Akonadi laat KMail crashen na update.

    Dat lijkt eerder een mysql probleem dan een kmail/akondi iets.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  4. #4
    Join Date
    Oct 2014
    Location
    Rotterdam
    Posts
    208

    Default Re: Akonadi laat KMail crashen na update.

    Ja, het lijkt alsof Akonadi zich verslikt in iets.

    Ik heb een tijdje geleden een probleem met akonadi_control, zelfs een bug aangemaakt maar uiteindelijk "opgelost" door te deinstalleren en weer opnieuw te installeren.
    Geen idee of dat je gaat helpen, het zal waarschijnlijk betekenen dat je contactgegeven etc. verliest (backup...) maar ik zou dat ook proberen.







  5. #5
    Join Date
    Nov 2018
    Location
    Somwhere in the lowlands
    Posts
    85

    Default Re: Akonadi laat KMail crashen na update.

    Hi Knurpht & Marel,

    Thanks!

    Tja, uninstall en install al gedaan (doet volgens mij iedereen wel die lang in een microsoft omgeving heeft gewerkt).
    Het bood geen soelaas.

    Knurpht lijkt hier wel de juiste conclusie te trekken en het lezen van de log was daarin ook duidend (al vind ik begrijpend lezen van zo'n log ondoenlijk).

    Als ik check krijg ik dit:
    Code:
    AmadeusLinuxX1:/home/roland # service mysql status
    * mariadb.service - MariaDB database server
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
         Active: inactive (dead)
           Docs: man:mysqld(8)
                 https://mariadb.com/kb/en/library/systemd/
    Jullie een idee?

    Overigens ik heb een prima backup van alle e-mail adressen, data etc.
    Ik vind een herinstallatie dus geen groot probleem, mits ik eveneens mijn e-mail kan converteren naar de nieuwe installatie.
    De e-mail wi ik echt niet kwijt

    Dus mochten er geen manieren zijn mysql weer aan de prat te krijgen, dan leer ik graag waar de e-mail is opgeslagen, zodat ik de e-mailberichten zelf kan zekerstellen en in de (eventuele) nieuwe installatie weer terugplaatsen. De PIM import-export functie in KMail doet het nu uiteraard ook niet want geen werkende Akonadi of beter gezegd mysql server (nu vind ik die import-export functie ook niet prettig werken, maar dat terzijde).

    Ik hoor graag jullie visie.

    Alvast dank!
    Lenovo T480 i5 32GB DDR4 RAM (project) on Tumbleweed
    Lenovo X1 Yoga i5 8GB DDR3L RAM (my travel horse) on Tumbleweed
    Lenovo T460s i7 20GB DDR4 RAM (my work horse) on Tumbleweed
    Lenovo X220 i5 16GB DDR3L RAM on Linux Subgraph (best keyboard ever!).

  6. #6
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,872
    Blog Entries
    14

    Default Re: Akonadi laat KMail crashen na update.

    Je mysql draait helemaal niet. ( inactive - dead ). Doe eens een restart van die service, en dan opnieuw de status bekijken
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  7. #7
    Join Date
    Nov 2018
    Location
    Somwhere in the lowlands
    Posts
    85

    Default Re: Akonadi laat KMail crashen na update.

    Quote Originally Posted by Knurpht View Post
    Je mysql draait helemaal niet. ( inactive - dead ). Doe eens een restart van die service, en dan opnieuw de status bekijken
    Hi G-J,

    Thanks! voor je reactie.
    Ja dat zag ik ook "dead" spreekt voor zich....
    Helaas ben ik nu een ruime week onderweg zonder de Lenovo X1, omdat KMail op de X1 nu niet draait heb ik nu de Lenovo T480 megenomen.
    Ik kan dus even niet bij de Lenovo X1 die thuis ligt.

    Ik ben zondag a.s. terug dan zal ik mysql nog eens starten en de output hier in de thread plakken.
    Alvast dank voor het meedenken!
    Lenovo T480 i5 32GB DDR4 RAM (project) on Tumbleweed
    Lenovo X1 Yoga i5 8GB DDR3L RAM (my travel horse) on Tumbleweed
    Lenovo T460s i7 20GB DDR4 RAM (my work horse) on Tumbleweed
    Lenovo X220 i5 16GB DDR3L RAM on Linux Subgraph (best keyboard ever!).

  8. #8
    Join Date
    Nov 2018
    Location
    Somwhere in the lowlands
    Posts
    85

    Default Re: Akonadi laat KMail crashen na update.

    Quote Originally Posted by Knurpht View Post
    Je mysql draait helemaal niet. ( inactive - dead ). Doe eens een restart van die service, en dan opnieuw de status bekijken
    Hi G-J,

    Dagje later teruggekomen dan gepland.

    Hieronder de gevraagde output, ik ben benieuwd naar jouw inzichten.

    Code:
    AmadeusLinuxX1:/home/roland # systemctl start mysql
    AmadeusLinuxX1:/home/roland # service mysql status
    * mariadb.service - MariaDB database server
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
         Active: active (running) since Mon 2020-09-14 21:18:58 CEST; 1min 18s ago
           Docs: man:mysqld(8)
                 https://mariadb.com/kb/en/library/systemd/
        Process: 8125 ExecStartPre=/usr/libexec/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
        Process: 8131 ExecStartPre=/usr/libexec/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
       Main PID: 8241 (mysqld)
         Status: "Taking your SQL requests now..."
          Tasks: 30 (limit: 4915)
         Memory: 109.2M
         CGroup: /system.slice/mariadb.service
                 `-8241 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql
    
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8185]: information_schema
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8185]: performance_schema
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8185]: test
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8185]: Phase 7/7: Running 'FLUSH PRIVILEGES'
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8185]: OK
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8131]: Everything upgraded successfully
    sep 14 21:18:55 AmadeusLinuxX1 mysql-systemd-helper[8131]: Shutting down protected MySQL
    sep 14 21:18:57 AmadeusLinuxX1 mysql-systemd-helper[8131]: Final cleanup
    sep 14 21:18:58 AmadeusLinuxX1 mysql-systemd-helper[8241]: 2020-09-14 21:18:58 0 [Note] /usr/sbin/mysqld (mysqld 10.4.14-MariaDB) starting as process 8241 ...
    sep 14 21:18:58 AmadeusLinuxX1 systemd[1]: Started MariaDB database server.
    AmadeusLinuxX1:/home/roland #
    Lenovo T480 i5 32GB DDR4 RAM (project) on Tumbleweed
    Lenovo X1 Yoga i5 8GB DDR3L RAM (my travel horse) on Tumbleweed
    Lenovo T460s i7 20GB DDR4 RAM (my work horse) on Tumbleweed
    Lenovo X220 i5 16GB DDR3L RAM on Linux Subgraph (best keyboard ever!).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •