Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mariadb-10.4.6 and kde-akonadi-18.12.3-r1 compat problems?
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
jms.gentoo
Tux's lil' helper
Tux's lil' helper


Joined: 07 May 2009
Posts: 80

PostPosted: Wed Jun 26, 2019 12:58 pm    Post subject: mariadb-10.4.6 and kde-akonadi-18.12.3-r1 compat problems? Reply with quote

I wonder if there are some problem between mariadb-10.4.6 and kde-akonadi-18.12.3-r1
maybe due to the change as noted in elog
"Log: postinst
This version of mariadb reorganizes the configuration from a single my.cnf
to several files in /etc/mysql/mariadb.d.
Please backup any changes you made to /etc/mysql/my.cnf
and add them as a new file under /etc/mysql/mariadb.d with a .cnf extension.
You may have as many files as needed and they are read alphabetically.
Be sure the options have the appropriate section headers, i.e. [mysqld].
"
or something else with this version of mariadb

I only now that since this update it looks like I can't use kmail
I was going to reset my akonadi config/mysqldb folowing
"Clean start after a failed migration"
https://userbase.kde.org/KMail/FAQs_Hints_and_Tips

but i do encounter several errors
in ~/.local/share/akonadi/db_data/mysql.err

2019-06-26 13:14:41 0 [Note] InnoDB: Using Linux native AIO
2019-06-26 13:14:41 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-06-26 13:14:41 0 [Note] InnoDB: Uses event mutexes
2019-06-26 13:14:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-06-26 13:14:41 0 [Note] InnoDB: Number of pools: 1
2019-06-26 13:14:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-06-26 13:14:41 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-06-26 13:14:41 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-06-26 13:14:41 0 [Note] InnoDB: Completed initialization of buffer pool
2019-06-26 13:14:41 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-26 13:14:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-06-26 13:14:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-06-26 13:14:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-06-26 13:14:41 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-06-26 13:14:41 0 [Note] InnoDB: Waiting for purge to start
2019-06-26 13:14:41 0 [Note] InnoDB: 10.4.6 started; log sequence number 401125; transaction id 310
2019-06-26 13:14:41 0 [Note] InnoDB: Loading buffer pool(s) from /home/jms/.local/share/akonadi/db_data/ib_buffer_pool
2019-06-26 13:14:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-26 13:14:41 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-06-26 13:14:41 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2019-06-26 13:14:41 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2019-06-26 13:14:41 0 [Note] Reading of all Master_info entries succeeded
2019-06-26 13:14:41 0 [Note] Added new Master_info '' to hash table
2019-06-26 13:14:41 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.6-MariaDB' socket: '/tmp/akonadi-jms.ccu7Fb/mysql.socket' port: 0 Source distribution
2019-06-26 13:14:41 0 [Note] InnoDB: Buffer pool(s) load completed at 190626 13:14:41
2019-06-26 13:14:41 9 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
2019-06-26 13:14:41 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
and so on with Transaction not registered for MariaDB 2PC, but transaction is active

and in ~/.local/share/akonadi/akonadiserver.error
[...]
019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR:
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Error code: "1452"
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 5))(":1", QVariant(qlonglong, 7)))
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Query: "INSERT INTO CollectionMimeTypeRelation (Collection_id, MimeType_id) VALUES (:0, :1)"
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Error during adding a record to table "CollectionMimeTypeRelation"
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Failed to append mimetype "inode/directory" to Collection 5
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Failed to append mimetypes ("inode/directory", "message/rfc822") to new collection "akonadi_maildir_resource_1" (ID 5 ) in resource "akonadi_maildir_resource_1"
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_maildir_resource_1 (0x5636ef5aebb0)
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR:
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Error code: "1452"
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 6))(":1", QVariant(qlonglong, 7)))
2019-06-26T13:14:44 [CRITICAL] org.kde.pim.akonadiserver: Query: "INSERT INTO CollectionMimeTypeRelation (Collection_id, MimeType_id) VALUES (:0, :1)"
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Error during adding a record to table "CollectionMimeTypeRelation"
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Failed to append mimetype "inode/directory" to Collection 6
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Failed to append mimetypes ("inode/directory", "message/rfc822") to new collection "Local Folders" (ID 6 ) in resource "akonadi_maildir_resource_1"
2019-06-26T13:14:44 [WARN ] org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_maildir_resource_1 (0x5636ef5aebb0)

So I am the only one with this problem?
is there a relation between my updgarde to mariadb-10.4.6 and this problem?
I am going to downgrade mariadb to check...
thanks for insights, feedback...
Back to top
View user's profile Send private message
Goverp
l33t
l33t


Joined: 07 Mar 2007
Posts: 805

PostPosted: Wed Jun 26, 2019 2:20 pm    Post subject: Reply with quote

Have you upgraded the mariadb database? Assuming you're using the default internal database for akonadi, and if it's in the default location, the following script works for me.
Note you must adjust the name of your home directory (and the full path name is needed, no "~" as far as I can remember).
Ithink it's best run from a command line session, not from within KDE.

Code:
#! /bin/sh

# Startup mysqld and upgrade the akonadi database
touch /tmp/akonadi.socket

/usr/sbin/mysqld --defaults-file=/home/paul/.local/share/akonadi/mysql.conf --datadir=/home/paul/.local/share/akonadi/db_data/ --socket=/tmp/akonadi.socket &

# Wait for the server
sleep 5s
mysql_upgrade --user=root --socket=/tmp/akonadi.socket

# Shutdown mysqld

mysqladmin --user=root --socket=/tmp/akonadi.socket shutdown


If that doesn't work, delete the akonadi database in ~/.local/share/akonadi - it's just a cache, and kde will rebuild it.
_________________
Greybeard
Back to top
View user's profile Send private message
jms.gentoo
Tux's lil' helper
Tux's lil' helper


Joined: 07 May 2009
Posts: 80

PostPosted: Wed Jun 26, 2019 2:43 pm    Post subject: Reply with quote

thanks for your reply Goverp
Quote:
Have you upgraded the mariadb database?

well as I have been using mariadb from quite some time with akonadi I didn't do anything as previous update went somothly.
and going from 10.3 to 10.4 I wasn't thinking this was a major version change .
Was it a major version change?
Got confused by the major minor point change now..
I 'like to know if this is considered as a major change as i just filed a bug
bug 688746


in any case
downgrading worked for me
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