Re: [arch-general] maria update to 10.4.6 breaks akonadi's db
On Friday, 28 June 2019, 07:49:16 CEST you wrote: > On Fri, 28 Jun 2019, at 07:41, Oliver Jaksch via arch-general wrote: > > Updated three of my KDE clients by terminal (not logged in by display > > manager/DM) and ran > > > > # systemctl restart mariadb.service && mariadb-upgrade -u root -p > > This doesn't affect akonadi's data since it is located someplace else at a > non-system location: > > /usr/bin/mysqld --defaults-file=$HOME/.local/share/akonadi/mysql.conf > --datadir=$HOME/.local/share/akonadi/db_data/ --s > ocket=/tmp/akonadi-xxx.LdhzVw/mysql.socket > --pid-file=/tmp/akonadi-xxx.LdhzVw/mysql.pids Yes, I know that, but I thought that akonadi would run a similar upgrade by itself when started and necessary. Wasn't that the case in the past? > I suggest you look into actually upgrading akonadi's DB first. For that, you > probably can pass --defaults-file and --datadir as-is to mariadb-upgrade > (and the upgrade should be executed as the user akonadi is running as, not > root). Thanks for that good starting point. But, alas, it gives me a # mysql_upgrade: the '--datadir' option is always ignored ...but this gives me hope for further investigations (=search engine). Will try and report; chances are good as it's friday and it's quiet today :)
Re: [arch-general] maria update to 10.4.6 breaks akonadi's db
On Fri, 28 Jun 2019, at 07:41, Oliver Jaksch via arch-general wrote: > Updated three of my KDE clients by terminal (not logged in by display > manager/DM) and ran > > # systemctl restart mariadb.service && mariadb-upgrade -u root -p This doesn't affect akonadi's data since it is located someplace else at a non-system location: /usr/bin/mysqld --defaults-file=$HOME/.local/share/akonadi/mysql.conf --datadir=$HOME/.local/share/akonadi/db_data/ --s ocket=/tmp/akonadi-xxx.LdhzVw/mysql.socket --pid-file=/tmp/akonadi-xxx.LdhzVw/mysql.pids I suggest you look into actually upgrading akonadi's DB first. For that, you probably can pass --defaults-file and --datadir as-is to mariadb-upgrade (and the upgrade should be executed as the user akonadi is running as, not root).
[arch-general] maria update to 10.4.6 breaks akonadi's db
Updated three of my KDE clients by terminal (not logged in by display
manager/DM) and ran
# systemctl restart mariadb.service && mariadb-upgrade -u root -p
as stated by pacman and arch-acnnounce. All went fine so far. No client starts
or uses a mariadb service. But after logging in at DM and starting Kontact the
drama begins: New Mails are shown but no one can be read and journal is showing
lots of
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: DATABASE
ERROR:
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error
code: "1452"
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: DB
error: "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`)
REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error
text: "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`)
REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3:
Unable to execute statement"
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver:
Values: QMap((":0", QVariant(qlonglong, 345491))(":1", QVariant(qlonglong,
9))(":2", QVariant(QByteArray, "Return-Path:
\r\nDelivered-To: copy...@bla.com\r\nReceived: from localhost
(localhost [127.0.0.1])\r\n\tby mail.sender.com (Postfix) with ESMTP id
6E9EF624B8;\r\n\tFri, 28 Jun 2019 05:49:16 +0200 (CEST)\r\nDKIM-Filter:
OpenDKIM Filter v2.11.0 mail.sender.com 6E9EF624B8\r\nDKIM-Signature: v=1;
a=rsa-sha256; c=relaxed/relaxed; d=sender.com;\r\n\ts=mail; [...]
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Query:
"INSERT INTO PartTable (pimItemId, partTypeId, data, datasize, version) VALUES
(:0, :1, :2, :3, :4)"
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error
during insertion into table "PartTable" "Cannot add or update a child row: a
foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT
`parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`)
ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error
while handling command CreateItem on connection akonadi_imap_resource_10
(0x55f027a24a20)
Jun 28 05:49:17 zotac3 akonadi_imap_resource[1543]: org.kde.pim.akonadicore:
Creating/updating items from the akonadi database failed: "Failed to insert new
part into database."
Jun 28 05:49:17 zotac3 akonadi_imap_resource[1543]: org.kde.pim.akonadicore:
Error during ItemSync: "Failed to insert new part into database."
~/.local/share/akonadi/db_data/mysql.err is showing continuously
2019-06-28 6:14:21 10 [ERROR] Transaction not registered for MariaDB 2PC, but
transaction is active
Stopping akonadi and therefore mariadb, then downgrading to mariadb* 10.3.16-1
helped.
Looks like something's not really going together there yet.
-
Oliver
[arch-general] Mariadb Tables Still Compatible with Backup Server Running Earlier Version?
This is more a general question following the mariadb feature update to 10.4.6-1. Do the tables remain compatible with servers running earlier versions of mariadb? What happens if a backup from an earlier version has to be rolled into the new version? Or more importantly, can a backup from the new version be used to update servers running earlier versions of mariadb? (I have the same database running on Arch with backup handled by openSuSE, still running 10.0.35) https://wiki.archlinux.org/index.php/MariaDB doesn't mention anything special. Nor does https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-104/ Any help or comment would be appreciated. -- David C. Rankin, J.D.,P.E.
Re: [arch-general] Maria update
did that 7 phases earlier here is the FULL output from that command string systemctl restart mariadb.service && mariadb-upgrade -u root -p Enter password: Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.eventOK mysql.func OK mysql.gtid_slave_pos OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mappingOK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_typeOK mysql.transaction_registry OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases information_schema performance_schema webtrees webtrees.wt_block OK webtrees.wt_block_setting OK webtrees.wt_change OK webtrees.wt_dates OK webtrees.wt_default_resn OK webtrees.wt_families OK webtrees.wt_favorite OK webtrees.wt_gedcom OK webtrees.wt_gedcom_chunk OK webtrees.wt_gedcom_setting OK webtrees.wt_hit_counterOK webtrees.wt_individualsOK webtrees.wt_link OK webtrees.wt_logOK webtrees.wt_media OK webtrees.wt_messageOK webtrees.wt_module OK webtrees.wt_module_privacy OK webtrees.wt_module_setting OK webtrees.wt_name OK webtrees.wt_news OK webtrees.wt_next_idOK webtrees.wt_other OK webtrees.wt_placelinks OK webtrees.wt_placelocation OK webtrees.wt_places OK webtrees.wt_sessionOK webtrees.wt_site_access_rule OK webtrees.wt_site_setting OK webtrees.wt_sourcesOK webtrees.wt_user OK webtrees.wt_user_gedcom_settingOK webtrees.wt_user_setting OK Phase 7/7: Running 'FLUSH PRIVILEGES' OK Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13 On Fri, 28 Jun 2019 at 01:14, Emil Lundberg wrote: > Maybe this? > > > https://www.archlinux.org/news/mariadb-104x-update-requires-manual-intervention/ > > /Emil > > On Fri, 28 Jun 2019, 03:10 mick howe via arch-general, < > arch-general@archlinux.org> wrote: > >> this mornings update of mariadb failed with this error:- >> Phase 7/7: Running 'FLUSH PRIVILEGES' >> OK >> Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' >> in the MariaDB Servers datadir, errno: 13 >> >> what does it mean and how do I fix it >> >> mick, freezing in glen innes >> >
Re: [arch-general] Maria update
Maybe this? https://www.archlinux.org/news/mariadb-104x-update-requires-manual-intervention/ /Emil On Fri, 28 Jun 2019, 03:10 mick howe via arch-general, < arch-general@archlinux.org> wrote: > this mornings update of mariadb failed with this error:- > Phase 7/7: Running 'FLUSH PRIVILEGES' > OK > Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' > in the MariaDB Servers datadir, errno: 13 > > what does it mean and how do I fix it > > mick, freezing in glen innes >
[arch-general] Maria update
this mornings update of mariadb failed with this error:- Phase 7/7: Running 'FLUSH PRIVILEGES' OK Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13 what does it mean and how do I fix it mick, freezing in glen innes
Re: [arch-general] [SOLVED] Different outputs for 'groups' and 'groups user'
On 6/26/19, Ralf Mardorf via arch-general wrote: > On Wed, 26 Jun 2019 18:00:53 -0300, riveravaldez via arch-general wrote: >>[user@arch ~]$ whoami >>user >>[user@arch ~]$ groups >>sys lp wheel ftp uucp log rfkill http games audio users user >>[user@arch ~]$ groups user >>sys lp wheel ftp uucp log rfkill http games audio users realtime user > > Log out and then log in again. Thanks a lot, everybody. You were right. I'm an ignorant. But also a lazy and impatient ignorant: "If the user is currently logged in, he must log out and in again for the change to take effect.", says a little below... Have a nice day and thanks again!
