Hello,
I’m trying to run mariadb on a Raspberry Pi 3B and it won’t work. Testing the same thing on an x86 works fine (v10.4) however, the one in the Pi is showing as (10.1). The exact same config so I know it’s not that.
p.s. had to modify the log to remove links due to me being a new user
Here is the docker-compose entry
mariadb:
image: linuxserver/mariadb:latest
restart: unless-stopped
container_name: mariadb
hostname: mariadb
volumes:
- “$PWD/backup/mariadb:/backup”
- “$PWD/data/mariadb:/config”
networks:
- backend
environment:
- PUID=2015
- PGID=2015
- MYSQL_ROOT_PASSWORD=test
- MYSQL_ROOT_HOST="%"
- MYSQL_DATABASE=test
- MYSQL_USER=test
- MYSQL_PASSWORD=test
- TZ=Europe/London
Here is the log from docker:
2020-11-01 22:24:43 [s6-init] making user provided files available at /var/run/s6/etc…exited 0.
2020-11-01 22:24:45 [s6-init] ensuring user provided files have correct perms…exited 0.
2020-11-01 22:24:45 [fix-attrs.d] applying ownership & permissions fixes…
2020-11-01 22:24:45 [fix-attrs.d] done.
2020-11-01 22:24:45 [cont-init.d] executing container initialization scripts…
2020-11-01 22:24:45 [cont-init.d] 01-envfile: executing…
2020-11-01 22:24:45 [cont-init.d] 01-envfile: exited 0.
2020-11-01 22:24:45 [cont-init.d] 10-adduser: executing…
2020-11-01 22:24:47 -------------------------------------
2020-11-01 22:24:47 _ ()
2020-11-01 22:24:47 | | ___ _ __
2020-11-01 22:24:47 | | / | | | / \
2020-11-01 22:24:47 | | _ \ | | | () |
2020-11-01 22:24:47 || |/ || __/
2020-11-01 22:24:47 Brought to you by linuxserver .io
2020-11-01 22:24:47 -------------------------------------
2020-11-01 22:24:47 To support LSIO projects visit:
2020-11-01 22:24:47 h ttps://www .linuxserver.io/donate/
2020-11-01 22:24:47 -------------------------------------
2020-11-01 22:24:47 GID/UID
2020-11-01 22:24:47 -------------------------------------
2020-11-01 22:24:47 User uid: 2015
2020-11-01 22:24:47 User gid: 2015
2020-11-01 22:24:47 -------------------------------------
2020-11-01 22:24:47 [cont-init.d] 10-adduser: exited 0.
2020-11-01 22:24:47 [cont-init.d] 30-config: executing…
2020-11-01 22:24:48 [cont-init.d] 30-config: exited 0.
2020-11-01 22:24:48 [cont-init.d] 40-initialise-db: executing…
2020-11-01 22:24:48 Setting Up Initial Databases
2020-11-01 22:24:48 Installing MariaDB/MySQL system tables in ‘/config/databases’ …
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] /usr/sbin/mysqld (mysqld 10.1.47-MariaDB-0ubuntu0.18.04.1) starting as process 273 …
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [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.
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: The InnoDB memory heap is disabled
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Using Linux native AIO
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Using generic crc32 instructions
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Completed initialization of buffer pool
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2020-11-01 22:24:49 2020-11-01 22:24:49 1995451200 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2020-11-01 22:24:50 2020-11-01 22:24:50 1995451200 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2020-11-01 22:25:03 2020-11-01 22:25:03 1995451200 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2020-11-01 22:25:11 2020-11-01 22:25:11 1995451200 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2020-11-01 22:25:11 2020-11-01 22:25:11 1995451200 [Warning] InnoDB: New log files created, LSN=45780
2020-11-01 22:25:11 2020-11-01 22:25:11 1995451200 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-11-01 22:25:12 2020-11-01 22:25:12 1995451200 [Note] InnoDB: Doublewrite buffer created
2020-11-01 22:25:12 2020-11-01 22:25:12 1995451200 [Note] InnoDB: 128 rollback segment(s) are active.
2020-11-01 22:25:12 2020-11-01 22:25:12 1995451200 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-11-01 22:25:13 2020-11-01 22:25:13 1995451200 [Note] InnoDB: Foreign key constraint system tables created
2020-11-01 22:25:13 2020-11-01 22:25:13 1995451200 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-11-01 22:25:13 2020-11-01 22:25:13 1995451200 [Note] InnoDB: Tablespace and datafile system tables created.
2020-11-01 22:25:13 2020-11-01 22:25:13 1995451200 [Note] InnoDB: Waiting for purge to start
2020-11-01 22:25:13 2020-11-01 22:25:13 1995451200 [Note] InnoDB: Percona XtraDB (http :// www. percona. com) 5.6.49-89.0 started; log sequence number 0
2020-11-01 22:25:15 2020-11-01 22:25:15 1287648176 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-11-01 22:25:42 OK
2020-11-01 22:25:42 Filling help tables…
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] /usr/sbin/mysqld (mysqld 10.1.47-MariaDB-0ubuntu0.18.04.1) starting as process 301 …
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [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.
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: The InnoDB memory heap is disabled
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Using Linux native AIO
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Using generic crc32 instructions
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Completed initialization of buffer pool
2020-11-01 22:25:44 2020-11-01 22:25:44 1995606848 [Note] InnoDB: Highest supported file format is Barracuda.
2020-11-01 22:25:46 2020-11-01 22:25:46 1995606848 [Note] InnoDB: 128 rollback segment(s) are active.
2020-11-01 22:25:46 2020-11-01 22:25:46 1995606848 [Note] InnoDB: Waiting for purge to start
2020-11-01 22:25:46 2020-11-01 22:25:46 1995606848 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 1616693
2020-11-01 22:25:46 2020-11-01 22:25:46 1388307376 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-11-01 22:25:52 OK
2020-11-01 22:25:52 Creating OpenGIS required SP-s…
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] /usr/sbin/mysqld (mysqld 10.1.47-MariaDB-0ubuntu0.18.04.1) starting as process 330 …
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [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.
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: The InnoDB memory heap is disabled
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: Using Linux native AIO
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: Using generic crc32 instructions
2020-11-01 22:25:53 2020-11-01 22:25:53 1995918144 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-11-01 22:25:54 2020-11-01 22:25:54 1995918144 [Note] InnoDB: Completed initialization of buffer pool
2020-11-01 22:25:54 2020-11-01 22:25:54 1995918144 [Note] InnoDB: Highest supported file format is Barracuda.
2020-11-01 22:25:55 2020-11-01 22:25:55 1995918144 [Note] InnoDB: 128 rollback segment(s) are active.
2020-11-01 22:25:55 2020-11-01 22:25:55 1995918144 [Note] InnoDB: Waiting for purge to start
2020-11-01 22:25:55 2020-11-01 22:25:55 1995918144 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 1616703
2020-11-01 22:25:55 2020-11-01 22:25:55 1283453872 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-11-01 22:26:00 OK
2020-11-01 22:26:00 To start mysqld at boot time you have to copy
2020-11-01 22:26:00 support-files/mysql.server to the right place for your system
2020-11-01 22:26:00 PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
2020-11-01 22:26:00 To do so, start the server, then issue the following commands:
2020-11-01 22:26:00 ‘/usr/bin/mysqladmin’ -u root password ‘new-password’
2020-11-01 22:26:00 ‘/usr/bin/mysqladmin’ -u root -h mariadb password ‘new-password’
2020-11-01 22:26:00 Alternatively you can run:
2020-11-01 22:26:00 ‘/usr/bin/mysql_secure_installation’
2020-11-01 22:26:00 which will also give you the option of removing the test
2020-11-01 22:26:00 databases and anonymous user created by default. This is
2020-11-01 22:26:00 strongly recommended for production servers.
2020-11-01 22:26:00 See the MariaDB Knowledgebase at http ://mariadb.com/kb or the
2020-11-01 22:26:00 MySQL manual for more instructions.
2020-11-01 22:26:00 You can start the MariaDB daemon with:
2020-11-01 22:26:00 cd ‘/usr’ ; /usr/bin/mysqld_safe --datadir=’/config/databases’
2020-11-01 22:26:00 You can test the MariaDB daemon with mysql-test-run.pl
2020-11-01 22:26:00 cd ‘/usr/mysql-test’ ; perl mysql-test-run.pl
2020-11-01 22:26:00 Please report any problems at http :// mariadb. org/jira
2020-11-01 22:26:00 The latest information about MariaDB is available at http :// mariadb .org/.
2020-11-01 22:26:00 You can find additional information about the MySQL part at:
2020-11-01 22:26:00 http :// dev. mysql .com
2020-11-01 22:26:00 Consider joining MariaDB’s strong and vibrant community:
2020-11-01 22:26:00 htt ps:// mariadb .org/get-involved/
2020-11-01 22:26:02 2020-11-01 22:26:02 1996143424 [Note] mysqld (mysqld 10.1.47-MariaDB-0ubuntu0.18.04.1) starting as process 357 …
2020-11-01 22:26:02 mysqld: Please consult the Knowledge Base to find out how to run mysqld as root!
2020-11-01 22:26:02 2020-11-01 22:26:02 1996143424 [ERROR] Aborting