Announcement

Collapse
No announcement yet.

mysql upgrade failed

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    [SOLVED] mysql upgrade failed

    The upgrade process failed to properly upgrade mysql. I am not an expert in mysql, so I don't really know what went wrong. I tried to start knotes, and got a blank note, where there should be stuff. The output of starting it from a terminal looks like this:

    Code:
    greenman@Crynfyd19.04 ~$ knotes 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
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...
org.kde.pim.akonadicore: Job error:  "" for collection: QVector()
    Akonadi (which knotes needs) won't start, and evidently has something to do with mysql not starting. Apparently mysql_upgrade no longer exists, and I really don't know enough about mysql to understand what the results from searching are telling me to do -- meaning, nothing I have found works.

    systemctl status mysql.service says this:

    Code:
    greenman@Crynfyd19.04 ~$ systemctl status mysql.service
● mysql.service - MySQL Community Server
 Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
 Active: active (running) since Sat 2019-10-26 14:13:31 PDT; 15s ago
Process: 13931 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 13953 (mysqld)
 Status: "Server is operational"
  Tasks: 39 (limit: 4915)
 Memory: 377.6M
 CGroup: /system.slice/mysql.service
         └─13953 /usr/sbin/mysqld

Oct 26 14:13:29 Crynfyd systemd[1]: Starting MySQL Community Server...
Oct 26 14:13:31 Crynfyd systemd[1]: Started MySQL Community Server.
    So I have no clue what went wrong.
    We only have to look at ourselves to see how intelligent life might develop into something we wouldn't want to meet. -- Stephen Hawking
    Tags: mysql
    • Top
    • Bottom
    #2
    @hear Knotes is working , check to see if all those paths in your first block of code) are their on your system (they are hear)

    Code:
    vinny@vinny-bonox8:/run/user/1000/akonadi/default$ ls -la
total 8
drwxrwxr-x 2 vinny vinny 140 Oct 26 17:35 .
drwxrwxr-x 3 vinny vinny  60 Oct 26 17:35 ..
srwxrwxr-x 1 vinny vinny   0 Oct 26 17:35 akonadiserver-cmd.socket
srwxrwxr-x 1 vinny vinny   0 Oct 26 17:35 akonadiserver-ntf.socket
-rw-r----- 1 vinny vinny   6 Oct 26 17:35 mysql.pid
srwxrwxrwx 1 vinny vinny   0 Oct 26 17:35 mysql.socket
-rw------- 1 vinny vinny   6 Oct 26 17:35 mysql.socket.lock
    Code:
    vinny@vinny-bonox8:~/.local/share/akonadi$ ls -la
total 28
drwxrwxr-x 1 vinny vinny   204 Oct 26 17:35 .
drwxr-xr-x 1 vinny vinny   934 Oct 26 17:41 ..
-rw-rw-r-- 1 vinny vinny 13414 Oct 26 17:42 Akonadi.error
-rw-rw-r-- 1 vinny vinny   140 Oct 26 17:35 Akonadi.error.old
drwxrwxr-x 1 vinny vinny   198 Oct 26 17:35 db_data
drwxrwxr-x 1 vinny vinny     0 Oct 26 17:35 db_misc
drwxrwxr-x 1 vinny vinny     0 Oct 26 17:35 file_db_data
-rw-rw-r-- 1 vinny vinny  3660 Oct 26 17:35 mysql.conf
drwxrwxr-x 1 vinny vinny   102 Oct 26 17:35 search_db
lrwxrwxrwx 1 vinny vinny    30 Oct 26 17:35 socket-vinny-bonox8-default -> /run/user/1000/akonadi/default
    VINNY
    i7 4core HT 8MB L3 2.9GHz
    16GB RAM
    Nvidia GTX 860M 4GB RAM 1152 cuda cores
    • Top
    • Bottom

    Comment

      #3
      /run/user/1000/akonadi/default exists, but is empty.

      Code:
      greenman@Crynfyd19.04 ~/.local/share/akonadi$ ls -l
total 64
-rw-rw-r-- 1 greenman greenman  103 Oct 25 06:50 akonadi_control.error
-rw-rw-r-- 1 greenman greenman  163 Oct 25 06:50 akonadi_control.error.old
-rw-rw-r-- 1 greenman greenman 1198 Oct 26 15:22 Akonadi.error
-rw-rw-r-- 1 greenman greenman  140 Oct 26 15:22 Akonadi.error.old
-rw-rw-r-- 1 greenman greenman 9033 Oct 25 06:56 akonadiserver.error
-rw-rw-r-- 1 greenman greenman 9034 Oct 25 06:50 akonadiserver.error.old
drwxrwxr-x 4 greenman greenman 4096 Oct 26 15:22 db_data
drwxrwxr-x 2 greenman greenman 4096 Mar  2  2014 db_misc
drwxrwxr-x 2 greenman greenman 4096 Mar  2  2014 file_db_data
-rw-rw-r-- 1 greenman greenman 3660 Oct  9  2017 mysql.conf
-rw-rw-r-- 1 greenman greenman 3660 Oct 26 13:50 mysql.conf-old
drwxrwxr-x 3 greenman greenman 4096 Oct  9  2017 search_db
lrwxrwxrwx 1 greenman greenman   38 Oct 25 06:50 socket-Crynfyd -> /tmp/user/1000/akonadi-greenman.5T0GlE
lrwxrwxrwx 1 greenman greenman   30 Oct 26 13:28 socket-Crynfyd-default -> /run/user/1000/akonadi/default
      The link for socket-Crynfyd is red, meaning its target does not exist.
      We only have to look at ourselves to see how intelligent life might develop into something we wouldn't want to meet. -- Stephen Hawking
      • Top
      • Bottom

      Comment

        #4
        Originally posted by doctordruidphd View Post
        /run/user/1000/akonadi/default exists, but is empty.

        Code:
        greenman@Crynfyd19.04 ~/.local/share/akonadi$ ls -l
total 64
-rw-rw-r-- 1 greenman greenman  103 Oct 25 06:50 akonadi_control.error
-rw-rw-r-- 1 greenman greenman  163 Oct 25 06:50 akonadi_control.error.old
-rw-rw-r-- 1 greenman greenman 1198 Oct 26 15:22 Akonadi.error
-rw-rw-r-- 1 greenman greenman  140 Oct 26 15:22 Akonadi.error.old
-rw-rw-r-- 1 greenman greenman 9033 Oct 25 06:56 akonadiserver.error
-rw-rw-r-- 1 greenman greenman 9034 Oct 25 06:50 akonadiserver.error.old
drwxrwxr-x 4 greenman greenman 4096 Oct 26 15:22 db_data
drwxrwxr-x 2 greenman greenman 4096 Mar  2  2014 db_misc
drwxrwxr-x 2 greenman greenman 4096 Mar  2  2014 file_db_data
-rw-rw-r-- 1 greenman greenman 3660 Oct  9  2017 mysql.conf
-rw-rw-r-- 1 greenman greenman 3660 Oct 26 13:50 mysql.conf-old
drwxrwxr-x 3 greenman greenman 4096 Oct  9  2017 search_db
lrwxrwxrwx 1 greenman greenman   38 Oct 25 06:50 socket-Crynfyd -> /tmp/user/1000/akonadi-greenman.5T0GlE
lrwxrwxrwx 1 greenman greenman   30 Oct 26 13:28 socket-Crynfyd-default -> /run/user/1000/akonadi/default
        The link for socket-Crynfyd is red, meaning its target does not exist.
        I do not have a link socket-whatever to /tmp
        even wile knotes is running ,

        you may want to remove it (sense it points to /tmp) and see if that changes anything , unless you created it or the target for some
        reason .

        also this dose not seem good
        /run/user/1000/akonadi/default exists, but is empty.
        Code:
        vinny@vinny-bonox8:~$ ps aux | grep mysqld
vinny    19074  0.1  1.1 2983132 196028 ? Sl   17:35   0:09 /usr/sbin/mysqld --defaults-file=/home/vinny/.local/share/akonadi/mysql.conf --datadir=/home/vinny/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/default/mysql.socket --pid-file=/run/user/1000/akonadi/default/mysql.pid
        VINNY
        Last edited by vinnywright; Oct 26, 2019, 05:17 PM.
        i7 4core HT 8MB L3 2.9GHz
        16GB RAM
        Nvidia GTX 860M 4GB RAM 1152 cuda cores
        • Top
        • Bottom

        Comment

          #5
          I did a ps aux | grep mysql, and there was a /usr/sbin/mysqld started by user mysql with no options. So I killed it, and started it with the command you showed, modified for my installation, and this is the result I got:

          Code:
          greenman@Crynfyd19.04 ~$ /usr/sbin/mysqld --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
mysqld: [ERROR] Failed to open required defaults file: /home/greenman/.local/share/akonadi/mysql.conf
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
          So it says it can't find /home/greenman/.local/share/akonadi/mysql.conf but the file is there.

          As another experiment, I noticed on DISCO that mysqld was running with different options, so I tried starting it on EOAN and this is what happened:

          Code:
          greenman@Crynfyd19.04 ~$ sudo -u mysql /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid
mysqld will log errors to /var/log/mysql/error.log
2019-10-27T02:38:14.300972Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
          And this is /var/log/mysql/error.log

          Code:
          greenman@Crynfyd19.04 ~$ cat /var/log/mysql/error.log
2019-10-26T20:34:42.712501Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-26T20:34:43.264825Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 6366
2019-10-26T20:34:44.470020Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-26T20:34:44.470035Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-26T20:34:44.470054Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-26T20:34:44.470068Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-26T20:34:44.470085Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-26T20:34:44.470098Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-26T20:34:44.470119Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-26T20:34:44.470135Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-26T20:34:45.069130Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-26T20:34:45.105569Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

Version: '8.0.17-0ubuntu2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2019-10-26T20:34:45.222664Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. 

Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-10-26T20:44:26.934255Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
mysqld: Can't create/write to file '/tmp/user/0/ibdcDqeh' (OS errno 13 - Permission denied)
2019-10-26T20:44:28.274120Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 13025
2019-10-26T20:44:28.310673Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file; errno: 13
2019-10-26T20:44:28.310703Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2019-10-26T20:44:28.310730Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2019-10-26T20:44:28.310957Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-10-26T20:44:28.311173Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-26T20:44:28.311862Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-26T20:44:30.201772Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 13116
2019-10-26T20:44:31.249645Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-26T20:44:31.249660Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-26T20:44:31.249679Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-26T20:44:31.249692Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-26T20:44:31.249709Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-26T20:44:31.249722Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-26T20:44:31.249742Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-26T20:44:31.249758Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-26T20:44:31.552255Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-26T20:44:31.582511Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

Version: '8.0.17-0ubuntu2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2019-10-26T20:44:31.758544Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. 

Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-10-26T21:01:48.954831Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-26T21:03:08.879960Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 13623
2019-10-26T21:03:09.898739Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-26T21:03:09.898755Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-26T21:03:09.898774Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-26T21:03:09.898787Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-26T21:03:09.898804Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-26T21:03:09.898817Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-26T21:03:09.898837Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-26T21:03:09.898854Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-26T21:03:10.192220Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-26T21:03:10.220759Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

Version: '8.0.17-0ubuntu2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2019-10-26T21:03:10.401481Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. 

Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-10-26T21:13:20.314149Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 8  user: 'root'.
2019-10-26T21:13:21.548910Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-26T21:13:30.291818Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 13953
2019-10-26T21:13:31.339632Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-26T21:13:31.339650Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-26T21:13:31.339675Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-26T21:13:31.339692Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-26T21:13:31.339714Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-26T21:13:31.339730Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-26T21:13:31.339757Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-26T21:13:31.339777Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-26T21:13:31.638914Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-26T21:13:31.668662Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

Version: '8.0.17-0ubuntu2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2019-10-26T21:13:31.842388Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. 

Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-10-26T22:18:54.292372Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-26T22:21:44.322720Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 15417
2019-10-26T22:21:45.455328Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-26T22:21:45.455344Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-26T22:21:45.455363Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-26T22:21:45.455376Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-26T22:21:45.455434Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-26T22:21:45.455447Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-26T22:21:45.455468Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-26T22:21:45.455484Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-26T22:21:45.759986Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-26T22:21:45.790178Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

Version: '8.0.17-0ubuntu2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2019-10-26T22:21:45.958047Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. 

Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-10-26T22:50:59.689327Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-27T02:35:06.713460Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 1743
2019-10-27T02:35:20.940772Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-27T02:35:20.940789Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-27T02:35:20.940810Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-27T02:35:20.940824Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-27T02:35:20.940841Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-27T02:35:20.940854Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-27T02:35:20.940875Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-27T02:35:20.940891Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-27T02:35:21.909384Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-27T02:35:22.575993Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

Version: '8.0.17-0ubuntu2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2019-10-27T02:35:22.693610Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. 

Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-10-27T02:37:23.095591Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
2019-10-27T02:38:12.485326Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 2633
2019-10-27T02:38:13.781779Z 0 [ERROR] [MY-013180] [Server] Function 'archive' already exists.
2019-10-27T02:38:13.781797Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2019-10-27T02:38:13.781822Z 0 [ERROR] [MY-013180] [Server] Function 'blackhole' already exists.
2019-10-27T02:38:13.781838Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2019-10-27T02:38:13.781861Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
2019-10-27T02:38:13.781876Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2019-10-27T02:38:13.781903Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
2019-10-27T02:38:13.781923Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2019-10-27T02:38:14.075507Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-27T02:38:14.076175Z 0 [ERROR] [MY-010273] [Server] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2019-10-27T02:38:14.076189Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2019-10-27T02:38:14.076554Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-27T02:38:15.182983Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2)  (Ubuntu).
          This is not going anywhere. Just as another test, I tried renaming ~/.local/share/akonadi but still no success.
          We only have to look at ourselves to see how intelligent life might develop into something we wouldn't want to meet. -- Stephen Hawking
          • Top
          • Bottom

          Comment

            #6
            Still working on this, no progress. Akoandi simply refuses to start, which means kalarm, knotes, and other stuff is non-functional.

            Tried reconfiguring akonadi for postgresql, and it still won't start, apparently with the same kind of error:

            Code:
            greenman@Crynfyd19.04 ~$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman@Crynfyd19.04 ~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Failed to use database "akonadi-greenman"
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"
org.kde.pim.akonadiserver: Failed to connect to database!
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"
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...
            The problem seems to be the socket stuff. In any event, the upgrade to eoan hosed akonadi, one way or another.
            We only have to look at ourselves to see how intelligent life might develop into something we wouldn't want to meet. -- Stephen Hawking
            • Top
            • Bottom

            Comment

              #7
              Never could get it to work with mysql.

              Finally got akonadi to work with postgresql, using the instructions here modified for local file names and locations:

              https://vinzv.de/en/bringing-kmail-and-postgresql-together/
              We only have to look at ourselves to see how intelligent life might develop into something we wouldn't want to meet. -- Stephen Hawking
              • Top
              • Bottom

              Comment

              Previous template Next
              Working...
              X