desktop-packages team mailing list archive

Thread
Date
[Bug 1445383] Re: Akonadi server is broken after mysql update

To: desktop-packages@xxxxxxxxxxxxxxxxxxx
From: Richard Johnson <richard@xxxxxxxxxxx>
Date: Tue, 13 Oct 2015 02:51:55 -0000
Reply-to: Bug 1445383 <1445383@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
*** This bug is a duplicate of bug 1437846 ***
    https://bugs.launchpad.net/bugs/1437846

Follow-up to previous note:

as suggested here:  
https://www.kubuntuforums.net/showthread.php?67801-Kontact-Reports-that-Akonadi-in-not-Operational&p=370725&viewfull=1#post370725

I removed the two files
~/.local/share/akonadi/db_data/ib_logfile0
and ~/.local/share/akonadi/db_data/ib_logfile1

The result follows.  It started the db but is missing a table.  I will
continue to look for old config files that seem to confuse it.

$ akonadictl start                   
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
richard@minerva:~/.local/share/akonadi/db_data$ search paths:  ("/home/richard/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  ""
Found mysqlcheck:  "/usr/bin/mysqlcheck"
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
Error    : Table 'akonadi.relationtable' doesn't exist in engine
status   : Operation failed
akonadi.relationtypetable
Error    : Table 'akonadi.relationtypetable' doesn't exist in engine
status   : Operation failed
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
akonadi.tagtypetable                               OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK

Repairing tables
test.relationtable
Error    : Table 'test.relationtable' doesn't exist
status   : Operation failed
test.relationtypetable
Error    : Table 'test.relationtypetable' doesn't exist
status   : Operation failed
MySQL version OK (required "5.1" , available "10.0" )
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table  "SchemaVersionTable"
checking table  "ResourceTable"
checking table  "CollectionTable"
checking table  "MimeTypeTable"
checking table  "PimItemTable"
checking table  "FlagTable"
checking table  "PartTypeTable"
checking table  "PartTable"
checking table  "CollectionAttributeTable"
checking table  "TagTypeTable"
checking table  "TagTable"
checking table  "TagAttributeTable"
checking table  "TagRemoteIdResourceRelationTable"
checking table  "RelationTypeTable"
"ALTER TABLE RelationTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY"
"
Sql error: Table 'akonadi.relationtypetable' doesn't exist in engine QMYSQL: Unable to execute query
Query: ALTER TABLE RelationTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY"
Unable to initialize database.
"[
0: akonadiserver() [0x57e2f6]
1: akonadiserver() [0x57e61e]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x352f0) [0x7fb9efbc32f0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37) [0x7fb9efbc3267]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fb9efbc4eca]
5: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_Z17qt_message_output9QtMsgTypeRK18QMessageLogContextRK7QString+0x185) [0x7fb9f05813d5]
6: akonadiserver() [0x580c1c]
7: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN9QIODevice5writeEPKcx+0x10b) [0x7fb9f069c49b]
8: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(+0x1bca26) [0x7fb9f06ada26]
9: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN11QTextStreamD2Ev+0x11b) [0x7fb9f06adc6b]
10: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN6QDebugD1Ev+0x3f) [0x7fb9f067ebdf]
11: akonadiserver() [0x422686]
12: akonadiserver() [0x503289]
13: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN7QObject5eventEP6QEvent+0xf1) [0x7fb9f07a4651]
14: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0xbc) [0x7fb9f0772efc]
15: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x2c7) [0x7fb9f0775057]
16: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(+0x2d8e73) [0x7fb9f07c9e73]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x2a7) [0x7fb9ee5e6ff7]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x4a250) [0x7fb9ee5e7250]
19: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fb9ee5e72fc]
20: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0x7fb9f07ca27f]
21: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x10a) [0x7fb9f077075a]
22: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN16QCoreApplication4execEv+0x9c) [0x7fb9f07782cc]
23: akonadiserver() [0x41fa79]
24: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fb9efbaea40]
25: akonadiserver(_start+0x29) [0x4204e9]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to akonadi in Ubuntu.
https://bugs.launchpad.net/bugs/1445383

Title:
  Akonadi server is broken after mysql update

Status in akonadi package in Ubuntu:
  Confirmed

Bug description:
  After recent updates, i cannot longer use the Akonadi services - it is
  failing during the start process with following error message:

  
  search paths:  ("/home/piotrek/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
  Found mysql_install_db:  "/usr/bin/mysql_install_db" 
  Found mysqlcheck:  "/usr/bin/mysqlcheck" 
  Database process exited unexpectedly during initial connection!
  executable: "/usr/sbin/mysqld-akonadi"
  arguments: ("--defaults-file=/home/piotrek/.local/share/akonadi/mysql.conf", "--datadir=/home/piotrek/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-piotrek.1jfWsZ/mysql.socket")
  stdout: ""
  stderr: "2015-04-17 10:12:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  "
  exit code: 1
  process error: "Unknown error"
  "[
  0: akonadiserver() [0x418c8a]
  1: akonadiserver() [0x418f04]
  2: /lib/x86_64-linux-gnu/libc.so.6(+0x352f0) [0x7fbbcbb662f0]
  3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37) [0x7fbbcbb66267]
  4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fbbcbb67eca]
  5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x12a) [0x7fbbcd390a8a]
  6: akonadiserver() [0x41ad0d]
  7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8a) [0x7fbbcd43030a]
  8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x121155) [0x7fbbcd440155]
  9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fbbcd448ab1]
  10: akonadiserver() [0x48235e]
  11: akonadiserver() [0x41b90f]
  12: akonadiserver() [0x41dff8]
  13: akonadiserver() [0x4e2e49]
  14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1e1) [0x7fbbcd4bf891]
  15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d) [0x7fbbcd4a617d]
  16: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x231) [0x7fbbcd4a9a21]
  17: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1b669e) [0x7fbbcd4d569e]
  18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x24d) [0x7fbbcb22ec3d]
  19: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49f20) [0x7fbbcb22ef20]
  20: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fbbcb22efcc]
  21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x7e) [0x7fbbcd4d580e]
  22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x41) [0x7fbbcd4a4cd1]
  23: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1a5) [0x7fbbcd4a5035]
  24: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x99) [0x7fbbcd4aaab9]
  25: akonadiserver() [0x4131b5]
  26: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fbbcbb51a40]
  27: akonadiserver(_start+0x29) [0x413be9]
  ]
  "
  ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
  "akonadiserver" crashed too often and will not be restarted!

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1445383/+subscriptions
References

[Bug 1445383] [NEW] Akonadi server is broken after mysql update
From: uszatan, 2015-04-17