[Bug 1445383] Re: Akonadi server is broken after mysql update
Richard Johnson
richard at ytivarg.com
Tue Oct 13 02:51:55 UTC 2015
*** 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 at 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 Kubuntu
Bugs, which is subscribed to akonadi in Ubuntu.
https://bugs.launchpad.net/bugs/1445383
Title:
Akonadi server is broken after mysql update
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1445383/+subscriptions
More information about the kubuntu-bugs
mailing list