- Arch-general - lists.archlinux.org

[arch-general] maria update to 10.4.6 breaks akonadi's db
by Oliver Jaksch 30 Jun '19

30 Jun '19

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: <receiver(a)bla.com>\r\nDelivered-To: copyrec(a)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

3 8

[arch-general] Mariadb Tables Still Compatible with Backup Server Running Earlier Version?
by David C. Rankin 28 Jun '19

28 Jun '19

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.

2 1

[arch-general] Maria update
by mick howe 28 Jun '19

28 Jun '19

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

4 4

[arch-general] Different outputs for 'groups' and 'groups user'
by riveravaldez 27 Jun '19

27 Jun '19

Hi, not sure if this is the right place to ask this, let me know if it's not. Maybe this is normal, but couldn't clarify it by reading the Arch Wiki [1]: [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 Why different outputs? Is it normal and with no issues? Should I do something? Thanks a lot! [1] https://wiki.archlinux.org/index.php/Users_and_groups#Group_management

3 3

[arch-general] I3 installation
by Ram Kumar 26 Jun '19

26 Jun '19

Hey Archers, I have a fresh installation now. Can you please guide me to install I3 gaps wm? I have seen sites but they are confusing me.. i need detaied step by step instruction please

4 6

[arch-general] HDMI Output died over night
by Florian Wehner 26 Jun '19

26 Jun '19

Hi! I wasn’t able to get my HDMI output running on my Lenovo X1 Carbon 6th gen today. I run gnome on Wayland. It has been working fine for the last few days but completely dead today. Symptom: The external display detects that an HDMI cable is connected (via ground?) but there is no signal. Here’s what I tried: Switch from wayland to Xorg Swapping cables / monitors Rebooting (with and without hdmi cable or power) Setting the boot display to HDMI (no influence) Looking at xrandr => Not connected Any ideas? Thanks, Flo

3 4

[arch-general] How long do you make the passphrase for the private key?
by Manuel Reimer 26 Jun '19

26 Jun '19

Hello, I want to publish a package repository with some packages that I need and only want to build once for all my systems. I want to make the packages available for general use. I have server space for that so I only have to rsync my final repo to my server after compiling my packages. I have my autobuild set up and signing seems to work, too. For convenience, I decided to make the passphrase not too long. I have 10 characters with both, alphanumeric and "special characters". I think if the passphrase is meant to be uncrackable alone, then we wouldn't need the big private key file, right? Is my passphrase long enough? What do the trusted users think about this topic? Thanks in advance Manuel

12 28

[arch-general] journalctl - configure date output persistent to short-iso
by Friedrich Strohmaier 25 Jun '19

25 Jun '19

Hi archers, I want journalctl to display date output persistently in short-iso format everytime everywhere. Searched around in manpages (journalctl journald.conf) and the web but no avail. I know about the -o switch, but didn't find the place to make this persistent. Anyone around who knows or did this already? -- Friedrich

2 2

[arch-general] CVE-2019-11477 (/proc/sys/net/ipv4/tcp_sack)
by David C. Rankin 22 Jun '19

22 Jun '19

After 5.12.1 is there any further mitigation needed for: https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-11477 related: https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-11478 https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-11479 Suggested work-around: echo 0 > /proc/sys/net/ipv4/tcp_sack or iptables -A INPUT -p tcp -m tcpmss --mss 1:500 -j DROP Are either needed after latest kernel, or is this resolved? -- David C. Rankin, J.D.,P.E.

2 2

[arch-general] package contents on fresh Arch install, like python etc...
by Ram Kumar 21 Jun '19

21 Jun '19

Dear Archers, A day back, i made a fresh install of Arch on my desktop. It is completely fresh as like it doesnt even have an account other than root. My doubt is, wont basic tools like python come in Arch install? or do we have to install by ourselves? also can anyone give me a brief approximate list of packages that will come pre-installed in Arch, other than gnu tools? Thanks in advance yours fellow newbie Archer Ramkumar

5 6