Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Akonadi fails to start (after downwgrading mariadb?)[Solved]
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Desktop Environments
View previous topic :: View next topic  
Author Message
vespaman
Guru
Guru


Joined: 28 Aug 2002
Posts: 309
Location: Stockholm, Sweden

PostPosted: Sun Sep 03, 2017 3:23 pm    Post subject: Akonadi fails to start (after downwgrading mariadb?)[Solved] Reply with quote

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
View user's profile Send private message
albright
Advocate
Advocate


Joined: 16 Nov 2003
Posts: 2540
Location: Near Toronto

PostPosted: Mon Sep 04, 2017 11:19 am    Post subject: Reply with quote

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
View user's profile Send private message
vespaman
Guru
Guru


Joined: 28 Aug 2002
Posts: 309
Location: Stockholm, Sweden

PostPosted: Tue Sep 05, 2017 4:47 pm    Post subject: Reply with quote

Thanks! :)
Sometimes the simple solutions works just fine, such as in this case.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Desktop Environments All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum