Arch Linux

StefanMajonez

Member

Registered: 2018-08-10

Posts: 2

[Resolved] MariaDB ArchWiki installation fails

Hi! I'm trying to install and run WordPress, and for that I needed MySQL.

I opened this Wiki page and started following the directions, this is what I got:

[root@server ~]# mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2018-08-10 17:01:40 140663769001920 [Note] /usr/bin/mysqld (mysqld 10.1.35-MariaDB) starting as process 16609 ...
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: The InnoDB memory heap is disabled
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Using Linux native AIO
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Using generic crc32 instructions
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Completed initialization of buffer pool
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2018-08-10 17:01:40 140663769001920 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-08-10 17:01:41 140663769001920 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-08-10 17:01:41 140663769001920 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-08-10 17:01:42 140663769001920 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-08-10 17:01:42 140663769001920 [Warning] InnoDB: New log files created, LSN=45781
2018-08-10 17:01:42 140663769001920 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-08-10 17:01:42 140663769001920 [Note] InnoDB: Doublewrite buffer created
2018-08-10 17:01:42 140663769001920 [Note] InnoDB: 128 rollback segment(s) are active.
2018-08-10 17:01:42 140663769001920 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-08-10 17:01:43 140663769001920 [Note] InnoDB: Foreign key constraint system tables created
2018-08-10 17:01:43 140663769001920 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-08-10 17:01:43 140663769001920 [Note] InnoDB: Tablespace and datafile system tables created.
2018-08-10 17:01:43 140663769001920 [Note] InnoDB: Waiting for purge to start
2018-08-10 17:01:43 140663769001920 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 0
2018-08-10 17:01:43 140663184160512 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-08-10 17:01:43 140663768832768 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
OK
Filling help tables...
2018-08-10 17:01:48 140631374290880 [Note] /usr/bin/mysqld (mysqld 10.1.35-MariaDB) starting as process 16640 ...
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: The InnoDB memory heap is disabled
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Using Linux native AIO
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Using generic crc32 instructions
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Completed initialization of buffer pool
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Highest supported file format is Barracuda.
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: 128 rollback segment(s) are active.
2018-08-10 17:01:48 140631374290880 [Note] InnoDB: Waiting for purge to start
2018-08-10 17:01:48 140631374290880 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616697
2018-08-10 17:01:48 140630787356416 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Creating OpenGIS required SP-s...
2018-08-10 17:01:51 139943718629312 [Note] /usr/bin/mysqld (mysqld 10.1.35-MariaDB) starting as process 16671 ...
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: The InnoDB memory heap is disabled
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Using Linux native AIO
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Using generic crc32 instructions
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Completed initialization of buffer pool
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Highest supported file format is Barracuda.
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: 128 rollback segment(s) are active.
2018-08-10 17:01:51 139943718629312 [Note] InnoDB: Waiting for purge to start
2018-08-10 17:01:51 139943718629312 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616707
2018-08-10 17:01:52 139943139604224 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h server password 'new-password'

Alternatively you can run:
'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

[root@server ~]# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@server ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.1.35 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2018-08-10 17:02:03 CEST; 4s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 16701 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=217/USER)

Aug 10 17:02:03 server systemd[1]: Starting MariaDB 10.1.35 database server...
Aug 10 17:02:03 server systemd[16701]: mariadb.service: Failed to determine user credentials: No such process
Aug 10 17:02:03 server systemd[16701]: mariadb.service: Failed at step USER spawning /bin/sh: No such process
Aug 10 17:02:03 server systemd[1]: mariadb.service: Control process exited, code=exited status=217
Aug 10 17:02:03 server systemd[1]: mariadb.service: Failed with result 'exit-code'.
Aug 10 17:02:03 server systemd[1]: Failed to start MariaDB 10.1.35 database server.

the part that seems most important (and the part I Googled, and got no results for) is this

Aug 10 17:02:03 server systemd[16701]: mariadb.service: Failed to determine user credentials: No such process
Aug 10 17:02:03 server systemd[16701]: mariadb.service: Failed at step USER spawning /bin/sh: No such process

I've read somewhere that MariaDB has issues with small disk space, so:

[root@server ~]# df -h
Filesystem      Size  Used Avail Use% Mounted on
dev             974M     0  974M   0% /dev
run             979M  668K  979M   1% /run
/dev/sda1       293G  6.0G  272G   3% /
tmpfs           979M     0  979M   0% /dev/shm
tmpfs           979M     0  979M   0% /sys/fs/cgroup
tmpfs           979M   28K  979M   1% /tmp
tmpfs           196M     0  196M   0% /run/user/1001

What did I do wrong? Did I miss a step?

Thanks in advance for helping out!

EDIT: Just realized this post might find a better home in the Newbie Corner

Last edited by StefanMajonez (2018-08-16 18:39:13)

jernst

Member

From: Silicon Valley

Registered: 2014-03-04

Posts: 290

Website

Re: [Resolved] MariaDB ArchWiki installation fails

Just tried, worked fine for me out of the box:

pacman -S mariadb
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl start mariadb
systemctl status mariadb

ktstmu

Member

Registered: 2018-08-15

Posts: 1

Re: [Resolved] MariaDB ArchWiki installation fails

Hi (my first post, yay!),

This problem is systemd-specific, not MariaDB or other. See this thread from systemd GitHub page. I managed to get it working by issuing following command as root:

# systemctl daemon-reexec

After this you can try to start the service again.

loqs

Member

Registered: 2014-03-06

Posts: 17,372

Re: [Resolved] MariaDB ArchWiki installation fails

Is there a patch for this regression?

StefanMajonez

Member

Registered: 2018-08-10

Posts: 2

Re: [Resolved] MariaDB ArchWiki installation fails

Just tried, worked fine for me out of the box:

pacman -S mariadb
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl start mariadb
systemctl status mariadb

Did a full system update, still didn't work. But...

Hi (my first post, yay!),

This problem is systemd-specific, not MariaDB or other. See this thread from systemd GitHub page. I managed to get it working by issuing following command as root:

# systemctl daemon-reexec
After this you can try to start the service again.

This works beautifully! Thanks!

hellking

Member

From: Ranchi, India

Registered: 2020-03-05

Posts: 1

Re: [Resolved] MariaDB ArchWiki installation fails

Thanks, this worked

Hi (my first post, yay!),

This problem is systemd-specific, not MariaDB or other. See this thread from systemd GitHub page. I managed to get it working by issuing following command as root:

# systemctl daemon-reexec

After this you can try to start the service again.

WorMzy

Forum Moderator

From: Scotland

Registered: 2010-06-16

Posts: 11,864

Website

Re: [Resolved] MariaDB ArchWiki installation fails

Please do not necrobump.

https://wiki.archlinux.org/title/Genera … bumping%22

Closing.

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.