Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

  1. #11

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    Kmail and akonadi work without problems on my 15.3 machine after the mariadb 10.5.12-3.6.1 update last week.

    Code:
    i+ | akonadi-server        | package | 20.04.2-bp153.4.2.1 | x86_64 | Update repository of openSUSE Backports
    i+ | mariadb               | package | 10.5.12-3.6.1       | x86_64 | Update repository with updates from SUSE Linux Enterprise 15 
    
    Could you can check if the journal had some akonadi error messages after the update ?

  2. #12

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    Quote Originally Posted by rawar View Post
    Could you can check if the journal had some akonadi error messages after the update ?
    Which journal are you referring to? I checked /var/log/messages (journald) and there is no message from Akonadi, that'shelpfull. It just states that it can't connect, but that we already know.

    The log shows that mariadb (....11) was succesfully replaces with (....12).


    Perhaps this is something:
    Code:
    2021-09-04T11:15:54.139807+02:00  akonadiserver[2595]: org.kde.pim.akonadiserver: Starting up the Akonadi Server...
    2021-09-04T11:15:58.262640+02:00  org.freedesktop.Akonadi.Control[2619]: libEGL warning: DRI2: failed to authenticate
    2021-09-04T11:15:59.515880+02:00 akonadiserver[2595]: org.kde.pim.akonadiserver: Shutting down AkonadiServer...
    

  3. #13

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    The update is now on my second 15.3 machine and again no problem with mariadb 10.5.12 and Kmail/akonadi here.
    You could try to start akonadi manual with the --verbose option
    Code:
    akonadictl --verbose start
    maybe this will show some helpful info. You could also check if there are errors in ~/.local/share/akonadi/db_data/mysql.err

  4. #14

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    Quote Originally Posted by rawar View Post
    The update is now on my second 15.3 machine and again no problem with mariadb 10.5.12 and Kmail/akonadi here.
    You could try to start akonadi manual with the --verbose option
    Code:
    akonadictl --verbose start
    maybe this will show some helpful info. You could also check if there are errors in ~/.local/share/akonadi/db_data/mysql.err

    Thanks for the good hints/tips!

    This is from mysql.err
    Code:
    2021-09-04 11:12:50 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
    2021-09-04 11:12:50 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
    2021-09-04 11:12:50 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
    2021-09-04 11:12:50 0 [Note] InnoDB: FTS optimize thread exiting.
    2021-09-04 11:12:50 0 [Note] InnoDB: Starting shutdown...
    2021-09-04 11:12:50 0 [Note] InnoDB: Dumping buffer pool(s) to /home/userjoe/.local/share/akonadi/db_data/ib_buffer_pool
    2021-09-04 11:12:50 0 [Note] InnoDB: Restricted to 2016 pages due to innodb_buf_pool_dump_pct=25
    2021-09-04 11:12:50 0 [Note] InnoDB: Buffer pool(s) dump completed at 210904 11:12:50
    2021-09-04 11:12:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2021-09-04 11:12:51 0 [Note] InnoDB: Shutdown completed; log sequence number 53112589359; transaction id 5495884975336692350
    2021-09-04 11:12:51 0 [Note] /usr/sbin/mysqld: Shutdown complete
    
    2021-09-04 11:15:45 0 [Note] InnoDB: Uses event mutexes
    2021-09-04 11:15:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2021-09-04 11:15:45 0 [Note] InnoDB: Number of pools: 1
    2021-09-04 11:15:45 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
    2021-09-04 11:15:45 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
    2021-09-04 11:15:45 0 [Note] InnoDB: Using Linux native AIO
    2021-09-04 11:15:45 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
    2021-09-04 11:15:45 0 [Note] InnoDB: Completed initialization of buffer pool
    2021-09-04 11:15:46 0 [ERROR] InnoDB: corrupted TRX_NO 4c454e44415999b9
    2021-09-04 11:15:46 0 [Note] InnoDB: Retry with innodb_force_recovery=5
    2021-09-04 11:15:46 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
    2021-09-04 11:15:46 0 [Note] InnoDB: Starting shutdown...
    2021-09-04 11:15:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2021-09-04 11:15:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2021-09-04 11:15:46 0 [Note] Plugin 'FEEDBACK' is disabled.
    2021-09-04 11:15:46 0 [ERROR] Unknown/unsupported storage engine: innodb
    2021-09-04 11:15:46 0 [ERROR] Aborting


    It looks like a problem with the innodb engine.


    The log lines just before the above lines, or the 10.5.11 engine:
    Code:
    2021-09-04  8:41:41 0 [Note] InnoDB: Uses event mutexes
    2021-09-04  8:41:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2021-09-04  8:41:41 0 [Note] InnoDB: Number of pools: 1
    2021-09-04  8:41:41 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
    2021-09-04  8:41:41 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
    2021-09-04  8:41:41 0 [Note] InnoDB: Using Linux native AIO
    2021-09-04  8:41:41 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
    2021-09-04  8:41:41 0 [Note] InnoDB: Completed initialization of buffer pool
    2021-09-04  8:41:41 0 [Note] InnoDB: 128 rollback segments are active.
    2021-09-04  8:41:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2021-09-04  8:41:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2021-09-04  8:41:41 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2021-09-04  8:41:41 0 [Note] InnoDB: 10.5.11 started; log sequence number 53111891541; transaction id 5495884975336691524
    2021-09-04  8:41:41 0 [Note] Plugin 'FEEDBACK' is disabled.
    2021-09-04  8:41:41 0 [Note] InnoDB: Loading buffer pool(s) from /home/userjoe/.local/share/akonadi/db_data/ib_buffer_pool
    2021-09-04  8:41:41 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    2021-09-04  8:41:41 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
    2021-09-04  8:41:41 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or 
    directory")
    2021-09-04  8:41:41 0 [Note] Reading of all Master_info entries succeeded
    2021-09-04  8:41:41 0 [Note] Added new Master_info '' to hash table
    2021-09-04  8:41:41 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '10.5.11-MariaDB'  socket: '/run/user/1000/akonadi/mysql.socket'  port: 0  MariaDB package
    2021-09-04  8:41:42 4 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
    2021-09-04  8:41:42 0 [Note] InnoDB: Buffer pool(s) load completed at 210904  8:41:42


    There seems to be an issue, but it starts at least.

    Any idea what's going on?


  5. #15
    Join Date
    Jun 2011
    Location
    Germany
    Posts
    514

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    I'd say this is the culprit somehow:
    Quote Originally Posted by rbos View Post
    Code:
    2021-09-04 11:12:50 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
    2021-09-04 11:12:50 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
    2021-09-04 11:12:50 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown

    I can't actually help nor trace this as I am on 15.2. I can't find any hint to "mysql.db" in any way, no hint in any error nor log nor config file. Not even
    Code:
    zypper se --provides mysql.db
    provides any result. I should mention akonadi / kontact works without problems. Not sure about the changes from 15.2 to 15.3 nor about mariadb from 10.5.11 to 10.5.12. It seems to call a database (mysql.db) which isn't there (resp. where it's supposed to be). So is this call wrong or should there be a "mysql.db" somewhere? Or is this even completely irrelevant?

  6. #16

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    Quote Originally Posted by kasi042 View Post
    I'd say this is the culprit somehow:

    Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
    Thanks for your thinking out load, appreciated and just what I need. I'll look into during the weekend, when I've a bit more time. Perhaps in the meantime some else may have a suggestion????

  7. #17

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    Does anybody how to initialize a mysql/mariadb database to be used with/for akonadi?

    I know that I can do this with:
    Code:
    mysql_install_db --defaults-file=~/.local/share/akonadi/mysql.conf --datadir=/var/tmp/mariadb/joe/db_data
    
    This will give me a DB engine, with only the information_schema database.

    In an original akonadi database, there are also the mysql and p
    erformance_schema databases.

    In short I expect this:
    Code:
    MariaDB [(none)]> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | akonadi            |
    | information_schema |
    | mysql              |
    | performance_schema |
    +--------------------+
    


    But I get:
    Code:
    MariaDB [(none)]> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    +--------------------+
    


    akonadi is of course missing, that is a database to import. But how or when do the other 2 (mysql and performance_schema) appear?

    Does anyone know?


  8. #18
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    29,488

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    As you do not show your complete command line, the prompts are missing. Thus we can not see who (main interest root or normal user) is running all these commands. I hope you are aware of the fact the the Akonadi database is per (KDE) user and that thus using or not of a MariaDB on the system level has no connection to them. This is as I understand this.
    Henk van Velden

  9. #19

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    Quote Originally Posted by hcvv View Post
    As you do not show your complete command line, the prompts are missing. Thus we can not see who (main interest root or normal user) is running all these commands. I hope you are aware of the fact the the Akonadi database is per (KDE) user and that thus using or not of a MariaDB on the system level has no connection to them. This is as I understand this.
    It is for a regular user.

    Indeed akonadi is for the user using KDE, I know. The thing is, when I update mariadb to the next version it breaks my current setup and I've to restore the databases (for various) users. That's why I need to re-install the databases, and I try to do this in the (KDE) correct way.

    If someone knows the script or executable that creates the akonadi DB, that would be nice to know as well.

  10. #20
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    29,488

    Default Re: Just updated mariadb from 10.5.11 to 10.5.12 this broke akonadi and so no email

    It could of course be that people here know how to help you. But maybe you should go to a more specialized place.

    There is the KDE forums: https://forum.kde.org/

    And there is the KDE-PIM mailing list: kdepim-users@kde.org
    Henk van Velden

Page 2 of 2 FirstFirst 12

Tags for this Thread

Posting Permissions

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