Bug 436418 - Akonadi fails to start : unknown variable innodb_additional_mem_pool_size
Summary: Akonadi fails to start : unknown variable innodb_additional_mem_pool_size
Status: REPORTED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: general (show other bugs)
Version: unspecified
Platform: Kubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-30 19:02 UTC by Tom Chiverton
Modified: 2021-05-02 11:41 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Chiverton 2021-04-30 19:02:29 UTC
SUMMARY
Does not start

STEPS TO REPRODUCE
1. Install akonadi-backend-mysql
2. Run `akonadictl start`

OBSERVED RESULT
konadictl staorg.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/falken/.local/share/akonadi/mysql.conf", "--datadir=/home/falken/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-04-30 19:56:12 0 [Note] /usr/sbin/mysqld (mysqld 10.5.9-MariaDB-1) starting as process 18631 ...\n"
org.kde.pim.akonadiserver: exit code: 7
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...


EXPECTED RESULT
Started OK

SOFTWARE/OS VERSIONS
KDE Plasma Version: 5.21.4
KDE Frameworks Version: 5.81.0
Qt Version: 5.15.2

ADDITIONAL INFORMATION
$ tail /home/falken/.local/share/akonadi/db_data/mysql.err
2021-04-30 19:56:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-04-30 19:56:12 0 [Note] InnoDB: 128 rollback segments are active.
2021-04-30 19:56:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-30 19:56:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-30 19:56:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-04-30 19:56:12 0 [Note] InnoDB: 10.5.9 started; log sequence number 9029384776; transaction id 85324444
2021-04-30 19:56:12 0 [Note] InnoDB: Loading buffer pool(s) from /home/falken/.local/share/akonadi/db_data/ib_buffer_pool
2021-04-30 19:56:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-30 19:56:12 0 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_additional_mem_pool_size=1M'
2021-04-30 19:56:12 0 [ERROR] Aborting
Comment 1 Tom Chiverton 2021-04-30 19:04:24 UTC
$ grep innodb_additional_mem_pool_s /home/falken/.local/share/akonadi/mysql.conf 
innodb_additional_mem_pool_size=1M

Removed this line, and it starts.

I have never knowingly edited this file.

Is it a migration error from older Kubuntu ?
Comment 2 Christophe Marin 2021-05-01 06:16:31 UTC
innodb_additional_mem_pool_size was removed from the akonadi settings in 2016:

https://invent.kde.org/pim/akonadi/-/blob/master/src/server/storage/mysql-global.conf#L42

can you check if it's still present for some reasons in the mysql-global.conf file installed by your distribution?
Comment 3 Tom Chiverton 2021-05-02 09:28:39 UTC
No, it's only in the -local file. I've never put it there myself, far as I can remember.

Was an update meant to add/remove this setting from -local file ?
Comment 4 Christophe Marin 2021-05-02 11:41:03 UTC
it should yes. It's strange to see this issue facing just now. This setting was commented out since years and was removed from mariaDB in 2016