- Arch-general - lists.archlinux.org

[arch-general] MariaDB not starting
by Peter Nabbefeld 27 Jan '17

27 Jan '17

Hello, I've got problems with MariaDB not working. 1) "systemctl status mariadb.service": ● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2017-01-27 13:04:10 CET; 13s ago Process: 4574 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 4519 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR Process: 4517 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 4574 (code=exited, status=1/FAILURE) Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Starting crash recovery... Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Crash recovery finished. Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454332160 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Server socket created on IP: '::'. Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Jan 27 13:04:10 tuchola systemd[1]: Failed to start MariaDB database server. Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Unit entered failed state. Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Failed with result 'exit-code'. 2) "journalctl -xe": -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mariadb.service has begun starting up. Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 4574 ... Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Using mutexes to ref count buffer pool pages Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: The InnoDB memory heap is disabled Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Using Linux native AIO Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Using SSE crc32 instructions Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Initializing buffer pool, size = 128.0M Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Completed initialization of buffer pool Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Highest supported file format is Barracuda. Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600749 in the Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Database was not shutdown normally! Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Starting crash recovery. Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Reading tablespace information from the .ibd files... Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Restoring possible half-written data pages Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: from the doublewrite buffer... Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: 128 rollback segment(s) are active. Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Waiting for purge to start Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09 140214454369792 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1600749 Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Plugin 'FEEDBACK' is disabled. Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140213863028480 [Note] InnoDB: Dumping buffer pool(s) not yet started Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Recovering after a crash using mysql-bin Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Starting crash recovery... Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Crash recovery finished. Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454332160 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [Note] Server socket created on IP: '::'. Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Jan 27 13:04:10 tuchola systemd[1]: Failed to start MariaDB database server. -- Subject: Unit mariadb.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mariadb.service has failed. -- -- The result is failed. Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Unit entered failed state. Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Failed with result 'exit-code'. Jan 27 13:04:10 tuchola sudo[4514]: pam_unix(sudo:session): session closed for user root Sorry, but those messages are not very expressive to me. I also tried to re-install mariadb, removing /var/lib/mysql (no important data had been in there until now ...) It seems to me, database data hadn't been re-created, but how can I get mariadb working now? BTW, is there a possibility to do a clean-up after package uninstall? Kind regards Peter

4 5

[arch-general] command line spreadsheet
by Jude DaShiell 27 Jan '17

27 Jan '17

neoleo is now in the aur and it builds and works as near as I can tell. That can be used on command line with the -x option starting it as well as in graphical user environments. It may be an improvement over libreoffice calc under orca I'm going to find out about that later. In the neoleo changelog a pointer to oleo documentation on the web on the official gnu site is provided but documentation doesn't yet come packaged with this spreadsheet. --

1 0

[arch-general] community/centerim findings
by Jude DaShiell 27 Jan '17

27 Jan '17

1) the key needed to get to the accounts screen after configuration is super-d or windows-d for those that don't know what super key is in Linux. That is the equivalent of the done button. It may be necessary to hit super-c to change the default configuration and actually write a configuration file to your home directory too before hitting super-d. I'm still researching that one. The man page doesn't describe what files centerim creates to support operation but I'll find that one out too. --

1 0

[arch-general] SSH access to Arch machines for testing
by Jeffrey Walton 26 Jan '17

26 Jan '17

Hi Everyone, Does Arch make machines available for testing software? (I'm interested in something like the GCC compile farm) If so, how do we sign up? Thanks in advance. Jeff

3 2

[arch-general] Pacman: Remove unneded dependencies
by L. Rose 24 Jan '17

24 Jan '17

Hi, I know, this is probably a very common question, but I couldn't find any information on the pacman wiki article about that, so I have to ask. How can I uninstall all packages on my system, which have been installed as a dependency, and aren't needed any longer? (Because I've uninstalled the dependent package or because the dependent package no longer depends on that dependency) I've read about pacman -Qe, but this lists packages I've explicitly installed and don't want to remove. And please, don't just point to the wiki article, I've checked that already. Thanks in advance, Lukas

5 5

Re: [arch-general] Hibernation not working
by ber532k 22 Jan '17

22 Jan '17

I had the same issue with my laptop some days ago. At the moment it seems to be working most times though, no idea why. I only made some seemingly unrelated changes in BIOS settings (fan speed, battery charging). The screen went blank, came back a second (as it usually does when about to hibernate) and went blank again. After that the laptop would still not turn off until the battery was fully drained. If I turned it off manually after the screen went blank the second time, however, it would later still resume all right. I guess it's something about triggering the correct acpi-event for poweroff or something.

1 0

Re: [arch-general] btrfs raid 10 fileserver with ata errors
by niya levi 19 Jan '17

19 Jan '17

> Date: Thu, 19 Jan 2017 08:02:52 +0100 > From: Karol Babioch <karol(a)babioch.de> > To: arch-general(a)archlinux.org > Subject: Re: [arch-general] btrfs raid 10 fileserver with ata errors > Message-ID: <f592f45e-07fd-bd32-06af-4ccdf549d5ca(a)babioch.de> > Content-Type: text/plain; charset="utf-8" > > Hi, > > Am 13.01.2017 um 03:22 schrieb niya levi via arch-general: >> how do i go about diagnosing and fixing the problem, >> any suggestions or guidance would be appreciated. >> shadrock > Check all cables and re-plug them. To narrow down the problem you can > also swap arond disks, so you know whether it is the disk itself or the > controller and/or cabling. But problems like these are a sometimes a > PITA to fix. > > Best regards, > Karol Babioch hi Karol i have replaced one sata cable which seem to have reduced the error warnings, i still get the odd failed cmd periodically , i am getting some more sata cables before further test. thanks shadrock

1 0

[arch-general] btrfs raid 10 fileserver with ata errors
by niya levi 19 Jan '17

19 Jan '17

hi everyone i have a fileserver with 6 1tb disks i get the following errors repeated constantly ------------------------------------------------------------------------------------------------------ ata17.00 exception Emask 0x0 Sact 0x0 SErr 0x0 action 0x6 frozen failed command: READ DMA cmd c8/00:30: tag 14 dma 65536 in res 40/00:ff:00 Emask 0x4 (timeout) status {DRDY} ---------------------------------------------------------------------------------------------------------- after some googling it's been suggested that it's either a hard drive, the sata controller or the sata cables. how do i go about diagnosing and fixing the problem, any suggestions or guidance would be appreciated. shadrock

4 3

[arch-general] Package signing on soyuz
by Jerome Leclanche 19 Jan '17

19 Jan '17

What is the current intended way to sign packages on the pkgbuild.com server? I spent the past day setting up agent forwarding (https://wiki.gnupg.org/AgentForwarding) for it. Had a lot of trouble setting it up due to systemd being seemingly overzealous about the gpg-agent socket. I have it working now, for myself, but wondering if anyone else is using it or if everybody is just signing locally. J. Leclanche

4 4

[arch-general] arch-security: CVE and ASA wiki logging
by G. Schlisio 17 Jan '17

17 Jan '17

Hi all, I appreciate the service of our valued Arch CVE Monitoring Team a lot. Since new year there are no more CVEs and ASAs logged on the respective Wiki pages [0] and [1], although ASAs are (thankfully!) still issued to arch-security. Is there a reason for discontinuing logging to the well-known wiki pages e.g. did logging move to another location, or is the security team in need of help keeping up with the work? Please let us know! Thankyou in advance Georg [0] https://wiki.archlinux.org/index.php/CVE [1] https://wiki.archlinux.org/index.php/Security_Advisories

4 4