LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 06-26-2019, 07:51 PM   #16
Labinnah
Member
 
Registered: May 2014
Location: Łódź, Poland
Distribution: Slackware-current
Posts: 185

Rep: Reputation: 112Reputation: 112

Problem is akonadi itself, not buggy implementation. During processing it copy mail many times from disk to other place on disk or into db. Split to single words put them into db again and again. It may works for couple of mails, but it will not scale up. Especially when db config setup have very limited resources. This "low speed" processing could be acceptable when akonadi clients are not blocked by it, but they are! When akonadi do any internal processing, kmail became unusable (yes, also kmail 5).
 
Old 06-28-2019, 07:08 PM   #17
jkh2cpu
Member
 
Registered: Feb 2014
Location: Michigan, USA
Distribution: slackware
Posts: 270

Original Poster
Rep: Reputation: 57
I'm the OP. I tried Alien Bob's suggestion,
but it did not fix the problem. Down in
~/.local/share/akonadi/db_data, I find mysql.err.
Here are the first few lines. Looks like the DB
is missing some tables. Once the repeating lines
begin, they continue to the end of the file.
Kmail is trying to do something, but it's not
working for kmail.

John.

2019-06-28 17:22:13 0 [Note] InnoDB: Using Linux native AIO
2019-06-28 17:22:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-06-28 17:22:13 0 [Note] InnoDB: Uses event mutexes
2019-06-28 17:22:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-06-28 17:22:13 0 [Note] InnoDB: Number of pools: 1
2019-06-28 17:22:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-06-28 17:22:13 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-06-28 17:22:13 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-06-28 17:22:13 0 [Note] InnoDB: Completed initialization of buffer pool
2019-06-28 17:22:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be
changed. See the man page of setpriority().
2019-06-28 17:22:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-06-28 17:22:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-06-28 17:22:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please
wait ...
2019-06-28 17:22:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-06-28 17:22:13 0 [Note] InnoDB: 10.4.6 started; log sequence number 15108425505; transaction id 27414937
2019-06-28 17:22:13 0 [Note] InnoDB: Loading buffer pool(s) from /home/jkh/.local/share/akonadi/db_data/ib_buffer_poo
l
2019-06-28 17:22:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-28 17:22:13 5 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table '
mysql.gtid_slave_pos' doesn't exist
2019-06-28 17:22:13 0 [Note] Reading of all Master_info entries succeeded
2019-06-28 17:22:13 0 [Note] Added new Master_info '' to hash table
2019-06-28 17:22:13 0 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.4.6-MariaDB' socket: '/tmp/akonadi-jkh.2pltk5/mysql.socket' port: 0 MariaDB Server
2019-06-28 17:22:13 0 [Note] InnoDB: Buffer pool(s) load completed at 190628 17:22:13
2019-06-28 17:22:13 9 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2019-06-28 17:22:13 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-28 17:22:13 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-28 17:22:13 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
 
Old 06-28-2019, 08:44 PM   #18
Labinnah
Member
 
Registered: May 2014
Location: Łódź, Poland
Distribution: Slackware-current
Posts: 185

Rep: Reputation: 112Reputation: 112
Missing tables are rather harmless, I have same errors and my ankonadi works.

But "Transaction not registered for MariaDB 2PC, but transaction is active" looks scary. I'm not quite sure what it mean. My only guess is that akonadi tries run SQL transaction query but your db did not support them. This can be true when you have MyISAM tables. You may try change table types to InnoDB (I have that type in my db), but I don't know how to login to akonadi's mysql to do so.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[Slackware64 14.2] Loading error of ath10k firmware with latest kernel-firmware and latest kernel-huge pensador_13 Slackware 3 06-16-2018 12:31 PM
Brightness function keys not working on Slackware64 & Slackware64 current Andersen Slackware 7 01-15-2018 04:27 AM
Pan does not run as user, but does as root with slackware64-current jkh2cpu Slackware 9 12-24-2017 11:17 AM
[SOLVED] suspend to ram ( sleep) does not work on my Slackware64-current multilib afreitascs Slackware 8 06-26-2012 10:57 PM
[SOLVED] Latest slackware64-current xorg and kernel update woes veeall Slackware 10 07-19-2009 12:31 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 02:07 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration