Public bug reported:
After upgrading from kubntu-19.04 to 19.10, the akonadi server will not
start. This means that knotes, kalarm, etc do not work. Manually trying
to start akonadi, as configured for mysql, produces the following:
----------
greenman@Crynfyd19.04 ~/.config/akonadi$ akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman@Crynfyd19.04 ~/.config/akonadi$ org.kde.pim.akonadiserver: Starting up
the Akonadi Server...
org.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-akonadi"
org.kde.pim.akonadiserver: arguments:
("--defaults-file=/home/greenman/.local/share/akonadi/mysql.conf",
"--datadir=/home/greenman/.local/share/akonadi/db_data/",
"--socket=/run/user/1000/akonadi/default/mysql.socket",
"--pid-file=/run/user/1000/akonadi/default/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/run/user/1000/akonadi/default/mysql.socket' (2)'
Check that mysqld is running and that the socket:
'/run/user/1000/akonadi/default/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...
----------
Switching akonadi to postgresql using the instructions found here
(modified for local installation): https://www.enricozini.org/blog/2015
/akonadi-install/
----------
greenman@Crynfyd19.04 ~/.local/share/akonadi$ akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman@Crynfyd19.04 ~/.local/share/akonadi$ org.kde.pim.akonadiserver:
Starting up the Akonadi Server...
The files belonging to this database system will be owned by user "greenman".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are enabled.
fixing permissions on existing directory
/home/greenman/.local/share/akonadi/db_data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... America/Los_Angeles
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
/usr/lib/postgresql/11/bin/pg_ctl -D
/home/greenman/.local/share/akonadi/db_data -l logfile start
org.kde.pim.akonadiserver: Failed to create database
org.kde.pim.akonadiserver: Query error: "ERROR: syntax error at or near
\"-\"\nLINE 1: CREATE DATABASE akonadi-greenman\n
^\n(42601) QPSQL: Unable to create query"
org.kde.pim.akonadiserver: Database error: "could not connect to server: No
such file or directory\n\tIs the server running locally and
accepting\n\tconnections on Unix domain socket
\"/run/user/1000/akonadi/default/.s.PGSQL.5432\"?\nQPSQL: Unable to connect"
waiting for server to shut down.... done
server stopped
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...
----------
Attempting to start the server with the line metioned above:
----------
greenman@Crynfyd19.04 ~/.local/share/akonadi$ /usr/lib/postgresql/11/bin/pg_ctl
-D /home/greenman/.local/share/akonadi/db_data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
----------
And the logfile is:
----------
greenman@Crynfyd19.04 ~/.local/share/akonadi$ cat logfile
2019-10-28 07:56:40.520 PDT [3139] LOG: could not bind IPv4 address
"127.0.0.1": Address already in use
2019-10-28 07:56:40.520 PDT [3139] HINT: Is another postmaster already running
on port 5432? If not, wait a few seconds and retry.
2019-10-28 07:56:40.520 PDT [3139] WARNING: could not create listen socket for
"localhost"
2019-10-28 07:56:40.531 PDT [3139] FATAL: could not create any TCP/IP sockets
2019-10-28 07:56:40.531 PDT [3139] LOG: database system is shut down
----------
According to lsof there is nothing else using port 5432; I have opened
the port with ufw, so there should be no access problem.
Still, it will not start. I have tried deleting both
~/.local/share/akonadi and ~/.config/akonadi, reinstalling and
reconfiguring akonadi-server. So far nothing has worked.
----------
greenman@Crynfyd19.04 ~/.local/share/akonadi$ lsb_release -rd
Description: Ubuntu 19.10
Release: 19.10
greenman@Crynfyd19.04 ~/.local/share/akonadi$ apt-cache policy akonadi-server
akonadi-server:
Installed: 4:19.04.3-0ubuntu3
Candidate: 4:19.04.3-0ubuntu3
Version table:
*** 4:19.04.3-0ubuntu3 500
500 http://us.archive.ubuntu.com/ubuntu eoan/universe amd64 Packages
100 /var/lib/dpkg/status
** Affects: akonadi (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1850162
Title:
Akonadi server will not start after upgrade to kubuntu 19.10
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1850162/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
