| View previous topic :: View next topic |
| Author |
Message |
vespaman
Guru
Joined: 28 Aug 2002
Posts: 326
Location: Stockholm, Sweden
|
 Posted: Sun Sep 03, 2017 3:23 pm Post subject: Akonadi fails to start (after downwgrading mariadb?)[Solved] |
 |
|
After having had issues with akonadi/mariadb blocker, I set mariadb to stable using keywords.
Not sure the downgrade is the issue, but anyway, now akonadi does not start;
| Code: | micke@h2 ~/Downloads/DashBox_BackupV1_1 $ 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 OK
akonadi.relationtypetable OK
akonadi.resourcetable OK
akonadi.schemaversiontable OK
akonadi.tagattributetable OK
akonadi.tagremoteidresourcerelationtable
Error : Table 'akonadi.tagremoteidresourcerelationtable' doesn't exist in engine
status : Operation failed
akonadi.tagtable OK
akonadi.tagtypetable OK
Repairing tables
akonadi.tagremoteidresourcerelationtable
Error : Table 'akonadi.tagremoteidresourcerelationtable' doesn't exist in engine
status : Operation failed
org.kde.pim.akonadiserver: "\nSql error: Table 'akonadi.tagremoteidresourcerelationtable' doesn't exist in engine QMYSQL: Unable to execute query\nQuery: ALTER TABLE TagRemoteIdResourceRelationTable ADD COLUMN tagId BIGINT NOT NULL"
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
|
and
| Code: |
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Using Linux native AIO
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Using SSE crc32 instructions
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Completed initialization of buffer pool
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Waiting for purge to start
2017-09-03 17:12:11 140156167739200 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 3388285017
2017-09-03 17:12:11 140155318957824 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-09-03 17:12:11 140156167739200 [Note] Plugin 'FEEDBACK' is disabled.
2017-09-03 17:12:11 140156167739200 [Note] Reading of all Master_info entries succeded
2017-09-03 17:12:11 140156167739200 [Note] Added new Master_info '' to hash table
2017-09-03 17:12:11 140156167739200 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.26-MariaDB' socket: '/tmp/akonadi-micke.7o2bAz/mysql.socket' port: 0 Source distribution
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
2017-09-03 17:12:11 140156063918848 [Warning] InnoDB: Cannot open table akonadi/tagremoteidresourcerelationtable from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
InnoDB: wrong number of columns in SYS_INDEXES record
InnoDB: wrong number of columns in SYS_INDEXES record
2017-09-03 17:12:11 140156063918848 [Warning] InnoDB: Cannot open table akonadi/tagremoteidresourcerelationtable from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
InnoDB: wrong number of columns in SYS_INDEXES record
2017-09-03 17:12:11 140156063918848 [Warning] InnoDB: Cannot open table akonadi/tagremoteidresourcerelationtable from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
InnoDB: wrong number of columns in SYS_INDEXES record
2017-09-03 17:12:11 140156063918848 [Warning] InnoDB: Cannot open table akonadi/tagremoteidresourcerelationtable from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2017-09-03 17:12:11 140156063615744 [Note] /usr/sbin/mysqld: Normal shutdown
2017-09-03 17:12:11 140155547432704 [Note] InnoDB: FTS optimize thread exiting.
2017-09-03 17:12:11 140156063615744 [Note] InnoDB: Starting shutdown...
2017-09-03 17:12:12 140156063615744 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-03 17:12:13 140156063615744 [Note] InnoDB: Shutdown completed; log sequence number 3388285027
2017-09-03 17:12:13 140156063615744 [Note] /usr/sbin/mysqld: Shutdown complete
|
What is the best way out of this, for a db rookie?
Last edited by vespaman on Tue Sep 05, 2017 4:47 pm; edited 1 time in total |
|
| Back to top |
|
 |
albright
Advocate
Joined: 16 Nov 2003
Posts: 2588
Location: Near Toronto
|
| Posted: Mon Sep 04, 2017 11:19 am Post subject: |
|
|
I use stable mariadb without problem (well, without any more
than the usual akonadi problems ... it is not the best functioning
software in the world).
Have you tried removing (back up if you like) all the akonadi
files in ~/.local/share and restarting?
_________________
.... there is nothing - absolutely nothing - half so much worth
doing as simply messing about with Linux ...
(apologies to Kenneth Graeme) |
|
| Back to top |
|
|
vespaman
Guru
Joined: 28 Aug 2002
Posts: 326
Location: Stockholm, Sweden
|
| Posted: Tue Sep 05, 2017 4:47 pm Post subject: |
|
|
Thanks! 
Sometimes the simple solutions works just fine, such as in this case. |
|
| Back to top |
|
|
|
Desktop Environments
